Relational Database Concepts and Facilities

This course covers the general conceptual methodology, models, and technology that are utilized in Relational Database Management Systems (RDBMS). The course is designed to give the user a top-down overview of relational database development and implementation. By breaking down the application development process into distinct components, the student will understand the key features of Relational Database Technology.

Relational Database Concepts and Facilities training covers such topics as:

Basic Relational Concepts
Database Objects
Designing the Logical Model
Developing the Relational Model
Using the Database

The course is designed to give an overview of relational database development and implementation

Relational Database Concepts and Facilities
Description
This course covers the general conceptual methodology, models, and technology that are utilized
in Relational Database Management Systems (RDBMS). The course is designed to give the user a
top-down overview of relational database development and implementation. By breaking down
the application development process into distinct components, the student will understand the key
features of Relational Database Technology.
Audience
The course is designed to give an overview of relational database development and
implementation.
Prerequisites
Some knowledge of an RDBMS.
Course Duration
» 5 hours
Topics Include
Unit 1- Basic Relational Concepts
» Database Terminology
Unit 2 - Database Objects
» Data Structures
» Database Management System
» Roles of Database Personal
Unit 3 - Designing the Logical Model
» Data Modeling
» Normalization
Unit 4:
- Developing the Relational Model
» Relational (Physical) Model
» Data Storage Language
» Data Definition Language
» Data Manipulation Language
Unit 5 - Using the Database
» Writing Applications
» Structure Query Language
» Unit of Work
» Application Functions
» Authentication
» Distributed Databases

System Requirements

» Pentium class computer
» 200 MHz processor (266 MHz recommended)
» 32 MB RAM (64 MB recommended)
» CD-ROM drive
» Any one of Windows 95, Windows 98, Windows Me, Windows NT 4.0, or Windows
2000 (both Windows NT 4.0 and Windows 2000 require at least 64 MB RAM)
» SVGA monitor capable of 16-bit color and 800 x 600 screen resolution
» Sound card with speakers or headphones (optional)

Features
• Industry-leading Technology - CCI's Learning Object Framework enables the design and development of flexible, self-contained learning modules for a personalized training experience

• Award-winning Products - eSchool Solutions create anywhere, anytime learning environments that boost productivity with their off-the-shelf courseware or fully customized content.

• Powerful Training Solutions - Highly adaptable and customized e-learning models and instructional design tailored to the diverse needs of the training industry, delivered in a packaged CD or on the Web.

• Satisfied Clients - With a solid reputation for quality products and bottom-line results, CCI's e-learning solutions have been adopted by diverse organizations including Royal Bank, Thomson Publishing, IBM, Paradyne Corporation, InfoCast Corporation, GE, Delta Environmental, HighTech Campus, California Federal Bank, CIBC and many others.