March 20, 2009 at 4:49 am
Hi,
I am new to SQL Server and have recently bought SQL Server 2005 programming by Rob Viera.
But I want to polish my SQL Query and Procedure writing skills. So can anybody point me to extensive SQL Exercises targetting Pubs or Northwind database or any other SQL database? I was not able to find anything like this for SQL Server in the internet.
Thanks in advance,
Jai.:-)
March 20, 2009 at 5:14 am
Hi Jai
No direct answer to your question, but...
If you are using SSE 2k5 I would advice you to use the AdventureWorks database for learning. Pubs and Northwind are a little bit too simple. AdventureWorks represents much more features of SQL Server.
You also find much more documentation about them in internet.
Greets
Flo
March 20, 2009 at 5:47 am
I'm really not aware of "excercises" that you can do with any of the sample databases.
If it helps at all, and I doubt it does, both my books use AdventureWorks for all the samples.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 20, 2009 at 6:09 am
Grant Fritchey (3/20/2009)
I'm really not aware of "excercises" that you can do with any of the sample databases.If it helps at all, and I doubt it does, both my books use AdventureWorks for all the samples.
Hi
This sample databases are good just try some things. In my opinion sometimes structure is more handy than table test1 to test5 ;-).
Another benefit of AdventureWorks is that many BOL samples are working with.
Greets
Flo
March 20, 2009 at 6:21 am
Absolutely. Plus, I'm lazy. If I can pick something up for trying stuff out, that's what I'm going to do. I know there are lots of complaints about AdventureWorks... it's too big, it's too small, it's structure is wierd... I think it's a reasonable representation of a database. It's not perfect for all situations, but it works.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply