Big Data Analytics Using Sqoop and Hive

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Introduction

Lecture 2: Introduction to Big Data

Lecture 3: Data analytics Introduction

Chapter 2: Newly added section- Installation and Configuration of Cloudera

Lecture 1: Steps of Cloudera Installation

Lecture 2: Hands on Lab: Cloudera Installation

Lecture 3: Know more about Cloudera VM tools

Chapter 3: Understand Big Data

Lecture 1: Introduction to Big Data

Lecture 2: Big Data Concepts

Lecture 3: Big Data Ecosystem

Lecture 4: Big Data Distributions

Chapter 4: Understating of MapReduce

Lecture 1: Learn MapReduce

Lecture 2: Map Reduce Core Concept

Lecture 3: Map Reduce Concept with Simple Example

Chapter 5: Ingestion

Lecture 1: Introduction of Sqoop

Lecture 2: Sqoop Import

Lecture 3: Import From RDBMS To HDFS

Lecture 4: Hands Lab on Sqoop Import

Lecture 5: Sqoop Export

Lecture 6: Hands on Lab Sqoop export

Lecture 7: Sqoop Incremental Import

Lecture 8: Sqoop Jobs

Lecture 9: Hands on Lab Sqoop Job

Lecture 10: Hands on Lab: Sqoop Incremental Import

Lecture 11: Hands on Lab Sqoop incremental

Chapter 6: Hive

Lecture 1: Hadoop in Retail Industry

Lecture 2: Hive Introduction

Lecture 3: Hive Architecture

Lecture 4: DataTypes in Hive

Lecture 5: Managed table and External table in Hive

Lecture 6: Demonstrating difference between Internal and external table

Lecture 7: Hands on Lab Hive ExternalVsInternalTable

Lecture 8: Partitions in Hive with demo

Lecture 9: Hands on Lab Hive Partition

Lecture 10: HIve Dynamic Partitioning

Lecture 11: Hands on Lab HIve Dynamic Partitioning

Chapter 7: Project

Lecture 1: Data Masking Project Overview

Lecture 2: Data Masking Project Solution Design

Lecture 3: Data Masking Project Solution Walkthrough

Lecture 4: DataMaskingProject-step1(Create tables inMySql)

Lecture 5: Hands on Lab DataMaskingProject-step1-Document

Lecture 6: Step2:Creating and importing data in hive external tables

Lecture 7: Hands on Lab DataMaskingProject-step2- Document

Lecture 8: Step3:Creating UDFs in Java

Lecture 9: Hands on Lab DataMaskingProject-step3(udf)- Document

Lecture 10: Step4:Exporting data to MySql in masked database

Lecture 11: Hands on Lab DataMaskingProjectStep4 – Document

Lecture 12: Bonus Lecture