Course description

  • What is this course about?

    The ‘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. On completing this course, learners will be able to interpret the role of Impala in the Big Data Ecosystem.

    The course focuses on the basics of Impala. It further provides an overview of the superior performance of Impala, against other popular SQL-on-Hadoop systems.

  • Why is this course popular?

    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. The growing need for professionals equipped with the knowledge Impala has increased opportunities for those who want to make a career in this field.

  • What learning benefits do you get from Simplilearn’s training?

    At the end of Simplilearn’s training in the Impala-an Open Source SQL Engine for Hadoop, the participants will be able to:
    • Describe Impala and its role in Hadoop Eco-system
    • Explain how to query data using impala SQL
    • Discuss partitioning of Impala tables and explain its benefits
    • List the factors affecting the performance of Impala
    • Describe the complete flow of a SQL query execution in Impala.

  • What are the career benefits in-store for you?

    After doing to this course you get an opportunity to work in highly rewarding big data projects and also gain knowledge about MPP data warehouse product. A good knowledge of SQL and familiar scripting languages, increases your career prospects in Big Data industry. According to, the average salary for an entry-level SQL developer ranges around $60,000.

  • Why should you do this course?

    Knowledge of Impala enables you to query data on big data in Apache Hadoop and skip the time-consuming steps of loading and reorganizing data. This course is specially designed to help professionals with the knowledge of Data base, SQL, data warehouse and other data base programing languages, to make a career transition into big data platform.

  • Who should do this course?

    The target group of the Impala-an Open Source SQL Engine for Hadoop course includes, but is not restricted to:
    • Analysts
    • Data scientists
    • Hadoop administrator and developers
    • SQL developers
    • Data warehouse developers
    • Database administrators and developers

