About
Contact
Register
Home
Programming
Java
HTML
CSS
JavaScript
React
JQuery
Ajax
PHP
Node.js
Python
C Programming
Databases
Oracle
MySQL
MongoDB
Neo4j
Redis
Cassandra
Subjects
Cyber Security
Ethical Hacking
Database Management Systems
Advanced Database Management Systems
Software Engineering
DBMS Home
Introduction to Database Management Systems
DBMS users, Application and Products
Installation - Oracle Database 11g Release 2 Express Edition
DBMS client server Architecture, SQL DDL and DML Commands
SQL -Multiple record Insert, Select with Where, Operators
Null and is Not Null, SQL Update and Delete, SQL Number Functions
SQL Constraints - Not null and Check Constraints
Unique, Default and Primary Key Constraints
Foreign Keys, On Delete Cascade, On Delete Set Null
Why an Entity Relationship (ER) Model, Parts of an ER model
ER Diagrams -Cardinality Ratio, ER to Relational/Table Mapping
Enhanced Entity Relationship (EER) Modelling , EER to Tables
Three Schema Architecture , Data Independence and DBMS Components
Group by, Having, Order by Clause
Joins, Equi, Non Equi, Self and Natural Join
Cross Join, Outer Join
Excercise on Joins
Informal Measures, Functional Dependency, Inference Rules
Inference Rules, Closure, Equivalence of FD'S
Minimal Covers, Normalization, 1st Normal Form
Second,Third and Boyce Codd Normal Forms
Test for Nonadditive Join Property of a Decomposition
Fourth and Fifth Normal Form
Relational Algebra
Heuristic Query Optimization - Session I
Heuristic Query Optimization Session 2
Introduction to Transaction Processing
Types of Locks, Preventing Lost Update Problem using Locks
2 Phase Locking Protocol (Strict and Rigorous 2PL)
Demo on 2 Phase Locking Protocol (Strict 2 Phase Locking)
Deadlock Avoidance, Conservative 2PL, Wait-Die and Wound-Wait
Recovery Techniques - Deferred update and Immediate Update
Shadow Paging
Recoverable Vs Non Recoverable Schedules
Precedence Graphs for Testing Serializability of a Schedule
Index, Primary and Secondary Index, Dense and Sparse Index
Multilevel Index, Dynamic Multilevel Index, B+ Trees
< Previous
Next >
DBMS - Excercise on Joins
< Previous
Next >