Home
Syllabus
Policies & Grading
» Recording/Copyright
» Piazza
Class Schedule
Office Hours
Notes Videos & Readings
» Section I
» Section II
Recitations
Assignments
» Submit
» Project Info
FAQ
Links
Section II: Class Notes, Videos, and Reading Guide
(Note: please visit this page frequently as it will be updated constantly during the term)

Lectures Zoom Details

Dates
Topic
Reading
Slides
Video Sec II
19 Aug 2020
 Introduction to Database Systems Chapter 1 & 2 from the textbook 1 slide per page
4 slides per page
24 Aug 2020
 Introduction to Database Systems Chapter 1 & 2 from the textbook 1 slide per page
4 slides per page
26 Aug 2020
 Introduction to Database Systems Chapter 1 & 2 from the textbook 1 slide per page
4 slides per page
Relational Database Model Chapter 5 from the textbook 1 slide per page
4 slides per page
31 Aug 2020
 Relational Database Model Chapter 5 from the textbook 1 slide per page
4 slides per page
2 Sept 2020
 Relational Database Model Chapter 5 from the textbook 1 slide per page
4 slides per page
Structured Query Language SQL - DDL Chapters 6.1-6.2 and 7.4 from the textbook (7th Ed.) 1 slide per page
4 slides per page
7 Sept 2020
 Structured Query Language SQL - DDL Chapters 6.1-6.2 and 7.4 from the textbook (7th Ed.) 1 slide per page
4 slides per page
9 Sept 2020
 Relational Algebra Chapter 8.1-8.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
14 Sept 2020
 Relational Algebra Chapter 8.1-8.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
16 Sept 2020
 Relational Algebra Chapter 8.1-8.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
21 Sept 2020
 SQL DML Introduction Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) 1 slide per page
4 slides per page
23 Sept 2020
 SQL DML Introduction Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) 1 slide per page
4 slides per page
28 Sept 2020
 Nested SQL Queries Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) 1 slide per page
4 slides per page
30 Sep 2020
 SQL Views Chapters 7.2-7.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
5 Oct 2020
 SQL Access Control Chapters 7.2-7.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
SQL Integrity Constraints Chapters 7.2-7.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
7 Oct 2020
 SQL Transactions Chapters 7.2-7.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
SQL Programming (PLSQL) Chapters 10-11 from the textbook (7th Ed.) 1 slide per page
4 slides per page
19 Oct 2020
 SQL Programming (PLSQL & Embedded SQL) Chapters 10-11 from the textbook (7th Ed.) 1 slide per page
4 slides per page
21 Oct 2020
 SQL Programming (Embedded SQL & JDBC) Chapters 10-11 from the textbook (7th Ed.) 1 slide per page
4 slides per page
26 Oct 2020
 SQL Programming (JDBC) Chapters 10-11 from the textbook (7th Ed.) 1 slide per page
4 slides per page
28 Oct 2020
 DB Design - Normalization Chapter 14 and Sections 15.2-15.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
2 Nov 2020
 DB Design - Normalization Chapter 14 and Sections 15.2-15.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
4 Nov 2020
 DB Design - Conceptual Design, ER Model Chapters 3, 4 and 9 from the textbook (7th Ed.) 1 slide per page
4 slides per page
9 Nov 2020
 DB Design - Conceptual Design, E-R Diagrams Chapters 3, 4 and 9 from the textbook (7th Ed.) 1 slide per page
4 slides per page
11 Nov 2020
 ER/EER Diagrams Chapters 3, 4 and 9 from the textbook (7th Ed.) 1 slide per page
4 slides per page
Physical Organization: Storage & Files Chapters 16 and 17 from the textbook (7th Ed.) 1 slide per page
4 slides per page
16 Nov 2020
 Physical Organization: Indexing Chapters 16 and 17 from textbook (7th Ed.) 1 slide per page
4 slides per page
18 Nov 2020
 Transaction Processing - Concurrency Control Chapters 20 to 22 from the textbook (7th Ed.) 1 slide per page
4 slides per page
Transaction Processing - Recovery Chapters 20 to 22 from the textbook (7th Ed.) 1 slide per page
4 slides per page

Copyright Panos K. Chrysanthis & Constantinos Costa © 2020 Last updated on January 18, 2021 at 21:41:11 EST