Course preview

    • Lesson 0 - Course Introduction 03:39
      • 0.1 Course Introduction00:23
      • 0.2 Table of Contents00:36
      • 0.3 Objectives00:31
      • 0.4 Course Overview00:36
      • 0.5 Value to Professionals and Organizations00:58
      • 0.6 Course Prerequisites00:18
      • 0.7 Lessons Covered00:08
      • 0.8 Conclusion00:09
    • Lesson 1 - Introduction to Impala 14:19
      • 1.1 Introduction to Impala00:17
      • 1.2 Objectives00:25
      • 1.3 What is Impala00:58
      • 1.4 Benefits of Impala01:17
      • 1.5 Benefits of Impala (Contd.)01:06
      • 1.6 Exploratory Business Intelligence00:56
      • 1.7 Impala Installation
      • 1.8 Demo - Using Cloudera Manager for Impala00:08
      • 1.9 Demo - Using Cloudera Manager for Impala (contd.)00:08
      • 1.10 Starting and Stopping Impala01:23
      • 1.11 Demo - Starting Impala from Command Line00:05
      • 1.12 Demo - Starting Impala from Command Line (contd.)00:53
      • 1.13 Data Storage01:10
      • 1.14 Managing Metadata01:20
      • 1.15 Controlling Access to Data00:40
      • 1.16 Impala Shell Commands and Interface01:31
      • 1.17 Impala Shell Commands and Interface (contd.)00:34
      • 1.18 Demo - Launching Impala Shell and Shell Command00:06
      • 1.19 Demo - Launching Impala Shell and Shell Command (contd.)00:06
      • 1.20 Quiz
      • 1.21 Summary00:51
      • 1.22 Summary (contd.)00:15
      • 1.23 Conclusion00:10
    • Lesson 2 - Querying with Hive and Impala 26:44
      • 2.1 Querying with Hive and Impala00:21
      • 2.2 Objectives00:34
      • 2.3 SQL Language Statements01:13
      • 2.4 DDL Statements00:55
      • 2.5 DML Statements00:55
      • 2.6 CREATE DATABASE00:43
      • 2.7 CREATE TABLE00:59
      • 2.8 CREATE TABLE - Examples00:59
      • 2.9 Internal and External Tables00:53
      • 2.10 Loading Data into Impala Table00:35
      • 2.11 ALTER TABLE00:34
      • 2.12 DROP TABLE00:41
      • 2.13 DROP DATABASE00:30
      • 2.14 DESCRIBE Statement00:47
      • 2.15 EXPLAIN Statement01:07
      • 2.16 SHOW TABLE Statement00:29
      • 2.17 INSERT Statement00:50
      • 2.18 INSERT Statement - Examples00:22
      • 2.19 SELECT Statement00:45
      • 2.20 Data Type01:17
      • 2.21 Data Type (contd.)00:46
      • 2.22 Operators01:22
      • 2.23 Functions00:39
      • 2.24 CREATE VIEW in Impala01:02
      • 2.25 Hive and Impala Query Syntax02:09
      • 2.26 Demo - Using Impala Shell for DDL and DDML SQL Statements02:09
      • 2.27 Demo - Using Impala Shell for DDL and DDML SQL Statements (contd.)02:09
      • 2.28 Quiz
      • 2.29 Summary00:49
      • 2.30 Conclusion00:10
    • Lesson 3 - Data Storage and File Format 11:47
      • 3.1 Data Storage and File Format00:22
      • 3.2 Objectives00:27
      • 3.3 Partitioning Tables00:43
      • 3.4 SQL Statements for Partitioned Tables01:16
      • 3.5 File Format and Performance Considerations01:02
      • 3.6 Choosing File Type and Compression Technique00:30
      • 3.7 Demo - File Formats and Compression Techniques00:15
      • 3.8 Demo - File Formats and Compression Techniques (contd.)06:24
      • 3.9 Quiz
      • 3.10 Summary00:39
      • 3.11 Conclusion00:09
    • Lesson 4 - Working with Impala 12:53
      • 4.1 Working with Impala00:18
      • 4.2 Objectives00:33
      • 4.3 Impala Architecture00:47
      • 4.4 Impala Daemon01:08
      • 4.5 Impala Statestore00:25
      • 4.6 Impala Catalog Service01:40
      • 4.7 Query Execution Flow in Impala00:47
      • 4.8 User - Defined Functions01:01
      • 4.9 Hive UDFs with Impala01:14
      • 4.10 Demo - UDF in Impala00:07
      • 4.11 Demo - UDF in Impala(contd.)02:31
      • 4.12 Improving Impala Performance01:35
      • 4.13 Quiz
      • 4.14 Summary00:40
      • 4.15 Conclusion00:07
    • {{childObj.title}}
      • {{childObj.childSection.chapter_name}}
        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

Exam & certification

  • What qualifications do you need?

    Fundamental Knowledge of programming language and Hadoop components is the basic course prerequisite. However, participants are expected to have knowledge of SQL commands.

  • What do I need to do to unlock my Simplilearn certificate?

    Online Self-Learning:
    • Complete 85% of the course.
    • Complete 1 simulation test with a minimum score of 60%.


    • How do I enroll for the Online training?

      You can enroll for this Online training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
      1. Visa debit/credit card
      2. American express and Diners club card
      3. Master Card, or
      4. Through PayPal

    • What will I get along with this training?

      You will have access to the online e-learning and practice tests along with the training.

    • Can I cancel my enrollment? Do I get a refund?

      Yes, you can cancel your enrollment. We provide you complete refund after deducting the administration fee. To know more please go through our Refund Policy.

    • Do you provide any course completion certificate?

      Yes, we offer course completion certificate after you successfully complete the training program.

    • Where and how can I access the e-learning content? Are there any limitations?

      Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail from our side will guide you through the process.

    • I am not able to access the online course. Whom should I contact for a solution?

      Please raise a request via our Help and Support portal to have your issue resolved.

    • Do you provide money back guarantee for the training programs?

      Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.

    • I want to know more about the training program. Whom do I contact?

      Please join our Live Chat for instant support, call us, or Request a Call Back to have your query resolved.

    • What does it mean to be GSA approved course?

      The course is part of Simplilearn’s contract with GSA (only US) with special pricing for GSA approved agencies & organizations. To know more click here

    • How do i know if I am eligible to buy this course at GSA price?

      You should be employed with GSA approved agencies & organizations. The list of approved agencies is provided here

    • Disclaimer
    • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.