STORED PROCEDURES exercises

This page lists the 8 exercises about Stored procedures in SQL on our website:

Software:	SQL
Topic:	Stored procedures
Level:	Relatively easy
Exercise:	Create a basic SQL stored procedure to return a list of number 1 music albums.

Show this exercise

Software:	SQL
Topic:	Stored procedures
Level:	Relatively easy
Exercise:	Create a stored procedure to list Dr Who episodes featuring Matt Smith.

Show this exercise

Software:	SQL
Topic:	Stored procedures
Level:	Relatively easy
Exercise:	Filter the select statement, only show events occuring in August.

Show this exercise

Software:	SQL
Topic:	Stored procedures
Level:	Relatively easy
Exercise:	Write a basic procedure to list countries in Asia, then make small changes to it.

Show this exercise

Software:	SQL
Topic:	Stored procedures
Level:	Average difficulty
Exercise:	Create a SQL stored procedure to return a list of rock and roll music albums.

Show this exercise

Software:	SQL
Topic:	Stored procedures
Level:	Average difficulty
Exercise:	Create a stored procedure to list Dr Who episodes written by Steven Moffat.

Show this exercise

Software:	SQL
Topic:	Stored procedures
Level:	Harder than average
Exercise:	Create a SQL stored procedure to return a list of concert tours and shows.

Show this exercise

Software:	SQL
Topic:	Stored procedures
Level:	Harder than average
Exercise:	Create a stored procedure to list Dr Who episodes by frequency in two ways.

Show this exercise

You can search our full list of SQL exercises here. Or why not learn to do them the right way on one of our SQL training courses? You can attend our online training classes wherever you are in the world!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page has 1 thread

Add a new post

From:	sharmila
When:	14 Jul 18 at 15:02

where do we find solution for these?

From:	Andrew G
When:	16 Jul 18 at 09:36

Hi, we don't publish solutions so as not to spoil the fun! Although you may find that other users have posted suggested answers to some of the exercises.

Add a new post