DB2 LUW (Linux, UNIX, Windows) FOR PROGRAMMERS

Course: DB2LUW

Duration: 4 Days

Level: I

Course Summary

The Course is designed for those applications programmers using DB2 on a Linux, Unix or Windows environment.

The presentation is a mixture of lecture sessions and a workshop, which is designed to introduce all aspects of relational technology as implemented by DB2, up to, and including version 9.

« Hide The Details

Topics Covered In This Course

DAY 1 TOPICS

Introduction to DB2
- Versions
- System architecture
- Terms/Terminology
  - Instance/Database/Partitioned Database
  - Tablespace
    - regular/system temporary/user temporary/catalog
  - Tables
  - Views
    - Merge
    - Materialization
  - Columns
  - Nulls
  - Referential Integrity
  - Buffer Pools
  - Alias
  - Attributes
    - Numeric
    - Character
    - Date/Time
    - UDT
    - Lob's
    - identity/sequence
  - SQL Execution Environment
    - Command line processing
    - Command line prompt
    - COMMAND CENTER
    - CONTROL CENTER(WIZARD)
    - SQL EXPLORER
  - Data Definition Language Overview
    - CONNECT
    - DATABASE
    - TABLESPACE
    - TABLE
    - ALTER
  - DAY 2 TOPICS
    - Catalog
      - How to search the catalog
      - Relevant tables
      - History tables
    - Simple SQL
      - SELECT (single table)
      - */ALL/COLUMNS/DISTICT/CONCATENATOR/literals/ORDER BY
      - FETCH FIRST
      - Efficiency aspects
    - Predicates
      - = (efficiency aspects)
      - IN (efficiency aspects)
      - BETWEEN (efficiency aspects)
      - LIKE (efficiency aspects)
      - AND/OR
    - Built in function
      - MAX/MIN/SUM/COUNT/AVG/COUNT_BIG
    - Scalar Functions
      - Examples and use of some of them e.g. SUBSTR/VALUE etc
    - GROUP
  - Complex SQL
  - Table joins
    - EQ JOIN
    - SUBSELECT
    - CORRELATED SUBSELECT
    - union/except/intersect
  - Left/Right/Full Joins
  - In Line Tables
  - CASE
  - Remainder of DML statements
    - UPDATE/DELETE/INSERT/MERGE
  - DAY 3 TOPICS
    - Embedded SQL
      - DCLGEN
      - SQLCA
      - Error handling
        
        Whenever
        
        SQLCODE/SQLSTATE test
      - Singleton selects
      - Uncursored SELECTS (Singleton SELECTS)
      - Scrollable cursors
      - CURSOR
      - CURSOR WITH UPDATE/DELETE
      - Block Fetch
      - Development cycle
        
        Dynamic/Static SQL
        
        Precompile
        
        DBRMs
        
        BIND
        
        PACKAGES
      - Developing and running applications
    - DAY 4 TOPICS
      - LOCKING STRATEGY
        
        Introduction
        
        What resources can be locked?
        
        The different locks available
        
        Duration of a lock
        
        Commit/rollback
        
        Locking notes
        
        INDEXING
        
        Physical data management
        
        Tablespace Object
        
        Page
        
        Record identifier
        
        RUNSTATS/REORG
        
        MDC (version 8)
        
        Access strategy
        
        Multi table access path
        
        VISUAL EXPLAIN
        
        INDEX ASSIST
      - HEALTH CENTRE
      - SECURITY
      - GRANT/REVOKE
      - Table check constraints
      - TRIGGERS
      - STORED PROCEDURES
      - Utilities
        
        BACKUP
        
        RESTORE
        
        LOAD/UNLOAD
        
        IMPORT/EXPORT

Who Should Take This Course

Applications programmers who are exposed to, or required to write and perform activities associated with application development and implementation, in a DB2 environment.

Recommended Prerequisites

Those attending the course should be familiar in developing applications.

« Hide The Details

Related Courses

Code	Course Title	Duration	Level
SQLDB2CP	SQL Fundamentals (Cross Platform)	2 Days	I	Details
DB2UDBI	DB2 for LUW (Linux, UNIX, Windows)	2 Days	I	Details
DB2U	DB2 SQL Application Programming	5 Days	I	Details
DB2PTUW	DB2 Performance and Tuning for UNIX and Windows	3 Days	II	Details
SQLADB2C	SQL Advanced Functionality (Cross Platform)	3 Days	II	Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.

Notify me the next time this course is confirmed!

Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]