Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

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.

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
    Start for free
    Gift this course

    Bundle deals

    86%
    off

    Reg. price
    $1442

    One to Rule 'Em All

    Includes 36 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS, How to Read and Write Excel Files in Python

    Bundle price $199

    35 hours left at this price!

    Buy bundle

    67%
    off

    Reg. price
    $369

    SQL Complete Track

    Includes 9 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Window Functions, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, PostGIS

    Bundle price $119

    35 hours left at this price!

    Buy bundle

    48%
    off

    Reg. price
    $193

    SQL First Aid

    Includes 5 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Tables in SQL

    Bundle price $99

    35 hours left at this price!

    Buy bundle

    47%
    off

    Reg. price
    $187

    Basic Data Analytics

    Includes 5 courses SQL Basics, SQL Practice Set, SQL JOINs, Statistics 101, Introduction to Python for Data Science

    Bundle price $99

    35 hours left at this price!

    Buy bundle

    Table of contents

    Progress: 0% completed 0 of 88 exercises done

    1. Warm up: Selecting from one table

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

    More details Less
    Start now

    0% completed 0 of 9 exercises done

    2. Aggregation and grouping

    Test your knowledge of GROUP BY and ORDER BY clauses.

    More details Less
    Start now

    0% completed 0 of 11 exercises done

    3. JOINs

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

    More details Less
    Start now

    0% completed 0 of 32 exercises done

    4. Subqueries

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

    More details Less
    Start now

    0% completed 0 of 15 exercises done

    5. SQL Challenge

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

    More details Less
    Start now

    0% completed 0 of 21 exercises done

    Reviews

    Average rating

    4.6/592.14285714285714 (28)

    Details

    5 Stars 81%
    4 Stars 7%
    3 Stars 4%
    2 Stars 4%
    1 Stars 4%
      Load more reviews

      Comments

      0