Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More DB2

Related Courses

DB2 UDB for Experienced SQL Developers

Recommended Duration:
3 Days
Benefits
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)
Audience
Experienced SQL programmers who need to work with DB2 UDB Databases, both from a Command Line perspective and from within application programs.
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.
Major 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
Exercises
There are nine hands-on exercises.