Description: Database Management System handles the storage, retrieval, and updation of data in computer system. For generating a formal specification of the database schema E-R model is used. Various SQL queries are also explained in this course.
Curriculum
- 1 Section
- 42 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Database Management System42
- 2.1Conceptual Designs Part 1
- 2.2Conceptual Designs Part 2
- 2.3Relational Model Part 1
- 2.4Relational Model Part 2
- 2.5Structured Query Language Part 1
- 2.6Structured Query Language Part 2
- 2.7ER Model to Relational Mapping
- 2.8Functional Dependencies & Normal Form
- 2.9ER Model to Relational Model Maping
- 2.10Storage Structures
- 2.11Indexing Techniques Single Level
- 2.12Indexing Techniques Multi-Level
- 2.13Constraints & Triggers
- 2.14Query Processing & Optimization Part 1
- 2.15Query Processing & Optimization Part 2
- 2.16Query Processing & Optimization Part 3
- 2.17Transaction Processing Concepts
- 2.18Transaction Processing & Database Manager
- 2.19Foundation for Concurrency Control
- 2.20Concurrency Control Part 1
- 2.21Concurrency Control Part 2
- 2.22Concurrency Control Part 3
- 2.23Concurrency Control Part 4
- 2.24Distributed Transaction Models
- 2.25Basic 2-Phase & 3-Phase Commit Protocol
- 2.26Concurrency Control for Distributed Transaction
- 2.27Introduction to Transaction Recovery
- 2.28Recovery Mechanisms Part 1
- 2.29Recovery Mechanisms Part 2
- 2.30Introduction to Data Warehousing & OLAP Part 1
- 2.31Introduction to Data Warehousing & OLAP Part 2
- 2.32Case Study : MYSQL
- 2.33Case Study : ORACLE & Microsoft Access
- 2.34Data Mining & Knowledge Discovery Part 1
- 2.35Data Mining & Knowledge Discovery Part 2
- 2.36Object Oriented Databases Part 1
- 2.37Object Oriented Databases Part 2
- 2.38XML – Introductory Concepts
- 2.39XML Advanced Concepts
- 2.40XML Databases
- 2.41Case Study – Database Design Part 1
- 2.42Case Study – Database Design Part 2
