Manual Testing & SQL

Manual Testing Syllabus

Software development life cycle

Waterfall Model
Spiral Model
Prototype Model
V & V Model
Hybrid Model

Software Testing

White Box Testing
Path Testing
Loop Testing
Condition Testing
White Box Testing from Memory Point of View
White Box Testing from Performance Point of View

Black Box Testing

Black Box Testing
Functionality Testing / Component Testing
Integration Testing
System Testing
Acceptance Testing
Smoke Testing / Sanity Testing / Dry Run
Ad-hoc Testing
Exploratory Testing
Compatibility Testing
Performance Testing
Reliability Testing
Usability Testing
Accessibility Testing
Globalization Testing
Regression Testing

Test Case

Introduction to Test Case
Test Case Design Techniques
Test Case Format
Functional Test Case
Integration Test Case
System Test Case
Procedure to Write and Execute Test Case
Test Case Review Process

Software Test Life Cycle

Traceability Matrix
Test Execution Reports

Test Plan

Sections of Test Plan
Test Metrics

Defect Tracking

Introduction to Defects
Defect Life Cycle
Status of Defects
Severity of a Defect
Priority of a Defect
Defect Report / Incident Report

Introduction

What Is Database?
What is Database Management System (DBMS)?
What is Relational Model?
Introduction to RDBMS

Data types and Constraints

What are Datatypes?
What are Constraints?

Statements in SQL

Data Definition Language (DDL)
Data Manipulation Language (DML)
Transaction Control Language (TCL)
Data Control Language (DCL)
Data Query Language (DQL)

Software Installation

Installing and Setup of Software
Working on Oracle

Data Query Language (DQL)

Select
From
Where
Group By
Having
Order By

Operators

Types and Examples

Functions in SQL

Max()
Min()
Sum()
Avg()
Count()

Sub Query

Introduction to Sub Query
Working of Sub Query
Query Writing and Execution
Types of Sub Query
Nested Sub Query

Joins

What Is Join?
Types of Joins

Co-Related Sub Query

Working and Examples

Data Definition Language (DDL)

Create
Rename
Alter
Truncate
Drop

Data Manipulation Language (DML)

Insert
Update
Delete

Transaction Control Language (TCL)

Commit
Save Point
Rollback

SDET with JAVA and Selenium

Introduction to programming

Introduction to Java
JDK Installation
Keywords
Identifiers
Data Types
Variables and Arrays
Widening and Narrowing
Operators
Control Statements
Conditional Statements
- if
- switch
Looping Statements
- for
- while
- do while
- for each
Control Transfer Statements
- break
- continue

Object Oriented Programming

User Defined Classes
Object Creation
Reference Variable
Global Variables
Static and Non-Static
Primitive and Non-Primitive
Final and Non-Final
Constructors
Static Block
Non-Static Block
Static and Non-Static Methods
Method Overloading
Inheritance
Package
Access Modifiers
Method Overriding
Polymorphism
Abstraction
Abstract Classes
Interfaces
Typecasting
Encapsulation

Java Built-in packages and API

String
String Buffer
Exception Handling
Wrapper Classes
Java Collections

Automation Testing

What is Automation Testing?
When to Switch to Automation Testing?
Why Automation Testing?
Advantages and Disadvantages of Automation Testing
Automation Testing Tools

Selenium

What is Selenium?
Advantages of Selenium
Java–Selenium Architecture
Basic Selenium Program
Runtime Polymorphism Program in Selenium
WebDriver Functions
Locators
XPath, Its Types and Use Cases
WebElement Functions
Check Points
Handling Multiple Elements
Handling Synchronization
- Implicit Wait
- Explicit Wait
- Custom Wait
- Blind Wait
Handling Dropdown (Static and Dynamic)
Handling Keyboard and Mouse Actions
Taking Screenshot
Handling Disabled Element
Performing Scroll Down Action
Handling Popups (Web-based and Window-based)
Handling Frames
Handling New Windows / New Tabs
Encapsulation in Selenium
Creating Test Class

Automation Framework

Stages and Types of Framework
Page Object Model (POM)
Handling Excel
TestNG
TestNG Annotations
Reporting
TestNG Suite
Assertion
Grouping
DataProvider
Parallel Execution
Maven
GitHub
Jenkins
Hybrid Framework
Designing Framework
Hybrid Framework Architecture
Framework Implementation
Framework Execution

SDET with Python and Selenium

Introduction to Python

Installation and Environment Settings
Introduction to Shell

Variables, Keywords, Data types and Identifiers

