Wronski Associates
Twitter
LinkedIn
Login
Contact Us
Company
Leadership Development
Training Solutions
Consulting Services
In The Spotlight
Close
Company
Leadership Development
Training Solutions
Consulting Services
In The Spotlight
Login
Contact Us
Twitter
LinkedIn
Send to a Friend
Content to send
DB2 UDB for Experienced SQL Developers
Course Number:
705-JK
Recommended Duration:
3 days
Intended Audience:
Experienced SQL programmers who need to work with DB2 UDB Databases, both from a Command Line perspective and from within application programs.
Objectives
Students who complete this course will be able to code SQL statements to access DB2 UDB objects by typing SQL and from within application programs (in the student's standard host environment)
DB2 UDB Version 8.1. Most of the class is suitable for those earlier versions of DB2 UDB (DB2 UDB 7).
Prerequisites
The student should have SQL experience and at least 6 months experience designing and coding application programs or have completed a basic programming course within the last 12 months. Familiarity with the available editor and execution environment is required.
Topics
DB2 UDB concepts
DB2 Clients: Run-time, Administration, SDK
Control center
Command line processor
Warehousing features: CUBE, ROLLUP, Analytic functions
COMMIT/ROLLBACK
Joins and subqueries
Review of advanced SQL syntax
Creating tables and views
Materialized query tables
System catalog tables
Cursors and locks
Security and authorization
DB2 extenders
DB2 connect
Database administration server
Dynamic SQL
Stored procedures and triggers
Efficiency considerations: Optimizer, Explain, and Application Plans
Share with others
Please provide the following information
Your Name
Your Email Address
Recipient Emails
Message
Can't Read?
Click to Generate New Code
Enter the verification code shown above into the text box below