GateXAIML
100% Free GATE DA

DA - Database Management Systems (DBMS)

9 Chapters 68 Video Lectures Notes + PYQs PDF
Your Progress 0 / 68 videos watched (0%)
Home View Book Download
Ch. 1 Ch. 2 Ch. 3 Ch. 4 Ch. 5 Ch. 6 Ch. 7 Ch. 8 Ch. 9
L1 - Introduction & Advantages over File System
L2 - Data Models | Data Independence | Levels | Database Languages (DDL, DML, DCL, TCL)
L3 - Database Architecture | DB Engine & Application Architecture Explained
L4 - Problem Solving on DB Languages, Data Abstraction & DB Architecture
L5 - ER Model | ER Diagram | Entity & Entity Set
L6 - Relationship Set | Degree (Unary, Binary, Ternary, N-ary) | Types of Attributes
L7 - Cardinality Ratio & Participation Constraints
L8 - Solved Examples on ER Diagrams
L9 - Practice Problems on ER Diagrams
L10 - GATE PYQs on ER Diagrams
L11 - Introduction to Relational Model | Degree | Cardinality | Domain | Atomicity | NULL Values
L12 - KEYS: Composite | Candidate | Primary | Unique | Super | Foreign | Alternate Keys
L13 - Integrity Constraints | Domain Constraint | Key Constraint | Entity Constraint | Referential Constraint
L14 - Mapping ER Model to Relational Model | Rules 1–4 Explained
L15 - Mapping ER Model to Relational Model | Rules 5–7 Explained
L16 - Mapping ER Model to Relational Model | Rules 8–10 Explained
L17 - Examples on Mapping ER Model to Relational Model
L18 - Solutions to Practice Problems on Relational Model
L19 - Solved GATE PYQs on Relational Model
L20 - Relational Algebra Basics | Selection, Projection, Cartesian Product & Rename
L21 - Relational Algebra Joins | Theta, Equi, Natural & Outer Joins
L22 - Relational Algebra Set Operations & Division Operation
L23 - Relational Algebra Solved Examples
L24 - Problem Solving on Relational Algebra
L25 - GATE PYQs on Relational Algebra
L26 - Tuple Relational Calculus (TRC)
L27 - Tuple Relational Calculus (TRC) | Solved GATE PYQs & Practice Problems
L28 - SQL Basics | CREATE, INSERT, DELETE, UPDATE, ALTER, & Aggregate Functions
L29 - GROUP BY & HAVING Clause | Order of Execution in SQL
L30 - NULL Values in SQL | IS NULL, IS NOT NULL, NULL Handling
L31 - Cartesian Product & Joins in SQL | Natural, Inner, Outer Joins
L32 - SET Operations in SQL | UNION, UNION ALL, INTERSECT, EXCEPT
L33 - Subqueries in SQL | Correlated & Non-Correlated | IN, ANY, ALL, EXISTS
L34 - Practice Problems on SQL
L35 - GATE PYQs on SQL
L36 - Functional Dependency & Armstrong’s Axioms (Rules of Inference)
L37 - Finding Candidate Keys | Normalization
L38 - Equivalence of FDs & Minimal Cover
L39 - Lossy vs Lossless Decomposition | Chase Algorithm Explained
L40 - Dependency Preserving Decomposition
L41 - Normal Forms | 1NF & 2NF Explained
L42 - Third Normal Form (3NF) | Removing Transitive Dependency
L43 - BCNF Decomposition | Boyce-Codd Normal Form Explained
L44 - Multivalued Dependency (MVD) & Fourth Normal Form (4NF)
L45 - Join Dependency & Fifth Normal Form (5NF)
L46 - Practice Problems on Normalization
L47 - GATE PYQs on Normalization
L48 - Record Organization | Record Format, Spanned vs Unspanned, Blocking Factor
L49 - Indexing in DBMS | Primary, Clustering, Secondary, Dense, Sparse, Multilevel
L50 - B-Tree Indexing | Dynamic Multilevel Indexing Explained
L51 - B+ Tree Indexing | Structure, Insertion, Searching
L52 - Problem Solving on Record Organization & Indexing
L53 - Solved GATE PYQs on Record Organization & Indexing
Problems 1–33 (Lecture 4)
Problems 34–64 (Lecture 9)
Problems 65–120 (Lecture 18)
Problems 121–133 (Lecture 24)
Problems 134–137 (Lecture 27)
Problems 138–181 (Lecture 34)
Problems 182–231 (Lecture 46)
Problems 232–260 (Lecture 52)
PB 1-7: GATE PYQs on ER Diagrams
PB 8-20: Solved GATE PYQs on Relational Model
Pb 21-44: GATE PYQs on Relational Algebra
Pb 45-47: Tuple Relational Calculus (TRC) PYQs
Pb 48-79: GATE PYQs on SQL
Pb 80-125: GATE PYQs on Normalization
Pb 126-145: Solved GATE PYQs on Indexing