Software Testing course Beginner level by 3RI Technologies Pvt Ltd

Manual Testing

1. Fundamentals of Testing
What is Software Testing?
What is Software Bug
Testing Principles
When to Start/Stop Testing?
2. Application Architecture
Desktop/Standalone Environment
Client Server Environment
Web Based Environment
3. SDLC and STLC
SDLC Phases
Various SDLC Models
Waterfall Model
Iterative and Incremental model
STLC Phases
Types of Testing
Methods of Testing
Static and Dynamic Testing
4. Verification and Validation
Verification
Methods of Verification
Validation
Levels of Testing
V Model
5. Functional and Non Functional testing
Functional Testing
o Unit Testing
o Integration Testing
o System Testing
o User Acceptance Testing
o Regression Testing
o Retesting

Non Functional Testing
o Performance Testing
o Load Testing
o Stress Testing
o UI and Usability Testing
o Security Testing
o Portability Testing
o Compatibility Testing
Other Special Testing Types
6. Test Management
Test Plan Template
Usecase Testing
Scenario Testing
Testcases & Test Data
Testcases Template
Test Design Technique
7. Defect Management
What is Defect/Bug?
Reason for Defects in Software
Defect Tracking System
Defect Life Cycle
Attributes of Defect
8. Bugzilla Defect Tracking Tool
How to Report a Bugs
Priority of Bugs
Report Generation
9. Quality Center (QC-Overview)
Opening QC
Requirements tab
Test Plan tab
Test lab tab
Defects tab
Report and analysis of result

Database Concepts (Oracle SQL)

1. Introduction to Database
2. DBMS, RDBMS, ORDBMS
3. DDL, DML, DCL, TCL
4. Data types
5. SELECT Statement
6. Restricting and Sorting Data
7. Aggregating Data using Group Functions
8. Manipulating Data
9. Sub queries
10. Important Functions
11. Joins and different types

Module II: Automation Testing Tool (SELENIUM)
Core Java

1. Overview of Java
OOPs , Data Types and Variables
Operators, Control Structures
Strings, Arrays
2. Objects and Classes
Object, Classes and Methods
Method Overloading
Constructors
3. Inheritance
Types of Inheritance
Method Overriding
4. Packages and Interfaces
Defining Packages
Extending Interfaces
5. Exception Handling
Fundamentals of Exception Handling
Exception types
Try and Catch and finally
Multiple Catch
6. Collections Framework
Collection Interfaces and Classes
Iterator, Map , HashMap

Basic Selenium

1. Introduction to Automation Testing
What is Automation Testing?
Which Test Cases to Automate?
Different Automation tools
Automation challenges & Mitigations
2. Introduction to selenium
What is selenium?
History and various versions of selenium
Advantages of using Selenium over other tools.
Selenium components
3. Selenium-IDE
Introduction
IDE Features
Building & Running Test Cases
Building and Running Test Suites
4. Selenium Web Driver 2.0
Why Selenium Web Driver
Automation Setup for Selenium Web Driver
Configuration of Selenium Jar using Eclipse
5. Selenium Commands
What is a Driver
Different methods of finding element
o By ID, By name
o By Xpath, By Tag name
o By class name
o By Link text

Various types of operation that can be performed on any elements and how to use them.
capturing Screen shots
Handling Keyboard Event and Mouse Event
Multiple Window Handling
Pop Up Handling.
Preparing basic Automation Scripts and running them
Creating Re usable class and their implementation in creating Test Scripts
Parameterizing Test Scripts using Excel
Creating Test Suites

Advanced Selenium
1. Framework Designing
What is Framework
What is a Framework?
Different Types of Framework.
How to Design a framework?
Data Driven Framework using Excel
Keywork Framework
Hybrid Framework
2. TestNg Framework
Test NG & TestNG features
How to integrate TestNG with Eclipse
Test NG Annotations
TestNG Reporting
3. POM Framework
Advantages of POM
How to implement
Using Page Object and Page Factory
4. Reporting
Using Report NG for generating reports through TestNG
Log4j -What is Log4j, how to use it, integration of Log4j with Eclipse
5. Build Tools -Maven
How to create a maven project in Eclipse
Maven Build Cycles.
How to compile and Run tests using Maven
6. Continuous Build Integration tools- Jenkins
What is Jenkins and how to use it
How to integrate Jenkins with Eclipse
7. Selenium Grid
Introduction & Architecture of Selenium Grid
Configuration of Selenium Grid(Hub And Node)
Writing a Sample Script using Selenium
Some Practice and Sample Programming using Grid
Hands on Experience on Industry Project, Mock Tests & Interview Tips

