SQL exercises on STORED PROCEDURES

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

Software: SQL
Version: Any version of SQL Server
Topic: Stored procedures
Level: Relatively easy
Course: Advanced SQL
Exercise: Write a basic procedure to list countries in Asia, then make small changes to it.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Stored procedures
Level: Relatively easy
Course: Advanced SQL
Exercise: Create a stored procedure to list Dr Who episodes featuring Matt Smith.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Stored procedures
Level: Relatively easy
Course: Advanced SQL
Exercise: Filter the select statement, only show events occuring in August.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Stored procedures
Level: Average difficulty
Course: Advanced SQL
Exercise: Create a stored procedure to list Dr Who episodes written by Steven Moffat.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Stored procedures
Level: Harder than average
Course: Advanced SQL
Exercise: Create a stored procedure to list Dr Who episodes by frequency in two ways.

Go to exercise ...

You can search our full list of SQL exercises here, or why not have a look at our other SQL training resources?

This page has 0 threads Add post