Comp 305-001/488-305: Database Administration
Spring 2020: Mondays, 5:30-8:00
Week 8
Mar 16
Homework 2, due Mar 12. Exam 1 is To Be Determined.
ER diagrams
More on inheritance
Invoice and Dellstore
Password dataset
Indexing
B-trees
Query
Trees and Query optimization
Join algorithms
index selection
Explain
Start with joins
Dell assignment
Very Slow
Query
Window functions
Normalization
Transactions