Home About Courses Schedule Services Webinars Contact Search

New Application Features of Db2 for z/OS

SEE SCHEDULE

Duration: 3 Days

Method: Instructor-led with hands on

Price: $1920.00

Course Code: DB1043



Audience

SQL coders and application developers that use Db2 for z/OS and would like to catch up on the latest features from versions 9, 10, 11 and 12!

Description

Are you still coding SQL from the 90s? The last several releases of Db2 have brought us quality new features that can be used to improve the functionality and performance of today's complex applications. This course will help you catch up!

Objectives

Upon successful completion of this course, the student will be able to:

  • Work with the SQL language on Db2 for z/OS using the latest features.
  • Understand how to use the features in a way that will perform well.

Prerequisites

Working knowledge of SQL

Topics

  1. Schema Enhancements
    • Global Variables
    • Sequences
  2. Advanced Grouping
    • GROUP BY Clause
    • HAVING Clause
    • Grouping Sets
    • ROLLUP & CUBE
  3. Built-in Function Upgrades
    • Online Analytical Processing (OLAP) Functions
      • RANK
      • DENSE_RANK
      • ROW_NUMBER
    • Advanced Aggregation
      • Moving SUMs and AVGs
      • ROWS BETWEEEN
      • RANGE BETWEEN
      • PARTITION BY
  4. Temporal Tables
    • Business Time
    • System Time
    • Querying using FROM clause extensions
    • Special Registers for Temporal Support
  5. Transparent Archiving
    • Automatic archiving of data
    • Data retrieval options
    • Global variables for Transparent Archiving
  6. Set Operations
    • UNION / UNION ALL (Review)
    • INTERSECT / INTERSECT ALL
    • EXCEPT / EXCEPT ALL
    • UNION SELECT INTO
  7. SQL Procedure Language (SQL PL)
    • Overview of SQL PL Stored Procedures
    • Overview of SQL PL User Defined Functions
    • SQL PL support in Triggers
    • XML and Array Variables
    • Autonomous Processing
  8. Performance Enhancements
    • New Stage 1 Predicates
    • Early-out Join Processing
    • SQL Pagination
    • Transitive Closure
    • Adaptive Indexing
    • UNION ALL and Outer Join Improvements
    • Access Path Stability
    • Implicit Casting
    • Currently Committed
    • Concentrate With Literals
    • SQL Pagination
    • In Memory Optimization - Fast Index Traversal
  9. Data Modification
    • MERGE Statement
      • Before Db2 12
      • After Db2 12
    • Piece-wise DELETE
  10. XML and pureXML Enhancements