Instructor Led Db2 Explain Training
Db2 Explain Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From FormaServe Systems Ltd
RPG Using Embedded SQL
This course teaches all the functionality necessary to use embedded SQL features inside your RPG programs.
Using SQL embedded combines the flexibility of SQL with the sophistication of RPG to create powerful programs. Let SQL manage your data retrieval, you can then concentrate on your RPG functionality.
This class demonstrates embedding techniques using hands on exercises and also reviews
more...
This course teaches all the functionality necessary to use embedded SQL features inside your RPG programs.
Using SQL embedded combines the flexibility of SQL with the sophistication of RPG to create powerful programs. Let SQL manage your data retrieval, you can then concentrate on your RPG functionality.
This class demonstrates embedding techniques using hands on exercises and also reviews
more...
From Affinity IT Training, LLC
DB2 -- Performance and Tuning
This course provides experienced SQL developers with a fast-paced transition to DB2 performance and tuning.
Following a review of the DB2 architecture, environment, and data structures,
course coverage includes index internals, block index MDC
'
s,
access methods, and how to write effective SQL predicates.
'
Explain
'
tables and tools are covered in detail as well as additional performance tools.
more...
This course provides experienced SQL developers with a fast-paced transition to DB2 performance and tuning.
Following a review of the DB2 architecture, environment, and data structures,
course coverage includes index internals, block index MDC
'
s,
access methods, and how to write effective SQL predicates.
'
Explain
'
tables and tools are covered in detail as well as additional performance tools.
more...
From Wintrac Inc.
DB2 Visual Explain for SQL Application Performance Analysis
About Wintrac
Wintrac provides one stop shopping for all your IT training needs. Wintrac s course catalog of over two thousand courses includes courses on Mainframe training , COBOL Training and DB2 training
This course gives a brief overview of DB2 SQL performance considerations, including establishing goals for Application SQL performance.
We explore the capabilities of Visual Explain
more...
DB2 Concepts and Facilities
First, the concepts of DB2 are presented and discussed.
The major features of the Structured Query Language (SQL) are presented as the means to access DB2 data (and to create and secure DB2 components). Several of the "special features" of SQL are presented.
Optionally, guided, hands-on, practice sessions give each attendee an opportunity to use SQL to access data. QMF and/ or SPUFI are
more...
DB2 for z-OS Application Programming - Advanced
DB2 performance guidelines are discussed in detail. The SQL statement EXPLAIN PLAN is used to help to evaluate the efficiency of SQL statements. Advanced Programming Performance considerations are presented to "tuned" programs to perform "better" that their "untuned" counter parts.
You can get a complete list of other DB2 classes at
more...
DB2 for z-OS Application Performance Tuning
...STATEMNT_TABLE are analyzed in detail. The results of the DB2 EXPLAIN process are reviewed to obtain insights into the Way(s) that the Optimizer chooses the access path to access DB2 data.
Extensive workshops allow the students to test the performance "goodness" of several SQL statements.
The Plan Analyzer is used to review the results of the EXPLAIN process.
You can get a complete list
more...
