DBMS for GATE Exams
Created by Arnab Chakraborty, Last Updated 05-Sep-2019, Language:English
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
Preview00: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
Preview00: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
Preview00: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
Preview00: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
Preview00: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
Preview00: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
Preview00: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
Preview00: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
Preview00: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
Preview00: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