CMSC424 Spring 2014: Detailed Syllabus and Lecture Notes

Note: Many slides copied and modified from Amol Deshpande, Nick Roussopoulos, and www.db-book.org.
Many thanks to all of them!

Date

Topic

Book

Lecture Notes

Jan 27

Introduction


Class policies

Introduction

Jan 29

Relational Model

Chapter 1

Deeper introduction

Feb 4

SQL

 Chapter 2

SQL

Feb 6

SQL



Feb 11

SQL


Advanced SQL

Feb 13

SQL

Chapter 3

SNOW DAY

Feb 18

SQL; Relational Algebra

Chapter 5, 6

Relational algebra

Feb 20

ER Model

Chapter 7

ER Model

Feb 25

ER Model...cont, Conversion to relational

Chapter 7


Feb 27

Functional dependencies
Normalization

Chapter 8

Prof. Pop out

Mar 4

Midterm 1


Everything including ER model but not functional dependencies

Mar 6

Normalization

Chapter 8

Normalization

Mar 11

Normalization



Mar 13

Storage/Files

Chapter 10

Storage

Mar 18

Spring Break



Mar 20

Spring Break



Mar 25

Indexing/Hashing


Indexing/Hashing

Prof. Pop out

Mar 27

Storage: Indexing/Hashing

Chapter 11

Mid 2

Apr 1

Midterm 2


Prof. Pop out/ ER model, functional dependencies/normalization, storage/files.

Apr 3

Storage: Indexing/Hashing



Apr 8

Query processing: Join/Sorting

Chapter 12

Checksums/codes

Query processing

Apr 10

Query processing: Join/Sorting



Apr 15

Query optimization

Chapter 13

Query optimization

Apr 17

Query optimization



Apr 22

Transactions

Chapter 14

Transactions

Apr 24

Catch-up/quiz (mini-midterm 3)


Indexing, query processing, query optimization

Apr 29

Concurrency

Chapter 15

Concurrency

May 1

Recovery

Chapter 16

Recovery

May 6

Recovery



May 8

Parallel Databases

Chapters 18,19

Parallel databases

May 13

Wrap-up



May 20
FINAL
1:30-3:30pm
CSIC 1121
EVERYTHING