Advance Unix and Shell + MySQL DB for Big Data Testing

Name: Advance Unix and Shell + MySQL DB for Big Data Testing
Rating: 3.7 (18 reviews)

Advance Unix, Linux and Shell Scripting + MySQL Database for Big Data Testing

Created byBig Data Engineer

Last updated 1/2026

English

What you'll learn

At the end of this course, students would understand the different Unix commands and they can start working in testing profile.
After completing this course, students would have good practical knowledge of Unix, Linux and Shell Scripting which has good expectation from big data testing
By the conclusion of this tutorial, learners will have gained a solid foundation and practical understanding of Big Data Testing
This knowledge will allow participants to pursue Big Data Testing roles at various professional levels

Course content

7 sections • 55 lectures • 7h 49m total length

Introduction3:30
After completing this video session, students would be able to get information about complete tutorial which we are going to cover in it.
Unix Overview5:41
After completing this video session, students would be able to get detailed information about Unix Overview with its Features.

How to Create Directory and File Inside Directory6:25
After completing this video session, students would be able to get detailed information about Unix command i.e. how to create directory and how to create file inside that directory.
Open File in Vi Editor and use cat command10:50
After completing this video session, students would be able to get detailed information how user can open file in editor and how user save the content in file and came out and how user can came out without saving the file.
View Files and File details8:46
How to Find Directory or Files?8:31
How to Remove File and Directory?5:16
Unix Architecture6:28
After completing this video session, students would be able to get detailed information about Unix Architecture with its components.
Unix Commands Background Detail3:43
After completing this video session, students would be able to get detailed information about Unix commands background information that how it works.
Directory Hierarchy Verification10:39
Create Directory, Copy File and Move File Commands10:56
How to Create and Write Into File and How to Append Into File?4:58
Process Level Commands i.e. PS and TOP3:47
How to Kill a Process?3:04
Why we use Head and Tail commands?4:27
Why we use More and Less commands?3:50
Find String with Count condition (GREP)8:27
Hands On - Diff with SORT and Uniq Commands9:33
How to Remove 0 (Zero) Byte File in Unix?8:14

Arithmetic Operators in Shell scripts i.e. Add, Subtract and Multiply19:48
Relational Operator in Shell Scripts i.e. Equal, Not Equal, Greater Than etc.16:47
String Comparison Operator in Shell Scripts i.e. '=', '!=' etc.9:05
How to Reverse String in Shell Scripts with Two Different Examples11:11
What is Palindrome and how to create Palindrome Shell Script?12:27
How to Work with Arrays in Shell Scripting?10:36
How to Work with WHILE LOOP in Shell Scripting?9:31
How to Work with UNTIL LOOP in Shell Scripting?4:44
How to ZIP and UNZIP Directories/Files in Shell Scripting?5:07
How to TAR and UNTAR (Archive) Directories/Files in Shell Scripting?11:14
Redirect Output to Other File which is generated from Conditition6:44

How to create database and Table?8:05
MySQL Queries using Where Conditions7:42
My SQL Joins Left Outer, Right Outer and Inner Joins24:30
Update and Delete Query9:10
Delete, Drop and Truncate Query5:53
Group By, Having and Order By Clause in MySQL11:21
Min, Max, Avg Functions with Count Implementation Query7:12
Compare Two MySQL Tables12:50
Concat and SubString in MySQL Query12:07
How to Work with Comparison Operators in MySQL Query4:29
Create Table using Select Statement8:37
Remove Content from Screen i.e. clean screen1:32
Like and Wild Cards8:27
My SQL command in Different Query7:42

Requirements

As such there is no prerequisite required for this course and it is useful for any level of tester. Any Tester profile candidate can start this tutorial.

Description

This course is for Testing profile candidate who wanted to build there career into Big Data Testing. So I have designed this course so they can start working with basic Unix and Shell Scripting commands into big data testing. 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 Unix, Linux and Shell Scripting.

It will give the detailed information for different Unix commands which is needed by the tester to move into bigger umbrella i.e. Big Data Testing.

This course is well structured with all elements of different Unix commands in practical manner separated by different topics. Students should take this course who wanted to learn Unix from scratch.

Who this course is for:

Any Level of Testing Profile Candidate is the target audience for this course.

Advance Unix and Shell + MySQL DB for Big Data Testing

What you'll learn

Explore related topics

Course content

Unix and Linux Tutorial2 lectures • 9min

How to Setup Cloudera Environment1 lecture • 20min

Unix Practicals17 lectures • 1hr 58min

Most Important SED Commands5 lectures • 34min

Most Important AWK Commands5 lectures • 42min

Shell Script Examples11 lectures • 1hr 57min

MySQL Queries14 lectures • 2hr 10min

Requirements

Description

Who this course is for: