DB2 Data Warehousing Performance And Tuning Workshop
Duration: 4 Days
This presentation and hands-on workshop emphasises how to optimise data warehouse design in both non-partitioned and partitioned environments.
Topics central to this presentation include:
Topics Covered In This Course
REVIEW OF THE BASICS
SYSTEM ENVIRONMENT CONSIDERATIONS
PERFORMANCE AND MONITORING TOOLS
DB2 UDB'S MATERIALIZED VIEWS
DB2 UDB ENVIRONMENT CONSIDERATIONS
COMMAND AND UTILITY OPTIONS
PARTITIONING AND PERFORMANCE
DB2 OPTIMIZER (COMPILER)
DB2 UDB'S STATISTICS, ANALYTIC, AND OLAP FUNCTIONS
MULTIDIMENSIONAL CLUSTERING (MDC)
What You Can Expect
Upon completion of this presentation, the participant should be able to design, optimise and implement large-scale data warehouses to meet a variety of BI (Business Intelligence).
Who Should Take This Course
DB2 BI and data warehouse developers, database administrators and system administrators.
Completion of our course DB2 Data Warehouse Fundamentals or equivalent knowledge.
Lecture and hands-on.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]