# Data Base Management System

- 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](https://nptel.ac.in/courses/106105175)
- Licence: [CC BY-NC-SA](https://nptel.ac.in/faq) (Non-commercial use only.)
- Syllabus: [at the source](https://nptel.ac.in/courses/106105175)
- Who can watch: Tweens profiles and older (sources give no ratings; placed by Invisible Network from the source's own words)

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

1. [Lecture 1 : Course Overview](https://invisiblenetwork.ai/learn/nptel/106105175/457fe6058871) (YouTube)
2. [Lecture 2 : Introduction to DBMS/1](https://invisiblenetwork.ai/learn/nptel/106105175/22c98c0a1ce5) (YouTube)
3. [Lecture 3 : Introduction to DBMS/2](https://invisiblenetwork.ai/learn/nptel/106105175/7352350ee6f8) (YouTube)
4. [Lecture 4 : Introduction to Relational Model/1](https://invisiblenetwork.ai/learn/nptel/106105175/6d2a53502517) (YouTube)
5. [Lecture 5 : Introduction to Relational Model/2](https://invisiblenetwork.ai/learn/nptel/106105175/df51d31cb131) (YouTube)
6. [Lecture 6 : Introduction to SQL/1](https://invisiblenetwork.ai/learn/nptel/106105175/ff0daff8eb00) (YouTube)
7. [Lecture 7 : Introduction to SQL/2](https://invisiblenetwork.ai/learn/nptel/106105175/e981694b1ff1) (YouTube)
8. [Lecture 8 : Introduction to SQL/3](https://invisiblenetwork.ai/learn/nptel/106105175/eb280f75c0d0) (YouTube)
9. [Lecture 9 : Intermediate SQL/1](https://invisiblenetwork.ai/learn/nptel/106105175/6fc8cee010b9) (YouTube)
10. [Lecture 10 : Intermediate SQL/2](https://invisiblenetwork.ai/learn/nptel/106105175/67ed7ad4ba55) (YouTube)
11. [Lecture 11 : Advanced SQL](https://invisiblenetwork.ai/learn/nptel/106105175/3c7cb3e1ed80) (YouTube)
12. [Lecture 12 : Formal Relational Query Languages](https://invisiblenetwork.ai/learn/nptel/106105175/ba0287c92764) (YouTube)
13. [Lecture 13 : Entity-Relationship Model/1](https://invisiblenetwork.ai/learn/nptel/106105175/267452002242) (YouTube)
14. [Lecture 14 : Entity-Relationship Model/2](https://invisiblenetwork.ai/learn/nptel/106105175/aec59d6d1bad) (YouTube)
15. [Lecture 15 : Entity-Relationship Model/3](https://invisiblenetwork.ai/learn/nptel/106105175/7ed1b386e587) (YouTube)
16. [Lecture 16 : Relational Database Design](https://invisiblenetwork.ai/learn/nptel/106105175/41399e06f87a) (YouTube)
17. [Lecture 17 : Relational Database Design (Contd.)](https://invisiblenetwork.ai/learn/nptel/106105175/939eadac0dac) (YouTube)
18. [Lecture 18 : Relational Database Design (Contd.)](https://invisiblenetwork.ai/learn/nptel/106105175/cb0b1df00a61) (YouTube)
19. [Lecture 19 : Relational Database Design (Contd.)](https://invisiblenetwork.ai/learn/nptel/106105175/89fec6fd272c) (YouTube)
20. [Lecture 20 : Relational Database Design (Contd.)](https://invisiblenetwork.ai/learn/nptel/106105175/55c59336d4a2) (YouTube)
21. [Lecture 21 : Application Design and Development](https://invisiblenetwork.ai/learn/nptel/106105175/871d3591d2fe) (YouTube)
22. [Lecture 22 : Application Design and Development (contd.)](https://invisiblenetwork.ai/learn/nptel/106105175/c45838fe114f) (YouTube)
23. [Lecture 23 : Application Design and Development (contd.)](https://invisiblenetwork.ai/learn/nptel/106105175/20cbbef47ad4) (YouTube)
24. [Lecture 24 : Storage and File Structure : Storage](https://invisiblenetwork.ai/learn/nptel/106105175/24cc768ddc4d) (YouTube)
25. [Lecture 25 : Storage and File Structure : File Structure](https://invisiblenetwork.ai/learn/nptel/106105175/8fcb9c95b9da) (YouTube)
26. [Lecture 26: Indexing and Hashing/1 : Indexing/1](https://invisiblenetwork.ai/learn/nptel/106105175/04ebe3027022) (YouTube)
27. [Lecture 27: Indexing and Hashing/2 : Indexing/2](https://invisiblenetwork.ai/learn/nptel/106105175/16f83eee53a5) (YouTube)
28. [Lecture 28: Indexing and Hashing/3 : Indexing/3](https://invisiblenetwork.ai/learn/nptel/106105175/cf07ce399a3f) (YouTube)
29. [Lecture 29: Indexing and Hashing/4 : Hashing](https://invisiblenetwork.ai/learn/nptel/106105175/fd4a5b590c27) (YouTube)
30. [Lecture 30: Indexing and Hashing/5 : Index Design](https://invisiblenetwork.ai/learn/nptel/106105175/5509408b7cad) (YouTube)
31. [Lecture 31: Transactions/1 : Serializability](https://invisiblenetwork.ai/learn/nptel/106105175/61caf366ffbb) (YouTube)
32. [Lecture 32: Transactions/2 : Serializability](https://invisiblenetwork.ai/learn/nptel/106105175/62cd57a75522) (YouTube)
33. [Lecture 33: Transactions/3 : Recoverability](https://invisiblenetwork.ai/learn/nptel/106105175/51824e1e9b30) (YouTube)
34. [Lecture 34: Concurrency Control/1](https://invisiblenetwork.ai/learn/nptel/106105175/a9b116e9b3a2) (YouTube)
35. [Lecture 35: Concurrency Control/2](https://invisiblenetwork.ai/learn/nptel/106105175/13791e6889f5) (YouTube)
36. [Lecture 36 : Recovery/1](https://invisiblenetwork.ai/learn/nptel/106105175/e08239957551) (YouTube)
37. [Lecture 37 : Recovery/2](https://invisiblenetwork.ai/learn/nptel/106105175/f9d57cf15665) (YouTube)
38. [Lecture 38 : Query Processing and Optimization/1 : Processing](https://invisiblenetwork.ai/learn/nptel/106105175/502bad87e27c) (YouTube)
39. [Lecture 39 : Query Processing and Optimization/2 : Optimization](https://invisiblenetwork.ai/learn/nptel/106105175/f6669041c40d) (YouTube)
40. [Lecture 40 : Course Summarization](https://invisiblenetwork.ai/learn/nptel/106105175/3e2ce5f78f2c) (YouTube)