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.0Lesson 1-Introduction to DBMS
- 1.1Lesson 2-Advantage of DBMS,Schema and Instance
- 1.2Lesson 3-Three Schema Architecture in DBMS
- 1.3Lesson 4-Data Independance
- 1.4Lesson 5-Data Models
- 1.5Lesson 6-Database Users
- 1.6Lesson 7-Database system applications
- 1.7Lesson 8-Database Languages
- 1.8Lesson 9-ER Model
- 1.9Lesson 10-Entity set and keys
- 1.10Lesson 11-ER Diagram Representation
- 1.11Lesson 12-Weak Entities
- 1.12Lesson 13-Degree of relationships
- 1.13Lesson 14-Draw ER Diagram
- Module 2-Relational Model4
- Modul;e 412
- 3.0Lesson 1-Anomalies in DB Design
- 3.1Lesoon 2-Functional Dependancy
- 3.2Lesson 3-Prime and Non Prime Attributes
- 3.3Lesson 4-Partial Dependency
- 3.4Lesson 5-Normal Forms-1NF and 2 NF
- 3.5Lesson 6-3 NF
- 3.6Lesson 7-BCNF
- 3.7Lesson 8-Losseless join decomposition
- 3.8Lesson 9-Dependency preserving dcomposition
- 3.9Lesson 10-Clossure of Attributes
- 3.10Lesson 11-canonical cover
- 3.11Lesson 12- Equivalence of FD
- Module 513
- 4.0Lesson 1-transactions
- 4.1Lesson 2-ACID Properties
- 4.2Lesson 3-Transaction Stages
- 4.3Lesosn 4-Schedule
- 4.4Lesson 5-Serializability
- 4.5Lesson 6-Precedence graph
- 4.6Lesson 7-Find Serializability
- 4.7Lesson 8-View Serializability
- 4.8Lesson 9-Recoverability
- 4.9Lesson 10-Lock based Protocol
- 4.10Lesson 11-2 Phase Locking protocol
- 4.11Lesson 12-Log based recovery
- 4.12Lesson 13-Checkpoint
- Module 34
