Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
As part of our ongoing learning journey, we'll be diving into so many topics to scale your SQL game:
If you have no idea what's all of this, don't worry, you WILL soon!
Using GROUP BY
Square Payments
Rewarding Creators with Stars
Ordering Aggregate Values
Top Amazon Buyers
Top 3 Spenders buyer_ids
Top Uber Drivers
Using HAVING
Finding Performing Categories
Removing Outliers
Exclude Most Performing Category
Congratulations
Using CASE in SELECT statement
Categorizing Post Engagement
Product Review Analysis
Listing Performance Analysis
Using CASE within Aggregate Functions
Categorizing Payment Amounts
Monthly Payment Analysis by Category
Congratulations
Why do we need many tables?
Syntax of a Join
Using INNER JOIN
Number of Buyers
Top 3 Spenders
Percentage Spendings in Electronics
Using LEFT JOIN
Users Sending Gifts
Users Funnel Analysis
Spend per User by Country
Using OUTER JOIN
Combining User Engagement Data
SELF JOIN
M2 to M1 Viewer Retention
Find Duplicate Jobs
Congratulations