Instructor: Mayank Singh: (office: AB-4/304, email: singh.mayank@iitgn.ac.in)
Location: AB1/102
Class Timings: F slot (Tuesday/Wednesday/Friday) - 11:05-12:00
Lecture Slides: Link to lecture slides will be updated before each class
QA sessions: Email me to book an appointment for discussing any doubts, clarifications, and concepts.
TAs:
Pritam Kadasi pritam.k@iitgn.ac.in
Himanshu Beniwal himanshubeniwal@iitgn.ac.in
Shruti Singh singh_shruti@iitgn.ac.in
Pankaj Pandey pankaj.p@iitgn.ac.in
Data Structures and Algorithms-I [ES 242 or equivalent]
Introduction to RDBMS
Structured Query Language (SQL)
Relational Algebra, Entity-Relationship 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
An Introduction to SQL [Video 1, 2, 3] [Slides, list of queries]
Formal Relational Query Languages [Video 1,2,3] [Slides 1,2]
Database Design and the E-R Model [Video 1,2,3] [Slides 1,2,3]
Relational Database Design [Slides 1]
Storage and File Structure [Slides]
Indexing and Hashing [Slides]
Query Processing [Slides]
Query Optimization [Slides]
Transactions [Slides]
Concurrency Control [Slides]
Recovery Systems [Slides]
Introduction to no-SQL databases [Slides]
8 Assignments: 40% [5% each] (Note: You shall get a week's time to complete the assignment. )
2 Surprise quizzes: 10% [5% each]
Mid-Sem Exam: 20%
End-Sem Exam: 20% (This includes everything covered in the entire course)
Class attendance: 10%
[SKS] Abraham Silberschatz, Henry Korth, and S. Sudarshan. Database System Concepts. 6th Edition, McGraw-Hill Education, 2010. (Primary). The official webpage contains a lot of practice material.
[HS] Joseph M. Hellerstein and Michael Stonebraker. Readings in Database Systems, 4th Edition, MIT Press, 2005.