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.

Note: this course will be available by the end of 2020 Q3. In the meantime you can enroll in the Data Virtualization Developer (Advanced) course for Denodo Platform 7.0.

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

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, £325, 375€

Instructor-led training:

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

* 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.

Course code

DEN80EDU22ADS