Easy Road Map to Big Data Testing (Hive and MySQL Databases)
4.0 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
227 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Easy Road Map to Big Data Testing (Hive and MySQL Databases) to your Wishlist.

Add to Wishlist

Easy Road Map to Big Data Testing (Hive and MySQL Databases)

Hive and MySQL for Testing Profile
4.0 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
227 students enrolled
Last updated 12/2016
English
Current price: $10 Original price: $25 Discount: 60% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • At the end of this course, students would be able to work on different Hive queries and get the detailed information about Hive as a Big Data database.
View Curriculum
Requirements
  • To learn Hive database, students should have Hive installed and running on their Ubuntu machine. However, I have also included a session which covers the Hive installation as well.
Description

This course is for Big Data Testing with Hive Database. All the users who are working in QA profile and wanted to move into big data testing domain should take this course and go through the complete tutorials.  

I have included the material which is needed for big data testing profile and it has all the necessary contents which is required for learning Hive database.

It will give the detailed information for Hive as database and what all areas tester should be fulfilled with their knowledge to make their career into Big Data Testing.

This course is well structured with all elements of Hive in detailed manner separated by different topics. Students should take this course for Hive learning. 

Who is the target audience?
  • Any QA profile candidate who wanted to work into Big Data technologies and willing to learn Big Data Database.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
34 Lectures
05:59:09
+
Hive Contents Introduction
2 Lectures 06:48

In this video, students would get the detailed information about all the contents which would be included in this Hive tutorial.

Preview 01:50

In this video, students would get the detailed information about Hive Overview and what kind of functionalities it includes.

Hive Overview
04:58
+
Hive - Views and Indexes Implementation
2 Lectures 27:47

In this session, students would get the detailed knowledge/information about the Views in Hive. They will get the information how it is implemented in real time projects.

Preview 11:01

In this session, students would get the detailed knowledge of Hive Indexes implementation with step by step information.

Hive - How to Implement Indexes
16:46
+
Different Type of Hive Partitions
2 Lectures 39:33

In this session, students would get the detailed knowledge of different types of Hive Partitions and Static Partition implementation with step by step information.

Preview 17:09

In this session, students would get the detailed knowledge of dynamic Partition implementation with step by step information practically.

How to Implement Dynamic Partitions
22:24
+
Other Hive Details
4 Lectures 23:05

In this session, students would get the detailed knowledge of all the different modules/components of Hive. 

Other Important Hive Details for its module
04:14

In this session, students would get the detailed knowledge of Hive and SQL differences. 

Hive Vs SQL
05:34

In this session, students would get the step by step information about the Hive Installation on Ubuntu machine.

How to Install Hive on UBuntu Machine
06:29

In this session, students would get the knowledge of the Hive characteristics and features in detail. 

What are Hive Features
06:48
+
Bucketing in Hive
1 Lecture 12:07

In this session, students would get the detailed knowledge on how students implement the Bucketing in Hive and how to query the using this and verify the different buckets created on Hive table in real projects.

How to Implement Bucketing in Hive
12:07
+
Different Types of Hive Tables and Its implementation
5 Lectures 55:48

In this session, students get the knowledge of different type of Hive and there differences in detail.

Different Type of Hive Tables
04:14

In this session, students would get the knowledge of different types of Joins available in Hive and how it is created and implemented practically.

Different Type of Joins Available in Hive
18:13

In this session, students would get the practical implementation knowledge of Managed Hive table i.e. default table in Hive.

Preview 13:45

In this session, students would get the practical implementation knowledge of External Hive table.

How to Implement External Table
09:03

In this session, students would get the knowledge of different Hive queries i.e. create table, insert values in tables, drop table etc. in detail. 

Different Hive Queries
10:33
+
How to Implement Hive UDFs
1 Lecture 15:34

In this session, students would get the detailed step by step information about UDF implementation in Hive and how it could be query through Hive CLI.

Hive UDFs Implementation
15:34
+
Hive Use Case Example
2 Lectures 24:11

In this session, students get the practical knowledge of the Movielens Use Case for Hive that has several queries implementation in detailed manner.

Hive Use Case Part-1
16:22

In this session, students get the practical knowledge of the Movielens Use Case for Hive that has several queries implementation in detailed manner.

Hive Use Case Part-2
07:49
+
How to Update and Delete Records In Hive Table
7 Lectures 01:03:33

In this session, students gets the detailed knowledge of the update and delete query implementation as they directly not available to use.

Preview 16:01

In this session, students get the knowledge of the add column feature that is used when they wanted to add/increase the columns in there table.

Add Columns in Table
03:32

In this session, students get the knowledge of the inbuilt function used in query i.e. Min, Max, Avg and Count function used in hive table column.

Different functions used in Hive Query i.e. Min Max Avg and Count
06:47

In this session, students would get the information about the adding new tables from existing tables available in database practically.

Preview 09:58

Compare Two Hive Tables
17:44

In this session, students get the knowledge of the inbuilt function used in query for updating the table name i.e. renaming the table.

How to Update the Table Name
05:31

In this session, students get the knowledge of the inbuilt function used in query to replace existing column schema with new column schema for which Replace inbuilt function used in hive table.

How to Replace Existing Columns Schema with New Schema
04:00
+
Hive Collections
2 Lectures 19:03
What is Collection and its implementation in Hive
10:57

In this session, students would get the detailed implementation for the insert into and insert overwrite query implementation and its difference.

How to Implement Insert INTO and Insert Overwrite Impplementation
08:06
1 More Section
About the Instructor
Big Data Module Lead QA Engineer Big Data QA
3.5 Average rating
199 Reviews
4,932 Students
12 Courses
Big Data QA Module Lead

Having more than 9 yrs industry experience.

Worked on different big data tools like Hadoop, Cassandra, HBase, Hive, Pig, Sqoop, Flume etc. 

ISTQB Certified professional. I have worked with CMMi level 5 companies and provided services to clients in fortune 15 companies like AT&T.

Trained more than 100 professionals in classroom training and more than 50 professionals online.

Training has been my passion and I am on my way to create courses which should help any beginner to step by step learn and be able to become a Big data QA expert.