I am becoming more and more involved in creating reports within my K1000. The canned reports are nice for some instances, but SQL based reports seem to be far more powerful. I am a total SQL noob and was wondering what kind of training would be a good foundation to learn SQL. My manager said that they would pay for whatever I needed.


I would appreciate any suggestions. Thanks.

0 Comments   [ + ] Show Comments


Please log in to comment

Community Chosen Answer


I feel your pain - started at ground zero here as well.  You could read through a couple blogs I wrote to see if this helps you get started:

Primer for Writing SQL Select Statement Queries on the K1000 (w/Custom SQL Report example)


Once you feel comfortable there, try this:

K1000 Reports - Advanced MySQL Query Techniques - Parsing Multiple Substrings from a Field Using Temporary Tables


I've got a bunch of other blogs that break down my reports, etc so you can keep reading those for ideas (just click on my username).

Hope that helps!


Answered 09/28/2012 by: jverbosk
Red Belt

Please log in to comment



Check this book out. It is older but it still valuable esepcially for beginners.


Answered 09/27/2012 by: Timi
Seventh Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity