- Lecture 1 - What is a database?
- Lecture 2 - Databases and DBMS in a nutshell
- Lecture 3 - Relational Model
- Lecture 4 - SQL DDL and DML
- SQL Examples on Altering Tables and Deleting Data
- Lecture 5 - LabThreeSixFive and MySQL Client
- Lecture 6 - SQL Date Type Conversions
- Lecture 7 - Relational Algebra
- Lecture 8 - SQL Select Statement
- Lecture 9 - Aggregate Operations
- Lecture 10 - Group By
- Lecture 11 - Example for Group By
- Lecture 12 - Subqueries
- Lecture 13 - Additional SQL Syntax: WITH, IF & ELSE, CASE & WHEN
- Lecture 14 - JOIN Syntax and Outer Joins
- Lecture 15 - Complex SQL Queries
- Lab 1-1
- Lab 1-2
- Lab 2: SQL DDL, DML
- Lab 3: SQL DDL, DML + Python
- Lab 4: SQL SELECT
- Lab 5: SQL SELECT and Counting
- Lab 6: Counting and grouping
- Lab 7: Complex SQL Queries
- Lab 8: URBANUNREST DB
- Homework 1
- HW 1 Solutions
- Some solutions may be inaccurate
- HW 1 Solutions