- NaN hours only!

Basic Track

SQL Practice

Review and consolidate your SQL skills with tons of interactive exercises! In this learning path, you’ll practice SQL JOINs, aggregation with GROUP BY and HAVING, and subqueries (including correlated subqueries).

4.92 ★★★★★ ★★★★★ (8,220 ratings)

104,495 Lerners enrolled

Want a better deal?

Get unlimited lifetime access to all 73 present and future courses

Save $450

Unlimited lifetime access

to all 73 present and future courses

$149 $599

32h : 23m : 47s 75% OFF

Lifetime access

limited to this track only

$468

Free trial Yes

Certificate of completion Yes

Estimated time 121 h

Courses included 12

Skills you will gain

  • Review SELECT statements and the WHERE clause.
  • Practice SQL joins (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, multiple JOIN, self-JOIN, non-equi JOIN).
  • Review aggregation with GROUP BY and HAVING.
  • Reinforce your knowledge of SQL subqueries (including correlated subqueries).

Last reviews

slide 2 of 3

Description

If you know the basics of SQL and want to keep your coding skills up-to-date, this learning path is for you. These SQL skills can be used with PostgreSQL, MySQL, Oracle, SQL Server, and SQLite database engines. Scroll down for details.

SQL is the most universal database language. Despite the recent explosion of NoSQL, SQL is becoming the preferred interface for data analysis. Whether you’re a student, a business professional, or an SQL enthusiast who’s simply eager to sharpen your skills, there’s always room for improvement.

The SQL Practice path will test your basic SQL knowledge and show you where you need to improve. With plenty of real-world examples and challenging exercises, you’ll brush up your SQL coding skills before you know it. Preparing for an interview? Completing this learning path will help you nail it!

Click “Start for free” and try it yourself!

What's in it for me?

  • Logical, interactive practice exercises. We’ll start with the easier exercises, then work towards the more challenging ones.
  • Learn by doing. Get hands-on practice with our real code editor, real data sets, and real-life problem-solving.
  • Online certification. After successfully completing the course, you will receive a certificate that you can publish on your LinkedIn profile.
  • Trusted support system. Every course comes with access to our resource base, student2student support, mentor2student support, and technical support. You can also join our learning community and participate in on-task discussions.
  • Hints and more. If you get stuck, you can use the included exercise hints. Or use the Discuss tab to ask questions and share insights with other members of the LearnSQL community. You can also drop us a line at contact@learnsql.com and we'll be more than happy to help!

Objectives:

  • Review topics that frequently challenge SQL beginners:
    • SELECT statements and the WHERE clause.
    • SQL joins (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, multiple JOIN, self-JOIN, non-equi JOIN).
    • Aggregation with GROUP BY and HAVING.
    • SQL subqueries (including correlated subqueries).

Who should take this learning path?

  • People who want to solidify their understanding of SQL.
  • Anyone preparing for a job interview involving SQL.
  • People who love a challenge.
  • Students preparing for a SQL test or exam.
  • You!

Requirements:

  • A web browser
  • An internet connection
  • Basic knowledge of SQL (e.g. you’ve completed our SQL Basics course)

Track courses

  1. SQL JOINs
    ★★★★★ ★★★★★ (8250) 93 Coding challenges Basic

    Review and deepen your knowledge of SQL JOINs with 93 exercises. Practice common and less common ways of getting data from multiple tables.

  2. SQL Practice Set
    ★★★★★ ★★★★★ (8038) 88 Coding challenges Basic

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

  3. Basic SQL Practice: A Store
    ★★★★★ ★★★★★ (501) 169 Coding challenges Basic

    Do you want to practice SQL? Are you looking for problems to help you practice what you've learned? You've come to the right place! Here are 169 interactive online exercises that will take your skills to the next level.

  4. SQL Practice: University
    ★★★★★ ★★★★★ (2) 156 Coding challenges Basic

    Looking for SQL practice exercises for beginners? This course is for you! Here are 156 interactive online exercises to refresh your basic SQL skills.

  5. Basic SQL Practice: Run Track Through Queries!
    ★★★★★ ★★★★★ (817) 119 Coding challenges Basic

    Do you like both sports competition and learning? We have something for you. Here are 119 interactive online SQL exercises to help you practice your skills. Challenge yourself, solve problems, and win the race to SQL proficiency.

  6. Basic SQL Practice: Blog & Traffic Data
    ★★★★★ ★★★★★ (4) 141 Coding challenges Basic

    Master SQL with blog and web traffic data for a dog supply store. Dive into data analysis with these 141 interactive online exercises with a pet e-commerce blog database.

  7. SQL Subqueries: Real-World Exercises for All Levels
    ★★★★★ ★★★★★ (4) 82 Coding challenges Basic

    Learn and practice SQL subqueries with over 70 exercises across 6 datasets. Perfect for beginners and those looking to sharpen their skills.

  8. 2020 Monthly SQL Practice Sets
    ★★★★★ ★★★★★ (3303) 160 Coding challenges Basic

    Practice SQL queries with all coding challenges from 2020!

  9. 2021 Monthly SQL Practice Sets - Basic
    ★★★★★ ★★★★★ (2147) 93 Coding challenges Basic

    Practice SQL queries with all basic coding challenges from 2021!

  10. 2022 Monthly SQL Practice Sets - Basic
    ★★★★★ ★★★★★ (1) 86 Coding challenges Basic

    Practice SQL queries with all basic coding challenges from 2022!

  11. 2023 Monthly SQL Practice Sets - Basic
    ★★★★★ ★★★★★ (3) 86 Coding challenges Basic

    Practice SQL queries with all basic coding challenges from 2023!

  12. 2024 Monthly SQL Practice Sets - Basic
    ★★★★★ ★★★★★ (1) 91 Coding challenges Basic

    Practice SQL queries with all basic coding challenges from 2024!

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Reviews (17)

Average rating

4.92/5

★★★★★ ★★★★★ (8220 ratings)

5 stars

95%

4 stars

5%

3 stars

0%

2 stars

0%

1 stars

0%

★★★★★
★★★★★
03/16/2021

Practice makes perfect!

Linda Shepard

★★★★★
★★★★★
03/12/2021

This set is a great way to cement the knowledge I've learnt previously through LearnSQL.

John McClain

★★★★★
★★★★★
03/03/2021

Good hands-on experince. Thinking required.

Tamera Raschelle

★★★★★
★★★★★
01/26/2021

Icing on the cake, great way to practice on a great platform.

Luke Allen

★★★★★
★★★★★
01/19/2021

A good set of tasks to test different SQL skills. Don't hasitate to get this one!

Maria Morales

★★★★★
★★★★★
01/14/2021

Perfect training before harder SQL exams.

Randell REV

★★★★★
★★★★★
12/30/2020

Great place to practice SQL

Terrell Howell

★★★★★
★★★★★
12/27/2020

I like the variety of skills/syntax tested in this set. Definitely a course for people wanting to keep their skills crisp.  

Paula Schmitz

★★★★★
★★★★★
12/14/2020

Perfect practice for people getting started with SQL

Molly Spencer

★★★★★
★★★★★
11/25/2020

Grandes tutoriales, ¡Se los recomiendo a todos! Especialmente si te preocupan los ejercicios prácticos.

Luis Preciado