Home | About Us | Courses | Schedules | Our Clients | News and Events | Contact Us | Careers  

Accredited SERVICES SETA Education and Training Provider as per www.serviceseta.org.za
Verhoef  Training

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 Applications Performance/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
      •

     
    Home | About Us | Courses | Schedules | Our Clients | News and Events | Contact Us
     

      to top
    © 2004-2017 Verhoef Training. All Rights Reserved.


    This Site Tracked by OneStat.com