RDBMS

 

INTRODUCTION OF DBMS

Data processing

Introduction of DBMS

TRADITIONAL FILE-ORIENTED APPROACH 

  Introduction of database approach:

  Introduction of database approach:( In Hindi)

 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

Data Warehouses in DBMS

 

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

 Variables in MySQL Stored Procedure 

Stored Function in mysql

 Triggers in MySQL 

 

 

 

 

 

 

 PL /SQL

PL/SQL Trigger
PL/SQL Cursor

 

 

Post a Comment

0 Comments