Move from spreadsheets to structured databases with normalization, SQL extraction, joins, CTEs, window functions and BI-ready Star Schema modeling.
What You'll Learn
1NF, 2NF, 3NF and table constraints
SELECT, FROM, WHERE, LIKE and NULL handling
INNER, LEFT, RIGHT and FULL OUTER JOIN
GROUP BY, HAVING and CASE WHEN
Subqueries and Common Table Expressions
ROW_NUMBER, RANK, LAG and LEAD
Power BI/Tableau connections to live SQL sources
Fact/Dimension tables and enterprise Star Schemas
Month 2 Capstone — Transactional Database BlueprintNormalize a flat retail dataset, execute complex joins and window partitions, and build a verified schema model.