Category Archives: Software Testing

Selenium Online Training

Selenium Online Training Course Content
Introduction
Different flavors in Selenium
  • IDE
  • Selenium Web Driver/Selenium 2.0
  • Selenium-Grid
Selenium IDE
  • Installing Selenium IDE
  • Selenium IDE icons
  • Recording your first test with Selenium IDE
  • IDE Context Menu
  • Assert
  • Verify
  • Adding Selenium IDE comments
  • Synchronization commands
  • Working on pages with AJAX
  • Storing elements
  • Creating test suites
  • What you cannot record
Locators & Object Identification
  • Tools to identify elements/objects
  • Firebug
  • IE Developer tools
  • Google Chrome Developer tools
  • Locating elements by ID
  • Finding elements by name
  • Finding elements by link text
  • Finding elements by XPath
  • Finding Elements by using CSS
  • Summary
  • Some Special IDE commands
  • Write your own Selenium IDE script without record and playback
Java For WebDriver
> Introducing the JAVA technology:
  • Relating Java with other languages
  • Showing how to download, install, and configure the Java environment on a Windows system
  • Key features of the technology and advantages of using Java
  • Java Features
  • Write Simple Java Program
  • Compile and Run the class files
  • Java Programming format
  • Java Keywords
  • Java Data Types
  • Declarations and Access Control
  • Operators and Assignments
  • Flow Control
  • Typecasting
  • Arrays
> Packages:
  • Introduction to all predefined packages
  • User Defined Packages
  • Access Specifiers
> Object Oriented Programming Concepts:
  • Introduction
  • Class
  • Object
  • Local, Instance and static variables
  • Constructors
  • This keyword
  • Inheritance and Types
  • Working with super classes and subclasses
  • Using types of polymorphism such as overloading, overriding, and dynamic
  • binding
  • Abstraction
  • Encapsulation
  • Abstract classes
  • Interfaces
> String Processing:
  • String manipulation with String Builder and String Buffer
  • Essential String Methods
> Exceptions and Assertions:
  • Introduction
  • Exceptions categories
  • Standard Java Exception classes
  • Using Try-catch and finally clause
> I/O Streams:
  • I/O using Java
  • Files (Create/Read/Write operations on files)
> Wrapper Classes:
  • Introduction
  • Byte, Short, Integer, Long
  • Float, Double
  • Character
  • Boolean classes
> Collections:
  • Introduction to Collections framework
  • util Package
  • List, Set and Map
  • Difference of All Collections Interfaces and classes
  • Reading data from Property files using java program
  • Reading and Writing data from/to Excel files using Apache POI API and JXL API
Junit Frame Work:
  • Running Java Programs using junit
  • Writing Selenium tests from scratch using Junit FrameWork
  • JUNIT Annotations
  • JUNIT Methods
  • Frequently used Selenium commands
  • Test Suites using JUNIT
  • Parameterized test cases using junit framework
TestNG Framework
  • Overview of TestNG
  • Environment of TestNG
  • Writing WebDriver Test Cases using TestNG
  • Basic Annotations of TestNG
  • Executing Tests
  • Executing Test Suites
  • Ignore Test
  • Dependency Test
  • Parameterized Tests
  • TestNG XML
  • Report Generation
Selenium WEB-DRIVER
  • Why Web Driver?
  • Downloading web driver Jars configuring in eclipse
  • Architecture of selenium webdriver
  • Drivers for Firefox, IE, Chrome, Iphone, Android etc
  • What is the difference between Selenium RC and WD?
Sample programs in web driver
  • Handel Text box
  • Handel HyperLink
  • Handel Button and Check box
  • Handel Radio Button and DropDown Controls
  • Select value from DropDown
  • Display all values
  • Select values step by step
  • Capture screenshots
  • Synchronization Commands In Web Driver
  • Why Implicit wait and Implementation of Implicit wait
  • Why Explicit wait and Implementation of Explicit wait
  • Web Driver Fluent wait and Thread Sleep functionality
  • File uploads and File downloads (Handling Window based controls using Robot and Sikuli API)
  • Handling alerts box and Verfying the Alert Texts
  • Handling confirmation messages
  • Keyboard actions
  • Mouse actions
  • Handling Iframes working with Nested Iframes
  • Handling multiple tabs
  • Handling popups
  • Preparing web driver test cases using customized x-path
  • Identifying controls using x-path predefined functions
  • Web Tables
  • What is Web Table
  • Extracting data from web tables
  • Examples on static and dynamic Web Tables
  • Creating Reusable functions for Web Tables
  • Web Driver with TEST NG Frame Work
  • Batch Running Test cases using TestNG
  • Validations and its usage in Automation test scripts
  • Customized Report Generation
  • Implementing Logs using Apache Log4j API
  • Database testing using Web Driver
