Helpline No :
|
Email: admissions@igu.ac.in

Staff Login

Basics of database system architecture
Database system architecture: Data Abstraction, Data Independence, Data Definition Language (DDL), Data Manipulation Language (DML). Data models: Entity-relationship model, network model, relational and object oriented data models, integrity constraints, data manipulation operations.

DDL DML

Data Models

Introduction of Relational Algebra

Normalization

joins in dbms

DDL- Data DEFINITION LANGUAGE – CREATE, ALTER, TRUNCATE, DROP

SQL Server CONVERT

Query optimization

Distributed Databases

Transaction in DBMS

2 phase locking

optimistic concurrency control

Multi version concurrency control

Shadow Paging and Logging

dbms concurrency deadlock

Multi-version

Database Security

Database Security(2)

What is DAC

SQL injection

Database types ORD spatial

Advance databases

Distributed Databases