This site contains the course content for SQL for Data Analytics. Due dates, submissions, and grades are in Canvas.
New here? Begin with Start here. Go through its pages in order, then do its practice and turn it in on Canvas.
Course resources
Getting started
Asking questions of data
Unit 01
Data and tables
Introduction to Data Analytics and Relational Data.
Unit 02
Querying single tables
Basic Querying: SELECT, math on columns, aliasing, WHERE, ORDER BY, LIMIT.
Unit 03
Aggregation
Aggregate functions, GROUP BY, HAVING, and the order a query runs in.
Unit 04
Answering a business question
Taking a real request from start to finish: what one row means, COUNT(DISTINCT), and checking your answer.
Unit 05
Joining tables
Table relationships, JOINs, joining several tables at once, and LEFT JOIN with the NULLs it leaves behind.
Unit 06
AI in Data Analytics
How to use AI to do data analytics.
Midterm
Midterm check-in
How the midterm check-in works, and the review game to get ready for it.
Designing data
Unit 07
Reading database designs
Entity Relationship Diagrams: structure, relationships, data types and nullability, querying from diagrams.
Unit 08
Building and changing tables
Creating databases and tables, putting rows in and changing them, and the constraints that keep bad data out.
Unit 09
Modeling relationships
Many-to-many relationships and joining tables, table aliases, drawing your own diagrams, and composite primary keys.
Unit 10
Database design
Designing a database from a business problem, one decision at a time, with a sales opportunity tracker for a consulting company.
Unit 11· coming soon
Subqueries
Subqueries.
Final
Final exam
When and where the final is, how it works, and the cheat sheet you'll get.
For instructors
Nothing here is part of the course. If you're a student, you can ignore it.