Skip to content

Course Schedule - Section 1 (Elmore)

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

Section Timings

  • Section 1: Mon/Wed - 3:00pm to 4:20 - Stuart Hall 102
Week Lecture Topic HW / Assignments Readings
1 Lecture #1
Monday
March 20		 Introduction
  • Administrativa
  • Introduction to DBMSes
Database Systems Concepts
Ch. 1
Lecture #2
Wednesday
March 22		 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
Monday
March 27		 SQL (1/2)
  • Basics
  • Intermediate SQL
 SQL Out
Database Systems Concepts
Ch. 4, 5
Lecture #4
Wednesday
March 29		 SQL (2/2) & Application Development
  • DB Interfaces
  • Web Services
Database Systems Concepts
Ch. 9
3 Lecture #5
Monday
April 03		 Schema / Database Design
  • ER Model
  • Relational Database Design
Database Systems Concepts
Ch. 6
Lecture #6
Wednesday
April 05		 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
Monday
April 10		 Indexes (1/2)
  • Indexing Basics
  • Hash Indices
Database Systems Concepts
Ch. 14.1-14.2, 14.5
Lecture #6
Wednesday
April 12		 Indexes (2/2)
  • B+ Trees
Database Systems Concepts
Ch. 14
Friday
April 14
Rust Primer 1 Due (Noon)
5 Lecture #9
Monday
April 17		 Advanced Indexes and Buffering
  • LSM Trees
  • Buffer Pools
 CrustyDB 2 Out
Database Systems Concepts
Ch. 13.5, 24.2
Lecture #10
Wednesday
April 19		 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
Wednesday
April 26		 Query Optimization
  • Introduction
  • Query Planning
  • Materialized Views
Database Systems Concepts
Ch. 16
7 Lecture #12
Monday
May 01		 Transactions
  • Basics
  • Serializability
  • Isolation Levels
 CrustyDB 3 Out
Database Systems Concepts
Ch. 17
Lecture #13
Wednesday
May 03		 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
Monday
May 08		 Recovery
  • Failure Models
  • ARIES
Database Systems Concepts
Ch. 19
Lecture #15
Wednesday
May 10		 Distributed and Parallel DBs (1/2)
  • DB Architectures
  • Parallel and Distributed Storage
Database Systems Concepts
Ch. 20-20.5, 21
9 Lecture #16
Monday
May 15		 Distributed and Parallel DBs (2/2)
  • Distributed Transactions
  • Replication
  • CAP Theorem
Database Systems Concepts
Ch. 23
Lecture #17
Wednesday
May 17		 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