|
NOTE: SHARING OF SCREENSHOTS, PDFs IS PROHIBITED. Account will be banned paermanently
|
|
|
INTRODUCTION TO BASIC CONCEPTS : By Shrikant Sir
|
|
|
|
Introduction to DBMS
|
|
|
|
File System vs DBMS
|
|
|
|
Relation,Keys and More Basics Concepts
|
|
|
|
Integrity Constraints
|
|
|
Entity-Relationship Model
|
|
|
|
ER Diagram: Part 1
|
|
|
|
ER Diagram: Part 2
|
|
|
|
ER Diagram: Part 3
|
|
|
|
Concept Clearing MCQs
|
|
|
|
ER Diagrams
|
|
|
Relational Algebra
|
|
|
|
Introduction To Relational Model
|
|
|
|
Complete Relational Algebra
|
|
|
|
tuple calculus complete lecture ( Prerequisites: requires basics of predicate logic)
|
|
|
Transaction and concurrency control
|
|
|
|
Introduction To Transaction and concurrency control
|
|
|
|
Transaction States
|
|
|
|
Lost Update and Dirty Read Problem
|
|
|
|
Unrepeatable Read | Phantom Tuple | Incorrect Summary Problem
|
|
|
|
Concept of Schedule
|
|
|
|
Concept of Recoverable Schedule
|
|
|
|
Cascading Abort | Cascadeless | Strict Schedule
|
|
|
|
Relationship Between Recoverable, Cascadeless, Strict Schedule
|
|
|
|
Numerical on Recoverable, Cascadeless, Strict
|
|
|
|
Concept of Serializability
|
|
|
|
Conflict Serializable Schedule
|
|
|
|
View Serializable Schedule
|
|
|
|
Relationship Between View Serializable & Conflict Serializable Schedules
|
|
|
|
Numerical on Serializability
|
|
|
|
Transaction Asignment 1
|
|
|
|
Transaction Assignment 1 Solution
|
|
|
|
Transaction Asignment 2
|
|
|
|
Transaction Assignment 3
|
|
|
|
Types of Lock
|
|
|
|
Two Phase Locking Protocol | 2PL
|
|
|
|
Conservative Strict and rigorous 2PL
|
|
|
|
Asignment 2 &3 Dicussion
|
|
|
|
Transaction Test 1
|
|
|
|
Test 1 Dioscussion
|
|
|
|
Transaction Analysis
|
|
|
|
Timstamp and 2PL Concept
|
|
|
|
Deadlock Prevention Techniques For 2PL
|
|
|
|
Wait-Die & Wound-Wait Reading
|
|
|
|
Basic Timestamp Ordering Protocol For Concurrency Control
|
|
|
|
Strict Timestamp and Thompson Write Rule
|
|
|
|
HandWritten Notes On Transaction (Deepa T.)
|
|
|
|
HandWritten Notes On Transaction (Jash)
|
|
|
Relational Database Design
|
|
|
|
Concept of Functional Dependency
|
|
|
|
Types of Functional Dependency
|
|
|
|
Live Lecture: Inference Rule
|
|
|
|
Closure Operation on Attributes
|
|
|
|
Finding Candidate Key using Functional Dependencies
|
|
|
|
Finding Candidate Key Examples
|
|
|
|
Equivalence of Two Functional Dependency Set
|
|
|
|
Minimization of Functional Dependency
|
|
|
|
Live Session: Numerical on Candidate Key
|
|
|
|
Gate Questions and Numerical on Minimization
|
|
|
|
Anomalies Due To Redundancy
|
|
|
|
Lossy Versus Lossless Decomposition
|
|
|
|
Concept of Dependency Preserving Decomposition
|
|
|
|
Numerical on Dependency Preserving & Lossless Decomposition
|
|
|
|
First Normal Form | 1NF
|
|
|
|
Second Normal Form| 2NF
|
|
|
|
Third Normal Form | 3NF
|
|
|
|
Normalization Numerical Part 1
|
|
|
|
Normalization Numerical Part 2
|
|
|
|
Normalization Numerical Part 3
|
|
|
|
Normalization Assignment 1
|
|
|
|
Normalization Assignment 1 Solution
|
|
|
|
Normalization Test
|
|
|
|
Normalization Test Discussion
|
|
|
|
Live Lecture: Multivalued Dependency and 4NF
|
|
|
Structured Query Language
|
|
|
|
Introduction To SQL
|
|
|
|
Creating Table in SQL
|
|
|
|
Recording - SQL Constraints and Pattern Matching
|
|
|
|
SET Operations,Various Operators,Aggregate functions , group by and having clause.
|
|
|
|
Recording - Joins and Views
|
|
|
|
Database Example
|
|
|
|
Understanding the different SQL JOIN types
|
|
|
|
Views
|
|
|
|
Recording - Nested Query and Subrelated Query
|
|
|
|
Recording - SQL Problem Solving : Part 1
|
|
|
|
Recording - SQL Problem Solving : Part 2
|
|
|
|
DBMS_SQL1
|
|
|
|
DBMS_SQL2
|
|
|
TEST SERIES
|
|
|
|
Transaction Test 1
|
|
|
|
Transaction Test 2
|
|
|
|
Normalization Test 1
|
|
|
|
Normalization Test 2
|
|
|
B & B+ TREES, FILE INDEXING
|
|
|
|
FILE AND INDEXING
|
|
|
|
B & B+ TREES
|
|
|
|
INDEXING NUMERICAL
|
|
Launch your Graphy