Database Management Systems (DBMS) are software systems that provide an interface to interact with and manage databases. These systems handle the storage, retrieval, and management of data, ensuring that data is stored efficiently and securely, and is available when needed. DBMSs are crucial in modern software applications, especially in handling large amounts of structured data.
Curriculum
- 5 Sections
- 47 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Module 1-Introduction to DBMS14
- 1.1Lesson 1-Introduction to DBMS
- 1.2Lesson 2-Advantage of DBMS,Schema and Instance
- 1.3Lesson 3-Three Schema Architecture in DBMS
- 1.4Lesson 4-Data Independance
- 1.5Lesson 5-Data Models
- 1.6Lesson 6-Database Users
- 1.7Lesson 7-Database system applications
- 1.8Lesson 8-Database Languages
- 1.9Lesson 9-ER Model
- 1.10Lesson 10-Entity set and keys
- 1.11Lesson 11-ER Diagram Representation
- 1.12Lesson 12-Weak Entities
- 1.13Lesson 13-Degree of relationships
- 1.14Lesson 14-Draw ER Diagram
- Module 2-Relational Model4
- Modul;e 412
- 3.1Lesson 1-Anomalies in DB Design
- 3.2Lesoon 2-Functional Dependancy
- 3.3Lesson 3-Prime and Non Prime Attributes
- 3.4Lesson 4-Partial Dependency
- 3.5Lesson 5-Normal Forms-1NF and 2 NF
- 3.6Lesson 6-3 NF
- 3.7Lesson 7-BCNF
- 3.8Lesson 8-Losseless join decomposition
- 3.9Lesson 9-Dependency preserving dcomposition
- 3.10Lesson 10-Clossure of Attributes
- 3.11Lesson 11-canonical cover
- 3.12Lesson 12- Equivalence of FD
- Module 513
- 4.1Lesson 1-transactions
- 4.2Lesson 2-ACID Properties
- 4.3Lesson 3-Transaction Stages
- 4.4Lesosn 4-Schedule
- 4.5Lesson 5-Serializability
- 4.6Lesson 6-Precedence graph
- 4.7Lesson 7-Find Serializability
- 4.8Lesson 8-View Serializability
- 4.9Lesson 9-Recoverability
- 4.10Lesson 10-Lock based Protocol
- 4.11Lesson 11-2 Phase Locking protocol
- 4.12Lesson 12-Log based recovery
- 4.13Lesson 13-Checkpoint
- Module 34
