Cloudera Data Analyst Training

Cloudera Data Analyst Training


Cloudera University's four-day Data Analyst Training course will you to apply traditional data analytics and business intelligence skills to big data. This course presents the tools data professionals need to access, manipulate, transform, and analyze complex data sets using SQL and familiar scripting languages.


4 Days


By the end of this course, you will be able to:

  • Explain how the open source ecosystem of big data tools addresses challenges not met by traditional RDBMSs.
  • Explain how Apache Hive and Apache Impala are used to provide SQL access to data
  • Answer questions about data using Hive and Impala syntax and data formats, including functions and subqueries as appropriate.
  • Create, modify, and delete tables, views, and databases; load data; and store results of queries.
  • Create and use partitions and different file formats.
  • Combine two or more datasets using JOIN or UNION, as appropriate.
  • Answer questions about data using analytic and windowing functions.
  • Store and query complex or nested data structures.
  • Process and analyze semi-structured and unstructured data.
  • Use different techniques to optimize Hive and Impala queries.
  • Extend the capabilities of Hive and Impala using parameters, custom file formats and SerDes, and external scripts
  • Determine whether Hive, Impala, an RDBMS, or a mix of these is best for a given task


This course is designed for data analysts, business intelligence specialists, developers, system architects, and database administrators. Knowledge of SQL is assumed, as is basic Linux command-line familiarity. Knowledge of at least one scripting language (such as Bash scripting, Perl, Python, Ruby) would be helpful, but is not essential. Prior knowledge of Apache Hadoop is not required.

Hands-On Exercises

Throughout the course, hands-on exercises help students build their knowledge and apply the concepts being discussed.

Certification Exam

Upon completion of the course, attendees are encouraged to continue their study and register for the CCA Data Analyst certification exam. Certification is a great differentiator. It helps establish you as a leader in the field, providing employers and customers with tangible evidence of your skills and expertise.

Upcoming Classes


Instructor-led online training

Location Jun 2020 Jul 2020 Aug 2020 Sep 2020
Virtual Classroom, EMEA (PUE) Jun 29 – Jul 2
Jul 6 – Jul 9
Virtual Classroom, AMER (Cloudera) Jun 29 – Jul 2
Virtual Classroom, AMER (ExitCertified) Jul 21 – Jul 24
Virtual Classroom, EMEA (Cloudera) Jul 21 – Jul 24

Classes in bold are guaranteed to run!


Location Jun 2020 Jul 2020 Aug 2020 Sep 2020
Italy, Milan (EMEA, PUE) Jul 6 – Jul 9

Classes in bold are guaranteed to run!


Location Jun 2020 Jul 2020 Aug 2020 Sep 2020
Spain, Madrid (PUE) Jul 6 – Jul 10

Classes in bold are guaranteed to run!


Location Jun 2020 Jul 2020 Aug 2020 Sep 2020
Malaysia, Kuala Lumpur (Iverson) Jul 13 – Jul 16

Classes in bold are guaranteed to run!


Location Jun 2020 Jul 2020 Aug 2020 Sep 2020
Turkey, Istanbul (Dilisim) Aug 25 – Aug 28

Classes in bold are guaranteed to run!

Can't travel? Get 20% off virtual & OnDemand classes with code StayWell.

Onsite Training

Request a quote for a private training session.

Request Quote

Public Training

Virtual Classroom, EMEA (PUE)

Virtual Classroom, AMER (Cloudera)

Milan, EMEA

Madrid, EMEA

Kuala Lumpur, APAC

Virtual Classroom, EMEA (Cloudera)

Istanbul, Umraniye, EMEA

Virtual Classroom, AMER (ExitCertified)

Don't see a date that works for you?

Request Class

Check out our FAQ page.