Northwind query exercises/examples

[frankwildyearsTom]

Hello,

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/

[frankwildyearsTom]

Hello,

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]

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

[frankwildyearsTom]

Post by Plamen Ratchev
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
--
Plamen Ratchevhttp://www.SQLStudio.com

thanx. Will take a look at it

[Erland Sommarskog]

Post by frankwildyearsTom

Post by Plamen Ratchev
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

thanx. Will take a look at it

In addition to Plamen's recommendation, I'm reading Itzik's book right
now, and you will find that there are indeed quite a few exercises in it,
as well as solutions.

[Fursan Sharafi]

Post by Plamen Ratchev
You can get the T-SQL Fundamentals book which has excellent explanation of queries, as well as examples and solutions
http://www.sql.co.il/books/tsqlfund2008/
--
Plamen Ratchev
http://www.SQLStudio.com

קיבלתי הודעת שגיאה שהאתר לא עולה כעת ובבנייה אולי, האם זה נ