SQL Exercises for PUBS and Northwind SQL Sevrer database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » SQL Exercises for PUBS and Northwind SQL...

SQL Exercises for PUBS and Northwind SQL Sevrer database

Rate Topic

Display Mode

Topic Options

Author

Message

jaideepc99

Posted Friday, March 20, 2009 4:49 AM

Forum 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. Smile

Post #680259

Florian Reischl

Posted Friday, March 20, 2009 5:14 AM

SSCrazy

Group: General Forum Members
Last Login: Sunday, November 04, 2012 12:23 PM
Points: 2,087, 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

Grant Fritchey

Posted Friday, March 20, 2009 5:47 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 13,383, Visits: 25,189

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #680285

Florian Reischl

Posted Friday, March 20, 2009 6:09 AM

SSCrazy

Group: General Forum Members
Last Login: Sunday, November 04, 2012 12:23 PM
Points: 2,087, 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 Wink

.

Another benefit of AdventureWorks is that many BOL samples are working with.

Greets
Flo

Post #680303

Grant Fritchey

Posted Friday, March 20, 2009 6:21 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 13,383, Visits: 25,189

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 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 »

Permissions