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 :: Fundamentals

"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
» SQL Fundamentals
» DB2-SQL Application Programming
» DB2 Administration

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
1 day   *   Basic   *   Lecture only

Course Summary:
This course is a basic introduction to Database/2 (DB2), IBM's Relational Data Base Management System. It will present the student with a comprehensive overview of the DB2 Product and how it relates to their current environment.

Target Audience:
All personnel who will be working with DB2 and wish a comprehensive overview of the functions of DB2, the DB2 product family and how to utilise DB2 in their current environment.

Recommended Prerequisites:
An understanding of TSO is helpful but not necessary.

Course Objectives:
After completing this course, the student should be able to:

  • Describe the objects that comprise a Relational Database
  • Describe the components that make up the DB2 Product
  • Describe the tabular format of data and how these tables are related
  • Describe the DB2 Environment and its associated attachments
  • Describe the functions of the Structured Query Language (SQL)
  • Describe the purpose of the various IBM supplied Relational Products

    Key Topics:

  • Introduction to Relational Database Systems
  • Definition of a Relational Data Base Management System
  • The Relational Model and how it is implemented by the DB2 product
  • The DB2 Structure Logical and Physical Data Structures
  • The DB2 System Objects
  • The DB2 Facilities and Product Family
       - DB2 Interactive (DB2I)
       - SPUFI (SQL Processing Using File Input)
       - DB2 Utilities
       - QMF (Query Management Facility)
       - DB2 Performance Monitor (DB2PM)
  • The DB2 Operational Environment

    Last modified: 13-Dec-2017

  • 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