Cloudera Data Analyst Training

Cloudera Data Analyst Training

Summary

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.

Duration

4 Days

Objectives

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

Prerequisites

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

Online

Instructor-led online training

Location Sep 2021 Oct 2021 Nov 2021 Dec 2021
Virtual Classroom, EMEA (Cloudera) Sep 21 – Sep 24
Virtual Classroom, APAC (Agilitics) Oct 5 – Oct 8
Nov 9 – Nov 12
Dec 7 – Dec 10
Virtual Classroom, AMER (Semantix) Oct 12 – Oct 15
Virtual Classroom, AMER (ExitCertified) Oct 19 – Oct 22
Virtual Classroom, Australia (Canberra) Oct 19 – Oct 22
Virtual Classroom, AMER (Central) Oct 26 – Oct 29
Nov 30 – Dec 3
Virtual Classroom, EMEA (PUE) Nov 8 – Nov 11
Nov 22 – Nov 25
Virtual Classroom, APAC (Iverson) Dec 6 – Dec 9
Virtual Classroom, APAC (China) Dec 7 – Dec 10
Virtual Classroom, APAC (Softsource) Dec 14 – Dec 17

Classes in bold are guaranteed to run!

Spain

Location Sep 2021 Oct 2021 Nov 2021 Dec 2021
Spain, Madrid (PUE) Oct 18 – Oct 21

Classes in bold are guaranteed to run!

Korea, Republic of

Location Sep 2021 Oct 2021 Nov 2021 Dec 2021
Korea, Seoul (GK Korea) Oct 18 – Oct 21
Dec 13 – Dec 16

Classes in bold are guaranteed to run!

United States

Location Sep 2021 Oct 2021 Nov 2021 Dec 2021
United States, Philadelphia PA (ExitCertified) Oct 19 – Oct 22
United States, Edison NJ (ExitCertified) Oct 19 – Oct 22
United States, McLean VA (Exitcertified) Oct 19 – Oct 22

Classes in bold are guaranteed to run!

Malaysia

Location Sep 2021 Oct 2021 Nov 2021 Dec 2021
Malaysia, Kuala Lumpur (Iverson) Oct 25 – Oct 28

Classes in bold are guaranteed to run!

France

Location Sep 2021 Oct 2021 Nov 2021 Dec 2021
France, Paris (OCTO) Nov 2 – Nov 5

Classes in bold are guaranteed to run!

Republic of China (Taiwan)

Location Sep 2021 Oct 2021 Nov 2021 Dec 2021
Republic of China (Taiwan), Taipei (UCOM) Nov 9 – Nov 12

Classes in bold are guaranteed to run!

Onsite Training

Request a quote for a private training session.

Request Quote

Public Training

Virtual Classroom, EMEA (Cloudera)

Virtual Classroom, APAC (Agilitics)

Virtual Classroom, AMER (Semantix)

Madrid, EMEA

Seoul, APAC

McLean, VA, AMER

Virtual Classroom, Australia (Canberra)

Kuala Lumpur, APAC

Virtual Classroom, AMER (Central)

Paris, EMEA

Virtual Classroom, EMEA (PUE)

Taipei, APAC

Virtual Classroom, APAC (Iverson)

Virtual Classroom, APAC (China)

Virtual Classroom, APAC (Softsource)

Virtual Classroom, AMER (ExitCertified)

Edison, NJ, AMER

King of Prussia, PA, AMER


Don't see a date that works for you?

Request Class

Check out our FAQ page.