CCA Data Analyst | Firebrand Training

Overview

On this accelerated 3-day Cloudera CCA Data Analyst course, you'll get the skills you need to apply traditional data analytics and business intelligence skills to big data.

Your expert instructor will introduce you to the tools and techniques you need to access, manipulate, transform, and analyse complex data sets using SQL and familiar scripting languages.

You'll learn topics such as:

The features that Pig, Hive, and Impala offer for data acquisition, storage, and analysis
The fundamentals of Apache Hadoop and data ETL (extract, transform, load), ingestion, and processing with Hadoop
How Pig, Hive, and Impala improve productivity for typical analysis tasks
Joining diverse datasets to gain valuable business insight
Performing real-time, complex queries on datasets

Access to 24/7 labs means that you can test your hands-on skills in navigating the Hadoop ecosystem whenever you like. Through our unique Lecture | Lab | Review technique, you'll gain Apache Hadoop skills faster.

On this course, you'll prepare for and sit the CCA Data Analyst exam, covered by your Certification Gurantee.

If you're a data analyst, business intelligence specialist, developer, system architect or database administrator, this course is ideal for you.

See prices now to find out how much you could save when you train at twice the speed.

See prices

Benefits

Other accelerated training providers rely heavily on lecture and independent self-testing and study.

Effective technical instruction must be highly varied and interactive to keep attention levels high, promote camaraderie and teamwork between the students and instructor, and solidify knowledge through hands-on learning.

Firebrand Training provides instruction to meet every learning need:

Intensive group instruction
One-on-one instruction attention
Hands-on labs
Lab partner and group exercises
Question and answer drills
Independent study

Think you are ready for the course? Take a FREE practice test to assess your knowledge!

Free Practice Test

Curriculum

Introduction Apache Hadoop Fundamentals

The Motivation for Hadoop
Hadoop Overview
Data Storage: HDFS
Distributed Data Processing: YARN, MapReduce, and Spark
Data Processing and Analysis: Pig, Hive, and Impala
Database Integration: Sqoop
Other Hadoop Data Tools
Exercise Scenarios

Introduction to Apache Pig

What is Pig?
Pig's Features
Pig Use Cases
Interacting with Pig

Basic Data Analysis with Apache Pig

Pig Latin Syntax
Loading Data
Simple Data Types
Field Definitions
Data Output
Viewing the Schema
Filtering and Sorting Data
Commonly Used Functions

Processing Complex Data with Apache Pig

Storage Formats
Complex/Nested Data Types
Grouping
Built-In Functions for Complex Data
Iterating Grouped Data

Multi-Dataset Operations with Apache Pig

Techniques for Combining Datasets
Joining Datasets in Pig
Set Operations
Splitting Datasets

Apache Pig Troubleshooting and Optimisation

Troubleshooting Pig
Logging
Using Hadoop's Web UI
Data Sampling and Debugging
Performance Overview
Understanding the Execution Plan
Tips for Improving the Performance of Pig Jobs

Introduction to Apache Hive and Impala

What is Hive?
What is Impala?
Why Use Hive and Impala?
Schema and Data Storage
Comparing Hive and Impala to Traditional Databases
Use Cases

Querying with Apache Hive and Impala

Databases and Tables
Basic Hive and Impala Query Language Syntax
Data Types
Using Hue to Execute Queries
Using Beeline (Hive's Shell)
Using the Impala Shell

Apache Hive and Impala Data Management

Data Storage
Creating Databases and Tables
Loading Data
Altering Databases and Tables
Simplifying Queries with Views
Storing Query Results

Data Storage and Performance

Partitioning Tables
Loading Data into Partitioned Tables
When to Use Partitioning
Choosing a File Format
Using Avro and Parquet File Formats

Relational Data Analysis with Apache Hive and Impala

Joining Datasets
Common Built-In Functions
Aggregation and Windowing

Complex Data with Apache Hive and Impala

Complex Data with Hive
Complex Data with Impala

Analysing Text with Apache Hive and Impala

Using Regular Expressions with
Hive and Impala
Processing Text Data with SerDes in Hive
Sentiment Analysis and n-grams in Hive

Apache Hive Optimisation

Understanding Query Performance
Bucketing
Indexing Data
Hive on Spark

Apache Impala Optimisation

How Impala Executes Queries
Improving Impala Performance

Extending Apache Hive and Impala

Custom SerDes and File Formats in Hive
Data Transformation with

Custom Scripts in Hive
User-Defined Functions
Parameterised Queries

Choosing the Best Tool for the Job

Comparing Pig, Hive, Impala, and Relational Databases

Exam Track

On this course, you'll prepare for and take the following exam at the Firebrand Training centre, covered by your Certification Guarantee.

CCA Data Analyst Exam (CCA159)

Number of questions: 8-12
Format: performance-based
Duration: 120 minutes
Passing Score: 70%

What's Included

On this course, you'll receive:

Official Cloudera Data Analyst courseware

Your accelerated course includes:

Accommodation *
Meals, unlimited snacks, beverages, tea and coffee *
On-site exams **
Exam vouchers **
Practice tests **
Certification Guarantee ***
Courseware
Up-to 12 hours of instructor-led training each day
24-hour lab access
Digital courseware **

* For residential training only. Doesn't apply for online courses
** Some exceptions apply. Please refer to the Exam Track or speak with our experts
*** Pass first time or train again free (just pay for accommodation, exams and incidental costs)

Prerequisites

Before attending this course, you should have knowledge of:

SQL
Linux command line
At least one scripting language (e.g., Bash scripting, Perl, Python, Ruby).

You don't need to have experience in Apache Hadoop.

Unsure whether you meet the prerequisites? Don’t worry. Your training consultant will discuss your background with you to understand if this course is right for you.

Reviews

Here's the Firebrand Training review section. Since 2001 we've trained exactly 125505 students and asked them all to review our Accelerated Learning. Currently, 96.59% have said Firebrand exceeded their expectations.

Read reviews from recent accelerated courses below or visit Firebrand Stories for written and video interviews from our alumni.

"I recommend Firebrand Training Sessions since it is concentrating on the core information and save precious time for attendees."
Anonymous (20/6/2022 (Monday) to 24/6/2022 (Friday))

"A great learning experience."
Alan Crowdy, GNS . (5/12/2019 (Thursday) to 7/12/2019 (Saturday))

"Firebrand is providing me with a condensed training always fitting my tight timetable with a high success rate on the certification."
Anonymous (5/12/2019 (Thursday) to 7/12/2019 (Saturday))

"Good training. I have learned very much in a short time."
Frank Lute. (19/11/2018 (Monday) to 21/11/2018 (Wednesday))

Course Dates

Start	Finish	Status	Location
23/5/2022 (Monday)	25/5/2022 (Wednesday)	Finished - Leave feedback	-
26/9/2022 (Monday)	28/9/2022 (Wednesday)	Wait list	Nationwide
7/11/2022 (Monday)	9/11/2022 (Wednesday)	Limited availability	Nationwide
19/12/2022 (Monday)	21/12/2022 (Wednesday)	Open	Nationwide
30/1/2023 (Monday)	1/2/2023 (Wednesday)	Open	Nationwide
13/3/2023 (Monday)	15/3/2023 (Wednesday)	Open	Nationwide

This summer up to 50% discount on the second training! Watch here!

Cloudera - CCA Data Analyst