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
Remove files and directories in unix using rm, inspect results with ls -la, and understand basic permissions to manage deletions effectively.
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
Explore directory hierarchy verification in Unix by navigating the downloads folder, mastering cd, find, and path commands to reveal files and hidden files within the system.
Create Directory, Copy File and Move File Commands10:56
How to Create and Write Into File and How to Append Into File?4:58
Explore creating files, writing text, and appending data in the Unix shell using redirection operators like > and >>, and viewing or searching content with commands such as cat.
Process Level Commands i.e. PS and TOP3:47
How to Kill a Process?3:04
Learn how to identify running processes, find their pids, and safely kill unwanted tasks to free system resources.
Why we use Head and Tail commands?4:27
Why we use More and Less commands?3:50
Explore why the less command offers greater flexibility than more in the Unix shell, enabling easy up-and-down navigation and seamless viewing of file content in the terminal.
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

Hands On - SED Command - Part 19:19
Hands On - SED Command - Part 29:05
Learn to use the sed command for in-place text editing in big data workflows, including substitutions, global replacements, and practical examples like changing characters and names.
Hands On - SED Command - Part 33:56
Hands On - SED Command - Part 46:11
Learn hands-on sed techniques to edit specific lines and ranges by using line numbers, substitution commands like s/old/new, and applying targeted replacements.
Hands On - SED Command - Part 55:14

Hands On - AWK Command - Part 112:49
Hands On - AWK Command - Part 210:56
Engage in hands-on awk command practice, processing columnar data in Unix shells by referencing fields with the dollar sign, selecting delimiters, and printing specific columns.
Hands On - AWK Command - Part 36:39
Hands On - AWK Command - Part 43:32
Master hands-on awk techniques to count and print the number of columns in each line, display names with their column counts, and show line numbers.
Hands On - AWK Command - Part 58:13
Explore awk basics to filter data with conditions and print specific fields, using $n notation, such as selecting rows where age is greater than 30 and printing relevant columns.

Arithmetic Operators in Shell scripts i.e. Add, Subtract and Multiply19:48
Master arithmetic in shell scripts by performing add, subtract, and multiply operations using variables and expressions with the dollar notation.
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
Define and manipulate shell arrays by setting elements, reading 0-based indices, and retrieving specific items by index, while using a star to print all values.
How to Work with WHILE LOOP in Shell Scripting?9:31
How to Work with UNTIL LOOP in Shell Scripting?4:44
Explore how to use the until loop in shell scripting, defining variables, applying less-than conditions, and printing results to control iterative flows.
How to ZIP and UNZIP Directories/Files in Shell Scripting?5:07
Learn to zip and unzip directories and files using Unix commands in shell scripting, creating archives, handling multiple files, and extracting contents efficiently.
How to TAR and UNTAR (Archive) Directories/Files in Shell Scripting?11:14
Learn to create and extract archives in shell scripting using tar, compress files, and manage directories and data safely for big data testing.
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
Learn to write MySQL queries using where conditions to filter records, apply greater than comparisons, and retrieve specific results efficiently.
My SQL Joins Left Outer, Right Outer and Inner Joins24:30
Update and Delete Query9:10
Master update and delete queries in mysql, using set and where clauses to modify salaries by employee id and remove records.
Delete, Drop and Truncate Query5:53
Explore delete, drop, and truncate commands in MySQL to manage table data and structure, including when to remove rows, drop tables, or truncate datasets in big data testing.
Group By, Having and Order By Clause in MySQL11:21
Min, Max, Avg Functions with Count Implementation Query7:12
Compare Two MySQL Tables12:50
Explore how to compare two MySQL tables to find records present in one but not the other, using left joins and set operations like union and union all.
Concat and SubString in MySQL Query12:07
How to Work with Comparison Operators in MySQL Query4:29
Create Table using Select Statement8:37
Learn how to create a new table from existing tables using a select statement, define the schema, select specific columns, and apply where conditions.
Remove Content from Screen i.e. clean screen1:32
Like and Wild Cards8:27
Learn to use the like keyword and wildcards in sql to search patterns, matching names that start with or end with strings in a table.
My SQL command in Different Query7:42
Master MySQL queries with conditional fetches, creating and populating a table, and querying with where clauses to filter by id and salary.

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: