-
Lesson 1 - Introduction to Apache Drill
-
Lesson 2 - SQL Queries with Apache Drill
-
Quiz 2
-
Lesson 3 - Apache Drill Operations and Functions
-
Quiz 3
- Course Materials
-
Lab Guide
-
Lab Environment Connection Guide
Introduction to SQL Analytics with Apache Drill
Intro to Apache Drill, covering some Drill SQL interfaces, queries, use cases, and the basics of data analysis. Use Drill to explore known or unknown data without writing code.
This course introduces students to Apache Drill and goes over some Drill SQL Interfaces, Queries, and use cases, and teaches the basics of data analysis. You will learn how to use Drill to explore known or unknown data without writing code. It also describes how a query is received and executed by Drill.
What's Covered
| Course Lessons | Lab Activities |
|
1: Introduction to Apache Drill Describe Apache DrillExplore Key Features of Apache Drill Review Data Types and Formats |
Explore the Drill SQL Interfaces Perform Drill SQL Queries |
|
2: SQL Queries with Apache Drill Plan Data Analysis ObjectivesPerform SQL Queries on Structured Data Perform SQL Queries on a Variety of Data Types Combine Data Types in SQL Queries |
Describe Schemas Query Marketing Data Query JSON Data Combine Data Types |
|
3: Apache Drill Operations and Functions Create and Drop Tables and ViewsUse Nested Data and Window Functions Extend Drill with Custom Functions Perform an End-to-End Drill Data Analysis |
Create and Drop Tables and Views Perform Nested Data Functions Perform Aggregate Window Functions Perform an End-to-End Data Analysis |
Prerequisites
- Basic understanding of application development principles