Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: Serebra Learning Corporation

DB2 Design & Administration (Rel 2.3)

Click here for more information or to take this course
Serebra Learning Corporation


  home  : Computer  : Databases and SQL  : DB2

Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by Serebra Learning Corporation

Provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance.

Training Avaliability and Delivery

This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
study at homeThis course may be available for home-study
web-based,online cbt,cdweb-based,online cbt,cd
Contact Serebra Learning Corporation for more information
Schedule:9 hours
Training Presented in:English

Related Keywords:  db2   design   administration   rel   database   performance   commands   efficiency   impact   indexes   integrity   referential 

Training Program Details


DB2 Design & Administration (Rel 2.3)
Course Code FC190

Outline

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

Description

Provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance.

Audience

Database Administrators, Analysts and Systems Designers.

Prerequisites

Thorough knowledge of DB2

Topics Include

Introductory Concepts Four Major Goals of a Database Management System; Structure of a Relational Database; Relational Database Structure; Conceptual Design Designing Tables and Normalizing to 3rd Normal Form; Appropriate Primary/Foreign Keys; Design Considerations that Impact Efficiency and Performance; Implementing the Conceptual Design DB2 OBJECTS: DATABASE, TABLESPACE, TABLE, INDEX; Creating DB2 Objects using DDL Command CREATE; Performance and Efficiency Considerations; Indexes Usage and Physical Implementation of Indexes; Roles and Creation of Clustering Indexes; Impact of Index Usage on Performance/Efficiency; Referential Integrity DB2 Referential Integrity vs. User Enforced Referential Integrity; RI Rules and Options for DELETE, UPDATE, INSERT Commands; DB2 Storage Definition Estimating Storage Quantities; Using the CREATE Command to Complete Necessary Space Attribute; PRIQTY, SECQTY, FREEPAGE, PCTFREE, SEGSIZE, LOCKSIZE; Managing Database Space Requirements; Security Using GRANT and REVOKE Commands to Authorize and Remove Database Authority; Security and Hierarchy Access; Database Management DML Commands ALTER and DROP; Monitoring DB2 Activity using the DB2 Catalog; 3rd Party, After Market Vendor Tools for Monitoring/Managing DB2 Databases; DB2 Performance Tuning Utilities RUNSTATS, EXPLAIN and TRACE; DB2 Optimizer and Access Path Selection; Impact of SQL Coding on Performance;

Duration

9 hrs

Minimum Requirements

CGA Color Monitor 512K RAM 2.5MB Hard Disk Space DOS 3.3 or Higher   Copyright © 1997 FirstClass Systems Corporation.

Media

© Copyright Serebra Learning Corp., 2002


About Serebra Learning Corporation - Training Provider

Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...

More Training from Serebra Learning Corporation

Click here for more information or to take this course

Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links


Connecting people who want to learn with people who love to teach
 Are you a Db2 training provider?
You could be on this page today - for FREE!