Advanced ADS

Advanced Agile Data Warehouse Service (ADS)

Summary

This course builds on the Agile Data Warehouse Service Essentials course by providing a more detailed look at the architecture of the GoodData Agile Data Warehouse Service. Practical hands-on exercises are included to walk participants through application of best practices for projections, physical design, data loading, and performance tuning. By the end of the course, participants will be able to tailor ADS storage structures to the characteristics of their data warehouse and staging data.

If you would like to enroll in this course, please contact training@gooddata.com or your account manager to schedule a time.

 

Duration

3 hours

Audience

Engineers responsible for loading data into GoodData

Prerequisites

  • Introduction to Data Modeling and ETL course
  • ETL Essentials course
  • Data Modeling Advanced course
  • Agile Data Warehouse Service Essentials course
  • A basic understanding of SQL (i.e., ability to create tables, select data and perform simple updates)
  • CloudConnect Designer installed on your computer system
  • DBVisualizer installed on your computer system

Outline

  • Architecture Deep Dive
    • Distributed Columnar Database (Tables, Projections, Segmentation)
    • Logical Model vs. Physical Implementation
  • Best Practices
    • Simple Rules for Physical Model Design
    • Simple Rules for Data Modeling
    • Performance Tuning
  • Hands-on Exercises (spread throughout the course)
  • Certification Test Module (for those seeking GoodData Certification)

Upcoming Classes

No classes have been scheduled, but you can always Request a Quote.

Onsite Training

For groups of three or more

Request Quote

Public Training