1. Manual Testing
2. Selenium with Jav
3. SQL

Add-on course with this Package

Live Online Classes

• Selenium with Python
• Cucumber
• DevOps
• Jira & Agile
• Project
• Aptitude
• Spoken English

Average Salaries: ₹ 3.5L – ₹ 8L Per Annum

Hiring Companies: TCS, Accenture, Amazon , CISCO, Capgemini  Etc

Course Fees: 25000 + Tax = ₹  29500

Manual Testing

• Introduction to testing
• Verification vs validation
• Types of Applications
• Probabilities of getting an error in an application
• SDLC – Software Development Life Cycle
  • Waterfall
  • Prototype
  • Spiral
  • Incremental(Agile methodology and Scrum Framework)
  • V-Model
• Advantages and Disadvantages of each software development life cycle
• Principles of Testing
• STLC –Software Testing Life Cycle
• Difference between Test case, Use case and Scenario.
• How to prepare test plan and strategy
• How to Prepare a test case template?
• Difference between Error, bug, defect, and failure
• Test Case Design Technique
  • Boundary Value Analysis
  • Equivalence Partitioning
  • Decision Table
  • State Transition Diagram
  • Use Case Testing
• Bug Life cycle
• How to Prepare the Bug template?
• Bug Tracking tool
• Types of Testing
• Difference between Static and Dynamic testing
• Difference between Functional and Non-functional testing
• Black box testing and its types
• White box testing and its types
• System Integration Testing vs User Acceptance Testing
• Entry Criteria and Exit Criteria
• Test Environment and Test data preparation
• Flow graph notations
  • Statement coverage
  • Branch Coverage
  • path coverage
  • Cyclometric Complexity
• Integration testing
  • Big Bang Integration
  • Incremental Approach – Top-Down, Bottom-up, and Hybrid
• Requirement traceability matrix

Selenium with Java

Introduction

• Introduction of selenium
• Selenium components
• How differs from other automation tools
• Advantages of selenium
• Overview of the Testing framework
• Overview of Eclipse

Object-Oriented Programming

• Creating Packages
• Accessing Classes and Methods
• Class, Object and Method
• Concept of Inheritance
• Overloading and Overriding Functions
• Usage of Inheritance in Selenium
• Good Features of the eclipse
• Accessing modifiers – Public, Private, Default, Protected
• Exception handling – try-catch block and throwable class
• The need for exception handling in Selenium framework

Core Java Basics

• Conditional and concatenation operators
• Usage of loops – While Loop, For Loops
• Data Types – String, Integer, Arrays, etc
• Functions – Input Parameters, Return Types
• Local, Global, Static and Non-Static Variables
• Creating Objects and Object References
• Call by reference and Value
• Constructors
• String class and functions
• Concept of jar file
• POI API in java

Selenium Architecture

• Types of Selenium
• Types of Webdriver
• Selenium RC Architecture
• Webdriver Architecture
• Webdriver Vs Selenium RC
• A brief explanation about the advantages of web driver

Locator Techniques

• Introduction about locator concept
• A brief explanation of different locator techniques
• Xpath techniques explanation with different kind of real-time scenarios

Selenium IDE

• Download and Installation
• Record and playback techniques
• Modifying the script using IDE
• Convert the IDE script into RC script
• Validate the locator value using IDE

Selenium setup

• Explanation of step by step instructions for setup
• Integration of eclipse and Testing

WebDriver

• Configuring Webdriver with Eclipse
• A detailed discussion about web driver commands
• Handling different browsers
• Create our own methods in web driver
• Handling links and Dynamic links
• Extracting and writing your own XPath
• Handling Multiple Windows
• Interacting with dynamic objects
• Working with Alerts
• Locating objects using different objects – ID, Name, CSS, Class, etc
• Handling Frames on the web page
• Taking Screenshots
• Working with textbox and buttons
• Working with a group of Objects
• Test data management in Excel
• Calling Dynamic values from Excel

TestNG

• Brief about the Testing framework and TestNG
• Annotation concept and different types
• Testing Configuration
• Suite execution from eclipse
• Parallel script execution
• Grouping the Test Cases
• Parameter configurations
• Suite creation methodology
• Report generation
• Assertions and Verifications

AutoIT

• The need for AutoIT tool
• Basics of AutoIT tool and create a simple script
• Converting AU3 file to excel  file
• Calling AutoIT script from selenium project

Selenium Grid

