1.1. Waterfall Method
1.1.1. Various phases covered in detail
1.1.1.1. Understand the role of a BA, QA
1.1.1.2. BA role in detail
1.1.1.2.1. User Requirements
1.1.1.2.2. Functional Requirements
1.1.1.2.3. Non-Functional Requirements
1.1.1.3. Overview of SDLC phases

1.2. Agile [with JIRA Tool]
1.2.1. Explain Agile
1.2.2. Scrum
1.2.2.1. Scrum Basics
1.2.2.2. Sprint
1.2.2.3. Product Backlog
1.2.2.4. Sprint Backlog
1.2.2.5. Burn Down Chart
1.2.2.6. Sprint Planning Meeting
1.2.2.7. Stand-up Meeting
1.2.2.8. Review Meeting
1.2.2.9. Retrospective Meeting
1.2.2.10. Sprint Closer

2.1. Software Testing Life Cycle and Manual Testing
2.1.1. Test Plan Preparation
2.1.2. Test Case Design
2.1.3. What is testing? Why test?
2.1.4. What is a test case?
2.1.5. How to develop test cases from IT requirements
2.1.6. Test Case Design Techniques
2.1.7. Manual Testing Exercises and Homework
2.1.8. Real-time Application Coverage
2.1.9. Test Execution
2.1.10. Defect Reporting
2.1.10.1. What is a Defect?
2.1.10.2. Defect Life Cycle
2.1.10.3. Defect Log Format
2.1.10.4. Priority and Severity
2.1.10.5. Real-time Examples

2.2. Test Report Preparation
2.3. Testing Types
2.3.1. White Box Testing
2.3.2. Black Box Testing
2.3.2.1. Functional
2.3.2.1.1. Smoke Testing
2.3.2.1.2. System Testing
2.3.2.1.3. End-to-End Testing
2.3.2.1.4. Regression Testing
2.3.2.1.5. Retesting
2.3.2.1.6. Concurrency Testing
2.3.2.1.7. Exploratory Testing
2.3.2.1.8. Compatibility Testing
2.3.2.1.9. User Acceptance (UAT) Testing
2.3.2.2. Non-Functional Testing
2.3.2.2.1. GUI Testing
2.3.2.2.2. Performance Testing
2.3.2.2.3. Security Testing

3.1. Selenium Introduction
3.1.1. Selenium History and Latest Version

3.2. Installations and Configurations with Java Basics
3.2.1. Java Installation
3.2.2. Eclipse Installation and Configuration
3.2.3. Selenium JARs Setup
3.2.4. Java Basics Brush-up

3.3. Java Basics to Advanced
3.3.1. First Steps – My First Program
3.3.2. Variables, Data Types, Operators
3.3.3. Expressions, Methods, Code Blocks
3.3.4. Control Flow Statements
3.3.5. Naming Conventions, Access Modifiers, Static/Final
3.3.6. Java Collections
3.3.7. Java OOPS Concepts

3.4. WebDriver First Program
3.4.1. WebDriver Interface
3.4.2. Invoking Browsers
3.4.3. Basic WebDriver Methods

3.5. Locator Techniques
3.5.1. Browser Add-ons
3.5.2. XPath, ID, Name, CSS, LinkText
3.5.3. Advanced XPath, CSS Selectors

3.6. Automating Web UI
3.6.1. Handling Different Elements like Dropdowns, Checkboxes, Radio Buttons
3.6.2. Alerts and Popups
3.6.3. Element Validation
3.6.4. Practice Exercises

3.7. Advanced Web UI Automation
3.7.1. Mouse Actions
3.7.2. Multiple Windows and Frames

3.8. Real-Time Selenium Exercises

3.9. TestNG with Selenium

3.10. Frameworks Overview
3.10.1. Page Object Model
3.10.2. Hybrid Framework

4.1. Introduction to Web Services
4.1.1. SOAP and REST
4.1.2. UDDI, WSDL

4.2. API/Webservices Test Automation with SOAP UI
4.2.1. Installation and Setup
4.2.2. Creating Projects, Suites, Test Cases
4.2.3. Properties, Assertions, Parameterization
4.2.4. SOAP and REST Examples
4.2.5. Instructor Labs & Interview Questions

4.3. API Testing with POSTMAN
4.3.1. What and Why Postman
4.3.2. GET/POST Requests
4.3.3. Parameterization and Tests
4.3.4. Collections and Runners

