ExcelR Jumbo Pass

You May Have Heard About Offers, But Have You Heard Of ExcelR's JUMBO PASS? Well, Here's Your Chance To Avail The JUMBO PASS!! Watch The video

Program Highlights

Program Highlights

Faculty
Faculty
Faculty
Faculty

Skills Covered

Faculty
Faculty
Faculty
Faculty
Faculty
Faculty
Faculty
Faculty

Why ExcelR

Faculty
Faculty
Faculty
Faculty
Faculty
Faculty

Projects

Project 1: Create a defect report for the Facebook application based on 20 test scenarios and 30 test cases using JIRA
  • Create the Excel document with Test Scenarios Test cases and defect reports as per the template shared
  • Create a Story in JIRA and attach the Sheet of test scenarios,test cases,and defect sheet.
  • Create the 10 defects and provide the steps to reproduce them in detail
Project 2:Create a defect report for the Amazon application based on 20 test scenarios and 30 test cases using JIRA
  • Create the Excel document with Test Scenarios Test cases and defect reports as per the template shared
  • Create a Story in JIRA and attach the Sheet of test scenarios,test cases,and defect sheet.
  • Create the 10 defects and provide the steps to reproduce them in detail

Career Progression

Learning Path

Road Map of Manual Testing Course :

Learning Path

Course Curriculum

Course Curriculum

Fundamentals of 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)

Lab Session:

  • JIRA Tool Creating the Project, Test Cases, Basic Tool Handling
Fundamental Test Process
  • Fundamental Test Process (Overview of Understanding Requirements and Creating Test Scenarios, Test design, Test Planning, Test Execution, Test Report)
  • STLC

Lab Session:

  • Understanding Requirements and Creating Test Scenarios
Test Types & Test Levels

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
Test Design Techniques
  • Experience-Based Techniques
  • Tracibility Matrix & Test Coverage
  • Defect Life Cycle, Priority & Severity of Defects
  • Real Time Defect Reporting and Practicals

Lab Session

  • JIRA Tool Set Up for Tracibility Matrix & Test Coverage
  • ZEPHYR Tool: Defects Reporting
Test Management
  • Test Organization
  • Test Plans, Estimates, and Strategies
  • Test Progress Monitoring and Control
  • Entry & Exit Criteria

Lab Sessions : Creating Defects in Jira

  • Practilcals on Creating Defects in Jira

Lab Sessions : Creating Test Cases From Requirement

  • Practical on Jira Tool for Assignements and Project Work
Introduction to API Testing (via Postman Tool)
  • API Testing (Manual Postman)
  • Why API
  • Types of API (Rest & SoapUI)
  • API Collection
  • Basic of API Testing (Get, Post, Put and Delete)

Lab Session

  • Postman Setup, CRUD Functionalities
Introduction to Selenium
  • What is Automation?
  • Why Automation (Manual vs Automation)? 
  • Scope of Automation Tester in Market
  • What is Selenium? Why Selenium?
  • Advantages of Using Selenium?

Value Added Courses

MySQL
  • 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