3.85 out of 5
3.85
39 reviews on Udemy

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

Database Testing , Server Side Testing, Bug Reporting and Management
Instructor:
Testing World
321 students enrolled
English [Auto-generated]
Ready to automate mobile application
Ready to face mobile automation testing interviews

This course is specially designed for Software Manual Testers or Professional having experience between 2 to 5 yrs, looking for Opportunity in Software Testing

In Today’s competitive environment companies want software tester with manual testing knowledge but also having extra skills like database testing, server side testing and test management knowledge.

This course targets these extra set of skills which every tester must have to get good opportunities in this competitive environment

Database Testing : Here we cover basic to advance set of SQL queries which every tester must know, it include working with data in table, create , insert, update and delete, different type of joins etc.

Server Side Testing : Here we cover Unix and shell scripting concepts from basic to advance level and their usage for Software Tester, it covers working with log file, memory status, etc

Test Management using ALM : 

We are going to learn following components Project Planning and Tracking HP ALM provides project planning and tracking so application development solutions teams can define, track, measure, and report on project milestones and key performance indicators.

Application Lifecycle Intelligence HP ALM delivers real-time traceability of requirements and defects. QA department can significantly benefit from this traceability to get on-time reports and have visibility into the system under development 

Lab Management Automation HP lab management capability allows testing teams to provision and deploy a test lab themselves in a hybrid delivery environment

Server Side Testing : Unix and Shell Scripting

1
Why Tester need to learn Unix

Basic Commnads

1
Basic Commands
2
Working with Log files
3
Process Command
4
Data Backup Command
5
Working with memory
6
File Comparison

Advance Unix Command

1
Advance Process Work
2
Search Command
3
Miscellaneous Command
4
Network Command
5
User Command
6
Environment Variable
7
What is Sudo

Shell Scripting Basics

1
Shell Basics
2
First Shell Script
3
Variables in Shell Script
4
User Interaction for Inputs

Drill Down Shell Scripts

1
Command Line Argument
2
Condition Handling - If Else
3
Condition Handling - Multiple Conditions
4
Condition Handling - Logical And / OR
5
For Loop
6
Functions

Database Testing : SQL Basic to Advance

1
Select Query Basics
2
Select with Where command
3
Select Data (In/ Between)
4
Select Data with sorting
5
Select Data (Pattern Matching)
6
Select Unique Data
7
SubQuery

Delete Data

1
Delete | Drop | Truncate

Grouping

1
Group Functions
2
Group By - Having

Joins

1
Cross | Cartesian Join
2
Equi | Simple | Inner Join
3
Outer Join (Left & Right)
4
Self Join

Working with tables

1
Create Table
2
Insert Data
3
Update Data

Advance SQL

1
Views
2
Indexes

Constraints

1
Not Null
2
Unique
3
Primary Key
4
Difference Between Unique and Primary Key

Bug Reporting and Test Management using JIRA

1
Jira Dashboard & Update Profile
2
Search Issue
3
Report a new Defect
4
Defect Life Cycle - In case of valid defect
5
Defect Life Cycle - defect rejected by developer

Test Management using ALM - Requirement

1
Setup ALM Account
2
Create Requirement Folder Structure
3
Create Requirement
4
Requirement Tab Feature

Create Test Case - Test Plan

1
Create Folder Structure
2
Create Test Case
3
Create Test Steps
4
Link Test case with requirement

Execute Test Case - Test Lab, Test Run

1
Create Test Set(Test Suite)
2
Execute Test Case
3
Link Defect to Test Case
4
Set Execution Flow
5
Test Run Tab

Defect

1
Report a new defect
2
Supported Attachment
3
Defect - View, Attachment, Sorting
4
Defect - History, Flagged, Pinned, Search
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.9
3.9 out of 5
39 Ratings

Detailed Rating

Stars 5
16
Stars 4
11
Stars 3
5
Stars 2
3
Stars 1
4
826c2c135abe00e69cf3c87d6e25d9b5
30-Day Money-Back Guarantee

Includes

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