Database Management systems (DBMS) Course Contents
Database Management systems
1. Introduction:3. The Relational Model
- 3.1 Relational Databases: Terminology
- 3.2 Properties of Relations
- 3.3 Integrity Rules
- 3.4 Relational Algebra Operators
- 4.1 Overview
- 4.2.1Data Manipulation Language-SELECT
- 4.2.1.1 General SELECT statements
- 4.2.1.2 Nested SELECT statements
- 4.2.1.3 Date Arithemetic Arithmetic Expressions
- 4.2.1.4 Numeric Functions
- 4.2.1.5 Date Functions
- 4.2.1.6 Character Expressions & Functions
- 4.2.2 The INSERT statement
- 4.2.3 The UPDATE statement
- 4.2.4 The DELETE statement
- 4.3 Data Definition Language
- 4.4 Data Control Language
- 5.1 Transaction
- 5.2 Recovery from System Failures
- 5.3 Recovery: An Example
- 5.4 Concurrency
- 5.5 Locking
- 5.6 Deadlocks
- 6.1 Query Optimization Overview
- 6.1 Query Optimization Overview
- 6.2 An Example of Query Optimization
- 6.3 The Query Optimization Process
- 6.4 Query Optimization in Oracle
Leave a Comment