DBMS for GATE Exams

Simply Easy Learning

Created by Arnab Chakraborty, Last Updated 05-Sep-2019, Language:English

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.

Course Content

DBMS

11 Lectures 00:58:34
- DBMS - Course Overview
  
  Preview
  
  00:04:06
- DBMS - Introduction
  
  00:02:53
- DBMS - Database System Applications
  
  00:03:14
- DBMS - Database System Versus File System
  
  00:09:46
- DBMS - Data Abstraction
  
  00:04:12
- DBMS - Instances and Schemas
  
  00:04:52
- DBMS - Database Users and User Interfaces
  
  00:03:47
- DBMS - Database Administrator
  
  00:04:27
- DBMS - Data Models
  
  00:08:22
- DBMS - Database Languages
  
  00:05:05
- DBMS - Database System Structure
  
  00:07:50
Database Design with E-R Model

22 Lectures 02:00:36
- DBMS - Entity and Entity Set
  
  Preview
  
  00:04:27
- DBMS - Attribute and Domain
  
  00:06:49
- DBMS - Keys Super, Candidate, Primary, Alternate
  
  00:09:13
- DBMS - Keys Foreign, Partial, Secondary
  
  00:10:00
- DBMS - Keys Unique, Surrogate, Composite
  
  00:07:01
- DBMS - Mapping Cardinalities
  
  00:03:16
- DBMS - Relationship and Relationship Sets
  
  00:10:07
- DBMS - Entity Relationship Diagram
  
  00:05:15
- DBMS - Symbols in ER-Diagram
  
  00:03:38
- DBMS - Mapping Cardinalities in ER-Diagram
  
  00:05:59
- DBMS - ER-Diagram With Role-Indicators
  
  00:03:02
- DBMS - ER-Diagram With Ternary Relationship
  
  00:02:24
- DBMS - Weak Entity Set With Total Participation
  
  00:06:55
- DBMS - Specialization and Generalization
  
  00:05:14
- DBMS - ER-Diagram With Aggregation
  
  00:04:18
- DBMS - ER-Diagram With Existence Dependency
  
  Preview
  
  00:04:32
- DBMS - Forming Schemas From ER-Diagram
  
  00:11:09
- DBMS - Case Study on Banking System
  
  00:07:40
- ER-Diagram - GATE Problem 1
  
  00:02:14
- ER-Diagram - GATE Problem 2
  
  00:02:02
- ER-Diagram - GATE Problem 3
  
  00:02:05
- ER-Diagram - GATE Problem 4
  
  00:03:16
Formal Relational Query Languages

26 Lectures 01:54:29
- DBMS - Introduction to Relational Calculus
  
  00:01:12
- DBMS - Tuple Relational Calculus
  
  00:03:29
- DBMS - Tuple Relational Calculus Query Example-1
  
  00:04:29
- DBMS - Tuple Relational Calculus Query Example-2
  
  00:05:46
- DBMS - Domain Relational Calculus Query Example-1
  
  00:04:45
- DBMS - Domain Relational Calculus Query Example-2
  
  00:06:22
- DBMS - Safety of Expressions of Domain and Tuple Relational Calculus
  
  00:02:24
- DBMS - Formal Definition of Domain Relational Calculus
  
  00:01:46
- DBMS - Select Operation in Relational Algebra
  
  00:04:02
- DBMS - Project Operation in Relational Algebra
  
  00:05:14
- DBMS - Union Operation in Relational Algebra
  
  00:03:44
- DBMS - Set-Difference Operation in Relational Algebra
  
  Preview
  
  00:02:48
- DBMS - Set Intersection Operation in Relational Algebra
  
  00:02:13
- DBMS - Cartesian Product Operation in Relational Algebra
  
  00:06:28
- DBMS - Rename Operation in Relational Algebra
  
  00:11:37
- DBMS - Join Operation in Relational Algebra
  
  00:07:19
- DBMS - Division Operation in Relational Algebra
  
  00:08:33
- DBMS - Assignment Operation in Relational Algebra
  
  00:01:53
- DBMS - Aggregate Function in Relational Algebra
  
  00:04:06
- DBMS - Deletion Operation on Database Using Relational Algebra
  
  00:02:29
- DBMS - Insert Operation on Database Using Relational Algebra
  
  00:05:42
- DBMS - Update Operation on Database Using Relational Algebra
  
  00:04:31
- DBMS - View Using Relational Algebra
  
  00:05:46
- Relational Algebra - GATE Problem 1
  
  00:02:15
- Relational Algebra - GATE Problem 2
  
  00:03:02
- Relational Algebra - GATE Problem 3
  
  00:02:34
Introduction to SQL

26 Lectures 01:54:53
- DBMS - Basic Structure of SQL
  
  00:06:09
- DBMS - Select From Where
  
  00:06:08
