RDBMS

 

INTRODUCTION OF DBMS

Data processing

Introduction of DBMS

TRADITIONAL FILE-ORIENTED APPROACH

Introduction of database approach:

Introduction of database approach:( In Hindi)

Characteristics of the Database Approach

Database System Structure & architecture

डेटाबेस सिस्टम structure and architecture (हिंदी में)

Data Models

The comparison among the record based data models in DBMS

DATA INDEPENDENCE IN DBMS

Schema and Instances

Database Language in DBMS

User Interfaces in DBMS

Entity in DBMS

Attributes in DBMS

Relationship in DBMS

Mapping Cardinalities (Dependencies) in DBMS

Roles in E-R Diagrams in DBMS

E. R. Model (entity relationship model) (E-R Diagram) in DBMS

Converting ER Diagrams to Tables in DBMS

Constraints in DBMS

KEYS IN DBMS

RELATIONAL ALGEBRA IN DBMS

Normalization in DBMS

Inference Rule (IR) in DBMS

Functional Dependency in DBMS

....

Concurrency Control:

DBMS Transaction Management: Introduction ACID

Operations and states of Transaction in DBMS

Schedule in DBMS

Deadlock in DBMS

Starvation in DBMS

Concurrency control

Lock Based Protocol and 2PL in DBMS

Time-Stamp Based Protocol in DBMS

Validation Based Protocol (optimistic concurrency control technique) in DBMS

Overview of database recovery techniques in DBMS

Data Warehouses in DBMS

SQL

DATA TYPE OF MYSQL

DDL (DATA DEFINITION LANGUAGE)- COMMANDS/ STATEMENTS IN THE SQL

DML (DATA MANIPULATION LANGUAGE)

Stored Procedure in MySQL

Variables in MySQL Stored Procedure

IF Statement in MySQL

CASE Statement in MySQL

LOOPING IN MySQL

MySQL Views

Stored Function in mysql

Triggers in MySQL

PL /SQL

PL/SQL Trigger

PL/SQL Cursor