subject
Intro

NPTEL: Database Management System

 with  Partha Pratim Das

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

0 Student
reviews
Cost Free Online Course
Pace Upcoming
Subject Databases
Provider NPTEL
Language English
Calendar 8 weeks long

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

+ Add to My Courses
FAQ View All
What are MOOCs?
MOOCs stand for Massive Open Online Courses. These are free online courses from universities around the world (eg. Stanford Harvard MIT) offered to anyone with an internet connection.
How do I register?
To register for a course, click on "Go to Class" button on the course page. This will take you to the providers website where you can register for the course.
How do these MOOCs or free online courses work?
MOOCs are designed for an online audience, teaching primarily through short (5-20 min.) pre recorded video lectures, that you watch on weekly schedule when convenient for you.  They also have student discussion forums, homework/assignments, and online quizzes or exams.

0 reviews for NPTEL's Database Management System

Write a review

Class Central

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

Sign up for free