IIT Kharagpur and NPTEL invite applications for Free Online Course on Data Base Management System

IIT Kharagpur has organised this course while keeping in mind the growing usage of DBMS in every industry. The course introduces the various concepts of data structures, file organizations, concepts and principles of DBMS’s, data analysis, database design, data modelling, database management, data & query optimization, and database implementation. It will also cover the different learning paradigms and some of the more popular algorithms and architectures used in each of these paradigms.

The objective of the course is to prepare a student to take a variety of focused, advanced courses in various subfields of Database Management. More specifically, the course introduces relational data models; entity-relationship modelling, SQL, data normalization, and database design. Further, it introduces query coding practices using MySQL (or any other open system) through various assignments. Design of simple multi-tier client/server architectures based and Web-based database applications are also introduced.

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 basic programming and probability and linear algebra. 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. These include – Microsoft, Samsung, Xerox, Yahoo, Google, IBM, TCS, Infosys, Amazon, Flipkart, etc.

Timeline of the course

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

Who will teach this DBMS course?

Prof. Partha Pratim Das and Prof. Samiran Chattopadhyay will lead the course. Prof Das received his BTech, MTech and PhD degrees in 1984, 1985 and 1988 respectively from IIT Kharagpur. He also served as a faculty in the Department of Computer Science and Engineering, IIT Kharagpur from 1988 to 1998. In 1998, he joined Alumnus Software Ltd as a Business Development Manager. From 2001 to 2011, he worked for Interra Systems, Inc. as a Senior Director and headed its Kolkata Center. In 2011, he joined back to Department of Computer Science and Engineering, IIT Kharagpur as Professor. Dr Das has also served as a Visiting Professor with Institute of Radio Physics and Electronics, Calcutta University from 2003 to 2013. Further, Dr Das has been offering Programming in C++ and Object-Oriented Analysis and Design in NPTEL-NOC.

Samiran Chattopadhyay received his B.Tech and M.Tech degrees in 1987, and 1989 respectively from IIT Kharagpur. He received his PhD in 1993 from Jadavpur University. Also, he served as a faculty in the Department of Computer Science and Engineering, Jadavpur University from 1989 to 1993 and 1997 to 2001 before joining the Department of Information Technology. He has two decades of experience in serving reputed Industry houses such as Computer Associates, Interra Systems India, Agilent, Motorola as Technical consultants. Dr Chattopadhyay has also served as an Adjunct Faculty at IIT Kharagpur.

What will the course teach?

This is an 8-week-long course. Here’s the itinerary for the course.

W1: Course Overview. Introduction to RDBMS

W2: Structured Query Language (SQL)

W3: Relational Algebra. Entity-Relationship Model

W4: Relational Database Design

W5: Application Development. Case Studies. Storage and File Structure

W6: Indexing and Hashing. Query Processing

W7: Query Optimization. Transactions (Serializability and Recoverability)

W8: Concurrency Control. Recovery Systems. Course Summarization.

How to obtain a certificate from IIT Kharagpur?

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 Kharagpur. Further, you can enrol in the course here.