Skip to content

Course Schedule - Section 2/3 (Rehman)

Schedule subject to change, changes will be announced in class and on Ed Discussion.

Section Timings

  • Section 2: Tue/Thu - 12:30pm to 1:50pm - Ryerson 177
  • Section 3: Tue/Thu - 3:30pm to 5:50pm - Rosenwald 011
Week Lecture Topic HW / Assignments Readings
1 Lecture #1
Tuesday
March 21		 Class Intro & Relational Model
  • Administrativa
  • Introduction to DBMSes
Database Systems Concepts
Ch. 1
Lecture #2
Thursday
March 23		 Relational Model & DB Overview
  • Relational Model
  • Database Internals
 Homework 0 Out
Rust Primer Out
 Database Systems Concepts
Ch. 2, Ch. 10.1
2 Lecture #3
Tuesday
March 28		 SQL (1/2)
  • Basics
  • Intermediate SQL
 SQL Out
Database Systems Concepts
Ch. 4, 5
Lecture #4
Thursday
March 30		 SQL (2/2) & Application Development
  • DB Interfaces
  • Web Services
Database Systems Concepts
Ch. 9
3 Lecture #5
Tuesday
April 04		 Schema / Database Design
  • ER Model
  • Relational Database Design
Database Systems Concepts
Ch. 6
Lecture #6
Thursday
April 06		 Data Storage Architectures
  • Data Layout
  • Access Methods
  • Nested Loop Joins
 CrustyDB 1 Out
Database Systems Concepts
Ch. 13.1 - 13.3
Friday
April 07
SQL Due (Noon)
4 Lecture #7
Tuesday
April 11		 Indexes (1/2)
  • Indexing Basics
  • Hash Indices
Database Systems Concepts
Ch. 14.1-14.2, 14.5
Lecture #8
Thursday
April 13		 Indexes (2/2)
  • B+ Trees
Database Systems Concepts
Ch. 14
Friday
April 14
Rust Primer 1 Due (Noon)
5 Lecture #9
Tuesday
April 18		 Advanced Indexes and Buffering
  • LSM Trees
  • Buffer Pools
 CrustyDB 2 Out
Database Systems Concepts
Ch. 13.5, 24.2
Lecture #10
Thursday
April 20		 Query Execution
  • Query Execution Basics
  • Joins
Database Systems Concepts
Ch. 15
Friday
April 21
CrustyDB 1 Due (Noon)
6 Tuesday
April 25 		Midterm Exam
  • 6:30pm - 8:30pm
  • Kent 107
Lecture #11
Thursday
April 27		 Query Optimization
  • Introduction
  • Query Planning
  • Materialized Views
Database Systems Concepts
Ch. 16
7 Lecture #12
Tuesday
May 02		 Transactions
  • Basics
  • Serializability
  • Isolation Levels
 CrustyDB 3 Out
Database Systems Concepts
Ch. 17
Lecture #13
Thursday
May 04		 Concurrency Control
  • Protocols
  • Handling Read/Write Operations
Database Systems Concepts
Ch. 18.1-18.4

Friday
May 05
CrustyDB 2 Due (Noon)
8 Lecture #14
Tuesday
May 09		 Recovery
  • Failure Models
  • ARIES
Database Systems Concepts
Ch. 19
Lecture #15
Thursday
May 11		 Distributed and Parallel DBs (1/2)
  • DB Architectures
  • Parallel and Distributed Storage
Database Systems Concepts
Ch. 20-20.5, 21
9 Lecture #16
Tuesday
May 16		 Distributed and Parallel DBs (2/2)
  • Distributed Transactions
  • Replication
  • CAP Theorem
Database Systems Concepts
Ch. 23
Lecture #17
Thursday
May 18		 Non-Relational Database Systems
  • NoSQL
  • Case Study: DynamoDB

Friday
May 19
CrustyDB 3 Due (Noon)
Finals Week Wednesday
May 24th		 Final Exam (All Sections)
  • 8:00 pm - 10:00 pm
  • KPTC 106 & KPTC 120