What you will learn
-
Computer Science and Engineering
-
IP/IM/MA
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 the details, they share a common set of models, design paradigms and a Structured Query Language (SQL). In this background the course examines 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. 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 is also introduced.
No Discussion Found
0.0
0 Reviews
Meet Your Instructor
About Instructor
Prof. Partha Pratim Das is a Professor at the Department of Computer Science and Engineering, IIT Kharagpur, India. He is also the Joint Principal Investigator of National Digital Library of India project of Ministry of Education and leads the initiative to integrate the Digital Repositories of various Institutions. Prof. 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 moved to the industry and served in director positions till 2011.
Free
-
Course Duration27 h 6 m 3 s
-
Course LevelIntermediate
-
Student Enrolled2
-
LanguageEnglish
This Course Includes
- 27 h 6 m 3 s Video Lectures
- 0 Quizzes
- 0 Assignments
- 0 Downloadable Resources
- Full Lifetime Access
- Certificate of Completion