Course Path

Benefits of (PMP)® Certification Training

Upcoming Batches

Select Your City

Click Here

Live Virtual Classroom

₹ 47999
₹ 37999
  • Guaranteed job interviews until you get placed
  • Intensive interview preparation from the very first day of the course
  • Real-life interview case study analysis
Upcoming Batches
21st

November

28th

November

12th

December

Show All Batches Enroll Now

Program Highlights

ExcelR DevOPs training

Top-Notch Faculty

ExcelR DevOPs training

Exhaustive Course Curriculum

ExcelR Data Analyst training

Guaranteed Job Interviews

ExcelR DevOPs training

Real-life Projects and Bootcamps

 

Skills Covered

Software Testing

Manual Testing

 

Agile Methodology

Jira's best practices

 

 

Tools Covered

Eclipse IDE

IntelliJ

 

TestNG

Maven

GIT

Python

Postman

Jira

MySQL

Swagger

Zephyr

Jenkins

 

Projects

  • Beginner
  • The objective of this project is to understand the business requirement and all the acceptance criteria from end-user perspective and, as per the acceptance criteria, learners can develop the real-time scenario and also be able to write all the possible test cases.
  • Intermediate
  • In this project, learners can create the JIRA Project and be able to create the epic and testing task for the same. From this application, learners will understand how to test e-commerce websites from the end-user perspective and also need to develop the real-time scenario and be able to write all the possible test cases.
  • Intermediate
  • The objective of this project is to perform end-to-end testing activity which includes test scenario development, test case writing, test case execution, bug finding and bug reporting. Based on the bug behavior, user needs to provide the bug priority and bug severity.
  • Advanced
  • The objective of this project is to perform manual and automation testing for all the mentioned scenarios. For test case writing, test writing learners can use the Zephyr tool. Here, learners need to write the automation test script by using Page Object Model and also need to perform the test case execution in different browsers.
  • Advanced
  • The objective of this project is to perform the automation testing for all the mentioned scenarios. Learners can use the Zephyr tool to create various test cases. Here, learners need to write the automation test script by using Page Object Model and also need to use the TestNG Annotation as per the requirement.
  • Advanced
  • Learners will create the JIRA Project and the different bugs. They will decide the priority and severity of the bug. This application is developed to find out the factorial. Learners will perform end-to-end testing on the website from an end-user perspective and develop the positive and negative scenarios of any functionality.

Career Progression and Salary Trends

Placement Process - ExcelR

Learning Path

Why ExcelR

ExcelR DevOPs training

Industry-Based Course Curriculum

ExcelR DevOPs training

Value Added Courses: DevOps, Core Python, and MySQL

ExcelR DevOPs training

Work Hands-on with 100+ Hours of Internship and 10+ Bootcamps

 

ExcelR DevOPs training

Guaranteed Job Interview Calls with our 2000+ partner companies

ExcelR DevOPs training

Support through WhatsApp, Calls, & Emails

ExcelR DevOPs training

Lifetime eLearning Access

Course Curriculum

Manual Testing

  • Fundamentals of Testing
  • What is Testing?
  • Testing Principles
  • What Is Software, Types of Software Application (Desktop, Web & Mobile), Types of Organizations
  • Type of Domains
  • Project & Team Members
  • Testing Throughout the Software Life Cycle
  • Software Development Models (Overview of All Models) - SDLC
  • Water Fall Model
  • Agile Model, V Shape, Spiral Model (Adv & Dis-adv), Roles
  • Agile Model, Scrum Framework, Roles, Ceremonies & Artifacts,
  • Sprint, Scrum, Test Managment Tool (JIRA, ZEPHYR)
  • Fundamental Test Process (Overview of Understanding Requirements and Creating Test Scenarios, Test design, Test Planning, Test Execution, Test Report)
  • STLC

Test Types

  • White Box Testing
  • Black Box Testing
  • Functional Testing
  • Smoke & Sanity Testing
  • Regression and Retesting
  • User Acceptance Testing - Alpha & Beta Programs
  • Non-functional Testing (Overview)
  • Usability Testing
  • UI UX Testing
  • L10N, I18N, G11N Testing
  • Compatibility Testing
  • Performance Testing
  • Security Testing

