SQL exercises/queries with sample database [closed]

Question

I am looking for some sample SQL exercises/query (preferred MySQL, or SQLServer)to practice. It would be great if it is with some sample database.

Could someone please point to sql exercises for Sakila Database( MySQL Sample Database) or exercises with some other sample database.

I have already came across http://courses.cs.tau.ac.il/0368-3458/databases201213a/assignments/hw1.pdf

and looking for more.

Thanks in advance, Sambhav

Answer 1

There is a lot out there! Here are a few nice ones that offer (online) practice:

• SQLZOO - lets you practice interactively with SQL queries for different database management systems;

• SQLCourse.com - also an interactive tutorial that lets you practice SQL queries;

• Introduction to Databases - a Stanford online course with a lot of explanatory video lectures. It is much more theoretical, but also provides the possibility to practice with the stuff that's taught. (This course seems now to have been chopped up into 5 different smaller courses.);

• GalaXQL - another interactive SQL tutorial using SQLite;

• SQL-EX - seems to provide SQL exercises, but requires an account.

Some sample databases can be downloaded here:

• SQL Server 2008/2012/2014 -> AdventureWorks sample databases;