- DBMS - Rename in SQL
  
  00:05:46
- DBMS - String Related Operations in SQL
  
  Preview
  
  00:04:41
- DBMS - Ordering Tuples in SQL
  
  00:03:48
- DBMS - Union and Intersect Operation in SQL
  
  00:03:12
- DBMS - Except Operation in SQL
  
  00:03:05
- DMS - Aggregate Functions in SQL
  
  00:08:29
- DBMS - Null Values in SQL
  
  00:02:16
- DBMS - Set Membership in SQL
  
  00:03:53
- DBMS - Set Comparison in SQL
  
  00:07:23
- DBMS - Test For Empty Relations in SQL
  
  00:11:00
- DBMS - Test For Absence of Duplicate Tuples In SQL
  
  00:05:29
- DBMS - Assignment on Company Database
  
  00:04:00
- DBMS - Assignment on Company Database Query-1
  
  00:02:15
- DBMS - Assignment on Company Database Query-2
  
  00:06:41
- DBMS - Assignment On Company Database Query-3
  
  00:02:51
- DBMS - Assignment on Company Database Query-4
  
  00:03:40
- DBMS - Assignment on Company Database Query-5
  
  00:03:28
- DBMS - Assignment on Company Database Query-6
  
  00:01:56
- DBMS - Assignment on Company Database Query-7
  
  Preview
  
  00:02:35
- DBMS - Assignment on Company Database Query-8
  
  00:05:34
- DBMS - Assignment On Company Database Query-9
  
  00:02:59
- DBMS - Assignment On Company Database Query-10
  
  00:03:16
- DBMS - Assignment on Company Database Query-11
  
  00:02:27
- DBMS - Assignment on Company Database Query-12
  
  00:01:52
Functional Dependencies and Normalization

23 Lectures 02:14:48
- DBMS - Functional Dependencies (FDs)
  
  00:06:35
- DBMS - Introduction to Normalization Of Database
  
  00:08:35
- DBMS - Rules of Functional Dependency (FD)
  
  00:04:51
- DBMS - First Normal Form (INF)
  
  00:03:31
- DBMS - Second Normal Form (2NF)
  
  00:10:20
- DBMS - Third Normal Form (3NF)
  
  00:08:16
- DBMS - Boyce-Codd Normal Form (BCNF)
  
  00:10:12
- DBMS - Fourth Normal Form 4NF
  
  00:03:12
- DBMS - Closure on Attribute Sets
  
  00:07:12
- DBMS - Canonical Cover Of FDs
  
  00:09:12
- DBMS - 3NF Algorithm
  
  00:10:48
- DBMS - 3NF Algorithm Problem Solve -1
  
  00:05:08
- DBMS - 3NF Algorithm Problem Solve-2
  
  00:08:27
- DBMS - Algorithm to Check Whether a Decomposition Is Lossless
  
  Preview
  
  00:06:42
- DBMS - Check Whether a Decomposition is Lossless Problem Solve -1
  
  00:04:45
- DBMS - Check Whether a Decomposition is Lossless Problem Solve -2
  
  00:04:43
- DBMS - Question Solve on Normalization - 1
  
  00:03:27
- DBMS - Question Solve on Normalization - 2
  
  00:05:08
- DBMS - Question Solve on Normalization - 3
  
  00:02:16
- DBMS - Question Solve on Normalization - 4
  
  00:01:50
- DBMS - Question Solve on Normalization - 5
  
  00:02:03
- DBMS - Question Solve on Functional Dependency
  
  00:02:55
- DBMS - Question Solve on Referential Integrity
  
  00:04:40
Physical Data Organization

31 Lectures 02:52:29
- DBMS - Disk Management
  
  00:14:58
- DBMS - Pages and Blocks
  
  00:04:04
- DBMS - IO Time to Access a Page
  
  00:06:25
- DBMS - Heap Files
  
  00:07:45
- DBMS - Index and Index Structure
  
  00:05:17
- DBMS - Sorted Files
  
  00:08:19
- DBMS - Storage Structure
  
  00:04:20
- DBMS - Clustered Index
  
  00:03:03
- DBMS - Unclustered Structure
  
  00:03:14
- DBMS - Problem on Cost of Range Search
  
  00:04:50
- DBMS - Sparse Vs. Dense Index
  
  00:03:54
- DBMS - Two Level Index
  
  Preview
  
  00:02:20
- DBMS - Multi Level Index
  
  00:02:44
- DBMS - Index Sequential Access Method (ISAM)
  
  00:06:39
- DBMS - B-Tree Definition and Properties
  
  00:06:29
- DBMS - B-Tree an Example
  
  00:08:38
- DBMS - B⁺ Tree
  
  00:06:00
- DBMS - Insertion and Deletion of B⁺ Tree
  
  00:06:54
- DBMS - Hash Index
  
  00:04:02
