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   [ - ] Hide 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
Answer this question or Comment on this question for clarity



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