CCA 159- Data Analyst using Sqoop and Advance Hive
4.1 (99 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,269 students enrolled

CCA 159- Data Analyst using Sqoop and Advance Hive

Become Big data Analyst using Hive and Sqoop.Great course for business Analyst,Testers and Sql Developers.CCA159
4.1 (99 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,268 students enrolled
Created by Navdeep Kaur
Last updated 6/2020
English
Current price: $12.99 Original price: $19.99 Discount: 35% off
21 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Course content
Expand all 50 lectures 04:32:38
+ Hadoop Introduction
4 lectures 29:45
CCA159 Exam Update 2020
00:34
Cluster Setup on Google Cloud
19:13
Environment Update
00:42
+ Hive
7 lectures 35:53
Hive Managed Tables
06:23
Hive External Tables
02:26
Hive Insert
05:30
Hive MultiInsert
03:12
Alter Command
06:12
+ Hive Data Types
4 lectures 14:26
DataTypes Introduction
03:09
Array DataType
03:06
Map DataType
04:34
Struct DataType
03:37
+ Hive Functions
5 lectures 22:37
Collection Functions
03:46
Conditional Functions
04:44
String Functions
06:21
Date Functions
05:39
Mathematical Functions
02:07
+ Hive Join
3 lectures 15:17
Join in Hive
07:42
Multi Joins in Hive
05:02
Map Side Joins
02:33
+ Working with Different File Formats & Compressions
3 lectures 11:00
Working with Parquet
03:29
Compressing Parquet
04:27
Working with Fixed File Format
03:04
+ Advance Hive
5 lectures 22:17
Hive Partitioning
07:16
Hive Bucketing
03:44
Views in Hive
03:33
Lateral View/Explode
03:23
Hive Analytics
04:21
+ Hive Windows Function
4 lectures 26:26
Rank/Dense Rank Windowing Function
08:26
Lead/Lag Windowing Function
05:15
Min/Max Windowing Function
03:03
Windowing Specification
09:42
+ Sqoop Import
13 lectures 01:28:48
Sqoop Introduction
15:48
Managing Target Directory
07:26
Working with Parquet
08:24
Working with Different Compressions
10:08
Conditional Imports
04:26
Split-By and Boundary Queries
08:27
Field Delimiters
03:18
Incremental Appends
11:38
Sqoop Hive Import
03:31
Practice 1
04:57
Practice2
04:17
Practice3
03:31
Bonus Lecture: Sqoop with Airflow
02:57
+ Sqoop Export
2 lectures 06:09
Export from HDFS to MYSQL
03:39
Export from Hive to MYSQL
02:30