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
Testimonials (5)
Dużo cierpliwości
Mateusz - WestWind Energy Polska Sp. z o.o.
Course - ArcGIS for Spatial Analysis
Ο εκπαιδευτής προσάρμοσε το υλικό και το περιεχόμενο σε αυτό που πίστευε ότι θα ήταν καλύτερο για εμάς και τα κατάφερε. Η ποιότητα της εκπαίδευσης ήταν εξαιρετική.
Jorge Sanchez Hernandez - CSMART - Carnival
Course - QGIS for Geographic Information System
Machine Translated
I genuinely enjoyed the lots of labs and practices.
Vivian Feng - Destination Canada
Course - Data Analysis with SQL, Python and Spotfire
Επαγγελματικό και πολύ πρακτικό, χρήσιμο σε καθημερινή εργασία
Jozefin Rékasi - SC Automobile Dacia SA
Course - Advanced Data Analysis with TIBCO Spotfire
Machine Translated
Κάλυψε τους τομείς που είπα ότι με ενδιέφεραν πριν από το μάθημα: σχέσεις δεδομένων, χρήση script python. Η σύνδεση με βάσεις δεδομένων θα καλύπτεται στην ενότητα για προχωρημένους.
Cristian Tudose - SC Automobile Dacia SA
Course - Introduction to Spotfire
Machine Translated