Link to home
Start Free TrialLog in
Avatar of Chandra Sekhar
Chandra SekharFlag for United States of America

asked on

Looking for SQL Server Database AdventureWorks based exercises needed for practice

Hi

Looking for SQL Server Database AdventureWorks based SQL exercises needed for extensive sql queries practices

Anybody know of SQL Server  excercise sanything like this?

Thanks
Avatar of yo_bee
yo_bee
Flag of United States of America image

If you buy or find any books authored by Itzik-Ben-Gan you will find that they are worth-while investment and the leverage AdventureWorks.  

You want to focus on T-SQL books.  

Here is a link to the list of databases.  
http://msftdbprodsamples.codeplex.com/
Avatar of Chandra Sekhar

ASKER

I have AdventureWorks Database, looking for more of AdventureWorks SQL queries ecercises to improve my skills. I am in very basic stage,would like to do my SQL queries.Really appreciate it
Unfortunately, it is not quite clear to me what you are looking for. Are you already comfortable with T-SQL? If yes, you can just try it yourself. If you are running short of ideas, I am not sure if these are available by itself, just for the purpose of exercise.

If you are learning T-SQL, you may wish to do some online free courses, which exclusively cover these topics, such as:

https://www.edx.org/course/querying-transact-sql-microsoft-dat201x-8

https://mva.microsoft.com/en-US/training-courses/querying-microsoft-sql-server-2012-databases-jump-start-8241

I believe, both of these courses use AdventureWorks db for example.
Perhaps , if you want to do SQL exercises this can help -

https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
Avatar of micah williams
micah williams

You can get your answer here: http://sqlzoo.net/wiki/AdventureWorks or https://www.sqlskills.com/

you can find these practices and use cases for learning at MindMajix. which provides you SQL Server training and help you excel your queries in SQL Server Database AdventureWorks.
You already have many good suggestions here but also note you can look right on MSDN.
https://msdn.microsoft.com/en-us/library/ms124825(v=sql.100).aspx

If you walk through the scenarios, Microsoft describes the business requirement and shows the SQL code.  It essentially is good exercise for learning the database structure as they basically start with a data dictionary on the specific tables.  I do second the recommendation on book by Itzik-Ben-Gan or other Microsoft SQL MVP.  In many cases, you will find that the books come with sample code that you can download.  In every case I have seen, this sample code uses AdventureWorks because it is a complete system that they know you can go get without them having to produce a whole new schema for and provide download...  Plus you now have the insight of the author to separate out theory from practical side of syntax as although some syntax works (is technically correct) does not make it the "right" thing to do.  If you are wanting to learn the correct way, using a guide would be prudent.

Anyway, good luck!
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.