Course
BasicDo 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.
The best way to learn SQL is through practice. After all, writing SQL is a practical skill. However, it's difficult to find good SQL practice problems for beginners. That's why we created this course.
Have you just started learning SQL? Or, maybe you already know the basics and are now looking for new challenges. If so, this course is for you. It will allow you to practice writing basic SQL queries.
Try to solve 169 interactive exercises grouped into different SQL topics: selecting from one table, JOINs, ORDER BY, 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.
You can choose only the topics that are difficult for you. Or, you can complete all of them to make sure you have mastered the basics of SQL. We selected topics that are challenging for beginners and often appear in exams or during job interviews to give you the most comprehensive SQL practice possible.
The exercises in this online SQL problem set are based on a database for a simple store. You'll work with tables that contain customer, product, purchase, and employee data. And you'll practice writing queries such as how to list top-selling products, how to identify the best employees, and how to identify which customers have spent the most in the store.
Our Basic SQL Practice course gives you the opportunity to practice frequently used queries on a simple database. You will be able to immediately apply some of them in your projects, while others can be easily adapted.
Do you run a shop or online store? Learn how to master the data you collect. This will help you gain even greater profits. Knowing how to use SQL simply pays off.
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 this all in our SQL Basics course. After you finish it, come back here to practice what you learned.
This course is interactive. You'll practice writing actual SQL queries to solve exercises in your web browser. Our web-based platform will run your command and verify your solution. You don't need to install anything on your computer, so you can start practicing right away.
Course progress
Exercises completed
1.
Review the fundamentals of SQL. Practice using SELECT and WHERE to filter data.
2.
Practice using JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, and non-equi JOIN. Check your skills of working with multiple tables.
3.
Practice sorting the rows by single and multiple columns.
4.
Test your knowledge of GROUP BY and HAVING clauses.
5.
Practice making calculations and dealing with NULLs and set operators. Verify your knowledge of subqueries. Practice simple and correlated subqueries.
6.
Write some more advanced queries which combine SELECT, WHERE, different kinds of JOINs, GROUP BY, HAVING, ORDER BY, set operators, and subqueries.