0 / 15
0% Complete
1
1. The Foundation (SELECT & FROM)
Learn the two commands that start every database query.
2
2. Filtering Data (WHERE)
Extract specific rows using conditions.
3
3. Sorting Data (ORDER BY)
Organize your results from highest to lowest.
4
4. Finding Uniques (DISTINCT)
Remove duplicates from your reports instantly.
5
5. Advanced Filtering (IN & LIKE)
Filter by lists or fuzzy text matches.
1
1. Merging Datasets (INNER JOIN)
Merge tables together using shared keys.
2
2. Handling Missing Data (LEFT JOIN)
Keep all records from one table, even if they don't match.
3
3. Executive Aggregation (GROUP BY)
Calculate totals and averages by category.
4
4. Filtering Aggregations (HAVING)
Learn to filter based on averages and sums.
5
5. Conditional Logic (CASE WHEN)
Write If/Else statements directly inside your database queries.
1
1. Organizing Chaos (CTEs)
Use Common Table Expressions (WITH clause) to build modular SQL.
2
2. Nested Queries (Subqueries)
Write a query inside another query.
3
3. The Game Changer (Window Functions)
Calculate rankings without collapsing your rows.
4
4. Time Travel (Date Math)
Extract months and years from timestamps.
5
5. Data Cleaning (String Math)
Fix messy text data instantly using SQL.