Hands on Sqoop, Hive and Impala for Data Analysts
Instructed by Durga Viswanatha Raju Gadiraju 20.5 hours on-demand video & 1 downloadable resource
What you’ll learn
-
Overview of Big Data ecosystem such as Hadoop HDFS, YARN, Map Reduce, Sqoop, Hive, etc
-
Overview of HDFS Commands such as put or copyFromLocal, get or copyToLocal, cat, etc along with concepts such as block size, replication factor, etc
-
Managing Tables in Hive Metastore using DDL Commands
-
Load or Insert data into Hive Metastore Tables using commands such as LOAD and INSERT
-
Overview of Functions in Hive to manipulate strings, dates, etc
-
Writing Basic Hive QL Queries using WHERE, JOIN, GROUP BY, etc
-
Analytical or Windowing Functions in Hive
-
Overview of Impala and understanding similarities and differences between Hive and Impala
-
Getting Started with Sqoop by reviewing official documentation and also exploring commands such as Sqoop eval
-
Importing Data from RDBMS tables into HDFS using Sqoop Import
-
Importing Data from RDBMS tables into Hive tables using Sqoop Import
-
Exporting Data from Hive or HDFS to RDBMS tables using Sqoop Export
-
Incremental Imports using Sqoop Import into HDFS or Hive Tables
Who this course is for:
- Any Big Data Professional or Aspirant who want to learn about Databases and Query Interfaces in Big Data
- Any Business Intelligence Professional who want to understand Data Analysis in Big Data eco system
- Any IT Professional who want to prepared for CCA 159 Data Analyst exam
Recommended Course
Deal Score+1
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.