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
Prof. 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-Apr 2019
View Course
Syllabus
Enrollment : 15-Nov-2018 to 25-Feb-2019
Exam registration : 25-Feb-2019 to 19-Apr-2019
Exam Date : 27-Apr-2019
Enrolled
42626
Registered
6297
Certificate Eligible
4749
Certified Category Count
Gold
96
Silver
898
Elite
1618
Successfully completed
2137
Participation
1016
Success
.jpg)
Category : Successfully Completed
Elite
.jpg)
Category : Elite
Silver
.jpg)
Category : Silver
Gold
.jpg)
Category : Gold
Legend
>=90 - Elite + Gold
75-89 -Elite + Silver
>=60 - 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: 42626
Registration Statistics
Total Registration : 6297
Assignment Statistics
Exam score
Final score