Get started with custom lists to organize and share courses.

Sign up

To support our site, Class Central may be compensated by some course providers.

Database Management System

Indian Institute of Technology, Kharagpur via NPTEL

students interested

Taken this course? Share your experience with other students. Write review

Overview

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.

Syllabus

Week 1: Relational Databases: Introduction to the Relational Model, Introduction to SQL, Intermediate SQL, Advanced SQL, Formal Relational Query Languages

Week 2: Relational Databases: Contd.

Week 3: Database Design: The Entity-Relationship Approach, Relational Database Design, Application Design

Week 4: Database Design: Contd.

Week 5: Data Storage and Querying: Storage and File Structure, Indexing and Hashing, Query Processing, Query Optimization

Week 6: Transaction Management: Transactions, Concurrency Control, recovery Systems

Week 7: System Architecture: Database System Architectures, Parallel & Distributed Databases Specialty Databases: Object-Based Databases, XML

Week 8: DBMS Case Studies: PostgreSQL, Application Case Studies: Student Academic Management

Taught by

Partha Pratim Das

Reviews for NPTEL's Database Management System
Based on 0 reviews

  • 5 star 0%
  • 4 star 0%
  • 3 star 0%
  • 2 star 0%
  • 1 star 0%

Did you take this course? Share your experience with other students.

Write a review

Class Central

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.