Basic Course
SQL Practice Set
Refine your SQL skills with 88 interactive exercises, ranging from simple tasks with SELECT FROM statements to more advanced problems involving multiple subqueries.
4.87
99,757 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 10 h
Coding challenges 88
Skills you will gain
- Write simple SELECT queries to retrieve specific data from databases.
- Use aggregate functions like COUNT, SUM, and AVG for data analysis.
- Group and order data to produce organized results.
- Perform various types of JOINs to combine data from multiple tables.
- Construct subqueries to handle complex queries within queries.
- Solve comprehensive SQL challenges to reinforce and integrate your SQL skills.
Last reviews
Description
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
Table of contents
Course progress 0%
Exercises completed 0/88
-
Review the fundamentals of SQL. Practice using SELECT and WHERE to filter data.
-
Test your knowledge of GROUP BY and ORDER BY clauses.
-
Practice using JOIN, LEFT JOIN, and non-equi JOIN. Check your skills of working with multiple tables.
-
Verify your knowledge of subqueries. Practice simple and correlated subqueries.
-
Practice your SQL skills. Write SQL queries which combine SELECT, WHERE, JOIN, GROUP BY, HAVING, ORDER BY and subqueries.
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills