Training Course:DB2 UDB Application Programming WorkshopSchool/Trainer:
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' This is an intermediate course for application programmers who need to write embedded SQL programs in Common Business Oriented Language (COBOL) or Programming Language One (PL/I).
Skills Taught
--------------------------------------------------------------------------------
Incorporate static SQL statements in an application program
Prepare the program for execution
Validate execution results are correct
Produce code to support multiple rows being returned from the database manager using cursors
Identify considerations regarding units of work, concurrency, and restart of programs
Identify differences between static and dynamic SQL
Provide test data for applications
Discuss program and DB2 options relative to performance of static SQL
Course outline
--------------------------------------------------------------------------------
DB2 concepts
identify DB2 family products
explain DB2 workstation component functions
identify DB2 objects
identify the key differences between static SQL and other application alternatives for accessing DB2 data
Program structure I
embed INSERT, UPDATE, DELETE and single-row SELECT statements in application programs
effectively communicate with DB2 when processing NULL values and determining the success of statement execution
demonstrate use of DB2 coding aids
code CONNECT statements within an application program
identify connection types and impacts on a unit of work
Program preparation
identify the additional steps necessary to prepare a program that contains embedded SQL for execution
describe the functions of the DB2 PRECOMPILE and BIND processes
describe factors relevant to the BIND process, including RUNSTATS positioning, package status, parameters, and authorization requirements
Program structure II
use DECLARE, OPEN, FETCH, and CLOSE CURSOR statements to handle select criteria that may return multiple rows in application programs
issue positioned UPDATE and DELETE statements
identify how scrollable cursors can be used (z/OS)
Recovery and locking concepts
define a unit of recovery
identify the basic locking strategies used by DB2
Dynamic SQL introduction
describe the difference between static and dynamic SQL
list the types of dynamic statements
code dynamic SQL in a program
Managing test data
identify methods to insert data into a table
use the LOAD or IMPORT utility
identify the purpose of the RUNSTATS utility
identify the purpose of the REORG utility
Performance considerations
use programming techniques that enhance DB2 application performance by following general guidelines, using indexable predicates, and avoiding unnecessary sorts
identify the access paths available to DB2
list common causes of deadlocks and avoid such causes when possible
use the EXPLAIN tools as aids to develop applications that emphasize performance
Daily Agenda
Day 1
Welcome
Unit 1 - DB2 Concepts
Lab - DDL
Unit 2 - Program Structure - Part 1
Lab - Program Structure I
Day 2
Unit 3 - Program Preparation
Lab - Program Preparation
Unit 4 - Program Structure - Part 2
Lab - Program Structure II
Unit 5 - Recovery and Locking Concepts
Lab - Cursor Restart
Day 3
Unit 6 - Dynamic SQL Introduction
Lab - Dynamic SQL
Unit 7 - Managing Test Data
Lab - Loading Data
Unit 8 - Performance Considerations
Lab - Performance
...''
Please go to the school's official website for training price and schedule:
http://www.mux-ed.com/
Phone:866-700-9811
School Address:
pSeries/AIX, CISCO, Linux, Microsoft, Professional Skills, Project Management, RedHat LINUX Enrollments 866-700-9811 (Toll Free) or 916-226-2537
CICS, iSeries/OS400, Enterprise/zSeries and WebSphere Enrollments 888-689-3326 (Toll Free) or 916-226-2511
DB2 UDB, Rational Software, and Tivoli Enrollments 866-700-9817 (Toll Free) or 916-226-2533
M/UX
9245 Laguna Springs Drive
Suite 315
Elk Grove, CA 95758 USA
Jobs & Resumes: Atlanta
Houses & Roommates: Atlanta
Other training courses offered by M/UX:
DB2 Universal Database Administration Workshop for Windows
DB2 Universal Database Administration Workshop for UNIX
DB2 UDB Multi Partition Database Administration Workshop for UNIX
DB2 9 for LUW Multiple Partition DBA Workshop
DB2 UDB for z/OS and OS/390 Data Sharing Implementation
DB2 for z/OS and OS/390 Data Sharing Recovery and Restart
DB2 for Linux, UNIX, and Windows Performance Tuning and Monitoring Workshop
DB2 9 for LUW Advanced Database Recovery
DB2 Stored Procedures Programming Workshop
DB2 UDB for z/OS System/Disaster Recovery Workshop
Query and Manage XML data with DB2 9
DB2 UDB for z/OS Stored Procedures using COBOL
DB2 and SQL Programming Workshop
iSeries RPG IV Version 5 Programming Fundamentals Workshop
iSeries RPG IV Version 5 Programming Advanced Workshop
iSeries Advanced System Operator Workshop Version 5
Backup and Recovery Media Services/400 Workshop
System i Performance Analysis Workshop
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent. |
|
|
