DB2 UDB for z/OS Database Administration Workshop

IBM
Bangalore, India

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

Course Description:

'' This course provides you with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities such as LOAD and REORG, and security considerations.

Note: This course material is at the DB2 UDB for z/OS Version 8 level.

The course contains the following units:

�Introduction

�Setting up a DB2 Database

- Overview of Setting up a DB2 Database

- Storage Groups, Databases, and Table Spaces

- Tables

- Views, Synonyms, and Aliases

- Materialized Query Tables

- Indexes

- Online Schema Enhancements and Other Considerations

�Referential Integrity

- Referential Integrity

- Informational RI Constraints

- Identity Columns and Sequences

�Getting Data into and out of DB2

- SQL INSERT, DELETE, and UPDATE

- Introduction to Utilities

- LOAD Utility

- Ensuring Referential and Check Constraints

- UNLOAD Utility

�Keeping your DB2 Data in Good Shape

- RUNSTATS

- REORG

- Real Time Statistics

- History Statistics

�Application Data Recovery Basics

�Data Compression

�Program Preparation / Bind

�Security

�Serialization

The course also includes extensive machine lab exercises which give you the opportunity to gain hands-on experience of:

�Creating and using databases, table spaces, tables, views, and indexes

�Defining check and referential constraints

�Creating and running the following utility jobs:

- LOAD, CHECK DATA, and UNLOAD

- RUNSTATS and REORG

- COPY and RECOVER

�DB2 security

�DB2 locking
...''

Phone:1800-425-3333

School Address:

SUBRAMANYAM ARCADE
NO12 BANNERGHATTA ROAD
BANGALORE 560029
India

Jobs & Resumes: Bangalore
Houses & Roommates: Bangalore

Object-Oriented Analysis with UML
Lotus Domino 7 System Administration
iSERIES AND AS/400e RPG IV PROGRAMMING WORKSHOP
IBM WebSphere Portal Application Development
IBM TotalStorage (TM) Enterprise Storage Server Implement. in z/OS Environment
RATIONAL ROSE
Rational Unified Process
Rational RequisitePro
Developing Lotus Domino 6 Applications
Visual Modeling with UML
DB2 UDB for Linux, UNIX, and Windows
AIX 5L Basics
AIX 5L APPLICATION PROGRAMMING

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.