FreeBeginner to intermediate

SQL for Data Analysis

SQL is how analysts get answers out of databases. In this course you work with Harbourline Freight, a fictional logistics company, and answer the questions its managers actually ask: who ships the most, which routes run late, what customers still owe. Every lesson starts with a business problem, explains the idea in plain language, and gives you queries to write in a live SQL editor in your browser.

About 12 hours
16 lessons
Final project
Certificate of completion

Curriculum

01Introduction to DatabasesWhat a database is, how tables connect, and your first query against a real one.20 min
02Relational Databases and SQL ToolsWhat a relational database is, the database products you'll meet at work, how their SQL differs, and how to find your way around SQL Server Management Studio and MySQL Workbench.30 min
03SELECTChoose the columns you need, rename them, calculate new ones and remove duplicates.25 min
04WHEREFilter rows with comparisons, AND/OR, IN, BETWEEN, LIKE and NULL checks.30 min
05ORDER BYSort results by one or more columns, in ascending or descending order.20 min
06LIMITReturn only the first rows of a result to answer "top N" questions and page through data.15 min
07Aggregate FunctionsSummarise many rows into one answer with COUNT, SUM, AVG, MIN and MAX.25 min
08GROUP BYCalculate totals and counts for each customer, route, month or status.30 min
09HAVINGFilter groups after they're calculated, such as customers with more than 30 shipments.20 min
10JOINsCombine tables with INNER JOIN and LEFT JOIN, and find records with no match.35 min
11CASE StatementsCreate categories and labels with CASE, and use it to count and compare groups.25 min
12SubqueriesUse the result of one query inside another, in WHERE, SELECT and FROM.30 min
13CTEsBreak complex questions into named steps with WITH, and avoid double-counting when combining totals.30 min
14Window FunctionsRank rows, number them within groups and calculate running totals without losing detail.35 min
15Business Analysis with SQLTurn a vague business question into precise queries, check your numbers, and present a clear answer.40 min
16Final ProjectThe brief for your final project, the Harbourline Freight operations review, and how it's assessed.15 min

Loading…