Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Apache Drill: A Hands-on Course
Rating: 4.7 out of 5(8 ratings)
64 students

Apache Drill: A Hands-on Course

Complete, In-depth & HANDS-ON practical course on Apache Drill
Created byShruti Mantri
Last updated 6/2021
English

What you'll learn

  • Learn using schema-free SQL Query Engine for Big Data : Apache Drill
  • Learn connecting to different data sources and querying over different file formats using Apache Drill
  • Hands-on Practicals helping you understand Apache Drill clearly
  • Even learn those concepts which are not properly explained in Drill's official documentation.
  • Understand the working of Apache Drill

Course content

5 sections • 22 lectures • 2h 16m total length

  • Introduction5:26

    Explore how Apache Drill delivers schema-free, multi-store SQL queries across Hadoop, RDBMS, NoSQL, cloud storage, and filesystems, with seamless integrations and a scalable three-layer architecture.

  • Course Objectives1:56

    Install drill on macOS or Linux, use the drill console, connect to filesystem and data stores like MySQL, MongoDB, Hive, Kafka, and HBase, and learn ANSI SQL, nested data.

  • Drill vs Presto & Community Support4:17

Requirements

  • Basic knowledge of SQL is required

Description

Apache Drill is a Schema-free SQL Query Engine for Hadoop, NoSQL and Cloud Storage. The major highlights of Apache Drill are:

1. Agility: Get faster insights without the overhead (data loading, schema creation and maintenance, transformations, etc.)
2. Flexibility: Analyze the multi-structured and nested data in non-relational datastores directly without transforming or restricting the data
3. Familiarity: Leverage your existing SQL skillsets and BI tools including Tableau, Qlikview, MicroStrategy, Spotfire, Excel and more

Apache Drill can scale upto 1000s of servers, and is very high performant because of the way it is architected. This course not only covers how to use Drill to connect and query different data sources, but also explains the functioning of Drill and why it beats query engines like Spark, Presto and Impala.

Drill is a go-to tool for interactive Data Exploration. With its capability to connect seamlessly to any data store, and schema-free data exploration, it has become a go-to tool in the analyst's toolkit. Drill uses ANSI SQL for querying, and treats every data like a table, even if it is not, making it very easy to use for querying purposes.

What's included in the course?

  • Complete course on Apache Drill concepts and capabilities explained from Scratch.

  • Each and Every Apache Drill concept is explained with a HANDS-ON.

  • Includes even those concepts, the explanation to which is not very clear even in Drill official documentation.

  • Related Commands and Datasets used in lectures are attached in the course for your convenience.

Who this course is for:

  • Students who want to learn Apache Drill from SCRATCH with all the details
  • Developers who want to upgrade themselves to have easy-to-use and powerful query engine in their toolkit
  • Developers who are exploring a low-latency schema-free query engine for Data exploration
  • Developers who are exploring query engine spanning across different data sources and file formats

Report abuse