Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.



SQL Practice Set in MS SQL Server

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.

Table of contents

10 free interactive coding challenges

Lifetime access


limited to this course only


Buy now

Want a better deal?


Get unlimited lifetime access to all 65 present and future courses

Save $450

Unlimited lifetime access


to all 65 present and future courses



75% OFF

Buy now

Interactive exercises

10 h

Estimated time


Users enrolled


2995 ratings

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.

Cover image for the course 'SQL Practice Set in MS SQL Server'

The scope of this practice set includes:

  • simple SELECT queries;
  • aggregate functions (COUNT(), SUM(), AVG());
  • grouping and ordering results;
  • JOINs (querying from multiple tables, self joins, LEFT JOIN, RIGHT JOIN, and non-equi JOINs);
  • subqueries (simple subqueries, subqueries with multiple results, correlated subqueries, and subqueries in the FROM and SELECT clauses).

The last two parts of the course comprise a special challenge that combines all of the above material for a comprehensive review.

What's in it fo Me?

  • 88 interactive exercises. Learn at your own pace, from any location and at any time. Work through hands-on exercises to help you retain what you have learned so far.
  • Lifetime access to the course. When you purchase the online course, you'll get instant personal access to all of its content forever.
  • Online certificate. After you successfully finish all of the exercises in the online course, you'll receive a downloadable PDF certificate to showcase your accomplishment.
  • 30-day money-back guarantee. If you're not satisfied with the quality of the online course, you can get a refund within 30 days of your purchase.
  • Exercise hints. You can take advantage of ready-made hints for every exercise, or ask questions and share insights with other members of our community through the Discuss tab. You can also drop us a line at, and we'll be more than happy to answer!

What Do You Need To Take This Course?

Just a web browser and an Internet connection

Who Should Take This Course?

  • Analysts who use relational databases
  • People preparing for a job interview that requires knowledge of MS SQL Server
  • Students taking courses in relational databases
  • Beginning programmers interested in SQL or SQL Server in particular
  • Anyone who finished the SQL Basics in MS SQL Server course or has equivalent knowledge
  • Anyone who wants to practice writing SQL queries in MS SQL Server

Table of contents


Paid content


Course progress


Exercises completed


Warm up: Selecting from one table

Review the fundamentals of SQL. Practice using SELECT and WHERE to filter data.

Start now

Reviews (17)

Average rating



2995 ratings


5 stars


4 stars


3 stars


2 stars


1 stars