Name: DB2 For z/OS and OS/390 Application Development
Course Code: ST900
Duration: 5
Scheduled Dates for ST900
DB2 for OS/390 Application Development offers the student a unique opportunity to learn how to use both interactive and embedded SQL. Typical business processing requirements are analyzed and coded into SQL statements. The SQL statements are tested using SPUFI, a DB2 interactive facility. In the programming phase of this course, the SQL statements are embedded in batch COBOL or PL/I programs that execute under TSO.
Target Audience
This class is for application programmers, application analysts, database designers or anyone who needs to code SQL in or outside of a DB2 application program.
Key Topics
- DB2 Concepts And Facilities
- The Student Database
- Basic SQL Select Operations
- Basic SQL Insert, Update And Delete Operations
- Column Functions
- Subquery, Join, And Union Operations
- Views And Nested Table Expressions
- DB2 Programming Overview
- Cursor Processing
- Embedded SQL
- DB2 Commit Processing And Program Isolation
- The Explain Function
- Stored Procedures
- Testing And Implementing DB2 Programs
Required Skills/Experience
- This course is intended for those who have programming experience.
Fee: $1,750.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
