3.5 out of 5
3.5
26 reviews on Udemy

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

Hive and MySQL for Testing Profile
Instructor:
Big Data Engineer
287 students enrolled
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.

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. 

Hive Contents Introduction

1
Course Contents Introduction

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

2
Hive Overview

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

Cloudera Environment Setup Process

1
What is Cloudera and how to Setup Cloudera Environment?

Hive - Views and Indexes Implementation

1
Hive - How to Implement Views

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.

2
Hive - How to Implement Indexes

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

Different Type of Hive Partitions

1
How to Implement Static Partitions

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

2
How to Implement Dynamic Partitions

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

Other Hive Details

1
Other Important Hive Details for its module

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

2
Hive Vs SQL

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

3
How to Install Hive on UBuntu Machine

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

4
What are Hive Features

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

Bucketing in Hive

1
How to Implement Bucketing in Hive

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.

Different Types of Hive Tables and Its implementation

1
Different Type of Hive Tables

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

2
Different Type of Joins Available in Hive

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

3
How to Implement Managed Table

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

4
How to Implement External Table

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

5
Different Hive Queries

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. 

How to Implement Hive UDFs

1
Hive UDFs Implementation

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 Use Case Example

1
Hive Use Case Part-1

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

2
Hive Use Case Part-2

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

How to Update and Delete Records In Hive Table

1
Update and Delete Query Implementation

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

2
Add Columns in Table

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.

3
Different functions used in Hive Query i.e. Min Max Avg and Count

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.

4
How to Add Tables from Existing Tables

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

5
Compare Two Hive Tables
6
How to Update the Table Name

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

7
How to Replace Existing Columns Schema with New Schema

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.

Hive Collections

1
What is Collection and its implementation in Hive
2
How to Implement Insert INTO and Insert Overwrite Impplementation

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

Different MySQL Queries

1
Create Table and Insert Value in Table
2
Different MySQL Joins i.e. Left Outer, Right Outer and Inner Join
3
Group By, Having and Order By Implementation
4
Different MySQL Functions
5
MySQL Query with Different Where Clause Query
6
Compare Two MySQL Tables
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.5
3.5 out of 5
26 Ratings

Detailed Rating

Stars 5
12
Stars 4
5
Stars 3
3
Stars 2
1
Stars 1
5
a376c1fbaf16abd4d48774445e667004
30-Day Money-Back Guarantee

Includes

6 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion