cookies-icon

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.

Course

Basic

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.

Table of contents

10 free interactive coding challenges

Lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

limited to this course only

$39

Buy now

Want a better deal?

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

Get unlimited lifetime access to all 65 present and future courses

Save $450

Unlimited lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

to all 65 present and future courses

$149

$599

75% OFF

Buy now
Details
141

Interactive exercises

20 h

Estimated time

590

Users enrolled

☆☆☆☆☆
★★★★★

4 ratings

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

Free

Paid content

0%

Course progress

0/141

Exercises completed

4.

GROUP BY

Practice grouping rows in SQL. Use GROUP BY and aggregate functions.

0/29

Reviews (0)

Average rating

5.00/5

☆☆☆☆☆
★★★★★

4 ratings

Details

5 stars

100%

4 stars

0%

3 stars

0%

2 stars

0%

1 stars

0%