Apache Drill Training Courses

Apache Drill Training Courses

Local, instructor-led live Apache Drill training courses demonstrate through interactive discussion and hands-on practice the fundamentals of Apache Drill, then how to leverage the power and convenience of SQL to interactively query big data without writing code, and how to optimize Drill queries for distributed SQL execution. Apache Drill training is available as "onsite live training" or "remote live training". Onsite live Apache Drill trainings in the UK can be carried out locally on customer premises or in NobleProg corporate training centres. Remote live training is carried out by way of an interactive, remote desktop. NobleProg -- Your Local Training Provider

Testimonials

★★★★★
★★★★★

Apache Drill Course Outlines

CodeNameDurationOverview
apachedrillApache Drill for On-the-Fly Analysis of Multiple Big Data Formats21 hoursApache Drill is a schema-free, distributed, in-memory columnar SQL query engine for Hadoop, NoSQL and other Cloud and file storage systems. The power of Apache Drill lies in its ability to join data from multiple data stores using a single query. Apache Drill supports numerous NoSQL databases and file systems, including HBase, MongoDB, MapR-DB, HDFS, MapR-FS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS and local files. Apache Drill is the open source version of Google's Dremel system which is available as an infrastructure service called Google BigQuery.

In this instructor-led, live training, participants will learn the fundamentals of Apache Drill, then leverage the power and convenience of SQL to interactively query big data across multiple data sources, without writing code. Participants will also learn how to optimize their Drill queries for distributed SQL execution.

By the end of this training, participants will be able to:

- Perform "self-service" exploration on structured and semi-structured data on Hadoop
- Query known as well as unknown data using SQL queries
- Understand how Apache Drills receives and executes queries
- Write SQL queries to analyze different types of data, including structured data in Hive, semi-structured data in HBase or MapR-DB tables, and data saved in files such as Parquet and JSON.
- Use Apache Drill to perform on-the-fly schema discovery, bypassing the need for complex ETL and schema operations
- Integrate Apache Drill with BI (Business Intelligence) tools such as Tableau, Qlikview, MicroStrategy and Excel

Audience

- Data analysts
- Data scientists
- SQL programmers

Format of the course

- Part lecture, part discussion, exercises and heavy hands-on practice
apachedrillqueryoptimApache Drill Query Optimization7 hoursApache Drill is a schema-free, distributed, in-memory columnar SQL query engine for Hadoop, NoSQL and other Cloud and file storage systems. The power of Apache Drill lies in its ability to join data from multiple data stores using a single query. Apache Drill supports numerous NoSQL databases and file systems, including HBase, MongoDB, MapR-DB, HDFS, MapR-FS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS and local files. Apache Drill is the open source version of Google's Dremel system which is available as an infrastructure service called Google BigQuery.

In this instructor-led, live training, participants will learn how to optimize and debug Apache Drill to improve the performance of queries on very large data sets. The course begins with an architectural overview and feature comparison between Apache Drill and other interactive data analysis tools. Participants then step through a series of interactive, hands-on practice sessions that include installation, configuration, performance evaluation, query optimization, data partitioning, and debugging of an Apache Drill instance in a live lab environment.

By the end of this training, participants will be able to:

- Install and configure Apache Drill
- Understand Apache Drill's architecture and features
- Understand how Apache Drills receives and executes queries
- Optimize Drill queries for distributed SQL execution
- Debug Apache Drill

Audience

- Developers
- Systems administrators
- Data analysts

Format of the course

- Part lecture, part discussion, exercises and heavy hands-on practice

Notes

- To request a customized training for this course, please contact us to arrange.

Upcoming Drill Courses

CourseCourse DateCourse Price [Remote / Classroom]
Apache Drill for On-the-Fly Analysis of Multiple Big Data Formats - Bristol, Temple GateMon, 2018-12-03 09:30£3300 / £4050
Apache Drill for On-the-Fly Analysis of Multiple Big Data Formats - OxfordMon, 2018-12-03 09:30£3300 / £4125
Apache Drill for On-the-Fly Analysis of Multiple Big Data Formats - Swansea- Princess HouseMon, 2018-12-03 09:30£3300 / £3750
Apache Drill for On-the-Fly Analysis of Multiple Big Data Formats - Aberdeen - Berry StreetWed, 2018-12-05 09:30£3300 / £4290
Apache Drill for On-the-Fly Analysis of Multiple Big Data Formats - St Helier, Jersey, Channel IslesMon, 2018-12-10 09:30£3300 / £4725
Weekend Apache Drill courses, Evening Drill training, Drill boot camp, Apache Drill instructor-led, Weekend Drill training, Evening Drill courses, Apache Drill coaching, Drill instructor, Drill trainer, Apache Drill training courses, Apache Drill classes, Drill on-site, Apache Drill private courses, Drill one on one training

Course Discounts

CourseVenueCourse DateCourse Price [Remote / Classroom]
Android DevelopmentGlasgowMon, 2018-11-19 09:30£4356 / £5756
Selenium WebDriver in C#: Introduction to Web Testing Automation in C#Edinburgh Training and Conference VenueTue, 2018-11-20 09:30£2178 / £2578
F#: Introduction to Functional ProgrammingPortsmouthMon, 2018-11-26 09:30£2178 / £2478
Python: Automate the Boring StuffSwindonWed, 2018-11-28 09:30£2178 / £2528
JMeter Fundamentals and JMeter AdvancedEdinburgh Training and Conference VenueMon, 2018-12-03 09:30£2178 / £2578
HAProxy AdministrationLondon, Hatton GardenMon, 2018-12-03 09:30£2178 / £2928
From Data to Decision with Big Data and Predictive AnalyticsBirmingham Tue, 2018-12-11 09:30£3861 / £4836
Test Automation with SeleniumManchester, King StreetWed, 2018-12-12 09:30£3267 / £4242
Artificial Intelligence OverviewLondon, Hatton GardenThu, 2018-12-27 09:30£1287 / £1662
RPA: Implementing Robotic Process AutomationLondon, Hatton GardenTue, 2019-01-29 09:30£3861 / £4986

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in the UK!

As a Business Development Manager you will:

  • expand business in the UK
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

contact us right away!