Datawarehousing - ETL Testing
Duration: 7-8 Weekend (Sat/Sunday Batch)
Prerequisites
Knowledge of Manual Testing
Knowledge of DBMS/SQL basics is advantageous.
Course Content

I. Database/SQL
RDBMS Concepts
o Data Models
o Entity Relationship Model
o Normalization
o DBMS, RDBMS, ORDBMS
SQL Overview
o Introduction to SQL
o Data types
o SELECT Statement
o Operators
o Pseduo Column
SQL Statements
o Data Definition Language (DDL)
o Data Manipulation Language (DML)
o Transaction Control Language (TCL)
o Data Control language (DCL)
Join
o Inner/Equi Join
o Non-Equi/Cross Join
o Self Join
o Outer Join
Constraints
o Primary Key Constraint
o Foreign Key Constraint
o Unique Key Constraint
o Not Null Constraint
o Check Constraint
Set Operator
o Union
o Union All
o Intersection
o Minus
Sub Query
o Sub/Inner Query
o Correlated Sub Query
Object
o Index
o Synonym
o View
Built-in Functions
o Aggregate Functions
o Character Function
o String Functions
o Case Manipulation Functions
o Date Functions
o Analytical Functions

II. Datawarehouse/ETL
Datawarehouse Fundamental
o Datawarehouse Overview
o DWH Characteristics
o Types of Datawarehouse
o Data Mart
o Database vs Data Warehouse
o Data Mart vs Data Warehouse
o Data Warehouse benefits
o DWH Architecture
Datawarehouse Terminologies
o Data Cleansing, Partitioning
o Staging area, Metadata
o OLTP, OLAP, ROLAP, MOLAP
o Surrogate Key
o Snapshot, View and Materialized View
o Meta Data, Data Mining & Data Cube
Dimension Modeling
o Facts and Dimensions
o Hierarchies and Levels
o Measures & DWH Schema
o Star, Snow-flake and Galaxy Schema
o Additive, Semi Additive, Non Additive Fact/Measure
ETL Overview
o Process Flow of ETL
o Types of Sources and Target
o ETL Data Load types
o Active vs Passive transformation
o Extraction Methods in ETL
o Tracing Level
o Types of Data used for ETL Process
Slowly Changing Dimension
o What is Slowly Changing Dimension?
o SCD Types : Type-1, Type-2, Type-3
ETL Testing Process
o Categories of ETL Testing
o Types of ETL Testing
o How to create ETL Test Case
o ETL Test Scenarios and Test Cases
o Types of ETL Bugs/Defects
o Responsibly of ETL Tester
OBIEE/BI Overview
o Introduction to OBIEE
o Business Intelligence Basics
o Overview of Reports
o Slice and Dice
o Roll-up and Drill-down & Pivot
III. Informatica Power Center Tool
Informatica Tool Overview
o Introduction to Informatica
o How developers work on Power Center
o Different components of Power Center and uses
o Tasks performed in different Components
o Mapping, Session, Worklet, Workflow, Mapplet
o Naming Conventions
Designer Component
o Working with Sources
o Working with Flat Files
o Working with Targets
o Data Transformation Source and Target
o Mapping Parameters and Variables
o Uses of Mapping Wizards
Workflow Manager Component
o Workflow Manager Overview
o Workflow Designer
o Task Developer
o Worklet Designer
o Using Workflow Wizard
o Creating a Task
o Configuring Task
o Workflow links
o Validating Tasks,Workflows
o Scheduling and Running Workflows
Workflow Monitor Component
o Workflow Monitor Overview
o Using Workflow Monitor
o Working with Tasks and Workflows
o Workflow and Task Status
o Using Gantt Chart and Task Views
o Session and Workflow Logs
Transformation
o How to use Transformations
o Aggregator Transformation
o Expression Transformation
o Filter Transformation
o Router Transformation
o Union Transformation
o Rank Transformation
o Sorter Transformation
o Joiner Transformation