4.4. API Automation with REST Assured
4.4.1. REST Assured Framework Setup
4.4.2. API Requests (GET, POST, PUT, DELETE)
4.4.3. Assertions and Validations with JSONPath
4.4.4. Serialization & Deserialization with Jackson
4.4.5. Data-Driven API Tests
4.4.6. API Authentication (Basic, OAuth 2.0, Token-based)
4.4.7. Logging & Reporting

5.1. Introduction to BDD & Gherkin Syntax
5.2. Writing Feature Files and Scenarios
5.3. Step Definitions in Java/Python
5.4. Cucumber Reporting and TestNG Integration
5.5. Managing Hooks (Before & After)

6.1. Introduction to Git and GitHub
6.2. Basic Git Commands (commit, branch, merge, pull, push)
6.3. Resolving Merge Conflicts
6.4. Using GitHub for Collaboration & CI/CD Workflows

7.1. SQL Basics
7.1.1. Tables, Rows, Columns
7.1.2. Data Types, Keys
7.1.3. SELECT, WHERE, ORDER BY
7.1.4. INSERT, UPDATE, DELETE

7.2. Advanced SQL
7.2.1. COUNT, SUM, GROUP BY, HAVING
7.2.2. Sub Queries, Joins
7.2.3. Working with Dates
7.2.4. Practice with Oracle APEX

7.3. SQL for QA
7.3.1. Data Validation
7.3.2. SQL Injection
7.3.3. Relational DB Testing

8.1. Editors and Script Files
8.2. Static Methods, Variables
8.3. SOAPUI Environment Variables and Properties
8.4. XML and JSON Handling

9.1. Introduction to CI/CD
9.2. Jenkins/GitHub Actions Fundamentals
9.3. Setting Up Test Automation Pipelines
9.4. Triggering Tests on Git Commit
9.5. Integration with Jira & Test Management Tools

10.1. Introduction to Generative AI in Testing
10.2. Use Cases of AI in Test Case Generation
10.3. Test Optimization with AI
10.4. AI-Based Bug Prediction & Prioritization
10.5. Hands-on with OpenAI/Gen AI APIs for QA

11.1. What is Kafka?
11.2. Kafka Architecture for Testers
11.3. Tools & Setup for Kafka Testing
11.4. Reading and Writing Kafka Messages
11.5. Validating Event-Driven Microservices

Introduction to SQL
SQL
 Database
Table, Rows and Columns
Data Types
Primary Key, Alternate/Secondary Keys/NOT NULL/UNIQUE/CHECK and Foreign Keys

Statements
SQL
Select and Select *
Column Alias, Null Value, Arithmetic Expressions
Concatenation Operator(||), Literal, DISTINCT
Where
Order By (Desc, Asc)
And & OR, Like
Not
IN
Not In
Insert, Update, Delete
DESCRIBE

Advanced SQL with Oracle
SQL commands
Update, Delete
Create, Alter, Drop
Truncate, Select with various operators
Count, Sum, Distinct
Order by, Group by, Having
Working With Dates
Sub Query
Introduction to Joins
Inner Join
Self Join
Outer Joins – Left/Right/Full
Hands on all above with Oracle APEX online

Why QA professionals need to know SQL basics
Sample queries for data verification
Acquiring test data
SQL Injection attack
What to test in Relational DB apps

• What is Power BI?
• What is Power BI Desktop
• Install Power BI Desktop
• Exploring Power BI Desktop
• Power BI Overview
• Components of Power BI
• Exploring Power BI Desktop Interface
• Data Loading with Power BI Desktop

Types of different Data loading modes

• Excel, CSV, PDF, SharePoint, Folder
• SQL Data loading
• Cube Data loading
• Combining Data Source

Data Transformation with Power BI

• Transforming Database Data
• Connecting to access database data
• Power Query Editor and Queries
• Creating and managing query groups
• Renaming Queries
• Splitting Columns
• Changing Data Types

Power BI Visualization

• Designer Options
• Power BI Visualization Types
• Custom Visualization
• Best Practices
• Choosing Colors
• Types of Charts and Usage

• 12.1. HR and IT Questions
  12.2. QA-Specific Questions
  12.3. Resume Writing Tips
  12.4. Mock Interviews and Job Support