Environments

  • Development, QA, UAT, Prod

Test Levels

  • Unit Testing
  • Integration Testing
  • System Testing
  • UAT Testing
  • Prod Testing
  • Experience-Based Techniques
  • Tracibility Matrix & Test Coverage
  • Defect Life Cycle, Priority & Severity of Defects
  • Real Time Defect Reporting and Practicals
  • Test Organization
  • Test Plans, Estimates, and Strategies
  • Test Progress Monitoring and Control
  • Entry & Exit Criteria
  • API Testing (Manual Postman)
  • Why API
  • Types of API (Rest & SoapUI)
  • API Collection
  • Basic of API Testing (Get, Post, Put and Delete)
  • What is Automation?
  • Why Automation (Manual vs Automation)? 
  • Scope of Automation Tester in Market
  • What is Selenium? Why Selenium?
  • Advantages of Using Selenium?

Selenium

  • What is Software Testing? Definition, Basics & Types
  • Sanity Testing Vs Smoke Testing: Introduction & Differences
  • What is Test Scenario? Template with Examples
  • Defect Management Process in Software Testing (Bug Report Template)
  • Agile Methodology & Model: Guide for Software Development & Testing
  • Introduction to JAVA & installation of JAVA & Eclipse
  • Basic Java, Java Operators, Java data types, If Else statements, Loop statements, Constructors
  • Java Collections
    • Arrays, 3D Arrays, Array List, list
    • Collection framework
  • Java Strings
    • Introduction of Strings in Java, All the String validation methods
  • Java Variables & Methods
    • Variables in Java, Methods in Java
  • Java Access Specifiers
    • Acess Specifires in Java, Constructors in Java
  • Java OOPS Concepts
    • Class, Object & Packages
    • Inheritance Polymorphism
    • Abstraction, Encapulation
  • Exception Handling
    • Try Catch finally block, Interfaces, File Handling
  • Locators in Selenium (id, name, class name)
  • Dynamic Xpath and css selector creation
  • Following sibling,
  • Preceding sibling,
  • Ancestor
  • Parent
  • What is Automation Testing?
  • What is Selenium?
  • What is WebDriver?
  • Features
  • Architecture of Selenium
  • Download Selenium Jars
  • Invoking for Web browser (Chrome, Firefox, Edge)
  • Navigation Commands
  • WebDriver Commands
  • FindElements Command
  • Waits in Selenium
  • Identifying and Interacting with HTML Elements using WebDriver
  • Check Box & Radio buttons
  • Drop Down
  • Multiple Selects
  • WebTable Handling
  • Alerts
  • Handling iFrames
  • Window Handles
  • Action class: Mouse Events, Click, doubleClick, contectClick, dragAndDrop, clickAndHold,release, Tool tip verification, Keyboard Events
  • Java Script Executor
  • How to handle hidden elements
  • How to handle broken links
  • How to upload & Download file, Taking Screenshot
  • Excel Handling using Apache POI, Reading & Writing from excel sheet
  • Introduction to Maven Repository & Commands, POM.XML
  • TestNG Basics, Create TestNG.XML file / Test / TestSuite
  • Run from TestNG and Tags in TestNG.XML file
    TestNG Annotations - Hands on to explain how its used in the projects 
    1. dependsonmethods/group 
    3. Priority 
    3. Groups
    3. data provider.
    3. TestNG Listerners, Log 3j
  • Types of Frameworks:
    • Data Driven,
    • Page Object Model,
    • Keywork Driven,
    • Hybrid,
    • BDD Cucumber (Overview of all frameworks)
  • Cucumber framework creation with POM
  • Cucumber framework creation with POM & Executing Automation scripts using BDD Framework
  • API Testing (Manual Postman)
  • Why API
  • Types of API (Rest & SOPUI)
  • API Collection
  • Basic 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
    d. Response Code of API
    e.Validation and assertion on response
  • Requirments of API
  • Understanding the API Contract

