Instructor: Mayank Singh: (office: AB-4/304, email: singh DOT mayank AT iitgn DOT ac DOT in)
Office Hours: Thursday 3:00PM - 4:00PM
Class Schedule: Monday, Wednesday, Thursday 2:05PM - 3:00 PM
Location: AB1/102
TAs: Rachit Chhaya (rachit DOT chhaya AT iitgn DOT ac DOT in), Sayak Chowdhury (sayak DOT chowdhury AT iitgn DOT ac DOT in), Vivek Srivastava (vivek DOT srivastava AT iitgn DOT ac DOT in)
Data Structures and Algorithms-I [ES 242 or equivalent]
1. Brief history and course logistics [PDF]
2. Introduction to Databases I [PDF], II [PDF]
3. Introduction to the Relational Model [PDF]
4. Introduction to SQL [PDF], II [PDF], III [PDF]
5. Intermediate SQL [PDF], II [PDF]
6. Advanced SQL [PDF], II [PDF]
7. Formal Relational Query Languages [PDF], II [PDF]
8. Database Design and the E-R Model [PDF], II [PDF], III [PDF]
9. Relational Database Design [PDF]
10. Storage and File Structure [PDF]
11. Indexing and Hashing [PDF]
12. Query Processing [PDF]
13. Query Optimization [PDF]
14. Transactions [PDF]
15. Concurrency Control [PDF]
16. Recovery Systems [PDF]
17. NoSQL Databases [PDF]
2 Assignments: 10% [Assignment 1] [Assignment 2]
2 Quizzes: 10%
Project: 40% Includes Mid-Sem and End-Sem presentations
Mid Sem Exam: 15%
End Sem Exam: 15%
Online Content Creation: 5% (May include: blogs, tutorials, videos, small application etc.) Here are some examples -- [1] ,[2] , [3]
Attendance: 5%