Refine your SQL Server skills with 88 interactive exercises, ranging from simple tasks with SELECT and FROM statements to more advanced problems involving multiple subqueries.
Ultimate money saver
With our Forever plan this course will cost you only
39 hours left
Whether you're a complete beginner, someone who just finished our SQL Basics in MS SQL Server course, or an SQL Server enthusiast who's simply eager to hone their skills, there's always room for improvement. This practice set will test your basic SQL knowledge and will show you where you need to improve. Remember that mastering SQL is a hands-on experience - learning the concepts is one thing, but writing good queries requires practice.
The scope of this practice set includes:
The last two parts of the course comprise a special challenge that combines all of the above material for a comprehensive review.
Just a web browser and an Internet connection
Review the fundamentals of SQL. Practice using SELECT and WHERE to filter data.
Test your knowledge of GROUP BY and ORDER BY clauses.
Practice using JOIN, LEFT JOIN, and non-equi JOIN. Check your skills of working with multiple tables.
Exercises with artists, museums and their pieces of art
Exercises with the band members table
Exercises with tables of Japanese 100 Yen store
Verify your knowledge of subqueries. Practice simple and correlated subqueries.
Practice your SQL skills. Write SQL queries which combine SELECT, WHERE, JOIN, GROUP BY, HAVING, ORDER BY and subqueries.
Challenge with artists
Challenge with orchestras