Database Lectures

Topic
Number 		Slides YouTube Playlist CSci 366 CSci 765
1 Database Concepts Database Concepts Week 1 Week 1
2 Relational Concepts Relational Concepts Week 2 Week 2
3 Entity-Relationship Modeling Entity-Relationship Modeling Week 3 Week 2
4 ER-to-Relational Mapping ER-to-Relational Mapping Week 3 Week 3
5 Enhanced Entity Relationship Modeling Enhanced Entity Relationship Modeling Week 4
(Week 5:
Exam 1) 		Week 3
6 Relational Algebra Operations Relational Algebra Operations Week 6 Week 4
7 SQL: Data Definition Language SQL: Data Definition Language Week 6 Week 4
(Week 5:
Exam 1)
8 SQL: Data Manipulation Language SQL: Data Manipulation Language Week 7 Week 6
9 Applications and their Security Applications and their Security Week 8 Week 7
10 Functional Dependencies Functional Dependencies Week 9
(Week 10:
Exam 2) 		Week 7
11 Normal Forms Normal Forms Week 11 Week 8
12 Storage Storage Week 12 Week 9
13 Index Structures Index Structures Week 13 Week 9
(Week 10:
Exam 2)
14 Database Security Database Security Week 13 Week 11
15 Recovery and Concurrency Control Recovery and Concurrency Control Week 14
(Week 15:
Exam 3)
 Week 11
16 Transaction Processing Transaction Processing Week 12
17 Distributed Databases Distributed Databases Week 12
18 Data Warehouses Data Warehouses Week 13
19 Information Retrieval Information Retrieval Week 13
20 Geographic Information Systems Geographic Information Systems Week 14
(Week 15:
Exam 3)