Learn Manual + Unix/ShellScript + MySQL for Complete Testing

Course Curriculum

Chapter 1: Manual Testing Concepts

Lecture 1: Introduction

Lecture 2: What is Testing and What is the Reason for Testing a Product/Application

Lecture 3: What is Test Plan and Types of Test Plan

Lecture 4: Test Plan Document Components

Lecture 5: What is Test Strategy?

Lecture 6: Test Strategy Document Components

Lecture 7: Agile Methodology in Detail

Lecture 8: Differences Between Agile Vs Traditional Model

Lecture 9: Static and Dynamic Testing

Lecture 10: Web App Checklist, Automation/Manual/Ad-Hoc Testing, Test Case Design Technique

Lecture 11: QA and QC along with Its Differences

Lecture 12: Bug and its Reason, Test Script and Test Enviornment

Lecture 13: Regression and Re-Testing and Smoke and Sanity Testing

Lecture 14: ErrorGuessting, TestCase and TestScenario, TestBed and TestData

Lecture 15: Priority and Severity with Examples

Lecture 16: Different WhiteBox Testing Techniques

Lecture 17: Software Development Life Cycle (SDLC) Process

Lecture 18: Software Testing Life Cycle (STLC) Process and Deliverable at Each Stage

Lecture 19: Defect and Effective Defect Format in Excel

Lecture 20: What is V Model in Testing?

Lecture 21: Verification and Validation with Different Types of Errors

Lecture 22: Testing Approach and Level Of Testing

Lecture 23: Different Test Case Design Technique

Lecture 24: Test Case and Effective Test Case Format with Different Status

Lecture 25: Different Non-Functional Testing Types

Lecture 26: Different Testing Types and Functional Testing in Detail

Chapter 2: MySQL Queries

Lecture 1: How to Create Database and Tables

Lecture 2: MySQL Joins (Left Outer + Right Outer + Inner Join)

Lecture 3: Self Join Implementation

Lecture 4: Full Outer Join Implementation

Lecture 5: How to Work with Update and Delete Query

Lecture 6: How to work with LIMIT Keyword in MySQL

Lecture 7: Delete, Drop and Truncate Query

Lecture 8: Create Table Using Select Statement

Lecture 9: Group By, Having and Order By Clause in MySQL Query

Lecture 10: Min, Max, Average and Count Operator

Lecture 11: MySQL Functions i.e. Min, Max, Avg and Count

Lecture 12: Comparison Operator Implementation

Lecture 13: Equal and Not Equal Operator Implementation

Lecture 14: How to Compare Two MySQL Table to Get the Distinct Records?

Chapter 3: Unix/Linux and Shell Scripting

Lecture 1: How to Create Directory and File?

Lecture 2: How to Open File in Editor and Save the File Contents?

Lecture 3: Copy and Move Directories/Files

Lecture 4: How to Search Files?

Lecture 5: Head and Tail Commands

Lecture 6: More and Less Commands

Lecture 7: Arithmetic Operators

Lecture 8: Relational Operators

Lecture 9: SED Command

Lecture 10: AWK Command

Lecture 11: Tar and Untar Commands

Lecture 12: How to Work with Arrays in Shell Scripting?

Lecture 13: Find String with Count condition