Variables
Keywords
Data Types
Identifiers

String, List, Set, Tuple and Dictionary and Slicing

String Data Types
List Data Types
Set Data Types
Tuple Data Types
Dictionary Data Types
Slicing

Operators

Arithmetic Operators
Logical Operators
Relational Operators
Bitwise Operators
Assignment Operators
Membership Operators
Identity Operators

Control Statements

Decisional Statements
Looping Statements
Break, Continue and Pass

Input and print Statements

Input Statements
Print Statements

Functions or Methods

Types of Functions
Recursion
Arguments
Packing and Unpacking (varargs)

Opps

Class, Objects
Inheritance
Method Overriding
Access Specifiers

File Handling and JSON

Flat File Handling
JSON
Pickle

Exception Handling

Try
Except and Finally
Custom Exceptions
Raising Exceptions
Assertions

Comprehension

Decorators

Map, Filter and Lambda Expressions

Iterators and Generators

Automation Testing

What is Automation Testing?
When to Switch to Automation Testing?
Why Automation Testing?
Advantages and Disadvantages of Automation Testing
Automation Testing Tools

Selenium

What is Selenium?
Advantages of Selenium
Java–Selenium Architecture
Basic Selenium Program
Runtime Polymorphism Program in Selenium
WebDriver Functions
Locators
XPath, Its Types and Use Cases
WebElement Functions
Check Points
Handling Multiple Elements
Handling Synchronization
- Implicit Wait
- Explicit Wait
- Custom Wait
- Blind Wait
Handling Dropdown (Static and Dynamic)
Handling Keyboard and Mouse Actions
Taking Screenshot
Handling Disabled Element
Performing Scroll Down Action
Handling Popups (Web-based and Window-based)
Handling Frames
Handling New Windows / New Tabs
Encapsulation in Selenium
Creating Test Class

Automation Framework

Stages and Types of Framework
Page Object Model (POM)
Handling Excel
TestNG
TestNG Annotations
Reporting
TestNG Suite
Assertion
Grouping
DataProvider
Parallel Execution
Maven
GitHub
Jenkins
Hybrid Framework
Designing Framework
Hybrid Framework Architecture
Framework Implementation
Framework Execution

Advance Selenium with Devops

File & DB Handling

Handling CSV File
Handling JSON File
Handling Property File
Advanced Excel
Handling Database

Reporting

Listeners
Log4j
Extent Report
Integration

Selenium Grid

Grid Customization
Sauce Labs Integration
AWS Integration
Docker Integration
Maven Integration
Jenkins Integration

Framework

JavaScript
Java Reflection API
Advanced AWT
Keyword Framework
Hybrid Framework
Live Project Implementation

API Manual & Automation Testing(POSTMAN & Rest Assured)

API Manual Syllabus

API (Application Programming Interface)
- What is an API
- Why APIs are used
- Real-time examples of APIs
Web Services
- What is a Web Service
- Difference between API and Web Service
- Types of Web Services (SOAP, REST)
CRUD Operations
- Create
- Read
- Update
- Delete
HTTP Methods
- GET – Retrieve data
- POST – Create new data
- PUT – Update existing data
- DELETE – Remove data
Exercise
- Basic understanding of API from UI application using browser
- Analyze API requests and responses
API Testing Using Browser Developer Tools
- Open Developer Tools (Inspect)
- Network tab overview
- How to identify API calls
- Request and Response analysis
Pre-Requisites
- HTTP Status Codes
- JSON basics and structure

API Automation Syllabus

Introduction
- Introduction to Rest Assured
- Setup Automation Test Project:
- Introduction on Test API's & Setup a project with RA library
Creating First API Test
- GET request API test & Validate the response
- Sending query parameters & validating response
- Working with query params and path params
Validations
- Basic Header validation
- Extracting Response Body values with JsonPath
- Response Header and Body validations using Hamcrest Matchers
- Understanding various Hamcrest Matchers
- POST/PUT/DELETE tests:
- POST Request with payload
- PUT/PATCH request with payload
- DELETE request
Deep Dive
- What is missing?
- Authentication
- Serialization and Deserialization in Rest Assured
- Creating POJO class
- Validating API Responses with created POJO
- Serializing data with POJO classes for POST and PUT / PATCH payload
BDD Framework
- Developing framework from scratch with Cucumber BDD, Maven & JUnit
- Adding logging capabilities
- Integrating reporting tool
- Framework Folder structure for API automation
- Creating global variables
- Creating end to end API automation scripts
- Adding assertions
- Creating Categories for execution control
- Script Execution and viewing the reports