DB2 LUW (Linux, UNIX, Windows) FOR PROGRAMMERS

Course:   DB2LUW
Duration:   4 Days
Level:   I
On our website at:   http://www.verhoef-training.com/courses/DB2LUW.html
 
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.

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.

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.