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

Comments

Please log in to comment

Community Chosen Answer

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

Answered 09/28/2012 by: jverbosk
Red Belt

Please log in to comment

Answers

1

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

http://www.itninja.com/link/a-visual-introduction-to-sql

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