Northwind query exercises/examples
frankwildyearsTom
Thus far all I have done with SQL are simple select statements, but
now I've also started learning about INNER JOINs, GROUP BY clauses and
inner queries. I learned the concepts, but now I’d like to do some
exercises using the Northwind database, so that such queries would
become second nature.
I tried to come up with good examples that would really test my skills
and enable me to become more proficient, but I’m not really good at
coming up with any worthwhile examples. Perhaps you guys could help me
come up with some examples?
* Examples should include just the following parameters ( INNER JOINs,
inner queries, GROUP BY, HAVING, IN, ANY, SOME, ALL, EXISTS, MIN, MAX,
SUM, AVG)
* They shouldn’t include any fancy business/economic terms, since I
don’t have a clue about those things
* Solutions to these examples would also be required
Much appreciated
Plamen Ratchev
You can get the T-SQL Fundamentals book which has excellent explanation of queries, as well as examples and solutions
(plus the tables used are very similar to Northwind):
http://www.sql.co.il/books/tsqlfund2008/
--
Plamen Ratchev
http://www.SQLStudio.com
frankwildyearsTom
I'm afraid that it will be like most other books where with each topic
there will be few example queries to make a point across, but they
won't be the kind of examples that would forward you from
understanding the topic ( and being able to use it in simpler cases )
to being really proficient at using it( namely, I already understand
the concepts I named in my initial post and can use them in simpler
queries, thus I don't really need a book that would explain the basics
to me ).
Point I'm trying to make is that there's a big difference between
understanding a particular kind of query and actually being able to
use it in more advanced/complex ways ( I just want to be sure I won't
spend money on something I don't really need )
I appreciate your input
Plamen Ratchev
not just some examples about how to use a particular statement. Go to a bookstore and preview it, and for a taste you
can download and read the sample chapters provided on the link I posted.
http://www.sql.co.il/books/tsqlfund2008/sample_chapters.htm
frankwildyearsTom
thanx. Will take a look at it
Erland Sommarskog
> On Jul 11, 6:05�pm, Plamen Ratchev <Pla...@SQLStudio.com> wrote:
>> In my opinion mastering the fundamentals will help you solve any
>> complex problem. This is what the book is about, and not just some
>> examples about how to use a particular statement. Go to a bookstore and
>> preview it, and for a taste you can download and read the sample
>> chapters provided on the link I
>> posted.http://www.sql.co.il/books/tsqlfund2008/sample_chapters.htm
>
>
now, and you will find that there are indeed quite a few exercises in it,
as well as solutions.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