- DBMS - Choosing a Hash Function
  
  00:04:37
- DBMS - Problems of Hash Addresses
  
  00:02:26
- DBMS - Extendible Hashing
  
  00:08:05
- DBMS - Question Solve on B Tree
  
  00:03:14
- DBMS - Question Solve on B⁺ Tree - 1
  
  00:01:50
- DBMS - Question Solve on B⁺ Tree - 2
  
  00:01:47
- DBMS - Question Solve on B⁺ Tree - 3
  
  00:02:14
- DBMS - Question Solve on Disk Scheduling
  
  00:07:37
- DBMS - Question Solve on Disk - 1
  
  00:06:42
- DBMS - Question Solve on Disk - 2
  
  00:09:52
- DBMS - Question Solve on Disk - 3
  
  00:08:33
- DBMS - Question Solve on Disk - 4
  
  00:05:37
Query Processing & Optimization

2 Lectures 00:10:36
- DBMS - Introduction to Query Processing
  
  Preview
  
  00:03:39
- DBMS - Introduction to Query Processing Example
  
  00:06:57
Transaction Processing and Concurrency Control

24 Lectures 01:46:25
- DBMS - Definition of Transaction
  
  00:02:50
- DBMS - State Transition of a Transaction
  
  00:03:55
- DBMS - ACID Properties of a Transaction
  
  00:04:05
- DBMS - Architecture of a Database Transaction
  
  00:04:02
- DBMS - Serializability and Recoverability
  
  00:07:52
- DBMS - Testing of Serializability
  
  00:08:22
- DBMS - Concurrency Control
  
  00:04:33
- DBMS - Concurrency Control Lost Update Problem
  
  00:03:08
- DBMS - Concurrency Control Uncommitted Dependency Problem
  
  00:03:50
- DBMS - Concurrency Control Inconsistent Analysis Problem
  
  00:05:33
- DBMS - Locking Methods
  
  00:05:06
- DBMS - Two Phase Locking
  
  00:03:18
- DBMS - Preventing Lost Update Problem Using 2PL
  
  00:04:23
- DBMS - Preventing Uncommitted Dependency Problem Using 2PL
  
  Preview
  
  00:03:31
- DBMS - Preventing Inconsistent Analysis Problem Using 2PL
  
  00:04:36
- DBMS - Cascading Rollback Problem Using 2PL
  
  00:05:14
- DBMS - Granularity of Data Items
  
  00:02:46
- DBMS - Non-Repeatable (Or Fuzzy) Read
  
  00:01:29
- DBMS - Phantom Read and Phantom Tuple
  
  00:01:45
- DBMS - Deadlock and Livelock
  
  00:02:36
- DBMS - Time Stamping Methods
  
  00:04:38
- DBMS - Thomas’s Write Rule
  
  00:04:26
- DBMS - Thomas’s Write Rule Example
  
  00:05:32
- DBMS - Optimistic Techniques
  
  00:08:55
Reliable and Reliability

11 Lectures 00:53:36
- DBMS - Reliable and Reliability
  
  00:01:32
- DBMS - Failure, Error and Fault
  
  00:04:08
- DBMS - Types of Failure
  
  00:08:13
- DBMS - Audit Trails
  
  00:03:02
- DBMS - Recovery Schemes
  
  00:05:45
- DBMS - Recovery in a Centralized DBMS
  
  00:02:55
- DBMS - Logs
  
  00:04:19
- DBMS - Checkpoints
  
  00:08:40
- DBMS - Archival Database and Implementation of Storage
  
  00:05:47
- DBMS - Do, Undo, Redo
  
  00:05:26
- DBMS - Reflecting Updates to The Database and Recovery
  
  00:03:49
System Architecture

2 Lectures 00:09:26
- DBMS - Client Server Model
  
  00:05:58
- DBMS - Introduction to Distributed Database
  
  00:03:28

Arnab Chakraborty

Corporate Trainer

Prof. Arnab Chakraborty is a Calcutta University alumnus with B.Sc. in Physics Hons Gold medalist, B. Tech and M. Tech in Computer Science and Engineering has twenty-six+ years of academic teaching experience in different universities, colleges and thirteen+ years of corporate training experiences for 170+ companies and trained 50,000+ professionals. He has also completed MBA from Vidyasagar University with dual specialization in Human Resource Management and Marketing Management. He is NLP and PMP trained, "Global DMAIC Six Sigma Master Black Belt" certified by IQF (USA). He is certified by ISA (USA) on "Control and Automation System". He is "Global ITIL V3 Foundation" certified as awarded by APMG (UK). Qualified for "Accredited Management Teacher" by AIMA (India). "Star Python" Global Certified from Star Certification (USA). "Certified Scrum Master (CSM)" Global Certification from Scrum Alliance (USA). He is also empaneled trainer for multiple corporates, e.g. HP, Accenture, IBM etc