CCA 159 - Data Analyst using Sqoop, Hive and Impala
- 0.0
Brief Introduction
Cloudera Certified Associate - Data Analyst using Technologies like Sqoop, Hive and ImpalaDescription
CCA 159 Data Analyst is one of the well recognized Big Data certification. This scenario based certification exam demands in depth knowledge of Hive, Sqoop as well as basic knowledge of Impala.
This comprehensive course covers all aspects of the certification with real world examples and data sets.
Overview of Big Data eco system
HDFS Commands
Creating Tables in Hive
Loading/Inserting data into Hive tables
Overview of functions in Hive
Writing Basic Queries in Hive
Joining Data Sets and Set Operations in Hive
Windowing or Analytics Functions in Hive
Importing data from MySQL to HDFS
Performing Hive Import
Exporting Data from HDFS/Hive to MySQL
Submitting Sqoop Jobs and Incremental Imports
and more
Exercises will be provided to prepare before attending the certification. Intention of the course is to boost the confidence to attend the certification.
All the demos are given on our state of the art Big Data cluster. If you do not have multi node cluster, you can sign up for our labs and practice on our multi node cluster.
Requirements
- Requirements
- A 64 bit Computer with at least 8 GB RAM is highly desired
- Access to Multinode Cluster or our ITVersity Labs (Paid Subscription Required)
- Setup Cloudera QuickStart VM in high end laptops (16 GB RAM and Quad Core) - Instructions Provided but Not Supported
- Basic Computer Skills
- Ability to write based SQL Queries and use Linux based environment