www.excelr.
com
SOFTWARE TESTING
Manual & Selenium Testing
Certification Training With
Job Interview Guarantee (JIG)*
*Terms & conditions apply
https://www.excelr.com/terms-and-conditions-for-job-interview-guarantee-program
www.excelr.com
A Word from the CEO
Whether you are looking for a pay raise, a career
transition, or a new job, upskilling is an unceasing
necessity. As a training provider, we understand
that this need constantly changes with time and
technological evolution, and we tailor courses
accordingly. We believe that complete learning is
a blend of theory and practice. Hence, we offer
the kind of post-training support for your
assignments and projects that makes us stand
apart from our counterparts.
Mr. Ram Tavva Our mission is to accompany people in
- CEO and MD of ExcelR Solutions their journey to excellence and empower
An alumnus of IIM-C and a PMP-certified trainer with them to realize their dream careers.
25+ years of experience.
Our Greatest ACHIEVEMENTS
Best Training Institute by Top 20 Most Promising
SiliconIndia on Analytics 2015 PMP Training Institutes in India 2018
Top 20 Most Promising 4.8 Stars on Google Reviews
Business Intelligence(BI) Solution for our Training and Support.
Provider Companies.
www.excelr.com
We're a Deloitte Technology Fast 50 India Winner
We have been recognized as one of the fastest
growing technology companies in the Deloitte
Technology Fast 50 India Award Ceremony
2022.
This achievement for ExcelR, which has been
accompanied by a staggering average growth
rate of 257% in three years, marks an incredible
milestone and has propelled our
transformation into a global company.
This reflects our dedication towards “Raising Excellence” and demonstrating the company’s
professionalism. Our top priority is to provide unparalleled training and consulting to students and
professionals in India and abroad so they can shape their future in the right direction.
On the heels of this good news, we are more committed than ever to creating a state-of-the-art
platform for all of you to succeed in your career and come out with flying colors.
We're Also a Partner of FutureSkills Prime,
A MeitY- Digital Skilling Initiative
We have successfully collaborated with FutureSkills Prime, a
first-of-its-kind partnership between MeitY and NASSCOM, to
build a digital skilling ecosystem and make India a global
digital talent in emerging technologies.
This collaboration will facilitate continuous learning and
knowledge enhancement of graduates and working
professionals with regard to their aspirations and aptitude,
improving their employability.
We’re proud to share in and contribute to the national
interest, and we will continue to play a significant role in the
digital upskilling revolution in the years to come.
www.excelr.com
Software Testing - Manual &
Selenium Testing: An Overview
With 135+ hours of learning, our Software Testing
course is customized for freshers and working
professionals to build their careers around
software testing. You’ll work on labs, assignments,
and capstone projects integrated with the
program and gain a thorough understanding of
the Software Development Life Cycle, Manual
Testing with Agile, Core Python, Automation Testing
via Selenium, API Testing, Fundamentals of DevOps,
MySQL, Core Python, and much more.
The detailed curriculum modules and other
highlights showcased in this brochure will explain
why you should start with us right away.
What is Software Testing?
Software testing is a thriving domain that combines various manual and automation tests using DevOps
and Agile, resulting in a significant decrease in the timelines of software development processes and
ensuring the new releases are bug-free and ready for end users before deployment.
www.excelr.com
Software Testing Life Cycle
Test Cycle Requirement
Closure Analysis
Test
Test
Execution
Planning
Test Environment Test
Setup Case
Development
Why Should You Invest in This Course?
Job vacancies
in India Job Satisfaction
10,400+ 65%
QA Analysts & Software Avg. Software Test
Testers to grow by Engineer Salary
22% 4 - 4.9 LPA
by 2029 (0-1.5 years Experience)
Source(s):
Naukri, Glassdoor, Ambitionbox, Indeed,
Statista, Career Bliss
www.excelr.com
Top Companies Hiring Software Test Engineers
and many more....
Career Progression and Salary Trends
20
10
0
Associate Software SDET Senior QA QA QA Product Manager
QA Engineer Test Engineer Engineer Engineer Lead Manager in Software
Avg. Experience (Years) Avg. Salary (LPA) Source: Glassdoor, Ambitionbox
www.excelr.com
GLOBAL SOFTWARE TESTING MARKET
The software industry is expected to grow to $63.9B by 2028 at a CAGR of 18.36%. This will unlock
numerous career opportunities in the software testing domain.
Source: Marketsandmarkets
59%
25% Asia Pacific
America
16%
Europe, Middle East,
and Africa
TOP-INDUSTRIES HIRING SOFTWARE TEST ENGINEERS
IT Services Finance Manufacturing
60% 08% 11%
Healthcare Other
07% 14%
www.excelr.com
Course Highlights
Our Software Testing course is a comprehensive program that takes you from the classroom to the
workplace. Once you complete your training, internship, and assessments successfully, you’ll get into the
placement pool. Once in it, you’ll have guaranteed job interviews until you receive the first job offer. We
have tie-ups with 2000+ companies for this job interview assurance program.
Guaranteed job interviews 135+ Hours of Blended Learning 25+ Skills Covered
until you get placed
12+ Tools Covered 10+ Capstone Projects 80+ Case Study Analyses
50+ Hours of 1000+ Interview Technical Presentations
Internship With AiVariant Preparation Questions by Participants
www.excelr.com
Skills Covered
Software Testing Manual Testing Agile Methodology Jira Best Practices Core Java
OOPS Concept Automation Testing Selenium Webdriver Page Object Model TestNG Framework
Data-Driven Testing Hybrid Framework API Testing CI/CD Pipeline Testing Process
Testing Life Cycle Test & Defects Design Techniques REST API Cucumber
Management
Functional Testing Black Box Testing White Box Testing Django DevOps
Framework Fundamentals
Tools Covered
Eclipse IDE IntelliJ TestNG Maven GIT
Python POSTMAN DevOps Basics JIRA MySQL
www.excelr.com
Value Added Courses
Our course curriculum doesn't stop at the core concepts of software testing. We also provide
complimentary value-added courses like Core Python, MySQL, and DevOps, which go hand-in-hand
with the core concepts of the Software Testing course and prove essential in the software testing
domain. Gaining a comprehensive skill set will give you an edge over your peers during interviews.
Core Python
Python, a simple and versatile programming language, has a strong binding with
Selenium Webdriver. Learning Python is an added advantage for a Software Test
Engineer.
Fundamentals of MySQL
Tests using automation methods do not require coding but a free, easy-to-use, highly
secure, platform-friendly database that works on simple, customizable code. MySQL
is one such relational database management system, which is important to know.
Overview of DevOps
The design testing process needs to be agile, effortless, and error-free, which is
possible through DevOps pipelines.
www.excelr.com
Your 2-in-1 Certification
Certificate from ExcelR Internship Certificate from AiVariant
Hereby confers upon
The
AŌer successful compleƟon of the mandated course requirements with
Automation Testing
disƟncƟon
Date: 02nd February 2023
Reg/Cert No : 12383 /EXCELR/ 02022023
A Division of
EXCELR SOLUTIONS (USA)
Director 201 S High Point Road APT 213
Madison, Wisconsin – 53717 USA.
www.excelr.com
Curriculum:
Manual Testing
Module 1: Fundamentals of Testing
Fundamentals of testing Project & team members
What is testing? Testing throughout the software life cycle
Testing principles Software development models (overview of
all models) - SDLC
What is software?
Waterfall model
Types of software applications
(desktop, web, & mobile) Agile model, V Shape, Spiral model
(advantages & disadvantages), roles
Types of organizations
ceremonies & artifacts
Type of domains
Sprint, Scrum, test management tool (JIRA,
ZEPHYR)
Module 2: Fundamental Test Process
Fundamental test process
Overview of understanding requirements and creating test scenarios,
test design, test planning, test execution, test report
STLC
Module 3: Test Types & Test Levels
Test types:
White-box testing Usability testing
Black-box testing UI UX testing
Functional testing L10N, I18N, G11N testing
Smoke & sanity testing Compatibility testing
Regression and retesting Performance testing
User acceptance testing - alpha Security testing
& beta programs
Non-functional testing (overview)
Environments: Test levels:
Development, QA, UAT, Prod Unit testing
Integration testing
System testing
UAT testing
Prod testing
www.excelr.com
Module 4: Test Design Techniques
Identifying test conditions and designing test cases
Categories of test design techniques:
Structure-based or white-box techniques Traceability matrix & test coverage
(overview)
Defect life cycle, priority & severity of defects
Specification-based or black-box techniques
Real-time defect reporting and practicals
Experience-based techniques
Module 5: Test Management
Test organization Test progress monitoring and control
Test plans, estimates, and strategies Entry & exit criteria
Lab Sessions: Creating defects in Jira
Practical on Jira Tool for assignments and project work
Lab Sessions: Creating test cases from requirement
Practicals on creating defects in Jira
Introduction to API Testing (via Postman Tool)
API testing (Manual Postman)
Why API?
Types of API (Rest & SOAPUI)
API Collections
Basics of API Testing (Get, Post, Put, and Delete)
a. Understanding of Path, Query, Parameters, and Headers
b. Authentication
c. Add Place API and Execution through Postman
c. Response Code of API
d. Validation and assertion on response
Requirements of API
Understanding the API contract
www.excelr.com
Introduction to Selenium
What is Automation?
Why Automation
(Manual vs Automation)?
Scope of Automation tester in the market
What is Selenium?
Why Selenium?
Advantages of using Selenium
Selenium Testing
Selenium Testing
What is software testing? Definition, basics, & types
Sanity testing vs Smoke testing: Introduction & differences
What is a test scenario? Template with examples
Defect Management Process in software testing (Bug Report template)
Agile methodology & model: Guide for Software Development & Testing
Fundamentals of Java
Introduction to JAVA & installation of JAVA & Eclipse
Basic Java, Java operators, Java data types
If Else statements, Loop statements, Constructors
Java Collections
Arrays, 2D Arrays, ArrayList, List
Collection framework
Java Strings
Introduction to Strings in Java
All the String validation methods
Java Variables & Methods
Variables in Java
Methods in Java
Java Access Specifiers
Access Specifiers in Java
Constructors in Java
www.excelr.com
Java OOPS Concepts:
Class, Object, & Packages Abstraction
Inheritance Encapsulation
Polymorphism
Exception Handling:
Try catch finally block, interfaces, file handling
Selenium Module 1:
What is Automation Testing? Dynamic CSS and XPath selector creation
What is Selenium? Following sibling
What is WebDriver? Preceding sibling
Features, Architecture of Selenium Ancestor
Download Selenium Jars Parent
Locators in Selenium (id, name, class
name)
Invoking for Web browsers (Chrome, Firefox, Edge),
Navigation commands, WebDriver commands, FindElements command,
Waits in Selenium
Identifying and interacting with HTML elements using WebDriver
Selenium Module 2:
Check Box & Radio buttons, Drop Down, Multiple Selects,
WebTable Handling, Alerts, Handling iFrames, Window Handles
Action class: Mouse events, click, doubleClick, contextClick, dragAndDrop, clickAndHold, release,
Tooltip verification, Keyboard events
JavaScriptExecutor, how to handle hidden elements, how to handle broken links,
How to upload & download files, take screenshot
Excel handling using Apache POI, reading & writing from Excel sheet
Introduction to Maven repository & commands, POM.XML
Selenium Module 3:
TestNG basics, create TestNG.XML file/test suite
Run from TestNG and tags in TestNG.XML file
TestNG Annotations - Hands-on to explain how it's used in the projects
1. dependsOnMethods & dependsOnGroup 4. DataProvider
2. Priority 5. TestNG Listeners, Log 4j
3. Groups
www.excelr.com
Selenium Module 4:
Types of Frameworks: Cucumber framework creation with POM
Data-Driven Cucumber framework creation with POM
& Executing Automation scripts using BDD
Page Object Model
Framework
Keyword Driven
Hybrid Driven
BDD Cucumber (Overview of all frameworks)
Value-Add Courses
Python
Intro
Python Introduction - Programming Cycle of Python
Python IDE and Jupyter notebook
Variables
Variables, Data types
Code Practice Platform
GitHub, HackerRank, Code Wars, and Sanfoundry accounts creation
Number, String, List, Tuple, Dictionary
Operators
Arithmetic, Comparison, Assignment, Logical, Bitwise operator
Loops
While loop, For loop, and Nested loop
Conversions Number type conversion - int(), long(), float()
Mathematical functions, Random functions, Trigonometric functions
String
Escape char, String special operator, String formatting operator
Build in string methods - center(), count()decode(), encode()
List
Accessing values in list, Deleting list elements, Indexing, Slicing & Matrices
Built in Function - cmp(), len(), min(), max(), list comprehension
www.excelr.com
Tuples
Tuples - Accessing values in Tuples, Delete Tuples elements, Indexing, Slicing & Matrices
Built in tuples functions - cmp(), len ()
Dictionary
Accessing values from dictionary, Deleting and updating elements in dictionary
Properties of Dist., Built-in Dist functions & Methods, Dictionary comprehension
Date & time - Time tuple, calendar module, and time module
Function
Define function, Calling function
Pass by reference as value, Function arguments, Anonymous functions, Return
statements
Scope of variables - local & global, Decorators and recursion
Map reduce and filter
Modules
Import statements, Locating modules - current directory, Pythonpath
Dir() function, global and location functions and reload () functions, Sys module and
subprocess module
Packages in Python
Files
Reading keyboard input, input function
Opening and closing files, Syntax and list of modes
Files object attribute - open, close
Reading and writing files, file position
Renaming and deleting files
Pickle and Json
Directories
mkdir() method, chdir() method, getcwd() method, rmdir() method
Exception Handling
List of exceptions - Try and exception
Try- finally clause and user-defined exceptions
OOP
OOP concepts, Class, Objects, Inheritance
Overriding methods like _init_, Overloading operators, Data hiding
www.excelr.com
Regular Expressions
Match function, Search function, Matching vs Searching
Regular exp modifiers and patterns
SQLite and MySQL
Database connectivity
Methods- MySQL, oracle, how to install MySQL, DB connection
Create, Insert, Update and Delete operations Handling errors
Framework
Introduction to Django framework, overview, environment
Apps lifecycle, creating views
Application, Rest API
DevOps
Introduction to DevOps
What is DevOps?
DevOps Lifecycle, Continuous Development, Introduction to GIT
GIT
Branching/Merging in GIT, Ansible Tutorial
Kubernetes Tutorial
CICD Pipeline
Introduction to Jenkins, Install and configure Jenkins, CICD Pipeline Introduction.
www.excelr.com
MySQL
Introduction to Database
What is Database? DDL - Data Definition Language
Database testing DML - Data Manipulation Language
Types of Database DCL - Data Control Language
What is MySQL? DQL - Data Query Language
Overview of Database
MySQL Commands What is field?
What is RDBMS? What is column?
What is table? What is NULL value?
MySQL Constraints
NOT NULL Constraint: Ensures that a column cannot have NULL value
DEFAULT Constraint: Provides a default value for a column when none is specified
UNIQUE Constraint: Ensures that all values in a column are different
PRIMARY Key: Uniquely identifies each row/record in a database table
FOREIGN Key: Uniquely identifies rows/records in any another database table
CHECK Constraint: The CHECK constraint ensures that all values in a column satisfy certain
conditions
INDEX: Used to create and retrieve
Aggregation Functions: (Mean, Max, Count), Group by, Sorting order
MySQL Statements and Joins
MySQL Syntax
MySQL SELECT Statement
MySQL Joins
Understanding of Data Contract & Mapping Specifications
Understanding of data contract
Understanding of mapping specifications
Creating test cases from requirement
www.excelr.com
Training Methodology
01
Day-wise Agenda and Activities
Consisting of topics as per day-wise calendar,
lab sessions for important topics, day-wise
interview questions, and interview preparation
practice tests in LMS
02
Technical Presentations by Learners
Weekly technical presentation sessions by the
learners, assessed and moderated by trainers
03
Topic-wise Interview Questions
Multiple practice tests with questions from
real-life interviews
04
Bootcamps & Case Study Analysis
Learners will work on bootcamps with
real-life interview questions and
case studies along with faculty
05
Graded Quizzes
Graded quizzes after completion of day-wise
agenda and assignments
06
Placement Preparation
Dedicated placement team will guide participants
in preparing resume and LinkedIn profile, and
also hold graded mock interviews
07
Job Interview Guarantee (JIG)*
Participants are eligible for JIG* after being
evaluated on technical presentations and
clearing the graded quizzes.
*Terms & Conditions apply
https://www.excelr.com/terms-and-conditions-for-job-interview-guarantee-program
www.excelr.com
GUARANTEED JOB INTERVIEWS
Our dedicated placement teams have over a decade of experience in transitioning students from the
classroom to the workplace.
Here’s how it goes:
Interview Preparatory Sessions
Your interview preparation begins on the first day of your course.
Faculty moderate daily interview quizzes and discussions, and
there are topic-specific preparation sessions. Participants also
give technical presentations and take part in numerous
bootcamps where experts tackle real-life interview case studies.
Resume Preparation Session
Our mentors will guide you through preparing a personalized
resume that connects your talents, skills, and previous
experience.
LinkedIn Profile Optimization
Your LinkedIn profile is key to getting the attention of recruiters.
We help you put your best foot forward by working with you to
optimize your profile.
Assessments and Mock Interviews
Regular assessments will be conducted and the results will be
shared with participants. A team of industry experts will perform
a SWOT analysis and provide feedback on your interview
performance, highlighting areas for improvement. Clearing
these assessments and mock interviews is crucial for advancing
to the placement pool.
Placement Pool
After you clear the assessments and mock interviews, you’ll get
into the placement pool. This is the phase where we’ll schedule
guaranteed job interviews until you get placed.
www.excelr.com
Why ExcelR?
Guaranteed Job Interviews
Our training doesn’t stop with theory and practice. We also take
responsibility for making you job-ready. Upon successful completion of
training, internship, and assessments, you will enter the placement pool.
Once in it, we’ll schedule interviews for you until you get the first job offer
Jumbo Pass
Our Jumbo Pass is a first-of-its-kind offering that allows you to attend
one classroom batch and unlimited live virtual classes for the next 365
days with any trainer of your choice.
Top-Notch Faculty
Our faculty is our strength. We have certified software testing trainers,
with over 12 years of experience, who have a strong passion for training.
The trainers are always at your disposal to assist you throughout the
learning process.
Industry-Based Course Curriculum
Considering the unmet skill gaps in industry, our course modules are
aligned to the latest technological trends, and cover all the essential
topics and tools.
Dedicated Post-Training Support
Learners gain hands-on experience when they start on their
assignments and case studies. We provide dedicated mentors to help
with any queries during this phase.
Lifetime Access to Self-Paced Learning
We provide lifetime access to the Learning Management System, so
you can revise concepts by going through the recorded sessions as
and when you want.
4.8/5 Star Reviews on Google
We have had many happy learners over the years, and our ratings
reflect our ethos of striving always to provide a high-quality learning
Reviews experience.
www.excelr.com
Academic Partners
Our Clientele
www.excelr.com
and many more...
www.excelr.com
Start Learning at as Low as
Ɵ5,999/- Per Month
with EMIs @ 0% Interest
COURSE FEE : 65999/-
`35,999 Incl. of GST
We offer classroom training at `45999/- or `7666. (for a 6-Month no-cost EMI) at selected locations.
Payment Options
UPI Netbanking Debit / Credit Cards All Major Credit Cards Are Accepted
(One-Time Payment)
EMI Partners Loans
All Major Bank Credit / Debit Cards Accepted for EMIs too.
For further information regarding EMI, please feel free to contact our career counsellors.
We don’t just TRAIN
We build CAREERS
Bangalore Chennai Hyderabad Pune Mumbai
INDIA
Overseas Malaysia
Kuala Lumpur
USA
Houston
UK
Reading RG1 5DS
Singapore
