DB2

Select the title to review a description of the course. Please note that these courses can often be adapted for virtual delivery and modified based on the target audience and goals of your program. Please contact us to discuss your training needs and we will work with you to identify and craft the best solution.
  • DB2 UDB Concepts and Facilities

    • DB2 UDB Concepts and Facilities

      Course Number: 703-JK
      Recommended Duration: 3 days

      Intended Audience: Applications developers who need to develop or maintain applications in a DB2 UDB environment, or who need a general understanding of DB2 UDB.

      Course Overview

      Students learn relational database terminology, and are introduced to DB2 UDB facilities most important to application developers. Students learn basic SQL, are exposed to the DB2 UDB application development environment, and develop skills normalizing data.

      DB2 Version 7. Class is suitable for those using DB2 version 5 or 6 also.

      Prerequisites

      Students should have the desire to learn about SQL and DB2 UDB. Students should also have recent experience using the available text editor.

      Topics

      • DB2 UDB features
      • DB2 UDB Objects
      • Graphical user interface tools and control center
      • Command Line Processor (CLP)
      • The DB2 UDB catalog
      • Relational operations: SELECT, PROJECT, and JOIN
      • DB2 UDB data types
      • Referential integrity and normalization
      • SQL data manipulation introduction: SELECT, UPDATE, DELETE, INSERT commands
      • SQL data definition introduction: CREATE, DROP, ALTER commands
      • SQL data control introduction: GRANT, REVOKE
      • DB2 UDB application development: compilation and execution
      • Host variables
      • COMMIT / ROLLBACK

      Share with others

  • DB2 UDB Database Administration

    • DB2 UDB Database Administration

      Course Number: 707-JK
      Recommended Duration: 5 days

      Intended Audience: Experienced DB2 programmers and Data Base Analysts who will design and implement DB2 Data Bases.

      Objectives

      The student will learn how to normalize relational data and how to define DB2 objects, including Data Bases, Storage Groups, Table Spaces, Tables, Indexes, Views, Synonyms, and Aliases. Students will also practice loading, modifying, backing up, recovering, and tuning DB2 Data bases; using DB2 utilities, services aids, and catalog tables.

      DB2 UDB Version 8.1. Course is suitable for shops still running DB2 UDB version 7; some exercises will not apply.

      Prerequisites

      Students should have at least six months SQL (DB2, Oracle, etc...) database administration experience or 6 months recent experience designing and coding application programs using DB2 UDB, or have completed one of a "DB2 UDB Programming" course.

      Topics

      • DB2 UDB architecture
      • Data base design
      • Interactive tools and control center
      • Entity / Relationship Model and Normalization
      • DB2 objects
      • Databases and tablespaces
      • File allocation with SMS and DMS
      • Creating Data Bases, Storage Groups, Table Spaces, Tables, Indexes, Views, Synonyms, and Aliases online and via DDL
      • Understanding materialized query tables
      • Referential integrity (Primary and foreign keys)
      • DB2 catalog tables
      • Loading tables
      • Reorganizing table spaces
      • Backup and recovery
      • Stored procedures and stored procedure builder
      • User-Defined Functions (UDFs)
      • Database triggers
      • Visual explain and efficiency considerations
      • Data base tuning
      • Application tuning
      • Data security

      Share with others

  • DB2 UDB for Experienced SQL Developers

    • DB2 UDB for Experienced SQL Developers

      Course Number: 705-JK
      Recommended Duration: 3 days

      Intended Audience: Experienced SQL programmers who need to work with DB2 UDB Databases, both from a Command Line perspective and from within application programs.

      Objectives

      Students who complete this course will be able to code SQL statements to access DB2 UDB objects by typing SQL and from within application programs (in the student's standard host environment)

      DB2 UDB Version 8.1. Most of the class is suitable for those earlier versions of DB2 UDB (DB2 UDB 7).

      Prerequisites

      The student should have SQL experience and at least 6 months experience designing and coding application programs or have completed a basic programming course within the last 12 months. Familiarity with the available editor and execution environment is required.

      Topics

      • DB2 UDB concepts
      • DB2 Clients: Run-time, Administration, SDK
      • Control center
      • Command line processor
      • Warehousing features: CUBE, ROLLUP, Analytic functions
      • COMMIT/ROLLBACK
      • Joins and subqueries
      • Review of advanced SQL syntax
      • Creating tables and views
      • Materialized query tables
      • System catalog tables
      • Cursors and locks
      • Security and authorization
      • DB2 extenders
      • DB2 connect
      • Database administration server
      • Dynamic SQL
      • Stored procedures and triggers
      • Efficiency considerations: Optimizer, Explain, and Application Plans

      Share with others

  • DB2 UDB Programming

    • DB2 UDB Programming

      Course Number: 704-JK
      Recommended Duration: 5 days

      Intended Audience: Java, C#, COBOL, PL/I, or C programmers who need to work with DB2 UDB Databases.

      Objectives

      Students who complete this course will be able to code SQL statements to access DB2 UDB objects by typing SQL and from within application programs (in the student's standard host environment). Students also learn to execute and test DB2 UDB programs.

      DB2 UDB Version 8.1. Most of the class is suitable for those earlier versions of DB2 UDB (DB2 UDB 7).

      Prerequisites

      The student should have 6 months experience designing and coding Java, C#, COBOL, or C application programs or have completed the appropriate course within the last 12 months. Familiarity with the available editor is required.

      Topics

      • Relational database concepts
      • DB2 UDB concepts
      • DB2 Clients: Run-time, Administration, SDK
      • SQL
      • Control center
      • Command line processor
      • SELECT
      • UPDATE/DELETE/INSERT
      • COMMIT/ROLLBACK
      • Joins and Subqueries
      • Functions
      • Analytic features
      • Creating tables, views, materialized query tables
      • System catalog tables
      • SQL in application programs
      • Host variables and structures
      • Cursors and locks
      • Security and authorization
      • DB2 Extenders
      • DB2 connect
      • Database administration server
      • Dynamic SQL
      • Stored procedures
      • Efficiency considerations

      Share with others

  • DB2 UDB SQL Coding

    • DB2 UDB SQL Coding

      Course Number: 706-JK
      Recommended Duration: 3 days

      Intended Audience: Persons who need to work with DB2 UDB Databases.

      Objectives

      Students who complete this course will be able to code SQL statements to access DB2 UDB using both the Command-Line Processor (CLP) and Control Center graphical interface programs.

      Course is suitable for shops still running DB2 UDB version 7; some exercises will not apply.

      Prerequisites

      The student should have familiarity with the environment used in the classroom (Windows, Unix, or Linux).

      Topics

      • Relational database concepts
      • DB2 UDB concepts
      • Command-Line Processor (CLP)
      • Interactive tools and control center
      • SELECT
      • UPDATE/DELETE/INSERT
      • COMMIT/ROLLBACK
      • Joined and nested queries
      • SQL functions and analytics
      • Creating DB2 tables and Views
      • DB2 UDB objects
      • Catalog tables/dictionary
      • Locking mechanism
      • Security and authorization

      Share with others


Please click here to return to the Technical Skills page.