Topic
OSI Model
Characteristics of a Database
Data Independence
Components of Database
Architecture of Database
Structure of DBMS and Database Structure of Database Management System
File Processing System
Database Management System
Tables in DBMS
Views in DBMS
Materialized Views in DBMS
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 in DBMS
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 Algebra
Relational Calculus – Tuple Relational Calculus – Domain Relational Calculus
File Organization in DBMS
Sequential File Organization in DBMS
Heap File Organization in DBMS
Hash/Direct File Organization in DBMS
Indexed Sequential Access Method (ISAM)
B+ Tree File Organization
Cluster File Organization in DBMS
Data Dictionary and Types of Data Dictionary
Structure, Views and Architecture of Data Dictionary
Functions, Advantages and Disadvantages of Data Dictionary
Basic concepts of Indexing – Ordered indices
Concepts of B+ Tree and Extensions – B+ and B Tree index files in DBMS
Multiple Key Access
Hashing Concepts
Bitmap Indices, Advantages and Disadvantages
Database Index
Relational Models
Database Keys
Database Constraints
Database Integrity
Relational Set Operators in DBMS
System Catalog
Codd’s Rule in DBMS
Normalization in DBMS
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (3.5NF) – BCNF
Fourth Normal Form (4NF)
Fifth Normal Form (5NF)
De-normalization in Database
Difference between Normalization and De-normalization in Database (DBMS)
Database Transaction (DBMS)
Concurrency Control in DBMS
DBMS Deadlock
Data Backup And Recovery in DBMS
Exceptions in DBMS
Triggers in DBMS
Data Types and Variables in DBMS
Advanced SQL
Select Operation in DBMS
NULL Values in DBMS
Sorting in DBMS
Aggregation in DBMS
Join operation in DBMS
Sub Queries in DBMS
Correlated Sub Queries in DBMS
Union in DBMS
Minus in DBMS
Intersect in DBMS
Rename in DBMS
Distinct in DBMS
Like in DBMS
Rownum in DBMS
Conditional Control in DBMS
Case Statement in DBMS
Cursors in DBMS
Query Processing in DBMS
Selection Algorithm in DBMS
File Scan in DBMS
Index Scan in DBMS
Conjunctions, Disjunction and Negation in DBMS
Joins in DBMS
Duplicate Elimination in DBMS
Grouping in DBMS
Set Operation in DBMS
Outer Joins in DBMS
Complex Joins in DBMS
Evaluation of Expressions in DBMS
Transformation of Relational Expressions in DBMS
Equivalence Rule in DBMS
Sorting Method in DBMS
Query Optimization in DBMS
Materialized Views (MV) in DBMS
Evaluation Plans in DBMS
Estimating Statistics of Expression results in DBMS
Size Estimation (Selectivity) in DBMS
Techniques of Operator Evaluation in DBMS
Choice of Evaluation Plans in DBMS
Database Transaction in DBMS
Transaction Management Concept in DBMS
Transaction Model in DBMS
Schedules in DBMS
Transaction Atomicity & Durability in DBMS
Logs in DBMS
Write-Ahead Log in DBMS
Shadow Database in DBMS
Storage Structure in DBMS
Data Access in DBMS
Data Backup in DBMS
Data Recovery in DBMS
Shadow paging in DBMS
Recovery with Concurrent Transactions in DBMS
Advanced Recovery Techniques in DBMS
Transaction Isolation in DBMS
Transaction Isolation Levels in DBMS
Transaction Serializability in DBMS
Transaction Isolation Implementations in DBMS
Deadlock Handling in DBMS
Embedded SQL in DBMS
Dynamic SQL in DBMS
Document Database in DBMS
XML Database in DBMS
XPath in DBMS
XQuery in DBMS
Distribute Database Systems in DBMS
Data fragmentation in DBMS
Distributed query processing in DBMS
Distributed concurrency in DBMS
Creating Database in Oracle in DBMS