Introduction to the Design and Development of Database Systems
Enrollment is Closed

This course will teach you Database concepts and its practical applications. The course will delve into the fundamentals of the database systems , performance and high level data query language. In this course you will also be introduced to modern No-SQL and distributed databases.

About This Course

This is an introductory course in Database Systems introducing theory behind the design of database systems and efficient data storage and its retrieval. In this course focus will be more on the effective usage of databases for data analysis tasks. The course will cover database concepts like relational model, concurrency control, ER concepts, Query Languages, Query Evaluation and Optimization. This course will also introduce you to modern emerging NoSQL databases and distributed computing. This course does not assume any prior Database experience

Course Contents

Session 1: Database Concepts and Architecture, Relational Models and Relational Algebra
Session 2: ER Model and Normalization, Data Query Language(SQL)
Session 3: Query Evaluation and Optimization, Physical Design and Indexing
Session 4: Transaction Processing
Session 5: No SQL Databases

In this course you will learn to:

Query and save data to a database
Access Database from a high level programming language like Python
Develop understanding of NoSQL and column based databases widely used in timeseries analysis
Develop computational thinking skills
Discover the pleasure of finding things out by exploring interesting problems through programs you write

Prerequisites

Familiarity with Python Programming Language

Length: 5 Weeks Lecture Dates: Jan. 21, 30; Feb. 6, 27; March 19

Effort: 1.5 hours lecture + 1.5 hours of in-class assignment + 3 hours study, review and practice per week

Grading: Passing Grade 50% based on weekly quizzes

Live Lectures: Thursdays 8:00 AM EST(6:30 PM India Time) 90 minutes + 90 minutes Lecture Link: https://zoom.us/j/738172444 First Lecture: First lecture on Jan 21st at 8:30pm - 9:30pm EST

Course Staff

Meet the Instructors

Dr Arnab Bhattacharya

Dr Arnab Bhattacharya is an Assosiate Professor in the department of Computer Science at IIT Kanpur since 2007. He received his Undergraduate degree in Computer Science from Jadavpur University in 2001 and MS/Ph.D. degree in Computer Science from University of California, Santa Barbara in 2007. His area of research are Databases, Data Mining, Information Retrieval, Natural Language Processing, Artificial Intelligence. Dr Bhattacharya has been teaching Principles of Database Systems, Topics in Biocomputing, Data Mining,Indexing and Searching Techniques in Databases courses at IIT Kanpur

Dr Amey Karkare

Dr Amey Karkare is an Associate Professor in the department of Computer Science at IIT Kanpur since 2010. He received BTech in Computer Science from IIT Kanpur in 1998 and Ph.D. degree in Computer Science from IIT Bombay in 2008. His area of research are Compilers, Data Flow Analysis and Heap Analysis. Dr Karkare has been teaching Fundamentals of Computing and Computer Organization at IIT Kanpur