Basic Course
Basic SQL Practice: Blog & Traffic Data
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.
5.00
1,123 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 20 h
Coding challenges 141
Skills you will gain
- Write basic SELECT queries to retrieve information from a single table.
- Filter data with WHERE by using numeric comparison operators, text patterns, and Boolean conditions, then combining them with AND, OR, and NOT.
- Sort query results with ORDER BY, using ASCending and DESCending order.
- Combine data from multiple tables using JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
- Compose complex queries incorporating multi-table JOIN.
- Group data with GROUP BY and calculating statistics by applying aggregate functions COUNT(), AVG(), SUM(), MIN(), and MAX().
- Use mathematical functions to perform simple calculations in SQL.
- Handle NULL in SQL queries using the IS NULL and IS NOT NULL operators.
- Write subqueries, including correlated subqueries.
- Combine all basic SQL features in a challenging advanced queries section.
Last reviews
Description
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.
What's in it for me?
- A collection of 141 engaging SQL exercises for you to practice SQL basics at a speed that suits you, from any location, and at any time.
- Lifetime access to this course. Upon purchase, you have immediate access to all its content.
- Certificate of completion. You receive a PDF certificate you can download and display to prove your achievement or post on social media platforms.
- 30-day refund policy. If you find the course not up to your expectations, you're entitled to a full refund within 30 days of your initial purchase.
- Hints and support. You're welcome to engage in discussions, pose questions, and exchange thoughts with fellow community members via the Discuss tab. Additionally, feel free to email us at contact@learnsql.com. We're always ready to assist you!
What are the requirements?
- Basic SQL skills (take this awesome SQL Basics course).
- A web browser.
What will I practice in this course?
- Writing basic SELECT queries to retrieve information from a single table.
- Filtering data with WHERE by using numeric comparison operators, text patterns, and Boolean conditions, then combining them with AND, OR, and NOT.
- Sorting query results with ORDER BY, using ASCending and DESCending order.
- Combining data from multiple tables using JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
- Composing complex queries incorporating multi-table JOIN.
- Grouping data with GROUP BY and calculating statistics by applying aggregate functions COUNT(), AVG(), SUM(), MIN(), and MAX().
- Using mathematical functions to perform simple calculations in SQL.
- Handling NULL in SQL queries using the IS NULL and IS NOT NULL operators.
- Writing subqueries, including correlated subqueries.
- Combining all basic SQL features in a challenging advanced queries section.
Who should take this course?
- Beginners who need some good SQL practice.
- People preparing for interviews for jobs that require SQL skills.
- Students taking database or computer science exams.
- Entrepreneurs who want to start using SQL to grow their businesses.
- Bloggers who struggle with analyzing their data.
- Marketing managers and marketing analysts who need to analyze website traffic data as a part of their job responsibilities.
- You!
Table of contents
Course progress 0%
Exercises completed 0/141
-
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.
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills