Database Management System (DBMS) is a software used to manage

data from a database.

A database is a structured collection of data that is stored in an
electronic device. The data can be text, video, image or any other
format.
A relational database stores data in the form of tables and a NoSQL
database in the form of key-value pairs.
SQL (Structured Query Language) is a standard language for accessing
and manipulating data in a relational database.
A DBMS is a software that allows to create, update and retrieval of data
in an organized way. It also provides security to the database.
Examples of relational DBMS are MySQL, Oracle, Microsoft SQL Server,
Postgre SQL and Snowflake.
Examples of NoSQL DBMS are MongoDB, Cassandra, DynamoDB and
Redis.

In this Database Management System tutorial, you’ll learn basic to

advanced topics like the ER model, Relational Model, Relation Algebra,
Normalization, File Organization, etc.
Introduction
Need For DBMS
DBMS Introduction
DBMS Architecture (1, 2 and 3 Tier)
Entity Relationship Model
ER Model
Enhanced ER Model
Minimization of ER Diagram
Generalization, Specialization and Aggregation
Recursive Relationships
Relational Model and Functional Dependencies
Relational Model
Keys (Candidate, Super, Primary, Alternate and Foreign)
Functional Dependency and Attribute Closure
Finding Attribute Closure and Candidate Keys using Functional
Dependencies
Armstrong’s Axioms in Functional Dependency
Equivalence of Functional Dependencies
Canonical Cover
Anomalies in Relational Model
Mapping from ER Model to Relational Model
Strategies for Schema design
Schema Integration
>> Quiz on ER and Relational Model
Normalization
Introduction
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
Introduction of 4th and 5th Normal form
Domain Key normal form
Denormalization in Databases
DBMS | Data Replication
>> Quiz on Normal Forms
Relational Algebra and Calculus
Introduction
Basic Operators
Extended Operators
Inner Join vs Outer Join
Join operation Vs nested query
Tuple Relational Calculus
Row oriented vs. column oriented data stores
Transactions and Concurrency Control
Introduction
ACID Properties
Concurrency Control -Introduction
Types of Schedules
Conflict Serializability
View Serializability
How to test if two schedules are View Equal or not ?
Recoverability of Schedules
Precedence Graph for testing Conflict Serializability
Transaction Isolation Levels in DBMS
Implementation of Locking in DBMS
Lock Based Protocol
Graph Based Protocol
Two Phase Locking (2-PL)
Multiple Granularity Locking
Thomas Write Rule
Polygraph to check View Serializability
Log based recovery
Timestamp Ordering Protocols
TimeStamp and Deadlock Prevention Schemes
Dirty read in SQL
Database Recovery Techniques
Starvation in DBMS
Deadlock in DBMS
DBMS | OLAP vs OLTP
Types of OLAP Systems
Types of Recoverability of Schedules and easiest way to test schedule |
Set 2
>> Quiz on Transactions and concurrency control
Indexing, B and B+ trees
Indexing and its Types
B-Tree | Set 1 (Introduction)
B-Tree | Set 2 (Insert)
B-Tree | Set 3 (Delete)
B+ Tree (Introduction)
Bitmap Indexing
Inverted Index
Difference between Inverted Index and Forward Index
SQL queries on clustered and non-clustered Indexes
>> Practice questions on B and B+ Trees
>> Quizzes on Indexing, B and B+ Trees
File Organization
File Organization – Set 1
File Organization – Set 2 (Hashing in DBMS)
File Organization – Set 3
File Organization – Set 4
>> Quiz on File structures
Advanced Topics
Multimedia Database
RAID
Query Optimization
How to store a password in database?
Storage Area Networks
Network attached storage
ODBMS – Definition and overview
Difference between RDBMS and HBase
Challenges of database security
Federated database management system issues
Distributed Database System
Functions of Distributed Database System
Semantic Heterogeneity
Advantages of Distributed database
Comparison – Centralized, Decentralized and Distributed Systems
Characteristics of Biological Data (Genome Data Management)
Data Management issues in Mobile database
Future Works in Geographic Information System
Difference between Structured, Semi-structured and Unstructured data
Web Information Retrieval | Vector Space Model
Data Warehouse and Data Mining
Star Schema in Data Warehouse modeling
Data Warehouse Modeling | Snowflake Schema
Dimensional Data Modeling
Data Warehousing
Data Warehouse Architecture
Characteristics and Functions of Data warehouse
Difficulties of Implementing Data Warehouses
Data Mining
Data Mining | KDD process
Data Mining | Sources of Data that can be mined
Data Marts
Architecture of HBase
Apache HBase
Architecture and Working of Hive
Apache Hive
Difference between Hive and HBase
Interview Questions
DBMS interview questions | Set 1
DBMS interview questions | Set 2
SQL Interview Questions
SQL Query Interview Questions
PostgreSQL Interview Questions
PL/SQL Intevriew Questions
SQL Tutorial
SQL | Tutorial
Quiz on SQL
Misc Topics
DBMS Interfaces
Categories of DBMS Users
Data Abstraction and Data Independence
Database Objects
Impedance Mismatch
DBMS practices questions
Database Management Systems | Set 1
Database Management Systems | Set 2
Database Management Systems | Set 3
Database Management Systems | Set 4
Database Management Systems | Set 5
Database Management Systems | Set 6
Database Management Systems | Set 7
Database Management Systems | Set 8
Database Management Systems | Set 9
Database Management Systems | Set 10
Database Management Systems | Set 11