IIT Madras invites applications for Free Online Course on Database System via NPTEL

IIT Madras has organised this course while keeping in mind the growing usage of DBMS in every industry. Databases are the backbone of almost all the digital services and e-governance solutions. Modern businesses and financial systems heavily depend on databases systems and transaction processing for their successful operation. This course introduces the students to the various theoretical and practical principles involved in the design and use of databases systems with the help of database management systems (DBMS) and the SQL Standard.

Who can enrol in the course?

This is an Undergraduate computer science level course. But anyone can enrol in the course. The only prerequisite is you should know Discrete Mathematics and Data Structures. You also should have the desire to expand the horizon of your knowledge. Moreover, this course is a must-take as DBMS is so fundamental that all companies dealing with systems as well as application development (including web, IoT, embedded systems, data mining, machine learning) need for the same.

Timeline of the course

This Elective course has a duration of 12 weeks. It will start from 18 January 2021 and end on 09 April 2021. If you want the certificate, you have to give a proctored exam on 25 April 2021. The last date to enrol is 25 January 2020.

Who will teach this DBMS course?

The instructor Dr P Sreenivasa Kumar has been a member of the faculty of the CSE Dept for the past two decades. His research interests are databases, semi-structured data and XML, theory and applications of ontologies. He completed his Masters and PhD from the Department of Computer Science and Automation of Indian Institute of Science, Bangalore.

What will the course teach?

This is a 12-week-long course. Here’s the itinerary for the course.

W1: Introduction and part of E/R Model Module

W2: ER Model Module

W3: Relational Model Module

W4: Relational Model Module

W5: TRC Module and part of SQL Module

W6: SQL Module

W7: Indexes Module

W8: Indexes Module + Query Processing Module

W9: Normal Forms Module

W10: Normal Forms Module

W11: Transaction Processing Module

W12: Transaction Processing Module

How to obtain a certificate from IIT Madras?

The course is free to enrol and learn. But if you want a certificate, you have to register and write the optional proctored exam. The fee for this exam is ₹ 1000. Also, the successful completion of the exam does not guarantee a certificate. To get a certificate, you need to get 25% from the assignments and 75% of the proctored certification exam score out of 100.

Final score = Average assignment score (>10/25) + Exam score (>30/75). If one of the 2 criteria is not met, you will still not get the certificate even if the Final score > 40/100.

This printable certificate will carry the stamp from both NPTEL and IIT Madras. Further, you can enrol in the course here.