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.
Looking for SQL challenges? You've come to the right place. Here's another batch of hands-on exercises to help you improve your SQL skills.
This SQL practice course is designed for beginners who know the basics of SQL and want practice exercises to review and hone their SQL skills.
The exercises in this course are based on a database that records the blog traffic of a dog supply store. The blog is a promotional tool for the store's products and includes articles about products for dogs as well as advice and guidance for pet owners about dog care, dog training, grooming, and feeding. We have created all tasks to resemble a real scenario as much as possible. So, expect real-life problems to solve by writing SQL queries.
The database holds information about the articles published on the blog, their authors, daily article traffic, and user traffic from the articles to specific product pages. Using your SQL skills on the data from the database, you will analyze the popularity of the articles, the quality of work by the authors, and the effectiveness of article-driven product promotions.
This interactive course consists of 141 exercises and requires approximately 20 hours to complete. It is divided into six parts, each addressing a different SQL topic that beginners often find challenging. The first part addresses retrieving data from a single table, and the next part focuses on various types of JOINs. In the third part, you practice sorting rows using the ORDER BY clause. Next, you dive into grouping rows using the GROUP BY clause and using aggregate functions in SQL. The fifth part delves into more advanced SQL features, such as mathematical computations, handling of NULL values, and subqueries. Finally, we provide a place for hands-on practice in combining the different SQL features. Each part starts with a brief overview of the topic, followed by a set of exercises designed to solidify your understanding.
To take full advantage of this course, you should know how to write simple SELECT statements, 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.
You may want to adjust your study plan according to your preferences. You may even want to focus on specific areas. When you complete all the exercises, you'll have a solid understanding of the SQL basics, and you’ll be prepared to take on more complex assignments. The course has been structured to include topics that are often a struggle for beginners and commonly seen in evaluations or job interviews, providing a balanced and practical approach to basic SQL query practice.
This course offers an interactive learning experience. You hone your SQL skills by writing SQL queries and solving tasks directly in your web browser. Our online platform executes your SQL code and validates your solutions. There's no need to install anything on your device, which means you start practicing immediately.
Review the fundamentals of SQL. Practice using SELECT and WHERE to filter data.
Practice using JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN. Check your skills of working with multiple tables.
Practice sorting the rows by single and multiple columns.
Practice grouping rows in SQL. Use GROUP BY and aggregate functions.
Practice using COUNT(), SUM(), MAX(), MIN() and SQL's mathematical operators. Test your knowledge of NULLs and subqueries.
Challenge yourself and try writing some more advanced queries! Use all of the skills you practiced in the previous parts: selecting from a table, joining tables, using ORDER BY, GROUP BY, aggregate functions and mathematical operations, and writing subqueries.