Hive for Processing Big Data

End-to-End Hive : HQL, Partitioning, Bucketing, UDFs, Windowing, Optimization, Map Joins, Indexes

Course Description
Hive helps you leverage the power of Distributed computing and Hadoop for Analytical processing. It's interface is like an old friend - the very SQL like HiveQL. This course will fill in all the gaps between SQL and what you need to use Hive.
The course is an end-to-end guide for using Hive: whether you are analyst who wants to process data or an Engineer who needs to build custom functionality or optimize performance - everything you'll need is right here. New to SQL? No need to look elsewhere. The course has a primer on all the basic SQL constructs.
Everything is taught using real-life examples, working queries and code .

Learning Outcomes

Write complex analytical queries on data in Hive and uncover insights
Leverage ideas of partitioning, bucketing to optimize queries in Hive
Customize hive with user defined functions in Java and Python
Understand what goes on under the hood of Hive with HDFS and MapReduce


Hive requires knowledge of SQL. The course includes and SQL primer at the end. Please do that first if you don't know SQL. You'll need to know Java if you want to follow the sections on custom functions.

Who is this course intended for?
Analysts who want to write complex analytical queries on large scale data

Engineers who want to know more about managing Hive as their data warehousing solution

Course Curriculum

Available in days
days after you enroll
  Hadoop and HDFS Overview
Available in days
days after you enroll
  Custom Functions in Python
Available in days
days after you enroll
  SQL Primer - Select Statements
Available in days
days after you enroll

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

This course is closed for enrollment.