• Introduction of Selenium Grid
• Installation and setup of Hub and node
• Script changes for Selenium grid execution
• Simple script execution using grid
• Parallel execution using grid

Configuration Management

• Jenkins Installation
• Maven Installation
• Dependencies and configure Maven Project
• Integrate Maven projects in Jenkins.

SQL Training

Introduction to Oracle Database

• List the features of Oracle Database 11g
• Discuss the basic design, theoretical, and physical aspects of a relational database
• Categorize the different types of SQL statements
• Describe the data set used by the course
• Log on to the database using SQL Developer environment
• Save queries to files and use script files in SQL Developer

Retrieve Data using the SQL SELECT Statement

• List the capabilities of SQL SELECT statements
• Generate a report of data from the output of a basic SELECT statement
• Select All Columns
• Select Specific Columns
• Use Column Heading Defaults
• Use Arithmetic Operators
• Understand Operator Precedence
• Learn the DESCRIBE command to display the table structure

Learn to Restrict and Sort Data

• Write queries that contain a WHERE clause to limit the output retrieved
• List the comparison operators and logical operators that are used in a WHERE clause
• Describe the rules of precedence for comparison and logical operators
• Use character string literals in the WHERE clause
• Write queries that contain an ORDER BY clause to sort the output of a SELECT statement
• Sort output in descending and ascending order

Usage of Single-Row Functions to Customize Output

• Describe the differences between single row and multiple row functions
• Manipulate strings with character function in the SELECT and WHERE clauses
• Manipulate numbers with the ROUND, TRUNC, and MOD functions
• Perform arithmetic with date data
• Manipulate dates with the DATE functions

Invoke Conversion Functions and Conditional Expressions

• Describe implicit and explicit data type conversion
• Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Nest multiple functions
• Apply the NVL, NULLIF, and COALESCE functions to data
• Use conditional IF THEN ELSE logic in a SELECT statement

Aggregate Data Using the Group Functions

• Use the aggregation functions in SELECT statements to produce meaningful reports
• Divide the data in groups by using the GROUP BY clause
• Exclude groups of date by using the HAVING clause

Display Data From Multiple Tables Using Joins

• Write SELECT statements to access data from more than one table
• View data that generally does not meet a join condition by using outer joins
• Join a table by using a self join

Use Sub-queries to Solve Queries

• Describe the types of problem that sub-queries can solve
• Define sub-queries
• List the types of sub-queries
• Write single-row and multiple-row sub-queries

The SET Operators

• Describe the SET operators
• Use a SET operator to combine multiple queries into a single query
• Control the order of rows returned

Data Manipulation Statements

• Describe each DML statement
• Insert rows into a table
• Change rows in a table by the UPDATE statement
• Delete rows from a table with the DELETE statement
• Save and discard changes with the COMMIT and ROLLBACK statements
• Explain read consistency

Use of DDL Statements to Create and Manage Tables

• Categorize the main database objects
• Review the table structure
• List the data types available for columns
• Create a simple table
• Decipher how constraints can be created at table creation
• Describe how schema objects work

Other Schema Objects

• Create a simple and complex view
• Retrieve data from views
• Create, maintain, and use sequences
• Create and maintain indexes
• Create private and public synonyms

Control User Access

• Differentiate system privileges from object privileges
• Create Users
• Grant System Privileges
• Create and Grant Privileges to a Role
• Change Your Password
• Grant Object Privileges
• How to pass on privileges?
• Revoke Object Privileges

Management of Schema Objects

• Add, Modify and Drop a Column
• Add, Drop and Defer a Constraint
• How to enable and disable a Constraint?
• Create and Remove Indexes
• Create a Function-Based Index
• Perform Flashback Operations
• Create an External Table by Using ORACLE_LOADER and by Using ORACLE_DATAPUMP
• Query External Tables

Manage Objects with Data Dictionary Views

• Explain the data dictionary
• Use the Dictionary Views
• USER_OBJECTS and ALL_OBJECTS Views
• Table and Column Information
• Query the dictionary views for constraint information
• Query the dictionary views for view, sequence, index and synonym information
• Add a comment to a table
• Query the dictionary views for comment information

Manipulate Large Data Sets

• Use Subqueries to Manipulate Data
• Retrieve Data Using a Subquery as Source
• Insert Using a Subquery as a Target
• Usage of the WITH CHECK OPTION Keyword on DML Statements
• List the types of Multitable INSERT Statements
• Use Multitable INSERT Statements
• Merge rows in a table
• Track Changes in Data over a period of time

Data Management in Different Time Zones

