Profile

e-Catalog

Contact

Search

Cart

Database Management

Audience

IS staff - DBA's, systems programmers, database designers, operations staff - requiring training in managing a database environment

Prerequisites

Ability to use SQL, or the course SQL Programming

Course Aim

To enable the student to manage a relational database

Learning Objectives

Classify users into the privilege levels specified by SQL, create users with access to the database and GRANT and REVOKE privileges. Describe the functions of data dictionaries, views, audit trails, and transaction logs as security mechanisms. Distinguish between referential and entity integrity, and state whether particular operations contravene integrity rules. Identify and create primary keys, identify foreign keys, and create an index for a table. Recognize a trigger and describe its operation. Identify three concurrency problems that may arise in relational systems and suggest locking solutions that avoid deadlocking. Distinguish between media and system failures, explain the consequences of transaction failure, and outline the key elements in transaction recovery. Explain the storage structures used at the internal level and relate space allocation to database performance. Discuss data clustering and indexing. Relate storage methods to access. Explain the concept of optimization, and identify the steps in processing and optimizing an SQL query.

Topics Covered

DBMS security - Methods of database security - Accessing a database - GRANT and REVOKE - Transaction logs Integrity - Entity and referential integrity - Foreign keys - Triggers - Integrity checking Concurrency control - Concurrency and transaction processing - Concurrency problems - Locking - Granularity