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 |