• Time Zones
• CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP
• Compare Date and Time in a Session’s Time Zone
• DBTIMEZONE and SESSIONTIMEZONE
• Difference between DATE and TIMESTAMP
• INTERVAL Data Types
• Use EXTRACT, TZ_OFFSET and FROM_TZ
• Invoke TO_TIMESTAMP,TO_YMINTERVAL and TO_DSINTERVAL

Retrieve Data Using Sub-queries

• Multiple-Column Subqueries
• Pairwise and Nonpairwise Comparison
• Scalar Subquery Expressions
• Solve problems with Correlated Subqueries
• Update and Delete Rows Using Correlated Subqueries
• The EXISTS and NOT EXISTS operators
• Invoke the WITH clause
• The Recursive WITH clause

Regular Expression Support

• Use the Regular Expressions Functions and Conditions in SQL
• Use Meta Characters with Regular Expressions
• Perform a Basic Search using the REGEXP_LIKE function
• Find patterns using the REGEXP_INSTR function
• Extract Substrings using the REGEXP_SUBSTR function
• Replace Patterns Using the REGEXP_REPLACE function
• Usage of Sub-Expressions with Regular Expression Support
• Implement the REGEXP_COUNT function

Selenium with Python

Installation

• Introduction
• Configuration of Python bindings for Selenium
• Installation for Windows users
• Downloading Selenium server
• Basic Python training (If required)

Getting Started

• Simple Usage
• Example Explained
• Using Selenium to write tests
• Walkthrough of the example
• Using Selenium with remote WebDriver

Navigating

• Interacting with the page
• Filling in forms
• Drag and drop
• Moving between windows and frames
• Popup dialogs
• Navigation: history and location
• Cookies

Locating Elements

• Locating by Id
• Locating by Name
• Locating by XPath
• Locating Hyperlinks by Link Text
• Locating Elements by Tag Name
• Locating Elements by Class Name
• Locating Elements by CSS Selectors

Waits

• Explicit Waits
• Implicit Waits

Page Objects

• Test case
• Page object classes
• Page elements
• Locators

WebDriver API

• Exceptions
• Action Chains
• Alerts
• Special Keys
• Locate elements By
• Desired Capabilities
• Utilities
• Firefox WebDriver
• Chrome WebDriver
• Remote WebDriver
• Web Element
• UI Support
• Color Support
• Expected conditions Support

BDD with Cucumber

Module 1 : Introduction to Behaviour driven development

• 1. How BDD Works
• 2. BDD Requirements – Title _ Narrative
• 3. BDD Requirements – Acceptance Criteria
• 4. BDD Requirements – The new approach
• 5. BDD Requirements – Characteristics

Module 2 : Agile and BDD framework

• 1. Agile Framework I
• 2. Agile Framework II
• 3. BDD Framework I
• 4. BDD Framework II
• 5. Implementation

Module 3 : Diving deeper into BDD

• 1. BDD In a Nutshell
• 2. Core of BDD
• 3. BDD as Behavior
• 4. Shared Understanding
• 5. BDD Process
• 6. Relation with TDD
• 7. Story, Feature, Scenario

Module 4 : Cucumber Framework

• 1. Cucumber Framework
• 2. Cucumber Examples Table
• 3. Cucumber Gherkin

Module 5 : Cucumber Framework in Action

• 1. Cucumber In Action
• 2. Cucumber Framework in Action
• 3. Cucumber-Selenium.In Action
• 4. JBehave Framework
• 5. JBehave I
• 6. JBehave II

Module 6 : Behave Framework in Action

• 1. JBehave In Action

Module 7 : Wrapping up

• 1. Benefits
• 2. Challenges
• 3. Conclusion

Module 8 : Course Completion Test

• 1. Take the test

DevOps

Introduction to DevOps

Learning Objective:

This session will help you understand the purpose and the scope of DevOps in the current market, tools and the skills the market is looking for and how the culture is applied in the industries

Topics:

• DevOps Principles in detail
• DevOps Engineer Skills in the market
• Knowing DevOps Delivery Pipeline
• The market trend of DevOps
• DevOps Technical Challenges
• Tools we use in DevOps

Hands-On:

A brainstorming session on the trends in current IT industries

DevOps on Cloud 

Learning Objective:

This session will help you understand how DevOps is currently being used on cloud infrastructure by automating entire setup. Learn cloud setup helps faster releases, fewer software failures and how trendy it is.

Topics:

