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
BasicLooking for SQL practice exercises for beginners? This course is for you! Here are 156 interactive online exercises to refresh your basic SQL skills.
Interactive exercises
Estimated time
Users enrolled
1 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.
Free
Paid content
Course progress
Exercises completed
1.
Review your basic SQL knowledge! Practice using SELECT and WHERE to filter data from a single table.
Introduction
SELECT
WHERE – numbers
WHERE – text
WHERE – NULL
2.
Practice your skills in joining multiple tables using various types of JOINs.
INNER JOIN
Multiple JOINs
Other JOIN types
Multiple JOINs of different types
Self-joins
3.
Practice using ORDER BY and sorting the results of the queries.
ORDER BY one column
ORDER BY multiple columns
ORDER BY + WHERE
4.
Test your knowledge of grouping in SQL. Practice using aggregate functions and GROUP BY.
Aggregate functions
GROUP BY one column
GROUP BY multiple columns
5.
Practice using COUNT(), SUM(), MAX(), MIN() and SQL's mathematical operators. Test your knowledge of NULLs and subqueries.
Calculations
NULL
Subqueries
Correlated subqueries
6.
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.
Advanced queries
Advanced queries – set 1
Advanced queries – set 2
Advanced queries – set 3
Average rating
5.00/5
1 ratings
Details
5 stars
100%
4 stars
0%
3 stars
0%
2 stars
0%
1 stars
0%