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 |  | This is an online eLearning or CBT training program |  | This 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
|
