Instructor: Mayank Singh: (office: AB-4/304, email: singh.mayank@iitgn.ac.in)
Location: AB 10/103
Class Timings: Tuesday and Friday 8:30-10:00
Lecture Slides: The link to lecture slides will be updated before each class
QA sessions: Email me to book an appointment to discuss any doubts, clarifications, and concepts.
TAs:
Aamod Thakur aamod.thakur@iitgn.ac.in
Bhavesh Jain bhavesh.jain@iitgn.ac.in
Jayesh Malaviya malaviya_jayesh@iitgn.ac.in
Ksheer Agrawal ksheer.agrawal@iitgn.ac.in
Ritesh Patidar patidarritesh@iitgn.ac.in
Shatarupa Bepari beparishatarupa@iitgn.ac.in
Shruti Singh singh_shruti@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
Introduction to Databases [slides]
Introduction to Relational Databases [slides]
Entity-Relationship Model, Relational Database Design [Slides 1, 2, 3]
Formal Relational Query Languages [slides]
Relational database design [Slides]
Storage and File Structure [Slides]
Indexing and Hashing [Slides]
Query Processing [Slides]
Query Optimization [Slides]
Transactions [Slides]
Concurrency Control [Slides]
Recovery Systems [Slides]
Additional Materials: Practice Materials
Assignment 1: Database design and ER Diagrams
Assignment 2: Developing the DBMS
Assignment 3: Implementing a Web App using MySQL
Assignment 4: Deploying the DBMS
4 Assignments: 40% [10% each] (Note: You shall get a week's time to complete the assignment.)
3 Surprise quizzes: 30% [10% each]
1 Exam: 30%
[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.