Course Content
Introduction:
- Approach to Data Management
- Advantages of Database Systems
- Functions of DBMS
- Role of a Database Administrator
- Types of Database Systems
The Internal Level
- Clustering
- Indexing
- Hashing
The Relational Model
- Relational Databases: Terminology
- Properties of Relations
- Integrity Rules
- Relational Algebra Operators
SQL
- Overview
- Data Manipulation LanguageSELECT
- General SELECT statements
- Nested SELECT statements
- Date Arithemetic Arithmetic
- Expressions
- Numeric Functions
- Date Functions
- Character Expressions & Functions
- The INSERT statement
- The UPDATE statement
- The DELETE statement
- Data Definition Language
- Data Control Language
Recovery and Concurrency
- Transaction
- Recovery from System Failures
- Recovery: An Example
- Concurrency
- Locking
- Deadlocks
Query Optimization
- Query Optimization Overview
- An Example of Query Optimization
- The Query Optimization Process
- Query Optimization in Oracle