Tentative schedule
(revised regularly - requires Refresh/Reload on the browser)

Week

Day

Date

Topics

Reading List
7th Edition
1
 Before class Watch Welcome video
Understand syllabus and grading policy, schedule format
Watch foundations of DB systems videos (Module1 concept map)		  
Mon 1/11

Overview of database foundations, enterprise database systems, query optimization process, sort algorithms: Wikipedia Illustration

Ch-2, 18

After class Review three layer schema, entrerprise DB structure, QOpt process sequence, external sorting
Review foundations of DB Systems lecture notes (Module1 CMap)		  video-1
2 Before class Watch Module-2 video from CMap  
Mon 1/25 

Implementation of select operations;  joins; Implementation of join operations Quiz (Module 1)

Ch-18
After class Visit the hyperlinks shown on this schedule page to reinforce the learning  video-2
3 Before class    
Mon 2/1

Implementation of other relational algebra operations, Query optimization - examples: Illustration

 Ch-19

After class    video-3
4 Before class    
Mon 2/8

Heuristic algebraic optimization algorithm , Tuning queries - notes Quiz (Module 2)

 
After class   video-4
5 Before class    
Mon 2/15

Transaction processing, ACID properties, Serializability  Isolation Level, schedules, view serializability  equivalence of schedules

Ch-20

After class   video-5
6 Before class    
Mon 2/22 

Concurrency control, locks, concurrency protocols, Deadlock prevention protocols, Time stamp ordering protocols Quiz (Module 3)

Ch-21

After class   video-6
7 Before class    
Mon 3/1 

Internet Databases and PHP queries; PHP Query examples; Quiz (Module 4) Review

 Ch-11
After class   video-7
Fri 3/5

Mid-term exam (5:00pm - 6:30pm)

  
8 Before class    
Mon 3/8

XML, Document Type Definition, Generating XML documents from databases, XML queries, XML schema

Ch-13
After class   video-8
9 Before class    
Mon 3/15

Data mining, generating association rules, Classification, clustering, Apriori and Frequent Pattern Tree algorithms Quiz (Module 5)

 Ch-28
After class   video-9
10 Before class    
Mon 3/22 

Data warehouse schema: star, snow flake; OLTP and OLAP Quiz (Module 6)

 Ch-29

After class   video-10
11 Before class    
Mon 3/29

Information retrieval and web search; No SQL Databases Quiz (Module 7)

Ch-27
After class   video-11
12 Before class    
Mon 4/5

Hadoop, DFS

Ch-24, 25
After class   video-12
13 Before class    
Mon 4/12

Map Reduce, Review, Quiz (Module 8)

 
After class   video-13

Fri 4/23

Final exam (6:30pm - 8:00pm)