Home
Syllabus
Policies & Grading
» Recording/Copyright
» Campuswire
Class Schedule
Office Hours
Notes Videos & Readings
Recitations
Assignments
» Submit
» Project Info
FAQ
Links
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
18 Jan 2021
 Martin Luther King Day (no classes)
20 Jan 2021
 Introduction to Database Systems Chapter 1 & 2 from the textbook 1 slide per page
4 slides per page
25 Jan 2021
 Overview of Database Management Systems Chapter 1 & 2 from the textbook 1 slide per page
4 slides per page
27 Jan 2021
 Overview of Database Management 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
01 Feb 2021
 Relational Database Model Chapter 5 from the textbook 1 slide per page
4 slides per page
03 Feb 2021
 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
8 Feb 2021
 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
10 Feb 2021
 Relational Algebra Chapter 8.1-8.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
15 Feb 2021
 Relational Algebra Chapter 8.1-8.5 from the textbook (7th Ed.) Practice
1 slide per page
4 slides per page
17 Feb 2021
 Relational Algebra Chapter 8.1-8.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
22 Feb 2021
 SQL DML Introduction Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) 1 slide per page
4 slides per page
24 Feb 2021
 SQL DML Introduction Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) 1 slide per page
4 slides per page
01 Mar 2021
 Nested SQL Queries Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) 1 slide per page
4 slides per page
03 Mar 2021
 Nested SQL Queries Chapters 6.3-6.6 & 7.1 from the textbook (7th Ed.) 1 slide per page
4 slides per page
SQL Views Chapters 7.2-7.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
08 Mar 2021
 SQL Views Chapters 7.2-7.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
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
10 Mar 2021
 SQL Integrity Constraints Chapters 7.2-7.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
SQL Transactions Chapters 7.2-7.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
15 Mar 2021
 Midterm
17 Mar 2021
 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
22 Mar 2021
 SQL Programming (PLSQL SQL & JDBC) Chapters 10-11 from the textbook (7th Ed.) 1 slide per page
4 slides per page
24 Mar 2021
 Student Self-Care Day
29 Mar 2021
 SQL Programming (PLSQL SQL & JDBC) Chapters 10-11 from the textbook (7th Ed.) 1 slide per page
4 slides per page
31 Mar 2021
 SQL Programming (PLSQL SQL & JDBC) Chapters 10-11 from the textbook (7th Ed.) 1 slide per page
4 slides per page
DB Design - Normalization Chapter 14 and Sections 15.2-15.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
05 April 2021
 DB Design - Normalization Chapter 14 and Sections 15.2-15.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
07 Apr 2021
 DB Design - Normalization Chapter 14 and Sections 15.2-15.5 from the textbook (7th Ed.) 1 slide per page
4 slides per page
DB Design - Conceptual Design, ER Model Chapters 3, 4 and 9 from the textbook (7th Ed.) 1 slide per page
4 slides per page
12 April 2021
 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
14 Apr 2021
 Physical Organization: Storage & Files Chapters 16 and 17 from the textbook (7th Ed.) 1 slide per page
4 slides per page
Physical Organization: Indexing Chapters 16 and 17 from textbook (7th Ed.) 1 slide per page
4 slides per page
19 Apr 2021
 Physical Organization: Indexing Chapters 16 and 17 from textbook (7th Ed.) 1 slide per page
4 slides per page
21 Apr 2021
 Transaction Processing - Concurrency Control Chapters 20 to 22 from the textbook (7th Ed.) 1 slide per page
4 slides per page
Recovery Chapters 20 to 22 from the textbook (7th Ed.) 1 slide per page
4 slides per page

Copyright Constantinos Costa © 2021 Last updated on January 10, 2022 at 15:15:51 EST