NEXT >
< PREVIOUS

DB2 UDB for UNIX and Intel SQL and Application Coding
 

This 5 day is intended for:

Application Programmers, Application Designers, Business Analysts and Database Administrators that will be writing and maintaining interactive SQL and static applications that will utilize SQL code.

Topics Covered:
  • Overview of the DB2 Product Family
  • Data and Object Types
  • Command Center uses
  • Basic SQL
  • Introduction to Advanced SQL
  • Building a Program with SQL
  • Preparing and Executing a Program
  • Using the EXPLAIN
  • Performance Tips

Objectives:

Students will learn:

  • How to code SQL statements
  • How to write programs utilizing SQL
  • How to analyze SQL statements with EXPLAIN to maximize performance
  • Learn valuable tuning tips

Duration: 5 days

Delivery: Class Lecture and Hands-on Labs

Audience: 

Programmers, Application Designers, Business Analyst, or Data Base Administrators who need to have working knowledge of how to write interactive SQL and static SQL programs.

Prerequisites:

Students need a working knowledge of an SQL Query Tool and/or background in a programming language.

Outline

1)   Fundamentals of DB2

    DB2 Product Overview
    DB2 Object Hierarchy
    Object Types
    Data Types
    SQL Language
    Referential Integrity
    Locking
    DB2 Catalog
    Controlling Access/Privileges
    Authorization
    Privileges
    DB2 Interactive
    GUI Tools
    Command Center

2) Basic Single Table SQL

    Data Retrieval
    Result tables
    SELECT Structure
    Using Conditions: WHERE
    Functions/Expressions
    ORDER BY / UNION
    Special Registers
    CONNECT

3) Joining Data from Multiple Tables

    Inner join
    Full Outer Join
    Left Outer Join
    Right Outer Join
    Using Multiple join types
    Nested Table Expressions

4) Summary and Data Modifications

    GROUP BY / HAVING
    Using Subqueries
    How to code subqueries
    Correlated subqueries
    Non-correlated subqueries
    Modifying Data

 

5) Static SQL in a Host Application

    Coding Embedded SQL
    Declare Section
    SQLCA
    SQLCODE handling
    Host Variables
    Indicator Variables
    Singleton Select's
    Delete, Update, Insert

6) Program for Execution

    DB2 Precompiler
    Compile Your Program
    Link Edit
    Bind : Package / Plan
    Output Listings
    Problem Determination

7) Cursor Processing

    Declare a Cursor
    Open, Fetch, Close a Cursor
    Deleting, Updating
    Cursor with Hold
    Cursor for Read Only
    Visual Explain/Tuning SQL

8) Explain Tables

    Examining Explain Data
    Optimizer/Predicates
    Application Performance

9 ) Tuning SQL and Tips
 
< PREVIOUS
NEXT >

sales@cbi4you.com   866.CBI.4YOU  ( 866.224.4968 )
  Please contact our Webmaster with questions or comments.

© Copyright 2004 Computer Business International, Inc. All rights reserved.