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
102,432 Lerners enrolled
Free trial Yes
Certificate of completion Yes
Estimated time 115 h
Courses included 11
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
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
-
SQL JOINs93 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.
-
SQL Practice Set88 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.
-
Basic SQL Practice: A Store169 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.
-
SQL Practice: University156 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.
-
Basic SQL Practice: Run Track Through Queries!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.
-
Basic SQL Practice: Blog & Traffic Data141 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.
-
SQL Subqueries: Real-World Exercises for All Levels82 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.
-
2020 Monthly SQL Practice Sets160 Coding challenges Basic
Practice SQL queries with all coding challenges from 2020!
-
2021 Monthly SQL Practice Sets - Basic93 Coding challenges Basic
Practice SQL queries with all basic coding challenges from 2021!
-
2022 Monthly SQL Practice Sets - Basic86 Coding challenges Basic
Practice SQL queries with all basic coding challenges from 2022!
-
2023 Monthly SQL Practice Sets - Basic86 Coding challenges Basic
Practice SQL queries with all basic coding challenges from 2023!
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills
