SQL is the language of data. Every data analyst uses it. This module takes you from installing SQL to writing complex queries with joins, window functions, CTEs — and a full healthcare data analysis project you can add to your portfolio.
3.1🔒Introduction to SQL & Databases — Install & Understand SQL on Windows7:29
3.2🔒SQL Tables — Create, Insert & View Data12:26
3.3🔒SELECT, WHERE & ORDER BY Clauses13:05
3.4🔒Primary Key vs Foreign Key + Importing Data into SQL11:23
3.5🔒SQL Aggregation Functions with Real Healthcare Data16:14
3.6🔒GROUP BY vs HAVING vs WHERE Explained9:55
3.7🔒SQL JOINS — INNER, LEFT, RIGHT, FULL OUTER with Examples20:09
3.8🔒SQL DDL vs DML vs DCL with Real-Life Examples16:53
3.9🔒CASE Statement & Nested CASE in SQL17:46
3.10🔒Mastering Subqueries in SQL13:16
3.11🔒CTEs vs Temporary Tables — Simplifying Complex Queries14:38
3.12🔒PARTITION BY & Window Functions — RANK, DENSE_RANK, ROW_NUMBER13:05
3.13🔒Healthcare Data Project — Exploration, Preparation & Cleaning (Part 1)31:28
3.14🔒Healthcare Data Project — Full Analysis (Part 2)21:08
3.15🔒Advanced: How to Clean Data in Excel Before SQL Import12:31