DBMS Tutorial
Characteristics of a DB
Data Independence
Components of Database
Architecture of Database
Structure of DBMS
File Processing System
Database Management System
Tables
Views
Materialized Views
Database Schema
Database Instance
Database Languages
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Control Language (DCL)
Transaction Control Language (TCL)
Database Interface
Data Models
Object based Data Models
Physical Data Models
Record based Data Models
Basic Concepts of ER Data Model
ER Data Model
Convert ER Diagram into Tables
Database Abstraction
Database Users and Administrators
Relational Query Languages
Relational Calculus
File Organization
Sequential File Organization
Heap File Organization
Hash File Organization
Indexed Sequential Access
B+ Tree File Organization
Cluster File Organization
Data Dictionary
Data Dictionary Structure
Data Dictionary Functions
Indexing Basics
B+ Tree
Multiple Key Access
Hashing Concepts
Bitmap Index
Database Index
Relational Models
Database Keys
Database Constraints
Database Integrity
Relational Set Operators
System Catalog
Codd’s Rule
Normalization
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (3.5NF)
Fourth Normal Form (4NF)
Fifth Normal Form (5NF)
De-normalization
Normalization Vs De-normalization
Database Transaction
Schedules in DBMS
Concurrency Control
DBMS Deadlock
Data Backup And Recovery
Exceptions in DBMS
Triggers
DataTypes and Variables
Advanced SQL
Select Operation
NULL Values
Sorting
Aggregation
Join operation
Sub Queries
Correlated Sub Queries
Union
Minus
Intersect
Rename
Distinct
Like
Rownum
Conditional Control
Case Statement
Cursors
Query Processing
Selection Algorithm
File Scan
Index Scan
Conjunctions, Disjunction and Negation
Joins
Duplicate Elimination
Grouping
Set Operation
Outer Joins
Complex Joins
Evaluation of Expressions
Transformation of Expressions
Equivalence Rule
Sorting Method
Query Optimization
Materialized Views (MV)
Evaluation Plans
Estimating Statistics of Expression results
Size Estimation (Selectivity)
Techniques of Operator Evaluation
Choice of Evaluation Plans
Database Transaction
Transaction Management Concept
Transaction Model
Schedules
Transaction Atomicity & Durability
Logs
Write-Ahead Log
Shadow Database
Storage Structure
Data Access
Data Backup
Data Recovery
Shadow paging
Recovery with Concurrent Transactions
Advanced Recovery Techniques
Transaction Isolation
Transaction Isolation Levels
Transaction Serializability
Transaction Isolation Implementations
Concurrency Control
Deadlock Handling
Embedded SQL
Dynamic SQL
Document Database
XML Database
XPath
XQuery
Distribute Database Systems
Data fragmentation
Distributed query processing in SQL
Distributed concurrency
Creating Database in Oracle