Impala Training

Course

Online

Price on request

Description

  • Type

    Course

  • Methodology

    Online

Simplilearn is the World’s Largest Certification Training Provider, with over 400,000+ professionals trained globally
Trusted by the Fortune 500 companies as their learning provider for career growth and training
2000+ certified and experienced trainers conduct trainings for various courses across the globe
All our Courses are designed and developed under a tried and tested Unique Learning Framework that is proven to deliver 98.6% pass rate in first attempt.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2017
2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 8 years

Course programme

Course Preview
  • Impala-An Open Source SQL Engine for Hadoop
    • Lesson 0 - Course Introduction
      • 0.1 Course Introduction
      • 0.2 Table of Contents
      • 0.3 Objectives
      • 0.4 Course Overview
      • 0.5 Value to Professionals and Organizations
      • 0.6 Course Prerequisites
      • 0.7 Lessons Covered
      • 0.8 Conclusion
    • Lesson 1 - Introduction to Impala
      • 1.1 Introduction to Impala
      • 1.2 Objectives
      • 1.3 What is Impala
      • 1.4 Benefits of Impala
      • 1.5 Benefits of Impala (Contd.)
      • 1.6 Exploratory Business Intelligence
      • 1.7 Impala Installation
      • 1.8 Demo - Using Cloudera Manager for Impala
      • 1.9 Demo - Using Cloudera Manager for Impala (contd.)
      • 1.10 Starting and Stopping Impala
      • 1.11 Demo - Starting Impala from Command Line
      • 1.12 Demo - Starting Impala from Command Line (contd.)
      • 1.13 Data Storage
      • 1.14 Managing Metadata
      • 1.15 Controlling Access to Data
      • 1.16 Impala Shell Commands and Interface
      • 1.17 Impala Shell Commands and Interface (contd.)
      • 1.18 Demo - Launching Impala Shell and Shell Command
      • 1.19 Demo - Launching Impala Shell and Shell Command (contd.)
      • 1.20 Quiz
      • 1.21 Summary
      • 1.22 Summary (contd.)
      • 1.23 Conclusion
    • Lesson 2 - Querying with Hive and Impala
      • 2.1 Querying with Hive and Impala
      • 2.2 Objectives
      • 2.3 SQL Language Statements
      • 2.4 DDL Statements
      • 2.5 DML Statements
      • 2.6 CREATE DATABASE
      • 2.7 CREATE TABLE
      • 2.8 CREATE TABLE - Examples
      • 2.9 Internal and External Tables
      • 2.10 Loading Data into Impala Table
      • 2.11 ALTER TABLE
      • 2.12 DROP TABLE
      • 2.13 DROP DATABASE
      • 2.14 DESCRIBE Statement
      • 2.15 EXPLAIN Statement
      • 2.16 SHOW TABLE Statement
      • 2.17 INSERT Statement
      • 2.18 INSERT Statement - Examples
      • 2.19 SELECT Statement
      • 2.20 Data Type
      • 2.21 Data Type (contd.)
      • 2.22 Operators
      • 2.23 Functions
      • 2.24 CREATE VIEW in Impala
      • 2.25 Hive and Impala Query Syntax
      • 2.26 Demo - Using Impala Shell for DDL and DDML SQL Statements
      • 2.27 Demo - Using Impala Shell for DDL and DDML SQL Statements (contd.)
      • 2.28 Quiz
      • 2.29 Summary
      • 2.30 Conclusion
    • Lesson 3 - Data Storage and File Format
      • 3.1 Data Storage and File Format
      • 3.2 Objectives
      • 3.3 Partitioning Tables
      • 3.4 SQL Statements for Partitioned Tables
      • 3.5 File Format and Performance Considerations
      • 3.6 Choosing File Type and Compression Technique
      • 3.7 Demo - File Formats and Compression Techniques
      • 3.8 Demo - File Formats and Compression Techniques (contd.)
      • 3.9 Quiz
      • 3.10 Summary
      • 3.11 Conclusion
    • Lesson 4 - Working with Impala
      • 4.1 Working with Impala
      • 4.2 Objectives
      • 4.3 Impala Architecture
      • 4.4 Impala Daemon
      • 4.5 Impala Statestore
      • 4.6 Impala Catalog Service
      • 4.7 Query Execution Flow in Impala
      • 4.8 User - Defined Functions
      • 4.9 Hive UDFs with Impala
      • 4.10 Demo - UDF in Impala
      • 4.11 Demo - UDF in Impala(contd.)
      • 4.12 Improving Impala Performance
      • 4.13 Quiz
      • 4.14 Summary
      • 4.15 Conclusion

Impala Training

Price on request