cookies-icon

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.

Course

Basic

SQL Practice: University

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

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 66 present and future courses

Save $450

Unlimited lifetime access

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

to all 66 present and future courses

$149

$599

75% OFF

Buy now
Details
156

Interactive exercises

12 h

Estimated time

549

Users enrolled

☆☆☆☆☆
★★★★★

2 ratings

This SQL practice online course is for beginners who understand the basics of SQL and would like to practice writing SQL queries on examples from a real database.

Unlock your potential with our online SQL practice problems! The exercises are based on a simple database for a university. You’ll work with tables that contain student, lecturer, and course information. Sharpen your skills as you write queries and perform data analysis to uncover key insights. From discovering the curriculum for a specific degree and determining which courses a particular student has attended to creating a list of the courses a given lecturer has taught, our hands-on interactive tasks provide a comprehensive learning experience that enhances your expertise in no time.

There are 156 exercises in this online SQL course. They are grouped into sections by SQL topic: selecting from one table, JOINs, ORDER B, GROUP BY, subqueries, and set operations. Each section of the course starts with a brief review of the SQL syntax needed to solve the exercises. This is followed by hands-on, real-world tasks specially designed to strengthen your SQL skills.

To take full advantage of this course, you should know how to write simple SELECT queries, how to use the WHERE clause, what an SQL JOIN is, and how GROUP BY and HAVING work. You can learn all this in our SQL Basics course. After you finish it, come back here to practice what you learn.

Tailor your learning experience to your unique needs with the flexibility to choose the topics to focus on. By completing all the exercises, you master the basics of SQL and gain the confidence to tackle more advanced projects. We have selected topics that are challenging for beginners and that often appear in exams or job interviews to give you the most comprehensive basic SQL query practice possible.

This course is interactive. You practice writing real SQL queries to solve exercises on your web browser. Our web-based platform runs your command and verifies your solution. You don’t need to install anything on your computer, so you can start practicing right away.

What's in it for me?

  • A great set of 156 interactive SQL exercises. You practice the basics of SQL at your own pace, from anywhere and anytime.
  • Lifetime access to this course. When you purchase it, you get instant access to all of its content.
  • Certificate of completion. You get a downloadable PDF certificate to showcase your accomplishment or to publish on social media.
  • 30-day, money-back guarantee. If you're not satisfied with the quality of the course, you can get a refund within 30 days of your purchase.
  • Hints and support. You can ask questions and share insights with other members of the community through the Discuss tab. You may also drop us a line at contact@learnsql.com, and we'll be more than happy to answer!

What are the requirements?

  • Basic SQL skills (take this awesome SQL Basics course).
  • A web browser.

What will I practice in this course?

  • Writing simple SELECT queries to get data from a single table.
  • Filtering data with WHERE by using different number comparison operators, text patterns, and Boolean conditions, while combining these with AND, OR, and NOT.
  • Sorting query results with ORDER BY, using ASCending and DESCending order.
  • Combining data from multiple tables using JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
  • Writing challenging queries with JOIN, such as multiple JOIN, self-join, and non-equi JOIN.
  • Grouping data with GROUP BY and computing statistics using aggregate functions COUNT(), AVG(), SUM(), MIN(), and MAX().
  • Using mathematical functions to perform simple calculations in SQL.
  • Working with NULL in SQL queries using IS NULL and IS NOT NULL operators.
  • Writing subqueries, including correlated subqueries.
  • Merging query results using set operations UNION, INTERSECT, and EXCEPT.
  • Combining all basic SQL features in a challenging advanced queries section.

Who should take this course?

  • Beginners who need some good SQL practice.
  • People preparing for job interviews that require SQL skills.
  • Students taking database or computer science exams.
  • Entrepreneurs who want to start using SQL to grow their businesses.
  • You!

Table of contents

Free

Paid content

0%

Course progress

0/156

Exercises completed

1.

Selecting from one table

Review your basic SQL knowledge! Practice using SELECT and WHERE to filter data from a single table.

0/33

Introduction

SELECT

WHERE – numbers

WHERE – text

WHERE – NULL

WHERE – Boolean

WHERE – Logical Operators

2.

JOIN

Practice your skills in joining multiple tables using various types of JOINs.

0/31

INNER JOIN

Multiple JOINs

Other JOIN types

Multiple JOINs of different types

Self-joins

Non-equi JOIN

3.

ORDER BY

Practice using ORDER BY and sorting the results of the queries.

0/22

ORDER BY one column

ORDER BY multiple columns

ORDER BY + WHERE

ORDER BY + WHERE + JOIN

4.

GROUP BY

Test your knowledge of grouping in SQL. Practice using aggregate functions and GROUP BY.

0/24

Aggregate functions

GROUP BY one column

GROUP BY multiple columns

HAVING

5.

Other SQL Features

Practice using COUNT(), SUM(), MAX(), MIN() and SQL's mathematical operators. Test your knowledge of NULLs and subqueries.

0/29

Calculations

NULL

Subqueries

Correlated subqueries

Set operators

6.

Advanced queries

Write some more advanced SQL queries using your combined knowledge on SELECT, WHERE, different kinds of JOINs, GROUP BY, HAVING, ORDER BY, set operators, and subqueries.

0/17

Advanced queries

Advanced queries – set 1

Advanced queries – set 2

Advanced queries – set 3

Advanced queries – set 4

Reviews (0)

Average rating

5.00/5

☆☆☆☆☆
★★★★★

2 ratings

Details

5 stars

100%

4 stars

0%

3 stars

0%

2 stars

0%

1 stars

0%