Lecture Notes
| Date |
Topic |
PowerPoint |
PDF |
Book Chapters |
| Sep 6, 2017 |
Introduction |
intro.ppt |
intro.pdf |
1 |
| Sep 13, 2017 |
ER Model |
ER.ppt |
ER.pdf |
2,3 |
| Sep 18, 2017 |
Relational Algebra |
RA.ppt |
RA.pdf |
4 |
| Sep 25, 2017 |
SQL I |
SQLI.ppt |
SQLI.pdf |
5 |
| Sep 27, 2017 |
SQL II |
SQLII.ppt |
SQLII.pdf |
5 |
| Oct 2, 2017 |
SQL III |
SQLIII.ppt |
SQLIII.pdf |
5 |
| Oct 4,9, 2017 |
Normal Forms |
NF.ppt |
NF.pdf |
19 |
| Oct 11, 2017 |
Disks and Buffers |
DB.ppt |
DB.pdf |
8 |
| Oct 16, 2017 |
Files |
Files.ppt |
Files.pdf |
9 |
| Oct 18, 2017 |
Indexing |
Indexing.ppt |
Indexing.pdf |
10 |
| Oct 25, 2017 |
Btree |
Btree.ppt |
Btree.pdf |
10 |
| Oct 30, 2017 |
Hashing |
Hashing.ppt |
Hashing.pdf |
11 |
| Nov 1, 2017 |
Query Processing |
QP.ppt |
QP.pdf |
12,13 |
| Nov 6, 2017 |
Query Evaluation |
QE.ppt |
QE.pdf |
14 |
| Nov 13, 2017 |
Query Optimization |
QOI.ppt |
QOI.pdf |
12,15 |
| Nov 15, 2017 |
Query Optimization II |
QOII.ppt |
QOII.pdf |
15 |
| Nov 20,27 2017 |
Transactions |
CC.ppt |
CC.pdf |
16,17 |
| Nov 29, 2017 |
NoSQL |
NoSQL.ppt |
NoSQL.pdf |
|
| Dec 4, 2017 |
Recovery |
Recovery.ppt |
Recovery.pdf |
18 |