Suggestions for K1000 SQL Training
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.
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!