Denodo Performance Best Practices

Course content

Data Virtualization architectures need to be fully-performance. This course will talk about the internal details of the Denodo Optimizer to learn how to maximize the performance of the queries executed in Denodo Platform.

Duration

• Instructor-led: 8 hours (1 training day)
• On-demand: 4 hours (0.5 training days)

Prerequisites

Previous experience with Denodo Platform 8.0. It's recommended to complete the Connecting and Combining Data with Denodo) course before enrolling in this course.

Topics

• Denodo Query Optimizer Overview
• Delegation to sources
• Static Optimizer
  • Basic Static Optimizations
  • Branch Pruning
  • Alternative Wrappers
  • Summaries
• Data Movement
• Dynamic Optimizer
  • MPP
• Cache
• Memory Usage
• Detecting Bottlenecks
• Resource Manager

Language

This course is available in English.

The On-demand version supports the following subtitles: English, Japanese, Chinese, Spanish, Italian, French, German and Portuguese.

Training resources

• Public/Virtual classes
  • Denodo Software: Students will download the Denodo Platform from the Denodo Support Site.
  • An electronic copy of the presentations used during the training.
  • Each student will receive a 1-month Denodo training license (full capability).
• On-demand classes
  • Use Denodo Express for doing the labs.

Price

At your own pace:

• At on-demand training: $400 USD (fee is waived for Denodo customers and partners with an active contract).

Instructor-led training:

• At public classrooms*: $1000 USD, £675, €800
• At customer's facilities: request a private training
• At virtual classrooms**: $800 USD, £600, €700

* Price per attendee. It is recommended that you do not make any travel arrangements until the class is confirmed.

** Price per attendee.

Cancellation policies

• Requests for cancellations or date transfers need to be received by Denodo at least ten (10) business days prior to the course start date in order to receive a full refund. If cancellation or reschedule requests are received less than ten (10) business days before the course start date, the penalty of 100% of the cost of the course will be applied, resulting in no amount of the fee being refunded. There will be no penalty for requesting a reschedule more than ten (10) business days prior to the course start date.
• Denodo reserves the right to cancel courses for any reason up to five (5) business days prior to the course start date. In the event that a course is cancelled, Denodo will secure a future course date or refund fee in full. It is recommended that you do not make any travel arrangements until the class is confirmed.