Value Added Courses

  • Introduction
    • Python Introduction - Programing Cycle of Python
    • Python IDE and Jupyter notebook
  • Variables
    • Variables , Data type.
  • Code Practice Platform
    • Github, Hacker rank, Code Wars and Sanfoundry accounts creation
    • Number , string ,List , Tuple , Dictionary
  • Operators
    • Operator -Arthmatic ,comparison , Assignment ,Logical , Bitwise opeartor
    • Decision making - Loops
  • Loops
    • While loop, for loop and nested loop
    • Number type conversion - int(), long(). Float ()
    • Mathametical functions , Random function , Trigonometric function
  • Strings
    • Strings- Escape char, String special Operator , String formatting Operator
    • Build in string methods - center(), count()decode(), encode()
  • List
    • Python List - Accessing values in list, Delete list elements , Indexing slicing & Matrices
    • Built in Function - cmp(), len(), min(), max(), list comprehension
  • Tuples
    • Tuples - Accessing values in Tuples, Delete Tuples elements , Indexing slicing & Matrices
    • Built in tuples functions - cmp(), len ()
  • Dictionary
    • Dictionary - Accessing values from dictionary, Deleting and updating elements in Dict.
    • Properties of Dict. , Built in Dict functions & Methods, Dict comprehension
    • Date & time -Time Tuple , calendar module and time module
  • Function
    • Function - Define function , Calling function
    • pass by refernece as value , Function arguments , Anonymous functions , return statements
    • Scope of variables - local & global , Decorators and recursion
    • Map reduce and filter
  • Modules
    • Import statemnts , Locating modules - current directory , Pythonpath
    • Dir() function , global and location functions and reload () functions , Sys module and subprocess module
    • Packages in Python
  • Files
    • Files in Python- 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 methid, chdir () method , getcwd method , rm dir
  • Exception Handling
    • 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
  • Regular Expressions
    • match function , search function , matching vs searching
    • Regular exp modifiers and patterns
  • SQLite and My SQL
    • Data base connectivity
    • Methods- MySQL , oracle , how to install MYSQL , DB connection
    • create , insert , update and delete operation , Handling erros
  • Introduction to Django framwork , overview , environment
  • Framework
    • Apps life cycle , creating views
    • Application, Rest API
  • Introduction to Devops
    • What is Devops
    • Devops Lifecycle, Continuous Development, Introduction to GIT
  • GIT
    • Branching / Merging in GIT, Ansible TutorialKubernetes Tutorial
  • CICD Pipeline
    • Introduction to Jenkins, Install and configure Jenkins, CICD Pipeline Introduction
  • Introduction to Database
    • What is Database? Database testing?
    • Types of Database
    • What is MYSQL?
    • DDL - Data Definition Language
    • DML - Data Manipulation Language
    • DCL - Data Control Language
    • DQL - Data Query Language
  • Overview of Database
    • MYSQL Commands
    • What is RDBMS?
    • What is table?
    • What is field?
    • What is column?
    • What is NULL value?
  • MYSQL Constraints
    • 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 identified each rows/records in a database table.
    • FOREIGN Key: Uniquely identified a rows/records in any another database table.
    • CHECK Constraint: The CHECK constraint ensures that all values in a column satisfy certain conditions.
    • INDEX: Use to create and retrieve
    • Aggregation Functions: (Mean, Max, Count) Group by, Sorting order
  • SQL Statements and Joins
    • MYSQL Syntax
    • MYSQL SELECT Statement
    • SQL Joins
  • Understanding of Data Contract & Mapping Specifications
    • Understanding of Data COntract
    • Understanding of Mapping Specifications
    • Creating Test cases from Requirement

Contact Our Team of Experts

FAQs

Global Presence

ExcelR is a training and consulting firm with its global headquarters in Houston, Texas, USA. Alongside to catering to the tailored needs of students, professionals, corporates and educational institutions across multiple locations, ExcelR opened its offices in multiple strategic locations such as Australia, Malaysia for the ASEAN market, Canada, UK, Romania taking into account the Eastern Europe and South Africa. In addition to these offices, ExcelR believes in building and nurturing future entrepreneurs through its Franchise verticals and hence has awarded in excess of 30 franchises across the globe. This ensures that our quality education and related services reach out to all corners of the world. Furthermore, this resonates with our global strategy of catering to the needs of bridging the gap between the industry and academia globally.

ExcelR's Global Presence

Call Us