Working with multiple browsers
  • Executing Automation Test Cases in multiple browsers Sequentially
  • Working with Chrome and IE browsers
  • What is Firefox Profile And Implementation of Firefox Profile
  • What is WebDriver Desired Capabilities class
  • Executing Automation Test Cases in multiple browsers Parallel
  • Maven Project Management Tool

 

  • Introduction about maven
  • High Level Overview
  • Ant vs Maven
  • Installation of Maven
  • Demo using Sample Maven Project
  • Maven Structure

 

  • Introduction of Maven Folder Structure
  • The pom.xml
  • Dependencies
  • Goals
  • Local Reo Structure
  • Defaults
  • Sample Demo of Build Session of Maven Project
  • Maven Dependencies
  • Dependency version
  • Versions
  • Types
  • Transitive Dependencies
  • Scopes
  • Maven Repositories
  • What is a Repository
  • Dependency Repository
  • Adding a Repository
  • Plugin Repository
  • Maven Eclipse Integration
  • Demo Installation
  • Importing Projects
  • Converting Existing Projects
  • Pom Viewer
  • Effective Pom
Version controlling tool GITHUB
  • Downloading and configuring Github
  • Difference between CVC Versus DVC
  • Basic Git Commands
  • Working with Repositories
  • Setting up Repositories
  • Local and Remote Repositories
  • Create repository and cloning projects
  • Committing and Syncing the code
  • Reverting and Rolling Back the Code
  • Branch and Merging Concepts and Implementation
  • Stashing Changes
  • Resolving the Conflicts
Database testing using web driver
  • Installing MySQL Database
  • sql package
  • Overview on Connection Interface, Statement Interface, Prepared Statement and Result set Interfaces.
  • Example program to Access Database.
  • Some examples on SELECT,UPDATE and DELETE queues
  • Some Web driver examples using Data fetched from Database
Automation Test Frame Work

How to develop Test automation frame work in live environment

  • What is a frame work
  • Types of frame work
  • Data driven frame work
  • Modular driven frame work
  • Keyword driven frame work
  • User Defined Keyword driven framework with implementation
  • Execute test scripts from the framework
Continuous Integration Testing using Jenkins
  • About Jenkins
  • History of Jenkins
  • Splitting of Projects
  • What is Continues Integration
  • Installing Jenkins
  • Creating a simple job
  • Integrating Jenkins to the Project
The Fundamentals of RESTFul Services in Java
  • What is Jersey?
  • RESTFul Architecture
  • Using HTTP GET Demo
  • Test Created New REST Service USING HTTP GET
  • JSON Output for HTTP GET
  • Using HTTP POST Demo
  • Test Service USING HTTP POST
  • JSON Output for HTTP POST
  • Using HTTP PUT Demo
  • Test Service USING HTTP PUT
  • PUT vs POST
  • JSON Output for HTTP PUT
  • Using HTTP DELETE Demo
  • Test Service USING HTTP DELETE
  • JSON Output for HTTP DELETE
Interview Questions on
  • Selenium IDE
  • Selenium webdriver and Automation Testing
  • Core Java
  • Manual Testing Concepts
  • Overview on Selenium Grid

 

MS SQL Server Online Training

MS SQL Server Online Training Course Content

What is an MS SQL Server? MS SQL Server Online Training

SQL Server is Relational Database Management System (RDBMS). It is a full-featured Database primarily designed to against competitors Oracle DB Database and MySQL. Like SQL Server supports ANSI SQL, RBDMS, the standard SQL language.

Module I : SQL & T-SQL Server

SQL Server Introduction & Installation
SQL Server Database Design
SQL Server Table Design
Normal Forms, Keys & Constraints
Views, Joins and Sub Queries

Module II : T-SQL Queries & Programming

Indexes and Query Tuning
Stored Procedures (SPs) & Tuning
Cursors and Joins with Procedures (SPs)
Functions (UDF) and Sub Queries
Triggers and Data Audits, DTC
Module III : Real Time Project
Understanding Real-time Databases
Multi Server Data Access, Query Tuning

Linked Servers and Data Distribution
Configuring Linked Servers (Remote)
sp_addlinkedserver & sp_addsrvlogin
SQL Server & Non-SQL Server Products
Using MSDTC for Remote Queries
Using OPENROWSET for Remote Queries
Multi User and Multi Database Access
Real-world Query Blockings & Solutions
Self Joins and CTEs – Query Tuning
Using CTE and Temp Tables in SProcs
Transactions in Procedures (SPs), Functions

Understanding Transactions Concepts
ACID Properties, Transaction Types
EXPLICIT Transactions and Usage
IMPLICIT Transaction Types, Options
AUTOCOMMIT Transaction Advantages
Transactions Nesting – Rules & Usage
SAVEPOINT, Query Blocking Scenarios
Lock Hints and Remote CTE Queries
XML Data and Full Text Search (FTS)

XML Formats and Query Options
Sub Queries in T-SQL with XML
Releated Sub Queries with XML
XML PATH and Custom ROOT Options
Indexing XML Data for Performance
XML Operations on Views, Synonyms
Nested Queries & XML Limitations
KEYSET Cursors with XML Options
Full Text Search Service Options
Full Text Catalog and FT Indexes
Storing BLOB / CLOB Data (Docs, Pdf)
BULK..INSERT Commands – Options
OPENROWSET and Bulk Data Loads
SQL Server Architecture (Detailed)

Gearing for 70-461 Certification
Client Server Architecture – Detailed
TCP/IP, Named Pipes, Shared Memory
TDS Packets and Network Options
Storage Architecture, Transaction, IO
Query Parse, Optimizer, Mini LSN
Write Ahead Log, Lazy Writer Threads
SQL Engine and SQL Manager @ Query
SQLOS and Thread, Log Schedulers