DB2 Overview

 LENGTH OF COURSE:
2 Days

DESCRIPTION:This course is designed to be a comprehensive introduction to the IBM DB2 Product. Topics include Data Structures, Relational Databases, and Tables, Types of Relational Databases, Relational Architecture, DB2 Components, and DB2 Database Administration. In addition, students will be introduced to Structured Query Language and Query Management Facility.

PREREQUISITES:Some knowledge of data processing concepts and facilities.

INSTRUCTION TECHNIQUES: A combination of Lecture, Exercises, and Labs (when/where available).

AUDIENCE

This course is designed for DB2 Users, and Technicians that need to understand DB2 concepts and facilities. The course can accommodate an Audience that varies from application users to system programmers.
KEY HIGHLIGHTS:
  • Introduction
  • The Relational Model
    • Background
    • The Relational Table
    • Primary Keys
    • Domains & Values
    • Foreign Keys
    • Natural Join
    • Outer Join
    • Why a Relational DBMS?
  • Data Manipulation Language
    • Data Manipulation Language
    • SQL Syntax
    • The Select Clause
    • Select Distinct
    • Simple Predicates
    • BETWEEN, IN and Like
    • Column Functions
    • Scalar Functions
    • Special Registers
    • GROUP BY, HAVING
    • INSERT
    • Update


  • Data Manipulation Language (Continued)
    • DELETE
    • Join
    • Outer Join
    • Subquery
    • Exists, Union
  • ArchitectureData Objects
    • System Objects
    • Database
    • Indexes I
    • Table Space
    • Buffer Pools
    • Storage Groups
    • Architecture Review
    • DB2 Address Spaces
    • Logging
  • Data Definition Group
    • Create
    • Defining the LDS
    • Table Space


  • Application Programming
    • Program Preparation
    • Embedded SQL
    • Cursors


FROM OUR STUDENT EVALUATIONS...
"Enjoyed additions to the literature that Gary made."

Kathy Lisle
US Airways

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.