Home > Computer training exercises > SQL

Free SQL exercises

Click on any SQL exercise category below to see what exercises it contains:

SQL topic	No. exercises
Creating databases - overview	2
Simple Queries	4
Setting criteria using WHERE	4
Outputting to Excel	1
Calculations	4
Calculations using dates	3
Basic joins	2
More exotic joins	2
Aggregation and grouping	3
More complicated grouping	1
Views	3
Subqueries	2
Scalar functions	4
Overview of stored procedures	3
Transactions	2
Stored procedure basics	1
Variables	5
Parameters and return values	4
Testing conditions	1
Looping	1
Creating tables	2
Temporary tables and table variables	5
Table-valued functions	3
Derived tables and CTEs	4
Cursors	3
Avoiding scalar functions	3
Error-handling	2
Dynamic SQL	1

These SQL exercises are provided to allow potential course delegates to assess their suitability for the relevant Wise Owl course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Follow @WiseOwlTraining

Free SQL exercises

MAIN LINKS

TYPES OF TRAINING

NEW COURSES