DBMS

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.
Relational query languages
Relational algebra,
Tuple and domain relational calculus,
SQL3,
DDL and DML constructs,
Open source and Commercial DBMS - MYSQL,
ORACLE,
DB2,
SQL server.
Relational database design
Domain and data dependency,
Armstrong's axioms,
Normal forms,
Dependency preservation,
Lossless design.
Query processing and optimization
Evaluation of relational algebra expressions,
Query equivalence,
Join strategies,
Query optimization algorithms.
Storage strategies
Indices,
B-trees,
hashing.
Transaction processing
Concurrency control,
ACID property,
Serializability of scheduling,
Locking and timestamp based schedulers,
Multi-version and optimistic Concurrency Control schemes,
Database recovery
Database Security
Authentication,
Authorization and access control,
DAC,
MAC and RBAC models,
Intrusion detection,
SQL injection
SQL Concepts
Basics of SQL,
DDL,DML,DCL,
structure – creation,
alteration,
defining constraints –
Primary key,
foreign key,
unique,
not null,
check,
IN operator, aggregate functions,
Built-in functions
numeric,
date,
string functions,
set opera
Exist,
Any,
All ,
view and its types.,
transaction control commands. options,
sub-queries,
correlated
sub-queries,
join,
PL/SQL Concepts
Cursors,
Procedures,
Stored Function,
Database Triggers
Internship
Get in touch with us
close slider