Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Exercises for PUBS and Northwind SQL Sevrer database Expand / Collapse
Author
Message
Posted Friday, March 20, 2009 4:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 10, 2011 1:13 PM
Points: 3, Visits: 4

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.
Post #680259
Posted Friday, March 20, 2009 5:14 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 4, 2012 12:23 PM
Points: 1,893, Visits: 3,932
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



The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems
Post #680268
Posted Friday, March 20, 2009 5:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:03 PM
Points: 14,017, Visits: 28,396
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
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #680285
Posted Friday, March 20, 2009 6:09 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 4, 2012 12:23 PM
Points: 1,893, Visits: 3,932
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



The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems
Post #680303
Posted Friday, March 20, 2009 6:21 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:03 PM
Points: 14,017, Visits: 28,396
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
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #680311
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse