Master Advance Hive & Sqoop – Big Data Analytics & ingestion

Become Big data Analyst using Hive and Sqoop.Great course for 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

u 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

Master Advance Hive & Sqoop – Big Data Analytics & ingestion: Video, PDF´s