Share this program with friends or teammates.
Duration: 25 Hours
Category: Database
Type: Database
Module-wise curriculum for DBMS
Introduction
Entity Relationship Model
Relational Model
Relational Algebra
Functional Dependencies
Normalisation
Transactions and Concurrency Control
Indexing, B and B+ trees
File Organization
Advanced Topics
SQL
Need For DBMS
Data Abstraction and Data Independence
Database Objects
Multimedia Database
Interfaces
Categories of End Users
Use of DBMS in System Software
Choice of DBMS | Economic factors
Disadvantages of DBMS
Entity Relationship Model
ER Model
Enhanced ER Model
Minimization of ER Diagram
ER Model: Generalization, Specialization and Aggregation
Recursive Relationships
Impedance Mismatch
Relational Model and CODD Rules
Relational Model
Keys in Relational Model
Number of possible Superkeys
Anomalies in Relational Model
Mapping from ER Model to Relational Model
Strategies for Schema design
Schema Integration
Star Schema in Data Warehouse modeling
Data Warehouse Modeling | Snowflake Schema
Dimensional Data Modeling
Basic Operators
Extended Operators
Inner Join vs Outer Join
Join operation Vs nested query
Tupple Relational Calculus
GATE
Functional Dependencies
Normal Forms
Minimum relations satisfying 1NF
The Problem of redundancy in Database
Dependency Preserving Decomposition
Lossless Join Decomposition
LossLess Join and Dependency Preserving Decomposition
How to find the Highest Normal Form of a Relation
Domain Key normal form
Introduction of 4th and 5th Normal form
Denormalization in Databases
ACID Properties
Dirty read in SQL
Types of Schedules
Conflict Serializability
View Serializability
Recoverability of Schedules
B and B+ trees
File Organization
RAID
Query Optimization
How to store a password in database?
Storage Area Networks
Network attached storage
Data Warehousing
Data Warehouse Architecture
Characteristics and Functions of Data warehouse
