DB2: Greatest Hits - Topical Outline

Introduction
    The Big picture
        64-bit virtual storage
        Unicode
        Hardware exploitation – zIIPs
        XML
    Migration bases
The Course Database
        Computer Exercise: Course setup

SQL changes - 1
    Limit changes
    DISTINCT and NOT DISTINCT
    Scalar Fullselect
    INSERT within SELECT
    GROUP BY
    FETCH FIRST with ORDER BY
    Encryption scalar functions
    EXCEPT and INTERSECT
    ORDER BY and FETCH FIRST in subselect
    TRUNCATE TABLE
    MERGE
    SELECT FROM UPDATE / DELETE / MERGE
    Computer Exercise: SQL Changes - Round 1

SQL changes - 2
    New built-in functions
    OLAP-related functions
    Nested Table Expressions
    Common Table Expressions
    Recursive SQL
    Computer Exercise: SQL Changes - Round 2

Scrollable cursors
    INSENSITIVE
    SENSITIVE STATIC
    SENSITIVE DYNAMIC cursors
    ASENSITIVE cursors
    FETCH syntax
    Update and locking

Multiple Row SQL
    Rowsets
    FETCH / INSERT / UPDATE / DELETE
    Multi-row INSERT within SELECT
GET DIAGNOSTICS
    FETCH CONTINUE
    LOB file reference variables
    Bind Enhancements: REOPT AUTO and SWITCH
    New / improved special registers
    SKIP LOCKED DATA clause
    Computer Exercise: Application Programming Environment Enhancements

Native SQL procedures
    CREATE/ALTER PROCEDURE
    Versioning
    Computer Exercise: Native SQL Procedures

Data Base Administration Enhancements
    Sequence objects
    Clone tables
    Row change timestamps
    New data types: BIGINT, BINARY, VARBINARY, DECFLOAT
    Indexing on expressions
    Computer Exercise: Data Base Administration Enhancements

XML
    XML Overview
    XML and DB2
    XML and SQL
    XML in application programs
    XML Indexing
    Computer Exercise: Exploring XML in DB2

Course information: G-527 / 3 Days   These Materials © Copyright 2009 by Hunter Cobb    V1.x

Course Objectives
Course description
Home page

this page last updated: 11 June, 2009
this page copyright © 2009 by The Trainer's Friend, Inc.