• Syllabus

Week 15

• Section 15: Indexes

Week 14

• Section 14: Transactions and Concurrency Control

Week 13

• Section 13: Advanced Stored Programs

Week 12

• Section 12: Introduction to Stored Programs

Week 11

• Section 11: Data Definition Language
• Assignment 6: Creating a Schema

Week 10

• Section 10: Data Manipulation Language
• Assignment 5: Importing/Exporting Database Data

Week 9

• Section 9: SQL Data Manipulation Functions
• Assignment 4: Business Analytics

Week 8

Midterm

Week 7

• Section 8: Subqueries & Complex Query Management

Week 6

• Section 7: Joins & Unions

Week 5

• Section 6: Aggregates & Grouping
• Assignment 3: SQL Investigator

Week 4

• Section 5: SQL Introduction
• Assignment 2: Exploring PostgreSQL & SQLite CLI

Week 3

• Section 4: Normalization

Week 2

• Section 2: Relational Foundations
• Section 3: Entity Relationship Diagrams

Week 1

• Section 1: Intro to Databases
• Docker Setup Guide