Basic Course

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.

4.87 ★★★★★ ★★★★★ (8038 ratings)

99,757 learners enrolled

Lifetime access

limited to this course only

$19 $39

51% OFF

Buy now

Want a better deal?

Get unlimited lifetime access to all 74 present and future courses

Save $450

Unlimited lifetime access

to all 74 present and future courses

$149 $599

75% OFF

Free trial Yes

Certificate of completion Yes

Time to complete 10 h

Coding challenges 88

Skills you will gain

  • Write simple SELECT queries to retrieve specific data from databases.
  • Use aggregate functions like COUNT, SUM, and AVG for data analysis.
  • Group and order data to produce organized results.
  • Perform various types of JOINs to combine data from multiple tables.
  • Construct subqueries to handle complex queries within queries.
  • Solve comprehensive SQL challenges to reinforce and integrate your SQL skills.

Last reviews

Description

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

Course progress 0%

Exercises completed 0/88

  1. Warm up: Selecting from one table

    0/9

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

  2. Aggregation and grouping

    0/11

    Test your knowledge of GROUP BY and ORDER BY clauses.

  3. JOINs

    0/32

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

  4. Subqueries

    0/15

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

  5. SQL Challenge

    0/21

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

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Reviews (1)

Average rating

4.87/5

★★★★★ ★★★★★ (8038 ratings)

5 stars

90%

4 stars

10%

3 stars

0%

2 stars

0%

1 stars

0%