|
Tentative Schedule |
|||||
|
No. |
Day |
Date |
Module |
Topics |
Reading_List |
| 1 | Mon | 6/22 | 1 |
Course introduction & objectives; Overview of database systems; |
video, 1, 2 |
|
Relational model, Relational algebra, WinRDBI Asg 1+ |
5, 8 |
||||
| 2 | Wed | 6/24 | 1 |
SQL queries, MariaDB (XAMPP) |
6, 7, 18 |
|
Query execution (SQL -> Relational algebra) |
|||||
| 3 | Fri | 6/26 | 1 |
Database design and normalization(top-down), Design (Bottom-up), |
3, 4, 9, 14 |
|
Index, view, trigger, and stored procedure; Quiz (Module 1) |
video 17, 7, 10 | ||||
| 4 | Mon | 6/29 | 2 |
-Asg 1;Query processing, Relational algebra operator implementation, sort-merge join |
video-1 18 |
| External sorting algorithm - Illustration; Asg 2+ | video-2 18 | ||||
| 5 | Wed | 7/1 | 2,3 |
19 |
|
|
video 20 |
|||||
| Fri | 7/3 |
Independence Day observed (University Closed) |
|||
| 6 | Mon | 7/6 | 3 |
20 |
|
| locks (binary, shared/exclusive, intention) | video 20 | ||||
| 7 | Wed | 7/8 | 4 | -Asg 2 Concurrency protocols: Two-phase locking, | 21 |
| Deadlock prevention, and Time stamp ordering protocols | video 21 | ||||
| 8 | Fri | 7/10 |
Mid-term exam (Modules 1,2,3,4) |
||
| 9 | Mon | 7/13 | 5 | Web queries | 11 |
| Web Databases and PHP queries; Asg 3+ |
video 11 |
||||
| 10 | Wed | 7/15 | 6 |
XML, Document Type Definition, Generating XML documents from databases |
13 |
| video 13 | |||||
| 11 | Fri | 7/17 | 7 | 13 | |
|
video 28 |
|||||
| 12 | Mon | 7/20 | 7 |
Classification, clustering, Apriori algorithm |
28 |
|
Frequent Pattern Tree algorithm; Asg 4+ |
video 28 |
||||
| 13 | Wed | 7/22 | 7 |
-Asg 3; GCP demo |
|
|
video 29 |
|||||
| 14 | Fri | 7/24 | 8 |
27 |
|
| video 24 | |||||
| 15 | Mon | 7/27 | 8 |
MongoDB and Hive |
24 |
| video 25 | |||||
| 16 | Wed | 7/29 | 8 |
-Asg 4; Spark |
|
| Review | video | ||||
| 17 |
Fri | 7/31 |
Final exam (Modules 5,6,7,8) |
|
|
Asg x+ : The specification for Asg x will be made available
-Asg x : The completed Asg x must be submitted(uploaded) in Canvas