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.
Answers (2)
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)
http://www.itninja.com/blog/view/primer-for-writing-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
http://www.itninja.com/blog/view/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!
John
Check this book out. It is older but it still valuable esepcially for beginners.
