Verhoef  Training

DB :: 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
  •