Basic SQL Practice: Blog & Traffic Data

This course offers an interactive learning experience for SQL, focusing on real-life scenarios related to blog and traffic data. It contains 141 interactive exercises designed to help learners practice SQL and strengthen their skills.

Created by: Jakub Romanowski

Last Updated By: Jakub Romanowski

Language: The language of instruction is not specified in the provided information.

What You’ll Learn:

  • 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 and then combining them with AND, OR, and NOT.
  • Sorting query results in ascending or descending order with ORDER BY.
  • Combining data from multiple tables using JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
  • Composing complex queries incorporating multi-table JOINs.
  • Grouping data with GROUP BY and calculating statistics by applying the 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.

This Course Includes:

  • Interactive exercises to practice SQL
  • Hands-on practice with real-life scenarios
  • Immediate feedback on SQL solutions


Understanding core SQL concepts is essential to fully benefit from this course.

It is recommended to complete the SQL Basics course before starting this practice course.

Get This Free Course


Pin It on Pinterest