Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: 123-CBT Computer Based Training

IBM DB2 Universal Database V6 1--App Development

Click here for more information or to take this course
123-CBT Computer Based Training


Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by 123-CBT Computer Based Training

Course Overview

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 Contents

Unit 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.

    Training Avaliability and Delivery

    This is primarily online training
    on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
    cd romThis program may be available on CD
    Contact 123-CBT Computer Based Training for more information
    Training Presented in:English

    Related Keywords:  ibm   db2   universal   database   v6.1   app.   development 

    Training Program Details


    --

    About 123-CBT Computer Based Training - Training Provider

    123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6.10 - Access 2003 - Acrobat 6.0 - ASP - ASP.NET - C - Captivate 1.0 - Crystal Reports 8.5 - Crystal Reports v10 - Dreamweaver MX -...

    More IBM DB2 Universal Database V6 1 Training from 123-CBT Computer Based Training

    Click here for more information or to take this course
Custom Search

Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links


Connecting people who want to learn with people who love to teach
 Are you an Ibm training provider?
You could be on this page today - for FREE!