Sqoop, Hive and Impala for Data Analysts (Formerly CCA 159)

Hands on Sqoop, Hive and Impala for Data Analysts

[Free Udemy Course] Sqoop, Hive and Impala for Data Analysts (Formerly CCA 159)

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

Join Telegram Channel for updates




Please note that many coupons are limited-time coupons. Please let us know if you find any expired coupon.