|
Provided by: 123-CBT Computer Based Training IBM DB2 Universal Database V6 1--App Development |
![]() |
This 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.
Learn To:
- 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.
Content Emphasis
Skills-Based
Audience
This course is intended for application developers. Students should have a fundamental understanding of relational database technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Application Development students must also have solid programming skills using C, C++, Java, or equivalent programming language. In addition, participants should have taken the first part in this series, IBM DB2 UDB V6.1 Fundamentals (course13431) prior to taking this course. When coupled with appropriate on-the-job experience, this course will help prepare students for the IBM Certified Solutions Expert Certification Application Development exam 511.
Total Learning Time
6 - 8 Hour(s)
Course ContentsUnit 1: SQL Application Development
Duration: 1 - 2 Hour(s)- 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
Duration: 1 - 2 Hour(s)- 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
Duration: 2 Hour(s)- 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.
|
|
||||||||

