DB2 Programming Advanced Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	RT 188
Course Abstract:	The following areas are presented, discussed and built into programs - >DB2 Referential Integrity >Inner and Outer Joins >3, 4, 5 and 6 way joins >Scrollable Cursors >The expanded use of Unions (‘everywhere”) >Fetching 1 (or 2 or 15) Row only >Indicator Variables >Dynamic SQL >Nested Table Expressions >The CASE expression and column functions and scalar functions >Create tables, views and indexes. 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” than their “untuned” counter parts.
Audience:	This course is designed for experienced Data Processing personnel who need more of the “advanced” features of SQL to access DB2 tables in COBOL programs.
Duration:	3 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: >Modify a "shell" program to select a single row, multiple rows, and change rows >CREATE Tables, Indexes, Views >Discuss and program DB2’s Referential Integrity >Use the CASE expressions and several SCALAR / COLUMN FUNCTIONS >Code the UNION everywhere >Code Dynamic and Static SQL >Perform DCLGENs to build table definitions and I/O areas >Handle nulls in Program using indicator variables for Select, Insert and Update >Code scrollable cursors >Program Joins for 3, 4, 5 and 6 tables >Program Inner and outer Joins >Program Nested table expressions as an alternative to external tables >Discuss overall DB2 PERFORMANCE considerations >Run the EXPLAIN PLAN SQL statement and analyze results
Course Topics:	DAY 1 I. Single Table Access Course Introduction 1. DB2 Programming review 2. Create tables, views and indexes. Hands-on Lab – Create tables and Read with a propgram 3. DB2 Referential Integrity Hands-on Lab – DB2 RI 4. Indicator Variables Hands-on Lab – Handling Nulls 5. Dynamic SQL Hands-on Lab – Dynamic SQL 6. Nested Table Expressions Hands-on Lab – Nested table Expression 7. The CASE expression and column functions and scalar functions Hands-on Lab – CASE and Functions DAY 2 II. Multiple Table Access 8. Nested Table Expressions Hands-on Lab – Nested table Expression 9. Scrollable Cursors Hands-on Lab – Scrollable Cursors 10. Unions (‘everywhere”) Hands-on Lab - UNION 11. Inner and Outer Joins Hands-on Lab – Inner/Outer Joins 12. Joining more than 2 tables Hands-on Lab – More that 2 table Joins 13. Fetching 1 (or 2 or 15) Row only Hands-on Lab – Limiting Rows Fetched DAY 3 III. Additional Advanced Programming Considerations 14. Other Advanced Programming Items - Client Selected Topics Hands-on Lab – Other Programming Items IV. Performance Considerations 15. Performance Advanced DB2 Programming Considerations 16. EXPLAIN Statement 17. PLAN_TABLE and DSN_STATEMNT_TABLE Hands-on Lab - Performance Appendices Appendix A - IBM Sample Tables Appendix B – Bibliography Appendix C - The Programming Workshop Appendix D - EXPLAIN PLAN Statement - PLAN_TABLE & DSN_STATEMNT_TABLE Appendix E – SQLCODES / SQLSTATES
Prerequisites:	At least six months of DB2 COBOL Programming experience is required.

DB2 Programming Advanced Course

Hot Courses

Top Skills

Testimonials

AJAX and Web 2.0
Business Practices
Cisco
Customer Service/Communications
End User
Lotus
Mainframe
Messaging Infrastructure
Networking
Operating Systems
Programming Languages
Programming Methodologies
Relational Databases
Reporting Tools
SAP
Scrum Master
Server Applications
Testing
Virtualization
Web Technologies
Wireless Technology