Must Learn Skills for Testers[SQL+Unix+ShellScript+Jira+ALM]

Course Curriculum

Chapter 1: Server Side Testing : Unix and Shell Scripting

Lecture 1: Why Tester need to learn Unix

Chapter 2: Basic Commnads

Lecture 1: Basic Commands

Lecture 2: Working with Log files

Lecture 3: Process Command

Lecture 4: Data Backup Command

Lecture 5: Working with memory

Lecture 6: File Comparison

Chapter 3: Advance Unix Command

Lecture 1: Advance Process Work

Lecture 2: Search Command

Lecture 3: Miscellaneous Command

Lecture 4: Network Command

Lecture 5: User Command

Lecture 6: Environment Variable

Lecture 7: What is Sudo

Chapter 4: Shell Scripting Basics

Lecture 1: Shell Basics

Lecture 2: First Shell Script

Lecture 3: Variables in Shell Script

Lecture 4: User Interaction for Inputs

Chapter 5: Drill Down Shell Scripts

Lecture 1: Command Line Argument

Lecture 2: Condition Handling – If Else

Lecture 3: Condition Handling – Multiple Conditions

Lecture 4: Condition Handling – Logical And / OR

Lecture 5: For Loop

Lecture 6: Functions

Chapter 6: Database Testing : SQL Basic to Advance

Lecture 1: Select Query Basics

Lecture 2: Select with Where command

Lecture 3: Select Data (In/ Between)

Lecture 4: Select Data with sorting

Lecture 5: Select Data (Pattern Matching)

Lecture 6: Select Unique Data

Lecture 7: SubQuery

Chapter 7: Delete Data

Lecture 1: Delete | Drop | Truncate

Chapter 8: Grouping

Lecture 1: Group Functions

Lecture 2: Group By – Having

Chapter 9: Joins

Lecture 1: Cross | Cartesian Join

Lecture 2: Equi | Simple | Inner Join

Lecture 3: Outer Join (Left & Right)

Lecture 4: Self Join

Chapter 10: Working with tables

Lecture 1: Create Table

Lecture 2: Insert Data

Lecture 3: Update Data

Chapter 11: Advance SQL

Lecture 1: Views

Lecture 2: Indexes

Chapter 12: Constraints

Lecture 1: Not Null

Lecture 2: Unique

Lecture 3: Primary Key

Lecture 4: Difference Between Unique and Primary Key

Chapter 13: Bug Reporting and Test Management using JIRA

Lecture 1: Jira Dashboard & Update Profile

Lecture 2: Search Issue

Lecture 3: Report a new Defect

Lecture 4: Defect Life Cycle – In case of valid defect

Lecture 5: Defect Life Cycle – defect rejected by developer

Chapter 14: Test Management using ALM – Requirement

Lecture 1: Setup ALM Account

Lecture 2: Create Requirement Folder Structure

Lecture 3: Create Requirement

Lecture 4: Requirement Tab Feature

Chapter 15: Create Test Case – Test Plan

Lecture 1: Create Folder Structure

Lecture 2: Create Test Case

Lecture 3: Create Test Steps

Lecture 4: Link Test case with requirement

Chapter 16: Execute Test Case – Test Lab, Test Run

Lecture 1: Create Test Set(Test Suite)

Lecture 2: Execute Test Case

Lecture 3: Link Defect to Test Case

Lecture 4: Set Execution Flow

Lecture 5: Test Run Tab

Chapter 17: Defect

Lecture 1: Report a new defect

Lecture 2: Supported Attachment

Lecture 3: Defect – View, Attachment, Sorting

Lecture 4: Defect – History, Flagged, Pinned, Search