Course abstract
Databases form the backbone of all major applications today – tightly or loosely coupled, intranet or internet based, financial, social, administrative, and so on. Structured Database Management Systems (DBMS) based on relational and other models have long formed the basis for such databases. Consequently, Oracle, Microsoft SQL Server, Sybase etc. have emerged as leading commercial systems while MySQL, PostgreSQL etc. lead in open source and free domain. While DBMS’s differ in details, they share a common set of models, design paradigms and a Structured Query Language (SQL). In this background the course would examine data structures, file organizations, concepts and principles of DBMS’s, data analysis, database design, data modeling, database management, data & query optimization, and database implementation. More specifically, the course introduces relational data models; entity-relationship modeling, SQL, data normalization, and database design. It would also introduce 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 will also be introduced.
Course Instructor
Partha Pratim Das
Partha Pratim Das received his BTech, MTech and PhD degrees in 1984, 1985 and 1988 respectively from IIT Kharagpur. He served as a faculty in 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.
Teaching Assistant(s)
Course Duration : Feb-Mar 2018
View Course
Enrollment : 20-Nov-2017 to 05-Feb-2018
Exam registration : 08-Jan-2018 to 07-Mar-2018
Exam Date : 28-Apr-2018
Enrolled
29398
Registered
3195
Certificate Eligible
2419
Certified Category Count
Gold
32
Silver
0
Elite
1300
Successfully completed
1087
Participation
456
Success
.jpg)
Category : Successfully Completed
Elite
.jpg)
Category : Elite
Gold
.jpg)
Category : Gold
Legend
>=90 - Elite + Gold
60-89 - Elite
40-59 - Successfully Completed
<40 - No Certificate
Final Score Calculation Logic
- Assignment Score = Average of best 6 out of 8 assignments.
- Final Score(Score on Certificate)= 75% of Exam Score + 25% of Assignment Score
Enrollment Statistics
Total Enrollment: 29398
Assignment Statistics
Feedback Videos
Exam score
Final score