DBMS slides
Learn the fundamentals of Database Management Systems (DBMS), including data organization, storage, and retrieval. Understand how DBMS improves data security, consistency, efficiency, and accessibility.
Explore the fundamentals of Database Management Systems (DBMS) and their role in managing data.
Learn about databases, tables, keys, relationships, and SQL operations.
Understand concepts such as normalization, transactions, indexing, and data security.
Build a strong foundation for designing and managing efficient databases.
What You'll Learn
Introduction
Introduction to Databases: DBMS vs File Systems, Characteristics, Advantages & Disadvantages
A beginner-friendly, 16-slide walkthrough of why databases exist. It contrasts messy file-based sys…
43 minData Models in DBMS: Hierarchical, Network, Relational & the Three-Schema Architecture
An 18-slide visual guide to how databases are structured. It walks through the hierarchical, networ…
44 minEntity-Relationship (ER) Model in DBMS: ER Diagram, Entities, Attributes & Keys
A 20-slide visual guide to Entity-Relationship modelling — the blueprint phase of database design. …
44 minCardinality in DBMS: Connectivity, l..h Notation, Participation & ER-to-Table Mapping
A 16-slide visual guide to cardinality in DBMS. It separates connectivity (1:1, 1:M, M:1, M:M) from…
40 minConverting an ER Model to a Relational Schema: The 7-Step Mapping Algorithm
42 minDesigning an ER Diagram for a University Research Database
A 17-slide case study that turns a messy university research-office brief into a precise ER diagram…
39 minRelational Model & Relational Algebra: Select, Project, Join, Divide
An 18-slide visual guide to the relational model and relational algebra — the math beneath SQL. It …
45 minSQL Basics — DDL & DML Commands with Constraints (Create, Alter, Insert, Update, Delete)
A 16-slide, hands-on guide to SQL's DDL and DML core. It separates the command families, builds tab…
38 minAdvanced SQL — Aggregate Functions, GROUP BY, HAVING & Nested Subqueries
A 16-slide, practice-first guide to advanced SQL on a tiny hand-verifiable dataset with real NULL t…
39 minSet Operators, Views, Indexes & Joins in SQL
A 16-slide visual guide to four core SQL tools. It covers set operators (UNION, UNION ALL, INTERSEC…
42 minInteractive SQL Join Playground — Build Queries with WHERE & AND, See Live Results
A 12-slide interactive lesson with a built-in, no-backend SQL join simulator. Learners pick a join …
39 minFunctional Dependencies & Normalization
Closure, Covers & Minimal Cover — Solved Practice Problems
A 15-slide, worked-example guide to functional-dependency theory. It shows how attribute closure X+…
33 minFunctional Dependencies Explained — Full, Partial & Transitive
A 14-slide visual guide to functional dependencies — the foundation of normalization. It defines X→…
33 minFirst Normal Form (1NF) in DBMS with Examples
A 12-slide visual guide to First Normal Form — the entry gate to normalization. It shows the two wa…
34 minSecond Normal Form (2NF): Fixing What 1NF Left Behind
Second Normal Form builds on 1NF by removing partial dependencies — where a non-key attribute depen…
30 minThird Normal Form (3NF): The Key, the Whole Key, and Nothing but the Key
Third Normal Form builds on 2NF by removing transitive dependencies — where a non-key column depend…
39 minDatabase Normalization Made Simple: 1NF, 2NF, 3NF Solved Step by Step
Database normalization turned into a repeatable recipe. This tutorial solves three real problems — …
42 minBCNF in DBMS: 3NF vs BCNF Explained Simply
Boyce–Codd Normal Form closes the loophole 3NF leaves open. A table can pass every 3NF test and sti…
43 minFourth Normal Form (4NF)
A table can pass every BCNF test and still drown in redundant rows when one key independently deter…
36 minFifth Normal Form (5NF)
Fifth Normal Form removes the last redundancy the lower forms can't see — the kind created by a joi…
36 minTransactions and Concurrency
Transactions & Concurrency: Transaction States and ACID Properties
A transaction bundles many operations into one all-or-nothing unit. This tutorial covers the transa…
34 minSerializability in DBMS: Conflict Serializable Schedules
Serializability is the formal test for whether a concurrent schedule is safe — does it behave like …
36 minView Serializability in DBMS: Blind Writes, Examples and Solved Numericals
View serializability judges a schedule by its final result — same first read, same read-from, same …
35 minSchedules in DBMS: Serial, Non-Serial and Cascadeless Schedules
A schedule orders the operations of concurrent transactions — and its class decides what happens wh…
34 minConcurrency Control in DBMS: Locking and Two-Phase Locking (2PL)
Lock-based concurrency control keeps parallel transactions isolated. This tutorial covers shared an…
36 min