DBMS for GATE Exams
Simply Easy Learning
-
-
DBMS
11 Lectures-
DBMS - Course Overview
04:06Preview
-
DBMS - Introduction
02:53
-
DBMS - Database System Applications
03:14
-
DBMS - Database System Versus File System
09:46
-
DBMS - Data Abstraction
04:12
-
DBMS - Instances and Schemas
04:52
-
DBMS - Database Users and User Interfaces
03:47
-
DBMS - Database Administrator
04:27
-
DBMS - Data Models
08:22
-
DBMS - Database Languages
05:05
-
DBMS - Database System Structure
07:50
-
DBMS - Course Overview
-
Database Design with E-R Model
22 Lectures-
DBMS - Entity and Entity Set
04:27Preview
-
DBMS - Attribute and Domain
06:49
-
DBMS - Keys Super, Candidate, Primary, Alternate
09:13
-
DBMS - Keys Foreign, Partial, Secondary
10:00
-
DBMS - Keys Unique, Surrogate, Composite
07:01
-
DBMS - Mapping Cardinalities
03:16
-
DBMS - Relationship and Relationship Sets
10:07
-
DBMS - Entity Relationship Diagram
05:15
-
DBMS - Symbols in ER-Diagram
03:38
-
DBMS - Mapping Cardinalities in ER-Diagram
05:59
-
DBMS - ER-Diagram With Role-Indicators
03:02
-
DBMS - ER-Diagram With Ternary Relationship
02:24
-
DBMS - Weak Entity Set With Total Participation
06:55
-
DBMS - Specialization and Generalization
05:14
-
DBMS - ER-Diagram With Aggregation
04:18
-
DBMS - ER-Diagram With Existence Dependency
04:32Preview
-
DBMS - Forming Schemas From ER-Diagram
11:09
-
DBMS - Case Study on Banking System
07:40
-
ER-Diagram - GATE Problem 1
02:14
-
ER-Diagram - GATE Problem 2
02:02
-
ER-Diagram - GATE Problem 3
02:05
-
ER-Diagram - GATE Problem 4
03:16
-
DBMS - Entity and Entity Set
-
Formal Relational Query Languages
26 Lectures-
DBMS - Introduction to Relational Calculus
01:12
-
DBMS - Tuple Relational Calculus
03:29
-
DBMS - Tuple Relational Calculus Query Example-1
04:29
-
DBMS - Tuple Relational Calculus Query Example-2
05:46
-
DBMS - Domain Relational Calculus Query Example-1
04:45
-
DBMS - Domain Relational Calculus Query Example-2
06:22
-
DBMS - Safety of Expressions of Domain and Tuple Relational Calculus
02:24
-
DBMS - Formal Definition of Domain Relational Calculus
01:46
-
DBMS - Select Operation in Relational Algebra
04:02
-
DBMS - Project Operation in Relational Algebra
05:14
-
DBMS - Union Operation in Relational Algebra
03:44
-
DBMS - Set-Difference Operation in Relational Algebra
02:48Preview
-
DBMS - Set Intersection Operation in Relational Algebra
02:13
-
DBMS - Cartesian Product Operation in Relational Algebra
06:28
-
DBMS - Rename Operation in Relational Algebra
11:37
-
DBMS - Join Operation in Relational Algebra
07:19
-
DBMS - Division Operation in Relational Algebra
08:33
-
DBMS - Assignment Operation in Relational Algebra
01:53
-
DBMS - Aggregate Function in Relational Algebra
04:06
-
DBMS - Deletion Operation on Database Using Relational Algebra
02:29
-
DBMS - Insert Operation on Database Using Relational Algebra
05:42
-
DBMS - Update Operation on Database Using Relational Algebra
04:31
-
DBMS - View Using Relational Algebra
05:46
-
Relational Algebra - GATE Problem 1
02:15
-
Relational Algebra - GATE Problem 2
03:02
-
Relational Algebra - GATE Problem 3
02:34
-
DBMS - Introduction to Relational Calculus
-
Introduction to SQL
26 Lectures-
DBMS - Basic Structure of SQL
06:09
-
DBMS - Select From Where
06:08
-
DBMS - Rename in SQL
05:46
-
DBMS - String Related Operations in SQL
04:41Preview
-
DBMS - Ordering Tuples in SQL
03:48
-
DBMS - Union and Intersect Operation in SQL
03:12
-
DBMS - Except Operation in SQL
03:05
-
DMS - Aggregate Functions in SQL
08:29
-
DBMS - Null Values in SQL
02:16
-
DBMS - Set Membership in SQL
03:53
-
DBMS - Set Comparison in SQL
07:23
-
DBMS - Test For Empty Relations in SQL
11:00
-
DBMS - Test For Absence of Duplicate Tuples In SQL
05:29
-
DBMS - Assignment on Company Database
04:00
-
DBMS - Assignment on Company Database Query-1
02:15
-
DBMS - Assignment on Company Database Query-2
06:41
-
DBMS - Assignment On Company Database Query-3
02:51
-
DBMS - Assignment on Company Database Query-4
03:40
-
DBMS - Assignment on Company Database Query-5
03:28
-
DBMS - Assignment on Company Database Query-6
01:56
-
DBMS - Assignment on Company Database Query-7
02:35Preview
-
DBMS - Assignment on Company Database Query-8
05:34
-
DBMS - Assignment On Company Database Query-9
02:59
-
DBMS - Assignment On Company Database Query-10
03:16
-
DBMS - Assignment on Company Database Query-11
02:27
-
DBMS - Assignment on Company Database Query-12
01:52
-
DBMS - Basic Structure of SQL
-
Functional Dependencies and Normalization
23 Lectures-
DBMS - Functional Dependencies (FDs)
06:35
-
DBMS - Introduction to Normalization Of Database
08:35
-
DBMS - Rules of Functional Dependency (FD)
04:51
-
DBMS - First Normal Form (INF)
03:31
-
DBMS - Second Normal Form (2NF)
10:20
-
DBMS - Third Normal Form (3NF)
08:16
-
DBMS - Boyce-Codd Normal Form (BCNF)
10:12
-
DBMS - Fourth Normal Form 4NF
03:12
-
DBMS - Closure on Attribute Sets
07:12
-
DBMS - Canonical Cover Of FDs
09:12
-
DBMS - 3NF Algorithm
10:48
-
DBMS - 3NF Algorithm Problem Solve -1
05:08
-
DBMS - 3NF Algorithm Problem Solve-2
08:27
-
DBMS - Algorithm to Check Whether a Decomposition Is Lossless
06:42Preview
-
DBMS - Check Whether a Decomposition is Lossless Problem Solve -1
04:45
-
DBMS - Check Whether a Decomposition is Lossless Problem Solve -2
04:43
-
DBMS - Question Solve on Normalization - 1
03:27
-
DBMS - Question Solve on Normalization - 2
05:08
-
DBMS - Question Solve on Normalization - 3
02:16
-
DBMS - Question Solve on Normalization - 4
01:50
-
DBMS - Question Solve on Normalization - 5
02:03
-
DBMS - Question Solve on Functional Dependency
02:55
-
DBMS - Question Solve on Referential Integrity
04:40
-
DBMS - Functional Dependencies (FDs)
-
Physical Data Organization
31 Lectures-
DBMS - Disk Management
14:58
-
DBMS - Pages and Blocks
04:04
-
DBMS - IO Time to Access a Page
06:25
-
DBMS - Heap Files
07:45
-
DBMS - Index and Index Structure
05:17
-
DBMS - Sorted Files
08:19
-
DBMS - Storage Structure
04:20
-
DBMS - Clustered Index
03:03
-
DBMS - Unclustered Structure
03:14
-
DBMS - Problem on Cost of Range Search
04:50
-
DBMS - Sparse Vs. Dense Index
03:54
-
DBMS - Two Level Index
02:20Preview
-
DBMS - Multi Level Index
02:44
-
DBMS - Index Sequential Access Method (ISAM)
06:39
-
DBMS - B-Tree Definition and Properties
06:29
-
DBMS - B-Tree an Example
08:38
-
DBMS - B<sup>+</sup> Tree
06:00
-
DBMS - Insertion and Deletion of B<sup>+</sup> Tree
06:54
-
DBMS - Hash Index
04:02
-
DBMS - Choosing a Hash Function
04:37
-
DBMS - Problems of Hash Addresses
02:26
-
DBMS - Extendible Hashing
08:05
-
DBMS - Question Solve on B Tree
03:14
-
DBMS - Question Solve on B<sup>+</sup> Tree - 1
01:50
-
DBMS - Question Solve on B<sup>+</sup> Tree - 2
01:47
-
DBMS - Question Solve on B<sup>+</sup> Tree - 3
02:14
-
DBMS - Question Solve on Disk Scheduling
07:37
-
DBMS - Question Solve on Disk - 1
06:42
-
DBMS - Question Solve on Disk - 2
09:52
-
DBMS - Question Solve on Disk - 3
08:33
-
DBMS - Question Solve on Disk - 4
05:37
-
DBMS - Disk Management
-
Query Processing & Optimization
2 Lectures-
DBMS - Introduction to Query Processing
03:39Preview
-
DBMS - Introduction to Query Processing Example
06:57
-
DBMS - Introduction to Query Processing
-
Transaction Processing and Concurrency Control
24 Lectures-
DBMS - Definition of Transaction
02:50
-
DBMS - State Transition of a Transaction
03:55
-
DBMS - ACID Properties of a Transaction
04:05
-
DBMS - Architecture of a Database Transaction
04:02
-
DBMS - Serializability and Recoverability
07:52
-
DBMS - Testing of Serializability
08:22
-
DBMS - Concurrency Control
04:33
-
DBMS - Concurrency Control Lost Update Problem
03:08
-
DBMS - Concurrency Control Uncommitted Dependency Problem
03:50
-
DBMS - Concurrency Control Inconsistent Analysis Problem
05:33
-
DBMS - Locking Methods
05:06
-
DBMS - Two Phase Locking
03:18
-
DBMS - Preventing Lost Update Problem Using 2PL
04:23
-
DBMS - Preventing Uncommitted Dependency Problem Using 2PL
03:31Preview
-
DBMS - Preventing Inconsistent Analysis Problem Using 2PL
04:36
-
DBMS - Cascading Rollback Problem Using 2PL
05:14
-
DBMS - Granularity of Data Items
02:46
-
DBMS - Non-Repeatable (Or Fuzzy) Read
01:29
-
DBMS - Phantom Read and Phantom Tuple
01:45
-
DBMS - Deadlock and Livelock
02:36
-
DBMS - Time Stamping Methods
04:38
-
DBMS - Thomas’s Write Rule
04:26
-
DBMS - Thomas’s Write Rule Example
05:32
-
DBMS - Optimistic Techniques
08:55
-
DBMS - Definition of Transaction
-
Reliable and Reliability
11 Lectures-
DBMS - Reliable and Reliability
01:32
-
DBMS - Failure, Error and Fault
04:08
-
DBMS - Types of Failure
08:13
-
DBMS - Audit Trails
03:02
-
DBMS - Recovery Schemes
05:45
-
DBMS - Recovery in a Centralized DBMS
02:55
-
DBMS - Logs
04:19
-
DBMS - Checkpoints
08:40
-
DBMS - Archival Database and Implementation of Storage
05:47
-
DBMS - Do, Undo, Redo
05:26
-
DBMS - Reflecting Updates to The Database and Recovery
03:49
-
DBMS - Reliable and Reliability
-
System Architecture
2 Lectures-
DBMS - Client Server Model
05:58
-
DBMS - Introduction to Distributed Database
03:28
-
DBMS - Client Server Model
-
DBMS
-
Description
Database Management System or DBMS in short refers to the technology of storing and retrieving users’ data with utmost efficiency along with appropriate security measures. This tutorial explains different aspects of DBMS such as its architecture, data models, data schemas, data independence, E-R model, relation model, relational database design, functional dependencies, normalization, transaction management, concurrency control, recovery, reliability and storage and file structure and much more.
Audience
This tutorial will especially help GATE Exams aspirant students to get detailed study based on the respective syllabus and good guidance towards solving GATE Exams question and answers.
-
Preview
Preview Videos
- DBMS - Course Overview
- DBMS - Entity and Entity Set
- DBMS - ER-Diagram With Existence Dependency
- DBMS - Set-Difference Operation in Relational Algebra
- DBMS - String Related Operations in SQL
- DBMS - Assignment on Company Database Query-7
- DBMS - Algorithm to Check Whether a Decomposition Is Lossless
- DBMS - Two Level Index
- DBMS - Introduction to Query Processing
- DBMS - Preventing Uncommitted Dependency Problem Using 2PL
14.5 hours
178 Lectures
Lifetime Access
30-Days Money Back Guarantee
Sample Certificate
