Verhoef  Training

DB :: DB2 Administration

"Going the extra mile with ICT"

PO Box 2466, Cape Town 8000, South Africa
tel: 0861-102017 • fax: +27 21 856-0042 • e-mail: training@verhoef.co.za

Related Courses
» DB2 Fundamentals
» DB2-SQL Application Programming
» DB2 for z/OS SQL Performance and Tuning

Curricula Info
» MVS - z/OS - z/VM
» DB2 - SQL
» CICS TS
» IBM MQ
» Programming
» UNIX - Linux
» Networking
» Web Technologies
» Business Skills

Resources
» IBM Support
» IBM Redbooks
» Mainframe Month
» Mainframes.com
» z/Journal
» CIO Magazine
» Search390.com
» Linux Links
» XML Writer

Links
» CICS Central
» Programmer's Heaven
» Develoment Guru
» COBOL Centre
» COBOL User Groups
» REXXLA Home
» XML.com

Verhoef Sites:
» Verhoef USA
» Verhoef UK

 

Curriculum Description | Curriculum Roadmap | Curriculum Schedule | Course Enrolment

4 days   *   Advanced   *   Lecture and Labs

Course Summary:
This course will cover DB2 Physical Storage, Data Definition, Application Programming Considerations, Load Related Utilities, Performance Issues, Referential Integrity Implications, DB2 Catalog, Security end Auditing, and the Backup and Recover Processes. Application programmers may find this course to be an excellent tool to sharpen their DB2 skills helping them to bridge the traditional gap between programmers and database administrators.

Target Audience:
Project managers, team leaders, data analysts, database administrators, systems administrators and systems programmers who will be working with DB2.

Recommended Prerequisites:
Some experience with MVS and TSO is assumed as well as introductory level knowledge of DB2

Course Objectives:
Upon completion of this course, student should be able to:

Install the DB2 product and related attachments

Alter the install parameters with DSNZPARM overrides

Describe DB2 storage management techniques

Implement a DB2 database and it's performance considerations.

Manage the system objects

Manage the DB2 life-cycle

Perform a DB2 design review for proper working set and performance estimates

Implement DB2 security control

Describe the DB2 effect on standards and procedures

Key Topics:

Introduction to relational database systems

Using SQL for data definition

Using SQL for basic data retrieval

Using SQL for advanced data retrieval

Using SQL for data modification

Last modified: 29-Jun-2016

Site Map

 Home
  |
  •-- About Us
  |----Our Mission
  |----BEE Strategy
  |----Complaints
  |----Careers
  |----PAIA manual
  •-- Courses
  •-- Schedules
  •-- Our Clients
  •-- News and Events
  •-- Contact Us
  •-- Your Privacy
  |
  •-- MVS - z/OS - z/VM
  |----Roadmaps
  |----Schedule
  |
  •-- DB2 - SQL
  |----Roadmaps
  |----Schedule
  |
  •-- CICS TS
  |----Roadmaps
  |----Schedule
  |
  •-- IBM MQ
  |----Roadmaps
  |----Schedule
  |
  •-- Programming
  |----Roadmaps
  |----Schedule
  |
  •-- UNIX - Linux
  |----Roadmaps
  |----Schedule
  |
  •-- Networking
  |----Roadmaps
  |----Schedule
  |
  •-- Web Technologies
  |----Roadmaps
  |----Schedule
  |
  •-- Business Skills
  |----Roadmaps
  |----Schedule
  •