• Essentials of Cloud computing?
• Cloud and virtualization architecture
• Cloud deployment architecture
• Cloud providers – An overview
• Why we need DevOps on Cloud?
• Introducing to Amazon web services

Hands-on:

• How to setup AWS account
• Various AWS services for Devops – An overview
• DevOps using AWS – Demo

GIT – A version control tool

Learning Objective:

This session will help you understand why version control system streamlines the development of working with different people and makes very easy to collaborate on projects.

Topics:

• Knowing about Version control
• Git – A CLI
• Essentials of GIT in industry
• How to setup GIT
• Working with various commands in GIT
  • Recording Changes to the Repository
    • How to check the Status of Your Files
    • How to track New Files
    • Staging our modified files
    • Ignoring Files from GIT
    • Viewing Your Unstaged and Staged Changes
    • How to commit Your Changes
    • Skipping the Staging Area and commit
    • Removing Files from GIT
  • Viewing the Commit History
    • Limiting Log Output
    • Using a GUI to Visualize History
  • Undoing Things
    • Changing Your Last Commit
    • Unstaging a Staged File
    • Unmodifying a Modified File
  • Working with Remotes
    • Showing Your Remotes
    • Adding Remote Repositories
    • Fetching and Pulling from Your Remotes
    • Pushing to Your Remotes
    • Inspecting a Remote
    • Removing and Renaming Remotes
  • Branching and Merging in Git
    • What a Branch Is
    • Basic in Branching and Merging
    • Branch Management in GIT
    • Branching Workflows and its usage
    • Remote Branches – create and delete
    • Rebasing
  • Git workflows
  • Git cheat sheet

Hands-on exercises:

• Installing Git
• First-Time Git Setup
• Getting a Git Repository
• Working with various git commands
• Working with Local repository vs remote repository
• Managing remote repository
• Stashing operations and various local repository operations
• Branching and merging operations
• Resolving conflicts during merges
• Managing access on repository managements

Jenkins – Continuous integration 

Learning Objective:

This session will help you understand why Jenkins is evolving as a must tool in the current DevOps practices. Understanding how Jenkins allowing current industries to set up their build pipelines with a more quickly and sophisticated build process by drastically reducing the risks in the software development lifecycles.

Topics:

• Essentials of Continuous Integration
• An example scenario where CI is used
• Know about Jenkins and its architecture in detail
• Jenkins tool Management in detail
• Know about User management in Jenkins
  • Authentication
    • Jenkins own database user creation
    • Options to enable integration with LDAP
  • Authorization
    • Matrix-based authorization
    • Project-based authorization
  • Overview of Maven
    • Maven project structure
    • Maven plugins
    • Project Object Model (POM) – the fundamental unit of work in Maven project
    • Maven build lifecycle
    • Adding external dependencies to maven pom.xml
    • Maven build and test project
  • Creating jobs and automatic build settings
    • What is Jenkins Pipeline?
    • Why Pipeline?
    • Integration with GIT
    • How to enable project-based authorization for a job
    • Source code management while creating jobs
    • Triggering automated build
    • Maven job setup
    • Know about post-build options for jobs like notifications, trigger another build, publishing reports, etc.
  • Adding a slave node to Jenkins
  • Building Delivery Pipeline
  • Notification settings in Jenkins
  • Plugin management in Jenkins

Hands-on Lab:

• Installing Jenkins
• Post-installation setup wizard
  • Unlocking Jenkins
  • Customizing Jenkins with plugins
  • Creating the first administrator user
• Administration of Jenkins
• User management – Authentication and Authorization
• Master-slave set up on Jenkins
• Creating basic jobs to pull code from GitHub
• Jobs to perform individual operations
• Setup build pipeline
• Understanding build triggers, build and post-build operations
• Deploying an application to a container using Jenkins

Docker – A containerization technology

Learning Objective:

This session will help you understand why Docker knowledge is required in order to master DevOps cultures in the current IT industry Understanding containerizing the application is also isolating that into a completely separated environment.

Topics:

• Introduction
  • Real-world Shipping Transportation Challenges
  • Introducing Docker and its technology
  • Understanding of Docker images and containers
• Working with container
  • How to Share and copy a container
  • Container Life Cycle
  • How to use Base Image and customize
  • Creation of Docker File
  • How to Publish Image on Docker Hub
• Introduction to Docker Networking
  • Network Types in docker technology
  • Docker Container Networking
  • Docker Compose – An introduction
