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

Requirements:

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.

Report Problem

• Issue: *
  Expired Coupon Invalid Link Duplicate Post New Coupon Available Others

• Details: *
  

Submit