Menu
  • LOGIN
  • No products in the cart.

Apache Impala Course Description

The ‘Apache Impala-an Open Source SQL Engine for Hadoop’ is an ideal course package for individuals who want to understand the basic concepts of Massively Parallel Processing or MPP SQL query engine that runs on Apache Hadoop.

Impala is widely used by analysts and data scientists to perform analytics on data stored in Hadoop with the help of SQL or business intelligence tools. Impala online training course focuses on the basics of Impala and provides an overview of Apache Impala’s superior performance.

 

Apache Impala Course Learning Outcomes;

  • Understand Impala, benefits of Impala, Impala installation
  • How to run query with Impala
  • Learn the concept of Data Storage and File Format and much more…

 

Apache Impala Training – Suggested Audience

This training is aimed at professionals who have a knowledge of Hadoop & big data and wish to build a strong skill set in that domain. Suggested attendees are:

  • Software Developer
  • Java Developer
  • Software Architect
  • IT Consultant

 

Apache Impala Training – Prerequisites

It is mandatory to have the knowledge of Hadoop and Big data in order to do this course. Hive knowledge is not compulsory but it will be nice to have.

 

Apache Impala In-house/Corporate Training

If you have a group of 5-6 participants, apply for in-house training. For commercials please send us an email with group size to hello@pincorps.com

Course Curriculum

Module 1 - Introduction to Impala
 What is Impala Details 00:00:00
 Benefits of Impala Details 00:00:00
 Exploratory Business Intelligence Details 00:00:00
 Impala Installation Details 00:00:00
 Starting and Stopping Impala Details 00:00:00
 Data Storage Details 00:00:00
 Managing Metadata Preview Details 00:00:00
 Controlling Access to Data Preview Details 00:00:00
 Impala Shell Commands and Interface Details 00:00:00
Module 2 - Querying with Hive and Impala
 Querying with Hive and Impala Details 00:00:00
 SQL Language Statements Details 00:00:00
 DDL Statements Details 00:00:00
 DML Statements Details 00:00:00
 CREATE DATABASE Details 00:00:00
 CREATE TABLE Preview Details 00:00:00
 CREATE TABLE – Examples Preview Details 00:00:00
 Internal and External Tables Details 00:00:00
 Loading Data into Impala Table Details 00:00:00
 ALTER TABLE Details 00:00:00
 DROP TABLE Details 00:00:00
 DROP DATABASE Details 00:00:00
 DESCRIBE Statement Preview Details 00:00:00
 EXPLAIN Statement Preview Details 00:00:00
 SHOW TABLE Statement Details 00:00:00
 INSERT Statement Details 00:00:00
 INSERT Statement – Examples Details 00:00:00
 SELECT Statement Details 00:00:00
 Data Type Details 00:00:00
 Operators Preview Details 00:00:00
 Functions Details 00:00:00
 CREATE VIEW in Impala Details 00:00:00
 Hive and Impala Query Syntax Details 00:00:00
Module 3 - Data Storage and File Format
 Data Storage and File Format Details 00:00:00
 Partitioning Tables Preview Details 00:00:00
 SQL Statements for Partitioned Tables Details 00:00:00
 File Format and Performance Considerations Details 00:00:00
 Choosing File Type and Compression Technique Details 00:00:00
Module 4 -  Working with Impala
 Working with Impala Details 00:00:00
 Impala Architecture Preview Details 00:00:00
 Impala Daemon Details 00:00:00
 Impala Statestore Details 00:00:00
 Impala Catalog Service Details 00:00:00
 Query Execution Flow in Impala Details 00:00:00
 User – Defined Functions Preview Details 00:00:00
 Hive UDFs with Impala Details 00:00:00
 Demo – UDF in Impala Details 00:00:00
 Improving Impala Performance Details 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

X