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

Four reasons why you should sit your CCA Data Analyst course with Firebrand Training

You'll be CCA Data Analyst trained and certified faster. Learn more on this 3-day accelerated course. You'll get at least 12 hours a day of quality learning time in a distraction-free environment
Your CCA Data Analyst course is all-inclusive. One simple price covers all course materials, exams, accommodation and meals – so you can focus on learning
Pass CCA Data Analyst first time or train again for free. Your expert instructor will deliver our unique accelerated learning methods, allowing you to learn faster and be in the best possible position to pass first time. In the unlikely event that you don't, it's covered by your Certification Guarantee
Study CCA Data Analyst with an award-winning training provider. We've won the Learning and Performance Institute's "Training Company of the Year" three times. Firebrand is your fastest way to learn, with 125.505 students saving more than one million hours since 2001

Benefits

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.

Are you ready to get certified in record time?

We interview all applicants for the course on their technical background, degrees and certifications held, and general suitability. If you get through this screening process, it means you stand a great chance of passing.

Firebrand Training is an immersive training environment. You must be committed to the course. The above prerequisites are guidelines, but many students with less experience have other background or traits that have enabled their success in accelerated training through Firebrand Training.

If you have any doubts as to whether you meet the pre-requisites please call (0)8 52 50 01 66 and speak to one of our enrolment consultants, who can help you with a training plan.

Reviews

We've currently trained 125.505 students in 12 years. We asked them all to review our Accelerated Learning. Currently,
96,60% have said Firebrand exceeded their expectations:

"Great training at a convenient location."
Kenneth Brann, DOD. (25/7/2022 (Monday) to 26/7/2022 (Tuesday))

"Pretty good and enjoyable course"
James McRobbie, Lexis Nexis. (26/7/2022 (Tuesday) to 27/7/2022 (Wednesday))

"The instructor was a great teacher and has gone through everything in great detail. He has been great to have"
Joseph Bulpin, LexisNexis. (26/7/2022 (Tuesday) to 27/7/2022 (Wednesday))

"The instructor was a wonderful and adaptable trainer that took into account the needs of the group and the differing paces of learning. He also put up with a lot of rambunctiousness very gracefully! Thank you for helping coach us in Scrum."
Saara Laspa. (26/7/2022 (Tuesday) to 27/7/2022 (Wednesday))

"Firebrand\''s approach to training just makes sense."
Darren Edmondson. (25/7/2022 (Monday) to 26/7/2022 (Tuesday))

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

Cloudera - CCA Data Analyst