This training shows analysts and database administrators how to apply traditional data analytics and business intelligence skills to Big Data. Learn the tools data professionals need to access, manipulate, and analyze complex data sets using SQL and familiar scripting languages.

You will benefit from the Cloudera Data Analyst training if:

• You are a data analyst, business analyst, developer or administrator,
• You have experience with SQL and basic UNIX or Linux commands.

Prior knowledge of Java and Apache Hadoop is not required.

What you will achieve

This training alternates between instructional sessions and hands-on labs.

After completing the 4-day training, you will know:

• the fundamentals of Apache Hadoop and data ETL (extract, transform, load), ingestion, and processing with Hadoop tools,
• how to apply the fundamentals of familiar scripting languages to the Hadoop cluster with Apache Pig.

You will have hands-on experience in:

• joining multiple data sets and analyzing disparate data with Pig,
• organizing data into tables, performing transformations, and simplifying complex queries with Hive,
• making multi-structures data accessible with Hive.

You will have the skills to:

• perform real-time interactive analyses on massive data sets stored in HDFS or HBase using SQL with Impala,
• pick the best analysis tool for a given task in Hadoop,
• enable real-time interactive analysis of the data stored in Hadoop via a native SQL environment with Cloudera Impala.

! Please note, that you need to bring your own laptop for this training.This laptop should meet the following requirements:

• At least 2GB RAM (4GB or more preferred),
• 15GB of free hard disk space,
• VMware Player 5.x or above (Windows)/ VMware Fusion 4.x or above (Mac),
• Your laptop must support a 64-bit VMware guest image. If the machines are running a 64-bit version of WIndows, or Mac OS X on a Core DUO 2 processor or later, not other test is required. Otherwise, VMware provides a tool to check compatibility, which can be downloaded here.
• Your laptop must have VT-x virtualization support enabled in the BIOS,
• If running Windows XP: 7-Zip or WinZip is needed (due to a bug in Windows XP's built-in Zip utility),
• USB port accessible.

You will have the skills to:

• perform real-time interactive analyses on massive data sets stored in HDFS or HBase using SQL with Impala,
• pick the best analysis tool for a given task in Hadoop,
• enable real-time interactive analysis of the data stored in Hadoop via a native SQL environment with Cloudera Impala.

! Please note, that you need to bring your own laptop for this training.This laptop should meet the following requirements:

• At least 2GB RAM (4GB or more preferred),
• 15GB of free hard disk space,
• VMware Player 5.x or above (Windows)/ VMware Fusion 4.x or above (Mac),
• Your laptop must support a 64-bit VMware guest image. If the machines are running a 64-bit version of WIndows, or Mac OS X on a Core DUO 2 processor or later, not other test is required. Otherwise, VMware provides a tool to check compatibility, which can be downloaded here.
• Your laptop must have VT-x virtualization support enabled in the BIOS,
• If running Windows XP: 7-Zip or WinZip is needed (due to a bug in Windows XP's built-in Zip utility),
• USB port accessible.