Lecture 4 Aggregates

Lecture 5 Joins and Aggregates

Lecture 6-7 SQL Subqueries

Lecture 8 Relational Algebra

Lecture 9 ER Diagram

Lecture 10 Design Theory

Lecture 11 BCNF Decomposition

Lecture 13 Transactions Schedules

Lecture 14 Transactions Locks

Lecture 15 Transactions Isolation Levels

Lecture 16 Cost Estimation

Lecture 17 Tuning and Indexes

Lecture 18 Introduction to Parallel DBMS

Lecture 19 MapReduce and Spark

Lecture 21 Semi-structured Data

Lecture 22 SQL++ Nesting