Denodo Platform Full Overview

Course Content

This course provides the key concepts of the data virtualization architecture needed for management, planning, design and implementation of this kind of architectures.

Duration

5 Days of Instructor-led Training.

Prerequisites

Basic knowledge of HTML, relational database and Structured Query Language (SQL) and a basic knowledge of programming are required. Basic knowledge of the Java programming language, JDBC and Web services are required.

Topics

  • Introduction to Denodo Platform
  • Virtual DataPort architecture
  • Virtual DataPort basic concepts
  • Introduction to the Virtual DataPort Administration Tool
  • Importing data sources and creating base views with Virtual DataPort
    • Data Sources: Relational databases (JDBC, ODBC), Web services, XML, JSON, delimited files, LDAP
    • Creating base views
  • Creation of derived views and queries with Virtual DataPort
    • Derived view types (union, join, selection, projection, aggregation, flatten, …)
    • Additional concepts
  • Publication of views as Web services
  • VQL (Virtual Query Language)
  • Advanced view management
    • Query capabilities
    • Query optimization
    • Internationalization and cache
    • Views configuration
    • Interfaces and top-down development
    • Data governance
  • Development best practices
    • Version Control Integration
    • Error analysis
    • Virtual DataPort performance optimization
  • Introduction to custom functions
  • Introduction to stored procedures
  • User administration in Virtual DataPort
    • Role management
    • User management
    • Database management
    • Security
    • Cache
  • Governance and data lineage
  • Server and user administration in Virtual DataPort
    • Server configuration
    • Monitoring
    • High availability
  • Updating the Denodo Platform
  • Backup and migration best practices
  • Monitoring and error analysis
  • Scheduler. Architecture.
  • Scheduler Administration Tool, jobs, handlers

Training Resources

  • 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).

Price

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

**Price per attendant. 

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.

Reference

Course code

DEN60EDUG01