• Docker Swarm – An introduction
  • Use Docker Compose to create PHP, WordPress, MySQL
  • How to Start Containers on a Cluster with Docker Swarm
  • Creating and Scaling an application in Docker swarm

Hands-on:

• How to setup docker-engine
• How to run docker container from pulling image from public repo
• How do we create a docker file
• Creating different docker files for different application
• Creating a docker-compose file to deploy multi-container
• Creating docker custom bridge networks
• Creating docker swarm cluster
• Orchestration of container using swarm cluster

Kubernetes 

Learning Objective:

This session will help you understand how Kubernetes helps to orchestrate the Docker containers. How the opensource system helps to automate the deployment, scaling and managing the containers.

Topics:

• Introduction to Kubernetes
• Kubernetes Cluster Architecture – An overview
• Understanding concepts of Pods, Replica sets, deployments and namespaces
• Understanding the concepts of services and networking
• Persistent volumes and persistent volume claims – an overview
• Design of Pods
• Understanding labels, selectors, jobs, and schedulers

Hands-on:

• Setting up the Kubernetes Cluster
• Deploying an app through Kubernetes Dashboard
• Accessing the application through service
• Rolling updates in Kubernetes
• Creating and adding volumes

Ansible – A configuration Management

Learning Objective:

This session will help you understand how significantly Ansible reduces your coding hours with the configuration management tool. Understanding most popular configuration management tool to set up easily, configure easily and deploy IT infrastructure easily.

Topics:

• Introducing Ansible – A configuration management tool
  • Basics / What Will Be Installed
  • Understanding Ansible architecture
  • Control Machine Requirements
  • Managed Node Requirements
• Inventory
  • Hosts and Groups
  • Host Variables
  • Group Variables
• Learn various Ansible Modules
• How to use Adhoc commands
  • Parallelism and Shell Commands
  • File Transfer
  • Managing Packages
  • Users and Groups
  • Deploying From Source Control
  • Managing Services
• Introduction to YAML script
• Playbook
  • About Playbooks
  • Playbook Language Example – YAML
  • How to Write Playbooks
  • Tasks in Playbooks
  • Understanding about various tasks in the playbook
  • Introduction to Handlers and variables
  • Learn about using handlers, variables in the playbook
  • Become (Privilege Escalation)
• Roles
  • Role of Directory Structure
  • Using Roles
  • Role Duplication and Execution
  • Role Default Variables
  • Role Dependencies
  • Role Search Path
  • Ansible Galaxy
• Including and Importing
  • Includes vs. Imports
  • Importing Playbooks
  • Including and Importing Task Files
  • Including and Importing Roles

Hands-on:

• How to setup Ansible server and target servers
• Writing Adhoc commands to install and configure the servers
• Writing a playbook to install and configure webservers and deplo0y an application
• How to create Ansible Role and use it
• Using an ansible role in a playbook
• How to use Ansible Galaxy to download roles.
• Example – Install and use Jenkins roles from ansible-galaxy

AGILE Training

MODULE 1. Introduction to AGILE ( 4Hrs)

• Roles in Agile
• Cross-functional Team
• How an Agile Team Plans its Work?
• What is a User Story?
• Relationship of User Stories and Tasks
• When a Story is Done
• What is Acceptance Criteria?
• How the Requirements are Defined?

MODULE 2. AGILE – MANIFESTO (3 Hrs)    

• Twelve Principles of Agile Manifesto

MODULE 3. AGILE – CHARACTERISTICS ( 4 Hrs)       

• Iterative/incremental and Ready to Evolve
• Face-to-face Communication
• Feedback Loop

MODULE 4. AGILE – DAILY STAND-UP (4 Hrs) 

• What is Daily Stand-up?
• Why Stand-up is Important?
• Who Attends a Stand-up?
• Geographically Dispersed Teams

MODULE 5. AGILE – DEFINITION OF DONE (4 Hrs)        

• User Story
• Iteration
• Release

MODULE 6. AGILE – RELEASE PLANNING (4 Hrs)        

• Release Planning
• Who is Involved?
• Prerequisites of Planning
• Materials Required
• Planning Data
• Output
• Agenda

MODULE 7. AGILE – ITERATION PLANNING (4 Hrs)       

• Iteration Planning
• Who is Involved?
• Prerequisites of Planning
• Planning Process
• Velocity Calculation
• Task Capacity
• Planning Steps

MODULE 8. AGILE – PRODUCT BACKLOG (3 Hrs)       

• Product Backlog
• Why Product Backlog is Important?
• Characteristics of Product Backlog