Course Outline

Introduction

  • How Dremio solves the problem of data staging, data warehousing, aggregation, extracts, etc.

Installing and Configuring Dremio

Overview of Dremio Features and Architectures

  • Data Acceleration
  • Data Reflections (on HDFS, MapR-FS, cloud storage such as S3, local storage, etc.)

Query Execution Life Cycle

  • Planning, coordination, execution,

Navigating the Dremio Web UI

Discovering Data

  • The unified data catalog

Curating Data

  • Creating virtual datasets

Using SQL to Define Transformations

  • Joins and data type conversions
  • Connecting through ODBC, JDBC and REST

Sharing Data with Team

  • Uploading, collaboration, and access rights

Integrating Dremio with BI (Business Intelligence) Tools

  • Serving up data for Tableau

Integrating Dremio with an Elasticsearch Cluster

Summary and Conclusion

Requirements

  • An understanding of Hadoop, NoSQL, and other data storage concepts
  • Experience with writing SQL queries
  • Experience with Linux command line
  21 Hours
 

Testimonials (3)

Related Courses

Related Categories