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

Taiwan

Location Oct 2019 Nov 2019 Dec 2019 Jan 2020
Taipei, Taiwan (UCOM) Oct 28 – Oct 31

Classes in bold are guaranteed to run!

Poland

Location Oct 2019 Nov 2019 Dec 2019 Jan 2020
Krakow, Poland (Compendium) Oct 28 – Oct 31

Classes in bold are guaranteed to run!

Online

Instructor-led online training

Location Oct 2019 Nov 2019 Dec 2019 Jan 2020
Virtual Classroom, EMEA (PUE) Nov 4 – Nov 7
Nov 12 – Nov 15
Nov 19 – Nov 22
Dec 16 – Dec 19
Virtual Classroom, AMER (ExitCertified) Nov 12 – Nov 15
Dec 10 – Dec 13
Jan 7 – Jan 10
Virtual Classroom, AMER (Cloudera) Dec 3 – Dec 6
Virtual Classroom, EMEA (Cloudera) Jan 7 – Jan 10

Classes in bold are guaranteed to run!

United States

Location Oct 2019 Nov 2019 Dec 2019 Jan 2020
McLean, VA (Exitcertified) Nov 12 – Nov 15
Jan 7 – Jan 10
Edison, NJ (ExitCertified) Nov 12 – Nov 15
San Francisco, CA (ExitCertified) Dec 10 – Dec 13

Classes in bold are guaranteed to run!

Turkey

Location Oct 2019 Nov 2019 Dec 2019 Jan 2020
Istanbul, Turkey (Dilisim) Nov 19 – Nov 22

Classes in bold are guaranteed to run!

Spain

Location Oct 2019 Nov 2019 Dec 2019 Jan 2020
Madrid, Spain (PUE) Nov 19 – Nov 22
Madrid, Spain (Core Networks) Dec 16 – Dec 20

Classes in bold are guaranteed to run!

Malaysia

Location Oct 2019 Nov 2019 Dec 2019 Jan 2020
Kuala Lumpur, Malaysia (Iverson) Dec 2 – Dec 5

Classes in bold are guaranteed to run!

Singapore

Location Oct 2019 Nov 2019 Dec 2019 Jan 2020
Singapore, Singapore (SoftSource) Dec 3 – Dec 6

Classes in bold are guaranteed to run!

Lithuania

Location Oct 2019 Nov 2019 Dec 2019 Jan 2020
Vilnius, Lithuania (DataMiner) Dec 4 – Dec 7

Classes in bold are guaranteed to run!

Russian Federation

Location Oct 2019 Nov 2019 Dec 2019 Jan 2020
Moscow, Russia (Dataminer) Dec 11 – Dec 14

Classes in bold are guaranteed to run!

United Arab Emirates

Location Oct 2019 Nov 2019 Dec 2019 Jan 2020
Dubai, United Arab Emirates (Fast Lane) Dec 16 – Dec 19

Classes in bold are guaranteed to run!

France

Location Oct 2019 Nov 2019 Dec 2019 Jan 2020
Paris, France (Xebia) Dec 18 – Dec 20

Classes in bold are guaranteed to run!

Saudi Arabia

Location Oct 2019 Nov 2019 Dec 2019 Jan 2020
Riyadh, Saudi Arabia (Fast Lane) Dec 23 – Dec 26

Classes in bold are guaranteed to run!

Canada

Location Oct 2019 Nov 2019 Dec 2019 Jan 2020
Toronto, Canada (ExitCertified) Jan 7 – Jan 10

Classes in bold are guaranteed to run!

Onsite Training

Request a quote for a private training session.

Request Quote

Public Training

Taipei

Virtual Classroom, EMEA (PUE)

McLean, VA

Istanbul, Umraniye

Madrid, Madrid

Kuala Lumpur, Malaysia

Virtual Classroom, AMER (Cloudera)

Moscow

Dubai

Riyadh

Virtual Classroom, EMEA (Cloudera)

Madrid, Spain

Virtual Classroom, AMER (ExitCertified)

Kraków, Poland

San Francisco, CA

Singapore, Singapore

Edison, NJ

Toronto, ON

Paris, France

Vilnius, Lithiuania


Don't see a date that works for you?

Request Class

Check out our FAQ page.