CCA 159: Advance Hive Zero to Expert in Big Data Analytics

Great for CCA159 Preparation - Big Data Certification for Non Programmers,Business Analyst,Testers and Sql Developers.

What you'll learn

Students will learn Advance Hive and Sqoop for Big Data Analytics and Ingestion.

Requirements

Basic Knowledge of SQL

Description

This course will prepare you for Advance Hive and prepare you to undergo CCA159 (Cloudera Big Data Analyst Certification),

You will start by learning what is Hadoop & Hadoop distributed file system and most common hadoop commands required to work with Hadoop File system.

Finally, we will start with Apache Hive [Advance]

Hive Intro

External & Managed Tables

Insert & Multi Insert

Data Types & Complex Data Types

Collection Function

Conditional Function

Hive String Functions

Hive Date Functions

Mathematical Function

Hive Analysis

Alter Command

Joins, Multi Joins & Map Joins

Working with Different Files - Parquet,Avro

Compressions

Partitioning

Bucketing

Views

Lateral Views/Explode

Windowing Functions - Rank/Dense Rank/lead/lag/min/max

Window Specification

Who this course is for:

Who are preparing for CCA159 Cloudera Big Data Analytics Certification or who wants to learn Advance Hive & Sqoop