|
Database Management
|
|
Database Technologies / DBMS / RDBMS
|
Concepts of System
Information Systems
Classification of Information systems
Database System
Components of DBMS
Data base concepts
File Organization
Data Structures in databases
Data Models
Steps of Database Design
Normalization
- Denormalization
- Keys
- Normalization Concepts
- Normalization Forms
Implementation Design
Network Data Base Management System
Data Modeling
- Data Modeling Concepts
- Logical versus Physical
- Redefining Tables
Relational Data Base Management System
Relational Algebra
Traditional Set Operators
- Union
- Intersection
- Minus
- Product
Special Relational Operators
- Selection
- Projection
- Join
Examples of Languages that follow Relational Alegebra
Relational Calculus
- What is a Well Formed Formula (WFF)?
- Examples of Languages that follow Relational Alegebra
Relational Algebra vs Relational Calculus
Structured Query Languages
- Basic Concept
- Basic Rules
- Cascades
- Referential Integrity Concept
- Result Sets
- SQL Functions Examples
- SQL Object Creation (Table, View, Index Mgmt.)
- SQL Object Creation Concept
- SQL Queries - Joins
- Views
Data Base Operational Maintenance
- Data Administration
- Database Administration
- Roles of a Database Administrator
- Database Security
- Concurrency
- What is Concurrency
- Problems due to Concurrency
- Inconsistent Read
- Lost Update
- How is Concurrency controlled?
- Locking Schemes
- Shared Lock (Ls)
- Exclusive Lock (Le)
Procedures and Transactions
- Cursors
- Procedures Concept
- Transaction Recoverability
- Transactions - Concept
- Triggers Concept
- Database Deadlock
- Deadlock Prevention
- Wait-Die Scheme
- Wound-Wait Scheme
- TimeOut
- Deadlock - Detection
- Deadlock - Recovery
- Database Recovery
- Backup & Restoration
- Transaction Log
- Checkpointing
|
|
