Online Courses > IT & Software > Other > Advance Unix and Shell + MySQL DB for Big Data Testing
3.8 out of 5
3.8
11 reviews on Udemy

Advance Unix and Shell + MySQL DB for Big Data Testing

Advance Unix, Linux and Shell Scripting + MySQL Database for Big Data Testing
Instructor:
Big Data Engineer
233 students enrolled
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 point of view as it is very much needed by the tester.

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.

Unix and Linux Tutorial

1
Introduction

After completing this video session, students would be able to get information about complete tutorial which we are going to cover in it.

2
Unix Overview

After completing this video session, students would be able to get detailed information about Unix Overview with its Features.

How to Setup Cloudera Environment

1
What is Cloudera and how to Setup Cloudera Environment?

Unix Practicals

1
How to Create Directory and File Inside Directory

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.

2
Open File in Vi Editor and use cat command

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.

3
View Files and File details
4
How to Find Directory or Files?
5
How to Remove File and Directory?
6
Unix Architecture

After completing this video session, students would be able to get detailed information about Unix Architecture with its components.

7
Unix Commands Background Detail

After completing this video session, students would be able to get detailed information about Unix commands background information that how it works.

8
Directory Hierarchy Verification
9
Create Directory, Copy File and Move File Commands
10
How to Create and Write Into File and How to Append Into File?
11
Process Level Commands i.e. PS and TOP
12
How to Kill a Process?
13
Why we use Head and Tail commands?
14
Why we use More and Less commands?
15
Find String with Count condition (GREP)
16
Hands On - Diff with SORT and Uniq Commands
17
How to Remove 0 (Zero) Byte File in Unix?

Most Important SED Commands

1
Hands On - SED Command - Part 1
2
Hands On - SED Command - Part 2
3
Hands On - SED Command - Part 3
4
Hands On - SED Command - Part 4
5
Hands On - SED Command - Part 5

Most Important AWK Commands

1
Hands On - AWK Command - Part 1
2
Hands On - AWK Command - Part 2
3
Hands On - AWK Command - Part 3
4
Hands On - AWK Command - Part 4
5
Hands On - AWK Command - Part 5

Shell Script Examples

1
Arithmetic Operators in Shell scripts i.e. Add, Subtract and Multiply
2
Relational Operator in Shell Scripts i.e. Equal, Not Equal, Greater Than etc.
3
String Comparison Operator in Shell Scripts i.e. '=', '!=' etc.
4
How to Reverse String in Shell Scripts with Two Different Examples
5
What is Palindrome and how to create Palindrome Shell Script?
6
How to Work with Arrays in Shell Scripting?
7
How to Work with WHILE LOOP in Shell Scripting?
8
How to Work with UNTIL LOOP in Shell Scripting?
9
How to ZIP and UNZIP Directories/Files in Shell Scripting?
10
How to TAR and UNTAR (Archive) Directories/Files in Shell Scripting?
11
Redirect Output to Other File which is generated from Conditition

MySQL Queries

1
How to create database and Table?
2
MySQL Queries using Where Conditions
3
My SQL Joins Left Outer, Right Outer and Inner Joins
4
Update and Delete Query
5
Delete, Drop and Truncate Query
6
Group By, Having and Order By Clause in MySQL
7
Min, Max, Avg Functions with Count Implementation Query
8
Compare Two MySQL Tables
9
Concat and SubString in MySQL Query
10
How to Work with Comparison Operators in MySQL Query
11
Create Table using Select Statement
12
Remove Content from Screen i.e. clean screen
13
Like and Wild Cards
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.8
3.8 out of 5
11 Ratings

Detailed Rating

Stars 5
5
Stars 4
1
Stars 3
3
Stars 2
1
Stars 1
1
2e7146b2f5ad7abeb1e6ce67de8d867e
Get on Udemy
30-Day Money-Back Guarantee

Includes

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