Relational Database Concepts

Outline

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Topics Include
6. Duration
7. Minimum Requirements
8. Media

Description

Teaches practical and useful information about database management systems, their design and environment.

Audience

Programmers, Systems Analysts, Designers, Computer Operators, Managers, Support Personnel, End Users.

Prerequisites

None.

Topics Include

What is a Database? Understanding Data; Objectives of a Database; Typical Database Users; Types of Database Systems Hierarchical Databases; Network Databases; Relational Databases; Life Cycle of a Database Personnel Involved with Database System Development; Stages in Database System Development; What is a Database Management System (DBMS)? Comparison of File Processing to DBMS; Components of a DBMS; Basic Functions of a DBMS; Users View of a Database The Logical Database Design Process; Common Features of a Logical Database Model; Normalization of Data Purpose of Normalization; Normalization Procedures; Optimization; The Data Dictionary/Directory System Purpose of a DD/DS; Functions and Components of a DD/DS; Typical Users; Database Administration Scope of Database Administration; Technical Responsibilities of a Database Administrator; Managerial Responsibilities of a Database Administrator;

© Copyright Serebra Learning Corp., 2002