IBM DB2 Training for Developer
IBM DB2 Universal Database V6.1 Application Development Curriculum
Complete IBM DB2 Universal Database V6.1 Application Development
necessary skills and knowledge needed to be successful with IBM DB2
Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment.
IBM DB2 Application Development Training Course on CDs
IBM DB2 V6.1 Administration Curriculum
IBM DB2 V6.1 Application Development
IBM DB2 V7.1 Transition Curriculum
IBM IMS Essentials Curriculum
IBM DB2 Universal Database V6.1 Fundamentals
course will provide both database administrators and application
developers with the broad foundation skills and knowledge needed to be
successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX,
Windows, or OS/2 environment. This course will teach students the basic
concepts of DB2 UDB V6.1, creating and accessing database objects,
basic Structured Query Language (SQL), and managing databases.
• Identify DB2 UDB product editions, their installation and verification, user interfaces, and security features.
• Create and access DB2 database objects, ensure data validation and
integrity, and create views and indexes.
• Master basic Structure Query Language (SQL).
• Manage database operations.
Unit 1: Introduction to DB2 Universal Database V6.1
• Match the product editions of DB2 UDB with their characteristics.
• Identify the satellite administration functions of the Satellite Administration Center.
• Match the DB2 UDB clients with their functions.
• Match the communication protocols that DB2 supports with their
associated platform environments.
• Identify which DB2 Connect product to use given a specific scenario.
• Match the DB2 UDB products with their functions.
• Install a DB2 UDB server given system specifications.
• Identify tasks performed to verify a DB2 installation using First Steps.
• Install a DB2 client given a scenario.
• Sequence the steps of a distributed installation for DB2 clients.
• Match the database directories with their descriptions.
• Catalog a node and a database using the CATALOG command.
• Identify the functions of the DB2 Administration Server instance.
• Match the DB2 command interfaces with their characteristics.
• Identify the tasks performed using the Control Center.
• Match security levels with their definitions.
• Sequence the steps in the authentication process a user follows when accessing a DB2 instance.
• Identify the characteristics of DB2 authorization levels.
• Provide a user with privileges on database objects using Data Control Language (DCL).
Unit 2: Creating and Accessing Database Objects
• Match the data placement objects with their definitions.
• Select the type of table space needed given a scenario.
• Create a database and table space given a set of parameters.
• Match data elements with their data types.
• Identify column definitions that allow the insertion of null values.
• Create a table based on a set of instructions.
• Locate information in system catalogs by viewing a system catalog table.
• Create a view with specific characteristics.
• Create an index with specific characteristics.
• Identify the effects of table check constraints given a CREATE table statement.
• Identify characteristics of a trigger.
• Analyze data modification instructions to determine whether DB2
applies referential constraints given referential constraint
Unit 3: Basic Structured Query Language Usage
• Display data using a SELECT statement.
• Specify rows to be retrieved from a table given certain requirements.
• Apply DB2 functions to groups within a table for a given scenario.
• Retrieve data from multiple tables given a scenario.
• Enter data into a table using an INSERT statement.
• Modify data in a table using an UPDATE statement.
• Remove data from a table using a DELETE statement.
• Identify considerations in embedding SQL in applications for DB2.
• Sequence the steps to prepare to run an application program.
Unit 4: Managing Databases
• Identify the effect of COMMIT and ROLLBACK processing given a scenario.
• Identify the objects on which locks can be obtained.
• Match row lock modes with their characteristics.
• Identify ways that DB2 resolves lock contention.
• Match isolation levels with their properties.
• Transfer data between databases using data movement utilities.
• Match maintenance utilities with their functions
IBM DB2 Universal Database V6.1 Application Development
course will provide application developers with the specific skills and
knowledge needed to be successful in an IBM DB2 Universal Database
(UDB) V6.1 application development environment for UNIX, Windows or
OS/2 platforms. This course will teach students about SQL application
development, application development objects, embedded SQL programming,
and dynamic SQL programming.
• Use SQL functions in DB2 Applications.
• Use different application objects in DB2, such as schema, user-defined types, user
-defined functions, and stored procedures.
• Use SQL within an application.
• Use dynamic SQL within an application
Unit 1: SQL Application Development
• Combine data from two or more tables using a join.
• Combine two queries into a single result table using set operations.
• Retrieve data in a restricted condition using a subquery.
• Retrieve data with referenced values using a correlated subquery.
• Retrieve data using scalar functions.
• Retrieve summarized data for groups using grouping functions.
• Create different levels of aggregation data using GROUPING SETS operations.
• Identify characteristics of STAR schemas for table design and index design.
• Code combined SQL statements using compound SQL.
• Create a local temporary table that can be referenced in an SQL
statement using a common table expression.
• Retrieve data with logical conditions using a CASE expression in a given scenario.
Unit 2: Application Development Objects
• Identify valid DB2 object names.
• Control a schema using a SET SCHEMA statement.
• Identify valid User-Defined Type (UDT) comparisons.
• Identify the User-Defined Function (UDF) type and its function.
• Register stored procedures using a CREATE PROCEDURE statement.
Unit 3: Embedded SQL Programming
• Identify the general tasks of an application containing embedded SQL statements.
• Declare the host variables that correspond to specific columns in a table.
• Code a statement that uses host variables in queries using an embedded SELECT.
• Code a statement that uses host variables to change data within a specific application.
• Analyze the content of host variables to determine whether a column contains null values.
• Identify situations in which to use cursors in an application that contains embedded SQL.
• Code a statement that uses a specific type of cursor to manipulate data using embedded SQL.
• Code a positioned update using embedded SQL.
• Match SQLCA elements with the error-handling information they contain.
• Identify the transaction that produces a specific effect on a database.
• Identify the characteristics of type 1 and type 2 connections to a database.
• Identify which isolation level is necessary to ensure a specific degree of data integrity.
• Identify the input and output of a PREP statement using deferred binding.
• Perform the steps to precompile and bind an application using specific parameters.
• Identify the privileges necessary to develop an application using embedded static SQL.
• Match the type of application development information with its system catalog name.
• Obtain configuration information using the correct tool.
• Analyze an SQL statement using EXPLAIN and VISUAL EXPLAIN.
Unit 4: Dynamic SQL Programming
• Identify the characteristics of dynamic embedded SQL.
• Match the SQLDA data structure elements with the information they contain.
• Code statements using SQL keywords specific to dynamic SQL applications.
• Code a dynamic SQL statement using parameter markers.
• Identify when to use various application interfaces.
• Identify the functionality of DB2 APIs.
• Code CLI functions in an application.
• Identify the tasks necessary to code JDBC applications and applets.