From 0 to 1: Hive for Processing Big Data

Course

Online

£ 10 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Prerequisites: 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. Taught by a 4 person team including 2 Stanford-educated, ex-Googlers and 2 ex-Flipkart Lead Analysts. This team has decades of practical experience in working with large-scale data. Hive is like a new friend with an old face (SQL). This course is an end-to-end, practical guide to using Hive for Big Data processing. Let's parse that A new friend with an old face: 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. End-to-End: 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, . Practical: Everything is taught using real-life examples, working queries and code . What's Covered: Analytical Processing: Joins, Subqueries, Views, Table Generating Functions, Explode, Lateral View, Windowing and more
Tuning Hive for better functionality: Partitioning, Bucketing, Join Optimizations, Map Side Joins, Indexes, Writing custom User Defined functions in Java. UDF, UDAF, GenericUDF, GenericUDTF, Custom functions in Python, Implementation of MapReduce for Select, Group by and Join
For SQL Newbies: SQL In Great Depth
Using discussion forums
Please use the discussion forums on this course to engage with other students and to help each other out. Unfortunately, much as we would like to, it is not possible for us at Loonycorn to respond to individual questions from students:-(

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • Install
  • Team Training
  • Systems
  • Warehousing
  • SQL
  • Linux
  • Windows
  • Data warehousing
  • Java

Course programme

You, Us & This Course 1 lecture 02:02 You, Us & This Course We start with an introduction. What is the course about? What will you know at the end of the course? You, Us & This Course 1 lecture 02:02 You, Us & This Course We start with an introduction. What is the course about? What will you know at the end of the course? You, Us & This Course We start with an introduction. What is the course about? What will you know at the end of the course? You, Us & This Course We start with an introduction. What is the course about? What will you know at the end of the course? You, Us & This Course We start with an introduction. What is the course about? What will you know at the end of the course? You, Us & This Course We start with an introduction. What is the course about? What will you know at the end of the course? We start with an introduction. What is the course about? What will you know at the end of the course? We start with an introduction. What is the course about? What will you know at the end of the course? Introducing Hive 4 lectures 43:31 Hive: An Open-Source Data Warehouse Data warehousing systems - which have become the rage with the rise of 'Big Data' - are quite different from traditional transaction processing systems. Hive is a prototypical data warehousing system. Hive and Hadoop Hive is built atop Hadoop, and can even be characterized as the SQL skin atop Hadoop MapReduce. Hive vs Traditional Relational DBMS Hive tries really hard - and mostly succeeds - at pretending to be a relational DBMS, but really, under the hood its quite different - understand how, and understand schema-on-read. HiveQL and SQL Now that we understand the differences between Hive and a traditional RDBMS, the differences between HiveQL and SQL will seem a lot less annoying and arbitrary. Introducing Hive 4 lectures 43:31 Hive: An Open-Source Data Warehouse Data warehousing systems - which have become the rage with the rise of 'Big Data' - are quite different from traditional transaction processing systems. Hive is a prototypical data warehousing system. Hive and Hadoop Hive is built atop Hadoop, and can even be characterized as the SQL skin atop Hadoop MapReduce. Hive vs Traditional Relational DBMS Hive tries really hard - and mostly succeeds - at pretending to be a relational DBMS, but really, under the hood its quite different - understand how, and understand schema-on-read. HiveQL and SQL Now that we understand the differences between Hive and a traditional RDBMS, the differences between HiveQL and SQL will seem a lot less annoying and arbitrary. Hive: An Open-Source Data Warehouse Data warehousing systems - which have become the rage with the rise of 'Big Data' - are quite different from traditional transaction processing systems. Hive is a prototypical data warehousing system. Hive: An Open-Source Data Warehouse Data warehousing systems - which have become the rage with the rise of 'Big Data' - are quite different from traditional transaction processing systems. Hive is a prototypical data warehousing system. Hive: An Open-Source Data Warehouse Data warehousing systems - which have become the rage with the rise of 'Big Data' - are quite different from traditional transaction processing systems. Hive is a prototypical data warehousing system. Hive: An Open-Source Data Warehouse Data warehousing systems - which have become the rage with the rise of 'Big Data' - are quite different from traditional transaction processing systems. Hive is a prototypical data warehousing system. Data warehousing systems - which have become the rage with the rise of 'Big Data' - are quite different from traditional transaction processing systems. Hive is a prototypical data warehousing system. Data warehousing systems - which have become the rage with the rise of 'Big Data' - are quite different from traditional transaction processing systems. Hive is a prototypical data warehousing system. Hive and Hadoop Hive is built atop Hadoop, and can even be characterized as the SQL skin atop Hadoop MapReduce. Hive and Hadoop Hive is built atop Hadoop, and can even be characterized as the SQL skin atop Hadoop MapReduce. Hive and Hadoop Hive is built atop Hadoop, and can even be characterized as the SQL skin atop Hadoop MapReduce. Hive and Hadoop Hive is built atop Hadoop, and can even be characterized as the SQL skin atop Hadoop MapReduce. Hive is built atop Hadoop, and can even be characterized as the SQL skin atop Hadoop MapReduce. Hive is built atop Hadoop, and can even be characterized as the SQL skin atop Hadoop MapReduce. Hive vs Traditional Relational DBMS Hive tries really hard - and mostly succeeds - at pretending to be a relational DBMS, but really, under the hood its quite different - understand how, and understand schema-on-read. Hive vs Traditional Relational DBMS Hive tries really hard - and mostly succeeds - at pretending to be a relational DBMS, but really, under the hood its quite different - understand how, and understand schema-on-read. Hive vs Traditional Relational DBMS Hive tries really hard - and mostly succeeds - at pretending to be a relational DBMS, but really, under the hood its quite different - understand how, and understand schema-on-read. Hive vs Traditional Relational DBMS Hive tries really hard - and mostly succeeds - at pretending to be a relational DBMS, but really, under the hood its quite different - understand how, and understand schema-on-read. Hive tries really hard - and mostly succeeds - at pretending to be a relational DBMS, but really, under the hood its quite different - understand how, and understand schema-on-read. Hive tries really hard - and mostly succeeds - at pretending to be a relational DBMS, but really, under the hood its quite different - understand how, and understand schema-on-read. HiveQL and SQL Now that we understand the differences between Hive and a traditional RDBMS, the differences between HiveQL and SQL will seem a lot less annoying and arbitrary. HiveQL and SQL Now that we understand the differences between Hive and a traditional RDBMS, the differences between HiveQL and SQL will seem a lot less annoying and arbitrary. HiveQL and SQL Now that we understand the differences between Hive and a traditional RDBMS, the differences between HiveQL and SQL will seem a lot less annoying and arbitrary. HiveQL and SQL Now that we understand the differences between Hive and a traditional RDBMS, the differences between HiveQL and SQL will seem a lot less annoying and arbitrary. Now that we understand the differences between Hive and a traditional RDBMS, the differences between HiveQL and SQL will seem a lot less annoying and arbitrary. Now that we understand the differences between Hive and a traditional RDBMS, the differences between HiveQL and SQL will seem a lot less annoying and arbitrary. Hadoop and Hive Install 4 lectures 42:49 Hadoop Install Modes Before we install Hive, we need to install Hadoop. Hadoop has 3 different install modes - Standalone, Pseudo-distributed and Fully Distributed. Get an overview of when to use each Hadoop Install Step 1 : Standalone Mode How to set up Hadoop in the standalone mode. Windows users need to install a Virtual Linux instance before this video. Hive install If you are all set with Hadoop, let's go ahead and install Hive. Code-Along: Getting started Let's run a few basic queries on Hive. Head on over to the SQL primer section at the end of the course, if you have no previous experience in Hive. Hadoop and Hive Install 4 lectures 42:49 Hadoop Install Modes Before we install Hive, we need to install Hadoop. Hadoop has 3 different install modes - Standalone, Pseudo-distributed and Fully Distributed. Get an overview of when to use each Hadoop Install Step 1 : Standalone Mode How to set up Hadoop in the standalone mode. Windows users need to install a Virtual Linux instance before this video. Hive install If you are all set with Hadoop, let's go ahead and install Hive. Code-Along: Getting started Let's run a few basic queries on Hive. Head on over to the SQL primer section at the end of the course, if you have no previous experience in Hive. Hadoop Install Modes Before we install Hive, we need to install Hadoop. Hadoop has 3 different install modes - Standalone, Pseudo-distributed and Fully Distributed. Get an overview of when to use each Hadoop Install Modes Before we install Hive, we need to install Hadoop. Hadoop has 3 different install modes - Standalone, Pseudo-distributed and Fully Distributed. Get an overview of when to use each Hadoop Install Modes Before we install Hive, we need to install Hadoop. Hadoop has 3 different install modes - Standalone, Pseudo-distributed and Fully Distributed. Get an overview of when to use each Hadoop Install Modes Before we install Hive, we need to install Hadoop. Hadoop has 3 different install modes - Standalone, Pseudo-distributed and Fully Distributed. Get an overview of when to use each Before we install Hive, we need to install Hadoop. Hadoop has 3 different install modes - Standalone, Pseudo-distributed and Fully Distributed. Get an overview of when to use each Before we install Hive, we need to install Hadoop. Hadoop has 3 different install modes - Standalone, Pseudo-distributed and Fully Distributed. Get an overview of when to use each Hadoop Install Step 1 : Standalone Mode How to set up Hadoop in the standalone mode. Windows users need to install a Virtual Linux instance before this video. Hadoop Install Step 1 : Standalone Mode How to set up Hadoop in the standalone mode. Windows users need to install a Virtual Linux instance before this video. Hadoop Install Step 1 : Standalone Mode How to set up Hadoop in the standalone mode. Windows users need to install a Virtual Linux instance before this video. Hadoop Install Step 1 : Standalone Mode How to set up Hadoop in the standalone mode. Windows users need to install a Virtual Linux instance before this video. How to set up Hadoop in the standalone mode. Windows users need to install a Virtual Linux instance before this video. How to set up Hadoop in the standalone mode. Windows users need to install a Virtual Linux instance before this video. Hive install If you are all set with Hadoop, let's go ahead and install Hive. Hive install If you are all set with Hadoop, let's go ahead and install Hive. Hive install If you are all set with Hadoop, let's go ahead and install Hive. Hive install If you are all set with Hadoop, let's go ahead and install Hive. If you are all set with Hadoop, let's go ahead and install Hive. If you are all set with Hadoop, let's go ahead and install Hive. Code-Along: Getting started Let's run a few basic queries on Hive. Head on over to the SQL primer section at the end of the course, if you have no previous experience in Hive. Code-Along: Getting started Let's run a few basic queries on Hive. Head on over to the SQL primer section at the end of the course, if you have no previous experience in Hive. Code-Along: Getting started Let's run a few basic queries on Hive. Head on over to the SQL primer section at the end of the course, if you have no previous experience in Hive. Code-Along: Getting started Let's run a few basic queries on Hive. Head on over to the SQL primer section at the end of the course, if you have no previous experience in Hive. Let's run a few basic queries on Hive. Head on over to the SQL primer section at the end of the course, if you have no previous experience in Hive. Let's run a few basic queries on Hive. Head on over to the SQL primer section at the end of the course, if you have no previous experience in Hive. Hadoop and HDFS Overview 2 lectures 18:26 What is Hadoop? What exactly is Hadoop? Its origins and its logical components explained. HDFS or the Hadoop Distributed File System HDFS based on GFS (The Google File System) is the storage layer within Hadoop. It stores files in blocks of 128MB. Hadoop and HDFS Overview. 2 lectures 18:26 What is Hadoop? What exactly is Hadoop? Its origins and its logical components explained. HDFS or the Hadoop Distributed File System HDFS based on GFS (The Google File System) is the storage layer within Hadoop. It stores files in blocks of 128MB. What is Hadoop? What exactly is Hadoop? Its origins and its logical components explained d what happens under the hood in HDFS with each of these activities....

Additional information

Hive requires knowledge of SQL. If you don't know SQL, please head to the SQL primer at the end of the course first You'll need to know Java if you are interested in the sections on custom user defined functions No other prerequisites: The course covers everything you need to install Hive and run queries!

From 0 to 1: Hive for Processing Big Data

£ 10 + VAT