DB2 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 Version 7. Class is suitable for those using DB2 version 5 or 6 also.
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 6 months recent experience designing and coding application programs using SQL in DB2, in one or more environments (CICS, IMS/DB/DC, TSO, or batch) in which DB2 is used and recent experience using ISPF (especially the text editor) and should be able to code JCL to run simple batch jobs or have completed the "DB2 Application Programming" course within the last 12 months. Major Topics
DB2 architecture
Data base design
Entity / Relationship Model
Normalization
Primary and foreign keys
DB2 objects
Creating Data Bases, Storage Groups, Table Spaces, Tables, Indexes, Views, Synonyms, and Aliases
VSAM file allocation
Referential integrity
DB2 catalog tables
Space estimates
Loading tables
Reorganizing table spaces
Backup and recovery
Data base tuning
Application tuning
Data Security
Distributed processing
...''

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 Database Administration training resources.

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 Database Administration
DB2 UDB SQL Coding
SQL Coding Workshop
DB2 Application Programming
QMF for Programmers
DB2/CICS Interface
DB2 Tuning and Performance
Oracle for Experienced SQL Developers
C on z/OS
Object-Oriented Concepts
C++ on z/OS
Data Modeling
UML
Structured COBOL Workshop for Enterprise COBOL

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.
 

Tips: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.