Hello everyone, first I'd like to thank everyone here since you guys have answered my questions to a high degree of technical knowledge w/o jargon. I was hoping some of you would know a very good SQL tutorial on running queries using the various commands.
Here is the problem I am running into. Every single SQL book I have read such as SQL for Dummies, Beginning SQL, and SQL for Beginners, et. al, and every single SQL training video I've watched whether it's from CBT Nuggets to other vendors, totally lacks a comprehensive review of writing queries using various commands. Heck, I've even gone to various websites that teach SQL such as SQL-Tutorial.Com, SQL-Tutorial2.Com, W3Schools.Com, and several others. All seem to go through some basic Select queries (whoop de do) and don't go in depth. After that they seem to jump straight into writing SPs. Books online is a great resource but it gets complicated for a brand new SQL programmer who has no programming background (Except I knew how to draw a mean animated comic in QBasic 15 years ago loll).
I don't want to jump into writing SPs as I can't even write a decent query, and correct me if I am wrong, but I need to know how to do this before I can write decent SPs. Don't I need to spend the bulk of my time in learning how to write a proper query before I can write SPs really well?
Here is the problem I am running into. Every single SQL book I have read such as SQL for Dummies, Beginning SQL, and SQL for Beginners, et. al, and every single SQL training video I've watched whether it's from CBT Nuggets to other vendors, totally lacks a comprehensive review of writing queries using various commands. Heck, I've even gone to various websites that teach SQL such as SQL-Tutorial.Com, SQL-Tutorial2.Com, W3Schools.Com, and several others. All seem to go through some basic Select queries (whoop de do) and don't go in depth. After that they seem to jump straight into writing SPs. Books online is a great resource but it gets complicated for a brand new SQL programmer who has no programming background (Except I knew how to draw a mean animated comic in QBasic 15 years ago loll).
I don't want to jump into writing SPs as I can't even write a decent query, and correct me if I am wrong, but I need to know how to do this before I can write decent SPs. Don't I need to spend the bulk of my time in learning how to write a proper query before I can write SPs really well?
