DB2 UDB Database Administration

King Training Resources
Littleton, Colorado, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Recommended Duration:
5 Days
Version
DB2 UDB Version 8.1. Course is suitable for shops still running DB2 UDB version 7; some exercises will not apply.
Benefits
The student will learn how to normalize relational data and how to define DB2 objects, including Data Bases, Storage Groups, Table Spaces, Tables, Indexes, Views, Synonyms, and Aliases. Students will also practice loading, modifying, backing up, recovering, and tuning DB2 Data bases; using DB2 utilities, services aids, and catalog tables.
Audience
Experienced DB2 programmers and Data Base Analysts who will design and implement DB2 Data Bases.
Prerequisites
Students should have at least six months SQL (DB2, Oracle, etc...) database administration experience or 6 months recent experience designing and coding application programs using DB2 UDB, or have completed one of a "DB2 UDB Programming" course.. Major Topics
DB2 UDB architecture
Data base design
Interactive Tools and Control Center
Entity / Relationship Model and Normalization
DB2 objects
Databases and Tablespaces
File allocation with SMS and DMS
Creating Data Bases, Storage Groups, Table Spaces, Tables, Indexes, Views, Synonyms, and Aliases online and via DDL
Understanding Materielized Query Tables
Referential integrity
(Primary and foreign keys)
DB2 catalog tables
Loading tables
Reorganizing table spaces
Backup and recovery
Stored Procedures and Stored Procedure Builder
User-Defined Functions (UDFs)
Database Triggers
Visual Explain and Efficiency Considerations
Data base tuning
Application tuning
Data Security
...''

Phone:800-252-0652 or 303-798-5727

School Address:

Peggy King
King Training Resources
6341 South Williams Street
Littleton, Colorado 80121-2627 USA


Jobs & Resumes: Littleton
Houses & Roommates: Littleton

Search other schools for DB2 UDB Database Administration training resources.

Oracle 11g/10g Differences for Developers
Oracle for Developers with PL/SQL
PL/SQL for Developers
Oracle SQL Statement Tuning
10g/9i Web Forms for Client-Server Forms Developers
Developer 10g/9i Forms
Developer 10g/9i Reports
DB2 UDB Programming
DB2 UDB SQL Coding
SQL Coding Workshop
DB2 Application Programming
QMF for Programmers
DB2 Database Administration
DB2/CICS Interface
DB2 Tuning and Performance
Oracle for Experienced SQL Developers
C on z/OS

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.