Course Contents & Slides
Key Topics
The course will cover the following key topics in Database Systems:
- Introduction to RDBMS
- Structured Query Language (SQL)
- Relational Algebra & ER Model
- Relational Database Design
- Storage and File Structure
- Application Development
- Indexing and Hashing
- Query Processing
- Query Optimization
- Transactions
- Concurrency Control
- Recovery Systems
- Introduction to No-SQL Databases
Lecture Slides
Lecture slides will be uploaded here before/after each class.
| Lecture | Date | Topic | Material |
|---|---|---|---|
| L1 | Jan 07 | Introduction / Overview | Slide 1 |
| L2 | Jan 09 | Introduction to Database Management Systems (DBMS) | Slide 2 |
| L3 | Jan 16 | Course Project Discussion | Slide 3 |
| L4 | Jan 21 | Introduction to Databases | Slide 4 |
| L5 | Jan 23 | Introduction to the Relational Model | Slide 5 |
| L6 | Jan 28 | Structured Query Language (SQL)-1 | Slide 6 |
| L7 | Jan 30 | Assignment 1 Discussion |
Case Study 1 Track 1/Assignment 1 Track 2/Assignment 1 |
| L8 | Jan 30 | Hands-on Exercise 1: SQL |
Hands-on Exercise 1 company_DDL company_DML university_DDL university_SQL |
| L9 | Feb 4 | Structured Query Language (SQL)-2 | Slide 9 |
| L10 | Feb 11 | SQL-3 & Formal Relational Query Languages |
Slide 10 Slide 10-11 |
| L11 | Feb 13 | Database Design and the E-R Model |
Slide 10-11 Slide 12 |
| L12 | Feb 18 | Formal Relational Query Languages & Quiz 1 |
Slide cont Quiz 1.1 Quiz 1.1 Answer Quiz 1.2 Quiz 1.2 Answer Quiz 1.3 Quiz 1.3 Answer |
| L13 | Mar 11 | Database Design and the E-R Model | Slide 13 |
| L14 | Mar 13 | Practical Database Design Methodology | Slide 14 |
| L15 | Mar 18 | Relational Database Design | Slide 15 |
| L16 | Mar 20 | Assignment 2 Doubt Session | B+ tree temp |
| L17 | Mar 25 | Relational Database Design-2 |
Slide 17 Quiz 2.1 Quiz 2.1 Answer Quiz 2.2 Quiz 2.2 Answer Quiz 2.3 Quiz 2.3 Answer |
| L18 | Mar 27 | Assignment 3 Doubt Session | Dashboard temp |
| L19 | Apr 1 | Indexing and Hashing | Slide 19 |
| L20 | Apr 8 | Query Processing and Optimizatoin |
Slide 20 Quiz 3.1 Quiz 3.1 Answer Quiz 3.2 Quiz 3.2 Answer Quiz 3.3 Quiz 3.3 Answer |
| L21 | Apr 10 | Assignment 4 Discussion |
Assignment 4 |
| L22 | Apr 15 | Introduction to NoSQL Databases |
Slide 22 |
| L23 | Apr 17 | Query Processing and Optimizatoin | Slide 23 |
| L24 | Apr 22 | Transaction Management |
Slide 24 Quiz 4.1 Quiz 4.1 Answer Quiz 4.2 Quiz 4.2 Answer Quiz 4.3 Quiz 4.3 Answer Quiz 4.4 Quiz 4.4 Answer Quiz 4.5 Quiz 4.5 Answer |