Mastering SQL Functions and Clauses
Take your SQL expertise to the next level by harnessing the power of SQL functions. Using data from an online shopping platform, this course delves into advanced SQL functions and clauses, helping you summarize, count, and differentiate data to gain deeper insights into shopping datasets.
Lessons and practices
Counting Rows in SQL
Counting Conditioned Rows in Orders Table
Fix the SQL Query
Counting Rows in a Table
Counting Selected Customer Orders
Extracting Category IDs Query
Finding Unique Category IDs
Fix the Unique Category Query
Unique Product with Support Retrieval
Unique Product Identification Task
Summing Orders by Category
Summing Items Sold by Categories
Fix the Aggregate Function Query
Summarize Events by Category
Mastering SQL Aggregate Functions
Exploring Yearly Shop Performance
Analyzing Yearly Shop Performance
Analyze Shop Performance by Years
Grouping Matches by Season
Counting Supports by Order Date for Specific Years
Fix SQL Aggregation Query
Fix the Aggregate Query
Calculate Average Supports Selected Per Year
Calculate Total Supports Selected
Aggregate Yearly Extended Supports
Interested in this course? Learn and practice with Cosmo!
Practice is how you turn knowledge into actual skills.