CCA 159: Expert in Big Data Analytics – Advance Hive & Sqoop

CCA 159: Expert in Big Data Analytics – Advance Hive & Sqoop
CCA 159: Expert in Big Data Analytics – Advance Hive & Sqoop

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 3h 30m | 1.27 GB
eLearning | Skill level: All Levels


Great for CCA159 preparation – Big data certification for non-programmers, business analysts, testers, and SQL developers

This course will prepare you for advanced Hive and get you ready to take the CCA159 (Cloudera Big Data Analyst) certification

You will start by learning what Hadoop and its distributed file system are and you’ll master the most common Hadoop commands you’ll need to work with Hadoop file systems. Then we explore the Apache Hive [Advanced]:

Learn

  • 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
+ Table of Contents

Hadoop Introduction
1 Hadoop Distributed File System & Commands

Hive
2 Hive Introduction
3 Hive Database
4 Hive Managed Tables
5 Hive External Tables
6 Hive Insert
7 Hive MultiInsert
8 Alter Command

Hive Data Types
9 DataTypes Introduction
10 Array DataType
11 Map DataType
12 Struct DataType

Hive Functions
13 Collection Functions
14 Conditional Functions
15 String Functions
16 Date Functions
17 Mathematical Functions

Hive Join
18 Join in Hive
19 Multi Joins in Hive
20 Map Side Joins

Working with Different File Formats & Compressions
21 Working with Parquet
22 Compressing Parquet
23 Working with Fixed File Format

Advance Hive
24 Hive Partitioning
25 Hive Bucketing
26 Views in Hive
27 Lateral ViewExplode
28 Hive Analytics

Hive Windows Function
29 RankDense Rank Windowing Function
30 LeadLag Windowing Function
31 MinMax Windowing Function
32 Windowing Specification

Sqoop Import
33 Sqoop Introduction
34 Managing Target Directory
35 Working with Different File Formats
36 Working with Different Compressions
37 Conditional Imports
38 Split-By and Boundary Queries
39 Field Delimiters
40 Incremental Appends
41 Sqoop Hive Import
42 Practice 1
43 Practice2
44 Practice3

Sqoop Import
45 Export from HDFS to MYSQL
46 Export from Hive to MYSQL