Course10610517540 lectures
Data Base Management System
Prof. Partha Pratim Das and Prof. Samiran Chattopadhyay · IIT Kharagpur
About
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.
Intended audience: Students from all disciplines can enroll for this course.PRE-REQUISTES :1. Procedural and / or Object-Oriented Programming (C / C++ / Java / Python) 2. Data Structures 3. AlgorithmsINDUSTRY SUPPORT : DBMS is so fundamental that all companies dealing with systems as well as application development (including web, IoT, embedded systems, data mining, machine learning) have a need for the same. These include – Microsoft, Samsung, Xerox, Yahoo, Google, IBM, TCS, Infosys, Amazon, Flipkart, etc.
Lectures
Week 1
- Lecture 1 : Course Overview
- Lecture 2 : Introduction to DBMS/1
- Lecture 3 : Introduction to DBMS/2
- Lecture 4 : Introduction to Relational Model/1
- Lecture 5 : Introduction to Relational Model/2
Week 2
- Lecture 6 : Introduction to SQL/1
- Lecture 7 : Introduction to SQL/2
- Lecture 8 : Introduction to SQL/3
- Lecture 9 : Intermediate SQL/1
- Lecture 10 : Intermediate SQL/2
Week 3
- Lecture 11 : Advanced SQL
- Lecture 12 : Formal Relational Query Languages
- Lecture 13 : Entity-Relationship Model/1
- Lecture 14 : Entity-Relationship Model/2
- Lecture 15 : Entity-Relationship Model/3
Week 4
- Lecture 16 : Relational Database Design
- Lecture 17 : Relational Database Design (Contd.)
- Lecture 18 : Relational Database Design (Contd.)
- Lecture 19 : Relational Database Design (Contd.)
- Lecture 20 : Relational Database Design (Contd.)
Week 5
- Lecture 21 : Application Design and Development
- Lecture 22 : Application Design and Development (contd.)
- Lecture 23 : Application Design and Development (contd.)
- Lecture 24 : Storage and File Structure : Storage
- Lecture 25 : Storage and File Structure : File Structure
Week 6
- Lecture 26: Indexing and Hashing/1 : Indexing/1
- Lecture 27: Indexing and Hashing/2 : Indexing/2
- Lecture 28: Indexing and Hashing/3 : Indexing/3
- Lecture 29: Indexing and Hashing/4 : Hashing
- Lecture 30: Indexing and Hashing/5 : Index Design
Week 7
- Lecture 31: Transactions/1 : Serializability
- Lecture 32: Transactions/2 : Serializability
- Lecture 33: Transactions/3 : Recoverability
- Lecture 34: Concurrency Control/1
- Lecture 35: Concurrency Control/2
Week 8
Syllabus and materials
At NPTEL, as the course publishes them.
Credits and licence
- Institution
- IIT Kharagpur
- Department
- Computer Science and Engineering
- Taught by
- Prof. Partha Pratim Das, Prof. Samiran Chattopadhyay
- Level
- Undergraduate
- Language
- English
- Subjects
- Computer science, Engineering
- Source
- NPTEL
- Licence
- CC BY-NC-SA, as NPTEL states it. Non-commercial use only. NPTEL's terms
- Attribution
- NPTEL states: "Distributed under Creative Commons Attribution-ShareAlike / CC BY - NC - SA", beside a BY-NC-SA badge.
- Who can watch
- NPTEL gives no rating. Invisible Network shows it to Tweens profiles and older, judged from what the source says about it. How courses are placed