Course

Basic

SQL Practice Set

Refine your SQL skills with 88 interactive exercises, ranging from simple tasks with SELECT FROM statements to more advanced problems involving multiple subqueries.

Table of contents

10 free interactive coding challenges

Lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

limited to this course only

$39

Buy now

Want a better deal?

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

Get unlimited lifetime access to all 69 present and future courses

Save $450

Unlimited lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

to all 69 present and future courses

$149

$599

75% OFF

Buy now
Details
88

Interactive exercises

10 h

Estimated time

98375

Users enrolled

☆☆☆☆☆
★★★★★

8038 ratings

Mastering SQL is a hands-on experience — learning the concepts is one thing, but writing good queries requires practice. Whether you’re a complete beginner, someone who just finished our SQL Basics course, or an SQL enthusiast who’s simply eager to hone their skills, there’s always room for improvement. This practice set tests your basic SQL knowledge and shows you where you need to improve.

Cover image for the course 'SQL Practice Set'

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 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
  • Students taking courses in relational databases
  • Beginning programmers interested in SQL
  • Business database users who want to improve their querying skills
  • Anyone who finished the SQL Basics course or has equivalent knowledge
  • Anyone who wants to practice writing SQL queries

Table of contents

Free

Paid content

0%

Course progress

0/88

Exercises completed

1.

Warm up: Selecting from one table

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

0/9

Introduction

Exercises

2.

Aggregation and grouping

Test your knowledge of GROUP BY and ORDER BY clauses.

0/11

Introduction

Exercises

3.

JOINs

Practice using JOIN, LEFT JOIN, and non-equi JOIN. Check your skills of working with multiple tables.

0/32

Introduction

Exercises with artists, museums and their pieces of art

Exercises with the band members table

Exercises with tables of Japanese 100 Yen store

Exercises with employees, salaries and benefits

4.

Subqueries

Verify your knowledge of subqueries. Practice simple and correlated subqueries.

0/15

Introduction

Exercises

5.

SQL Challenge

Practice your SQL skills. Write SQL queries which combine SELECT, WHERE, JOIN, GROUP BY, HAVING, ORDER BY and subqueries.

0/21

Introduction

Challenge with artists

Challenge with orchestras

Reviews (1)

Average rating

4.87/5

☆☆☆☆☆
★★★★★

8038 ratings

Details

5 stars

90%

4 stars

10%

3 stars

0%

2 stars

0%

1 stars

0%