ExamAdda LogoExamAdda
SYSTEM DESIGN (LLD)SYSTEM DESIGN (HLD)DSADBMSMYSQLINTERVIEWOSARTIFICIAL INTELLIGENCEMACHINE LEARNINGDEEP LEARNINGGENAIROADMAPSJAVASCRIPTPYTHON
Roadmap Section to Article Path

DBMS Tutorial Roadmap

14
Sections
8
Sub Section
117
Articles
0
Premium
01SectionBasic DBMS 5 subsections 28 articles
28/28 articles
1Introduction of DBMS
2DBMS vs File System
3Types of Databases Subsection 2/2 articles
Subsection articles
2/2 articles
1Relational Database
2NoSQL Database
4Database Architecture Subsection 5/5 articles
Subsection articles
5/5 articles
11-Tier Architecture
22-Tier Architecture
33-Tier Architecture
4Centralized Architecture
5Client-Server Architecture
5Data Models Subsection 5/5 articles
Subsection articles
5/5 articles
1Hierarchical Model
2Network Model
3Relational Model
4Entity Relationship Model
5Object-Oriented Model
6Schema vs Instance
7Constraints in DBMS Subsection 7/7 articles
Subsection articles
7/7 articles
1Super Key
2Candidate Key
3Primary Key
4Alternate Key
5Composite Key
6Foreign Key
7Surrogate Key
8Functional Dependencies Subsection 6/6 articles
Subsection articles
6/6 articles
1Introductions
2Types of FD
3Attribute Closure
4Armstrong’s Axioms
5Canonical Cover
6Inference Rules
02SectionER Model 0 subsections 10 articles
10/10 articles
1Basic Concepts
2ER Diagram
3Structural Constraints
4Weak Entity
5Relationship Types
6Generalization
7Specialization
8Aggregation
9Enhanced ER Model (EER)
10Mapping ER to Relational Model
03SectionNormalization 0 subsections 8 articles
8/8 articles
1Introductions
2Redundancy Problem
31NF
42NF
53NF
6BCNF
74NF
85NF
04SectionRelational Model 2 subsections 12 articles
12/12 articles
1Codd’s Rules
2Relational Algebra Subsection 6/6 articles
Subsection articles
6/6 articles
1Selection
2Projection
3Join
4Union
5Intersection
6Difference
3Relational Calculus
4Domain & Tuple Relational Calculus
5Integrity Constraints Subsection 3/3 articles
Subsection articles
3/3 articles
1Entity Integrity
2Referential Integrity
3Domain Constraints
05SectionTransactions 0 subsections 4 articles
4/4 articles
1What is Transaction?
2Transaction States
3ACID Properties
4Transaction Lifecycle
06SectionConcurrency Control 1 subsections 12 articles
12/12 articles
1Types of Schedules
2Serial & Non-Serial Schedule
3Serializability Subsection 2/2 articles
Subsection articles
2/2 articles
1Conflict Serializability
2View Serializability
4Lock-Based Protocol
5Two-Phase Locking (2PL)
6Timestamp-Based Protocol
7Multiple Granularity Locking
8Graph-Based Protocol
9Phantom Read
10Dirty Read
11Thomas Write Rule
07SectionIndexing in DBMS 0 subsections 8 articles
8/8 articles
1Single-Level Index
2Multi-Level Index
3B-Tree
4B+ Tree
5Bitmap Index
6Inverted Index
7Clustered vs Non-Clustered Index
8Hash Indexing
08SectionFile Organization 0 subsections 5 articles
5/5 articles
1Heap File
2Sequential File
3Hash File
4Disk Storage Structure
5Buffer Management
09SectionDeadlock 0 subsections 4 articles
4/4 articles
1Causes of Deadlock
2Detection
3Prevention
4Avoidance
10SectionRecovery Techniques 0 subsections 5 articles
5/5 articles
1Log-Based Recovery
2Checkpointing
3Shadow Paging
4Database Backup
5Database Restore
11SectionDistributed Database 0 subsections 5 articles
5/5 articles
1Distributed DBMS
2Fragmentation
3Replication
4Distributed Transactions
5Two-Phase Commit Protocol
12SectionBig Data 0 subsections 6 articles
6/6 articles
1Data Warehousing
2OLTP vs OLAP
3Data Lake
4ETL Process
5Sharding
6Replication
13SectionSecurity in DBMS 0 subsections 5 articles
5/5 articles
1Authentication
2Authorization
3Role-Based Access Control
4Encryption
5SQL Injection
14SectionPerformance Tuning 0 subsections 5 articles
5/5 articles
1Query Optimization
2Index Optimization
3Partitioning
4Caching
5Connection Pooling
Next Tutorial
Introduction of DBMS