Course Outline

Introduction to Apache Drill

How does Apache Drill compare to Spark SQL, Hive and Impala?

Overview of Apache Drill Features and Architecture

  • Apache Drill Components

Performing SQL Queries in Apache Drill

Understanding Data Types and Formats

Working with Schemas

Case Study and Exercise: Querying Sales Data for the Year

Performing Queries on JSON Data

Combining Data Types in SQL Queries

Creating and Dropping Tables and Views

Using Nested Data and Window Functions

Performing Data Analysis with Apache Drill

Case Study and Exercise: Analyzing the Results of a Marketing Campaign

Designing a Query Plan in Apache Drill

Optimizing Queries in Apache Drill

Integrating Apache Drill with MS Excel

Using Apache Drill ODBC/JDBC drivers to plug into Tableau, MicroStrategy, Qlikview, etc.

Case Study and Exercise: Visualizing the Data and the Power of a Good Story

Understanding Apache Drill's Decentralized Security Model

Apache Drill Performance and Debugging

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

Related Courses

SPSS Modeler

  14 hours

Databricks

  14 hours

Microsoft Power Platform Fundamentals

  14 hours

PL-900T00: Microsoft Power Platform Fundamentals

  7 hours

Data Cleaning

  7 hours

Sensu: Beginner to Advanced

  14 hours

Monitoring Your Resources with Munin

  7 hours

Automated Monitoring with Zabbix

  14 hours

Fluentd for Log Data Unification

  14 hours

Nagios Core

  21 hours

Nagios

  35 hours

Nagios XI Administration

  21 hours

Advanced Nagios

  21 hours

Zenoss Monitoring for Administrators

  21 hours

Netdata

  7 hours