|
Standard |
Posted: 09/12/07
|
R State Standard £ Institutionally Developed College: n/a |
CIS 2174 - DB2 Application Development
Course
Description
This course will provide application developers with the
specific skills and knowledge needed to be successful in an IBM DB2 Universal
Database (UDB) 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. 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 should have solid programming skills using C, C++, Java,
or equivalent programming language. Prepares student to take IBM Certification
test 733. Topics include: 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, and use dynamic SQL within an application.
|
Competency Areas |
Hours |
|
|
Use SQL
functions in DB2 Applications |
Class |
4 |
|
Use
different application objects in DB2, such as schema, user-defined types,
user-defined functions, and stored procedures |
D. Lab |
6 |
|
Use SQL
within an application |
P. Lab/O.B.I. |
0 |
|
Use
dynamic SQL within an application |
Credit |
7 |
|
Prerequisite: |
CIS 2170 |
|
Corequisite: |
|
|
Course Guide |
|
Competency |
After completing this section, the student will be
able to: |
Hours |
||
|
Class |
D.Lab
|
P.Lab/ O.B.I. |
||
|
USE SQL FUNCTIONS IN DB2
APPLICATIONS |
9 |
16
|
|
|
|
|
Utilize
DB2 object naming conventions |
|
|
|
|
|
Utilize
and understand application data access authorities |
|
|
|
|
|
Determine
programming interface requirements |
|
|
|
|
|
Identify
determine when to use available programming interfaces |
|
|
|
|
|
Determine
when to use SQL routines and functions |
|
|
|
|
|
|
|
|
|
|
USE DIFFERENT APPLICATION OBJECTS
IN DB2, SUCH AS SCHEMA, USER-DEFINED TYPES, USER-DEFINED FUNCTIONS, AND
STORED PROCEDURES |
15 |
20
|
|
|
|
|
Develop
multiple table queries and views across databases |
|
|
|
|
|
Use
common table expressions |
|
|
|
|
|
Use DB2
built-in routines |
|
|
|
|
|
Identify
and manipulate cursors |
|
|
|
|
|
Manipulate
large objects |
|
|
|
|
|
Manage
units of work |
|
|
|
|
|
Utilize
SQL/XML functions |
|
|
|
|
|
Validate
XML schema |
|
|
|
|
|
|
|
|
|
|
USE SQL WITHIN AN APPLICATION |
8
|
12 |
|
|
|
|
Connect
to databases within and embedded SQL programming application |
|
|
|
|
|
Problem
determination and results analysis |
|
|
|
|
|
Connect
to databases with ODBC/CL1 programming application |
|
|
|
|
|
Understand
ADO.NET object model |
|
|
|
|
|
Understand
IBM DB2 add-ins for Visual Studio |
|
|
|
|
|
Execute
SQL statements |
|
|
|
|
|
|
|
|
|
|
USE DYNAMIC SQL WITHIN AN
APPLICATION |
8 |
12
|
|
|
|
|
Identify
differences between dynamic and static SQL |
|
|
|
|
|
Ability to create user defined functions |
|
|
|
|
|
Ability to create triggers and identify their results |
|
|
|
|
|
Ability to create stored procedures in SQL |
|
|
|
|
Suggested Resources |
http://www-03.ibm.com/certify/ , IBM
Redbooks, tutorials for Database development, IBM Partners in Education
Curriculums