Find Courses Find Providers Providers - Promote Your Courses About Us

DB2 for LUW: Advanced DB2 via DB2 Explain

Training Courses

Would you like to see more Databases courses?

Training course summary

Sponsored links

SUMMARY: This course focuses on tuning advanced SQL via DB2 Explain facilities in terms of the following DB2 UDB features: - Isolation levels - Locking and concurrency - Join optimisation - Sequence and identity columns - Common Table Expressions - Recursive queries - Grouping sets - Materialized Query tables (MQTs) - Index design and usage - SARGable vs. non-SARGable predicates - Elapsed, CPU and I/O times

Regions:
  • All Areas
Delivery:
  • Public
Category:
Difficulty:
  • Advanced

Further Details

DURATION: 3 days AUDIENCE: Application Developers, Application Programmers, Production DBAs, Database Administrators and Capacity Planners. PREREQUISITES: Completion of our course 'DB2 SQL Essentials' or at least one year of SQL experience in a Windows, UNIX or OS/2 environment.

Guide price

900+VAT

 

Sponsored links

Interested in this course?

 

 
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net