Database Management System(DBMS) Full Course
4.0
(0)
5 learners
What you'll learn
This course includes
- 40 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 192 lessons • 40 hours of video
Database Management System(DBMS) Full Course
192 lessons
• 40 hours
Database Management System(DBMS) Full Course
192 lessons
• 40 hours
- L1: Introduction to DBMS (Database Management System), Features of Data in Database | What is DBMS 07:15
- L2: File System vs DBMS | Disadvantages of File System | DBMS Advantages | Database Lectures 07:00
- L3: Functions of Database Administrators(DBA) | Database Management System(DBMS) Complete Course 04:35
- L4: Database Architecture Working with the help of Diagram | Database Management System Lectures 03:48
- L5: 2 Tier and 3 Tier Architecture with Examples | Database Management System Lectures in Hindi 04:05
- L6: DBMS Components(Actors), Types of Users in Database | Database Management System Complete Course 05:44
- L7: Database Schema, Instances and Sub Schema | Database management system Lectures in Hindi 05:34
- L7-1: Difference between Database Schema & Instance | Relation between External & Conceptual Schema 05:19
- L8: Three Schema Architecture | Three Level of Abstraction | External , Conceptual , & Internal View 06:46
- L8-1: Categories of Data Models – Conceptual, Physical and Logical | Database Management System 06:28
- L9: What is Data Independence | Comparison between Physical and Logical Data Independence 05:37
- L10: Database Languages: DDL, DCL and DML with examples | Database Management System in Hindi 07:10
- L11: Introduction to ER Model | Notations, Strong and Weak Entity in Database ER Model 10:16
- L12: Explain the Need of Weak Entity Sets in ER Diagram | Database Management System in Hindi 06:16
- L13: What is Entity and Attributes | Types of Attributes with example | DBMS in Hindi 12:59
- L14: Relationship Set, Mapping Cardinality, Participation Constraints in Database ER Model 13:24
- L15: Types of Keys in Relation | Super Key, Candidate, Primary, Alternate, Foreign Key with examples 13:02
- L16: Extended ER Features, Generalization, Specialization, Aggregation with Examples and Diagram 07:19
- L17: Difference between Specialization and Generalization in ER Model | DBMS Lectures in Hindi 06:10
- L18: Examples of Aggregation in Database ER Model | Database Management Systems in Hindi 06:18
- L19: Recursive and Identifying Relationship in ER Model with examples | DBMS Lectures in Hindi 06:32
- L20: What is Relational Database and what are its advantages | Database Management Systems in Hindi 05:59
- L21: Relation Schema, Instance, Cardinality, Degree, Database Schema Definition | DBMS Lectures 06:17
- L22: Types of Keys and Why Keys are important in Relational Database Model | DBMS Lectures in Hindi 04:54
- L23: Introduction to Relationship and Types: One to One, One to Many(Many to One) and Many to Many 07:07
- L24: Relational Integrity Constraints in Relational Database with Example | DBMS Lectures in Hindi 06:15
- L25: Entity Integrity Rule and Integrity Constraints | Check and Foreign Key in SQL with Example 07:12
- L26: Introduction to Relational Algebra | Basic and Derived Operators | Database Management System 03:38
- L27: Selection in Relational Algebra | Select Operation Explanation with Examples | DBMS Lectures 10:10
- L28: Projection in Relational Algebra | Project Operation in DBMS Relational Algebra with example 07:53
- L29: Set Operations Union Compatibility Rule | Union Operation in Relational Algebra with Example 07:56
- L30: Intersection in Database Relational Algebra | Intersect Operation with Example in DBMS 03:53
- L31: Set Difference in Relational Algebra | Set Difference Operation(R-S) in Database(DBMS) 05:28
- L32: Cross/Cartesian Product in Relational Algebra | Database Management System(DBMS) in Hindi 08:56
- L33: Rename Operation in Relational Algebra | Database Management System(DBMS) in Hindi 04:47
- L34: Introduction to Joins and its types in Relational Algebra | Join Vs. Cartesian Product 06:47
- L35: Inner Join(Theta, Equi, Natural Join) Operations with Example | Database Management System 10:22
- L36: Outer Join(Left Outer, Right Outer, Full Outer Join) Operation in Relational Database 05:53
- L37: Division Operation in Relational Algebra | Database Management System in Hindi 06:16
- L38: Aggregate Function, Generalized Projection Operation in Relational Algebra | DBMS Lectures 10:14
- L40: Difference b/w Relational Algebra & Relational Calculus | Atoms in Tuple Relational Calculus 04:56
- L41: Relational Algebra Revision | All Topics with Examples and Practice Problems | DBMS Lectures 03:01:41
- L42: Introduction to Functional Dependency in Database with Examples | DBMS in Hindi 10:17
- L43: Functional Dependency Classification with Examples | Database Management System in Hindi 05:52
- L44: Armstrong's Axioms/Inference Rules | Functional Dependency Closure with examples in Database 05:47
- L45: Attribute Closure | How to Find Candidate Key in Relation, Find Additional FD with example 13:47
- L46: Practice Problem on Finding Functional Dependency Closure and Finding Candidate Keys 06:44
- L47: Practice Questions on Finding Key in Relation | Database Management System in Hindi 53:39
- L48: Equivalence of Functional Dependencies in Database Management System in Hindi with Example 05:21
- L49: Practice Questions on Functional Dependencies Equivalence in Database Management System(DBMS) 26:21
- L50: Lossless and Lossy Decomposition in DBMS with examples | Database Management System 11:37
- L51: Practice Questions on Lossless/Lossy Decomposition of a Relation in DBMS in Hindi 39:47
- L52: Dependency Preserving Decomposition in Database Management System(DBMS) with Examples in Hindi 11:37
- L53: Practice Questions on Dependency Preserving Decomposition of a Relation in DBMS 33:35
- L54: Minimal/Canonical Cover in Database Management System(DBMS) with Examples in Hindi 12:45
- L55: Practice Questions on Minimal/Canonical Cover in Database Management System(DBMS) in Hindi 41:29
- L56: Normalization Introduction in DBMS in Hindi | Why it is required | Types of Normal Forms 09:44
- L57: Insertion, Deletion & Updation Anomaly in Normalization | First Normal Form(1NF) with Example 07:41
- L57-1: How Functional Dependency is associated with Normalization | Database Management System 04:58
- L58: How to Find Candidate Key in Database Relation with Example in Hindi | DBMS in Hindi 05:21
- L59: Second Normal Form | 2NF in Database | How to Decompose Relation in 2NF with Example in Hindi 10:58
- L60: Third Normal Form(3NF) in Database Management System(DBMS) with examples in Hindi 13:52
- L61: Boyce Codd Normal Form(BCNF) in Database Management System(DBMS) with examples in Hindi 06:33
- L62: Comparison(Difference) between 3NF and BCNF with example | Database Management System(DBMS) 05:16
- L63: Practice Questions on How to Find Normal Form of a Relation in Database Management System(DBMS) 01:00:50
- L64: DBMS GATE Previous Year Questions Part 1 | PYQ | Decomposition, FD, Normal Form, Finding Key 31:00
- L65: DBMS GATE Previous Year Questions Part 2 | PYQ | Decomposition, FD, Normal Form, Finding Key 46:10
- L66: Fourth Normal Form(4NF) with Multi-Valued Dependency(MVD) in DBMS with Example in Hindi 18:34
- L67: Fifth Normal Form(5NF) with Join Dependency in Database Management System(DBMS) in Hindi 13:40
- L68: Revision of Normalization with Examples and Practice Problems | DBMS Lectures in Hindi 02:25:56
- L69: Introduction to Structured Query Language(SQL) | Types of SQL Commands with examples 07:43
- L70: Create Database, Table Command in SQL | SQL Table Constraints(NOT NULL Example) 06:48
- L71: ALTER Command (DDL) in SQL | Add Column, Drop Column, Change Column Datatype Examples 04:59
- L72: SQL DROP TABLE, DROP DATABASE, TRUNCATE TABLE Commands with Example | DBMS Lectures in Hindi 04:13
- L73: SQL Views, Create Views, DROP Views with examples | SQL Tutorial for Beginners 04:53
- L74: Difference between Delete, Drop & Truncate in SQL | Database Management System(DBMS) 04:20
- L75: Constraints in SQL | UNIQUE, NOT NULL, PRIMARY KEY, CHECK, FOREIGN KEY, DEFAULT with Examples 26:59
- L76: SQL Select Statement with Example | Database Management System(DBMS) Lectures in Hindi 11:14
- L77: SQL Where clause with Example | Database Management System(DBMS) Lectures in Hindi 07:49
- L78: SQL AND/OR Operator with Example | Database Management System(DBMS) Lectures in Hindi 09:56
- L 79: SQL Order By Clause with Example | Database Management System(DBMS) Lectures in Hindi 10:07
- L80: SQL Insert Into Statement with Example | Database Management System(DBMS) Lectures in Hindi 08:22
- L81 : SQL Update Statement with Example | Database Management System(DBMS) Lectures in Hindi 05:28
- L82: SQL Delete Statement with Example | Database Management System(DBMS) Lectures in Hindi 03:41
- L83: SQL Like Operator, Use of % and _ operator with examples| Database Management System in Hindi 11:30
- L84: SQL SET Operations | UNION Operation with Example | Database Management System(DBMS) 07:24
- L85: SQL SET Operations | INTERSECT Operation with Example | Database Management System(DBMS) 05:06
- L86: SQL SET Operations | MINUS(-) Operation with Example | Database Management System(DBMS) 05:23
- L87: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions with Example | DBMS in Hindi 08:25
- L88-1: Difference between Having and Where Clause in SQL with example | Database Management System 07:13
- L88: SQL Group By Clause and Having with Examples | Database Management System(DBMS) 08:06
- L89: SQL Inner Join with Example | Database Management System(DBMS) Lectures in Hindi 09:49
- L90: SQL Left Outer Join with Example | Database Management System(DBMS) Lectures in Hindi 08:21
- L91: SQL Right Outer Join with Example | Database Management System(DBMS) Lectures in Hindi 05:41
- L92: SQL Full Outer Join with Example | Database Management System(DBMS) Lectures in Hindi 03:48
- L93: SQL Nested Query - Insert, Update, Select and Delete using Sub Queries | DBMS in Hindi 12:00
- L94: Solved Question(1) on SQL Queries - Employee, Works, Company, Manages Relation Queries 05:00
- L95: Solved Question(2) on SQL Queries - Question on Vehicle, Person and Owner Table | DBMS Lectures 04:33
- L96: Solved Question(3) on SQL Queries - Question on Supplier Relation | DBMS Lectures 06:59
- L97: Introduction to PL-SQL in Database Management System | DBMS Lectures in Hindi 10:51
- L98: PL-SQL Select Into Statement with Example | Database Management System(DBMS) Lectures in Hindi 05:58
- L99: PL-SQL Condition Statement - IF Then, If Then else, CASE Statement with Examples | DBMS 08:25
- L100: PL-SQL Loops - For Loop, While Loop, Simple PL-SQL Loop with Examples | DBMS Lectures 09:30
- L101: PLSQL Cursor, Implicit and Explicit Cursor, How to Open, Fetch, Close Cursor | DBMS Lectures 14:37
- L102: PL-SQL Functions, How to Create PL SQL Function using Table with Examples | DBMS Lectures 11:07
- L103: PL-SQL Procedure, How to Create Procedure, Call Procedure with Example | DBMS Lectures 10:56
- L104: PLSQL Trigger, Row and Statement Level Trigger, How to Write Trigger with Examples | DBMS 10:23
- L105: PL SQL Exception Handling | How to Raise Exception in PLSQL with Examples | DBMS Lectures 09:25
- L106: Introduction to Transaction Management | ACID Properties in Database Management System(DBMS) 14:13
- L107: Transaction States with Diagram | Database Management System(DBMS) Lectures in Hindi 04:13
- L108: Database Concurrency Problems | Lost Update, Dirty Read, Unrepeatable Read, Incorrect Summary 15:27
- L109: Schedule in Database | Serial, Complete, Recoverable, Cascadeless, Strict Schedule with Eg. 18:06
- L110: Introduction to Serializability | Conflict and View Serializable Schedules in Database(DBMS) 22:07
- L110-1: Practice Problems on Problems on Conflict Serializability in Database Transaction Management 05:16
- L111: Conflict Equivalent Schedules with Example | Transaction concurrency and Control | DBMS 10:26
- L112: Concurrency Control - Lock Based Protocol in Database Management System(DBMS) with Examples 11:48
- L113: 2 Phase Locking(2PL) Protocol in Transaction Concurrency Control | Database(DBMS) Lectures 10:55
- L113-1: Practice Problem on 2PL(Two Phase Locking) - Add Lock/Unlock and check for Deadlock 04:26
- L114: Deadlock Detection in Database Transaction | Wait For Graph Explanation with Example | DBMS 10:44
- L115: Deadlock Control Techniques | Deadlock Prevention | Timestamps and Time Out based Scheme 08:59
- L116: Timestamp Ordering Protocol in Database Transaction Management | DBMS Lectures in Hindi 10:41
- L117: Thomas Write Rules in Database Transaction Management | DBMS Lectures in Hindi 05:31
- L118: Starvation in Database Transaction | Database Management System(DBMS) in Hindi 04:05
- L119: Deadlock Recovery in Database Transaction with example | Database Management System(DBMS) 06:47
- L120: Log Based Database Recovery | Write Ahead Log Buffer Strategy | DBMS Lectures in Hindi 06:24
- L121: Transaction Recovery Procedure - Deferred Database Vs. Immediate Database Modification 03:58
- L121-1: Differentiate between Immediate Update and Deferred Update Recovery Techniques | DBMS 05:06
- L122: Shadow Paging in Database Recovery | Advantages over Log Based Method and Drawbacks | DBMS 11:43
- L123: Explain Checkpoints and How Does it helps in reducing recovery time | DBMS Lectures in Hindi 04:54
- L124: Types of Database Indexes | Ordered, Clustered, Primary, Dense, Sparse, Secondary Index | DBMS 22:34
- L125: Database File Organization | B+ Tree and Other Types with Examples | DBMS Lectures in Hindi 24:02
- L126: Introduction to Distributed Database | Features, Advantages and Disadvantages | DBMS Lectures 15:22
- L127: Types of Distributed Databases | Data Storage (Fragmentation, Replication) | Transparency 16:40
- L128: Query Processing & Optimization in Distributed Database | Query Processing Steps, Query Blocks 15:36
- L129: Implementation of Select Operation, Complex Select Operation (And, Or) in Distributed Database 19:28
- L130: Implementation of Project Operation with Duplication Removal in Distributed Database 09:30
- L131: Implementation of Set Operation | Union, Intersection, Minus Operator in Distributed Database 21:54
- L132: Distributed Query Processing | Simple Join, Semi Join Processing | Parallelism | DBMS Lectures 14:45
- L133: Distributed Database Transactions | Distributed Locking (Single and Distributed Lock Manager) 13:26
- L134: Distributed Database Deadlock Handling | Local and Global Wait for Graph | DBMS Lectures 05:07
- L135: Distributed Database Recovery | Two Phase and Three Phase Commit Protocol | DBMS Lectures 26:20
- L136: Primary Copy | Majority Locking | Timestamping (Centralized and Distributed Scheme) | DBMS 12:20
- DBMS 2015 GGSIPU 2nd term question paper(Questions on Normalization and Transaction Mgmt) 15:29
- DBMS 2014 GGSIPU 2nd term question paper(Questions on Normalization and Transaction Mgmt) 33:19
- DBMS 2013 GGSIPU 2nd term question paper(Questions on Normalization and Transaction Mgmt) 26:11
- DBMS 2012 GGSIPU 2nd term question paper(Questions on Normalization and Transaction Mgmt) 25:39
- Solved Question on FD Closure, Finding Candidate Key, Canonical Cover 04:36
- Solved Question on finding Function Dependency Closure 02:35
- Solved Question on Relational Algebra - Problem on Select, Project, Union, Intersect, Minus 03:46
- Important Solved Numerical Problems on Normalization – DBMS Questions 13:17
- Important Solved Numerical Problems on Decomposition(Lossless/Lossy) – DBMS Questions 06:22
- Important Solved Numerical Problems on Canonical Cover – DBMS Questions 04:09
- Important Solved Numerical Problems on Functional Dependency – DBMS Questions 08:27
- Explain the ACID Concepts in DBMS - #DOEACC #NIELIT – DBMS Previous Year Questions 06:27
- What are Views - Explain How Views are different from Tables | Doeacc Nielit Questions 07:46
- Responsibilities of DBA and Relevance of Data Dictionary in Database - Placement Preparation 08:01
- Disadvantages of File Processing System, Difference between Physical and Logical Data Independence 09:39
- Difference between Candidate and Super Key | Short Note on Derived Attribute 06:22
- Three Level Architecture of Database System 05:11
- Basic and Aggregate Operations in Relational Algebra with Examples 10:01
- Shadow Paging and Shared/Exclusive Locking Mechanism - DBMS Question Answers 07:16
- Explain Two Phase Commit Protocol in Distributed Database System 08:24
- Three Schema Architecture of DBMS and need of Mapping between Schema Levels 05:18
- Audit Trail in DBMS and its Usage with respect to Security 07:43
- Dependency Preservation in DBMS – Solved Question on BCNF 05:15
- What is Database | Describe Advantages and Disadvantages of using DBMS 06:17
- Discretionary Access Control Based Privilege Grant and Revoke in DBMS System 05:08
- Different Types of Failures in Oracle Database - DBMS Important questions 04:39
- Different Types of Database Failures that occur in database environment 03:58
- How Grant Function relates with Security | Types of Privileges and How to Revoke them 04:57
- What happens when COMMIT is not executed after any SQL statement | Side effect of Commit 04:41
- What are different types of Database Users who interact with the database System 07:27
- DBMS Imp Terms : Authorization, Authentication, Audit Trail, Encryption, Grant Revoke 07:38
- How does Encryption Support in Database | Transparent Database Encryption 09:16
- Why Recovery of Interactive Transactions is more difficult to deal with Batch recovery transactions 04:30
- P1: PRACTICE PROBLEMS ON Database Design(Normal Forms) | GATE, ESE, PSU, UGC NET 2023 Preparation 11:23
- P2: PRACTICE PROBLEMS ON Database Design(Normal Forms) | GATE, ESE, PSU, UGC NET 2023 Preparation 11:29
- P3: PRACTICE PROBLEMS ON Database Design(Normal Forms) | GATE, ESE, PSU, UGC NET 2023 Preparation 16:20
- P4: PRACTICE PROBLEMS ON Database Design(Normal Forms) | GATE, ESE, PSU, UGC NET 2023 Preparation 15:41
- P5: PRACTICE PROBLEMS ON Database Design(Normal Forms) | GATE, ESE, PSU, UGC NET 2023 Preparation 12:12
- P6: PRACTICE PROBLEMS ON Database Design(Normal Forms) | GATE, ESE, PSU, UGC NET 2023 Preparation 22:47
- P7: PRACTICE PROBLEMS ON Database Design(FD Equivalence) | GATE, ESE, PSU, UGC NET 2023 Preparation 12:16
- P8: PRACTICE PROBLEMS ON Database Design(FD Equivalence) | GATE, ESE, PSU, UGC NET 2023 Preparation 15:25
- P9: PRACTICE PROBLEMS ON Database Design(Decomposition) | GATE, ESE, PSU, UGC NET 2023 Preparation 14:21
- P10: PRACTICE PROBLEMS ON Database Design(Decomposition) | GATE, ESE, PSU, UGC NET 2023 Preparation 15:18
- P11: PRACTICE PROBLEMS ON Database Design(Decomposition) | GATE, ESE, PSU, UGC NET 2023 Preparation 14:02
- P12: PRACTICE PROBLEMS ON Database Design(Dependency Preservation) | GATE, ESE, PSU, UGC NET 2023 16:05
- P13: PRACTICE PROBLEMS ON Database Design(Dependency Preservation) | GATE, ESE, PSU, UGC NET 2023 20:19
- P14: PRACTICE PROBLEMS ON Database Design(Normalization) | GATE, ESE, PSU, UGC NET 2023 15:05
- P15: PRACTICE PROBLEMS ON Database Design(Normalization) | GATE, ESE, PSU, UGC NET 2023 18:14
- P16: PRACTICE PROBLEMS ON Database Design(Normalization) | GATE, ESE, PSU, UGC NET 2023 13:58
- P17: PRACTICE PROBLEMS ON Database Design(Normalization) | GATE, ESE, PSU, UGC NET 2023 16:58
