Cloudera CCA Data Analyst | 3-day course

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 134.561 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. Accommodation is included from the night before the course starts. This 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 as many times as it takes, unlimited for 1 year. 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 21 96 61 82 and speak to one of our enrolment consultants, who can help you with a training plan.

Reviews

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

"I had a great time. The instructor is very knowledgeable and his training is on point. Two exams in 2 days is a lot. But he makes it doable."
Juan van Gom, Ministry of Defense Netherlands. (19/1/2024 (Friday) to 21/1/2024 (Sunday))

"Detailed and thorough training in a great environment."
Anonymous, SYP. (8/1/2024 (Monday) to 12/1/2024 (Friday))

"I attended the Cyber Crime Foundation course with very little knowledge.. The instructor was fantastic, explained subjects in depth and allowed a good amount of time for questions. I came away with lots of knowledge ready to use what I've learnt in my day-to-day role."
JS. (8/1/2024 (Monday) to 12/1/2024 (Friday))

"I very much enjoyed the training! It is a must for police officers new to Cyber Crime Units and is delivered at a good pace. Very good trainer with exceptional knowledge and enthusiasm."
Steve Lloyd, West Mercia Police. (8/1/2024 (Monday) to 12/1/2024 (Friday))

"I have really enjoyed the course, although I have been a self-professed nerd for many years, there was still some knowledge I took from this course. The tutorials on practical applications is something I will take away and use."
Joseph Ingram-Gettins, West Midlands Police. (8/1/2024 (Monday) to 12/1/2024 (Friday))

Course Dates

Start	Finish	Status	Location
19/2/2024 (Monday)	21/2/2024 (Wednesday)	Finished - Leave feedback	-
24/6/2024 (Monday)	26/6/2024 (Wednesday)	Wait list	Nationwide
5/8/2024 (Monday)	7/8/2024 (Wednesday)	Limited availability	Nationwide
16/9/2024 (Monday)	18/9/2024 (Wednesday)	Open	Nationwide
28/10/2024 (Monday)	30/10/2024 (Wednesday)	Open	Nationwide
9/12/2024 (Monday)	11/12/2024 (Wednesday)	Open	Nationwide

Cloudera - CCA Data Analyst