Database Management Systems (CSN-351)
Session:
Description:
The aim of this course is to introduce the concepts of database management systems and the design of relational databases. Few advanced topics on database management systems are also covered in this course.
Course Plan: PDF
Venue:
Lectures: LH-02, Tutorials: W-201, Seminar Room 1
Timing:
Lectures: MON, TUE, THU (14:00-14:55), Tutorials: WED (11:05-12:00, 12:05-13:00, 18:00-18:55)
Teaching Assistants
- Jayendra Barua
- Nivedita Sinha
- Hitesh Kumar
Books
Lectures
Designed by following Database Systems Concepts by Silberschatz et. al.
- Lecture 1: Overview
- Lecture 2: Entity-Relationship Model
- Lecture 3: Entity-Relationship Model (contd.)
- Lecture 4: Entity-Relationship Model (contd.)
- Lecture 5: Relational Model and SQL
- Lecture 6: SQL
- Lecture 7: SQL (contd.)
- Lecture 8: SQL (contd.)
- Lecture 9: Relational Database Design
- Lecture 10: Relational Database Design (contd.)
- Lecture 11: Relational Database Design (QA)
- Lecture 12: Relational Database Design (contd.)
- Lecture 13: Relational Database Design (contd.)
- Lecture 14: Relational Database Design (QA)
- Lecture 15: Wrapping up before Midterm
- Lecture 16: Transactions
- Lecture 17: Transaction (QA)
- Lecture 18: Concurrency Control
- Lecture 19: Concurrency Control (contd.)
- Lecture 20: Concurrency Control (contd.)
- Lecture 21: Recovery and File Structure
- Lecture 22: Indexing
- Lecture 23: B+ Tree
- Lecture 24: Hashing
- Lecture 25: Tuple Relational Calculus and Intermediate SQL
- Lecture 26: The Last Lecture (Contents are not in the syllabus of ETE)