top of page

SoapUi with Pl/SQL Online Training

Course Duration: 30 hours

Phone Operator

Course Content

SoapUi with Pl/SQL Online Training

Installation of SoapUI

  • Installing SoapUI

  • Setup of SoapUI

  • Installation of SoapUI pro

  • Setup of SoapUI pro

Get to Know about web services

  • Web Service Architecture

  • Web Services Concepts

  • Types of web services

  • SOAP

  • WSDL

  • UDDI

  • What is a Service-oriented Architecture?

  • Why SOA?

  • SOA Testing Methodology

  • SOA test challenges

Working with SoapUI tool

  • Creating Workspace

  • Adding projects to Workspace

  • Creating Project/Importing Project

  • Creating Requests for project operations

  • Creating Test Suites

  • Creating Test Cases

  • Creating Test Steps

  • Wsdl project

SOAP & WSDL

  • Soap Usage

  • Soap message structure

  • Soap detailed explanation

  • Soap encoding rules

  • SOA examples

  • WSDL usage

  • WSDL doc structure

  • WSDL examples

  • Request, Response

Data-driven testing

  • DataSource

  • DataSourceLoop

  • DataSink

  • Assertions

Assertions, Xpath & Loops

  • Conditional Goto

  • Assertions in SoapUI

  • Assertion – Contains & Not contains

  • Xpath match

  • SOAP/Not-SOAP

  • Contains/Not Contains

  • SOAP fault/Not-SOAP fault

  • Response SLA

  • XPath match

  • JDBC Timeout / JDBC Status

Transferring properties

  • Passing values between Test Steps

  • Passing values between Operations

  • Passing values between Services

  • TestRequests

  • Properties

  • Property transfer

  • Response to Request transfer

  • Global to Test case

Groovy scripting

  • What is Groovy Scripting

  • Similar to JVM

  • Printing logs

  • Defining Variable

  • Operators

  • Loosely Coupled Data types

  • if else Simulator

  • For loop

  • For enhanced loop

  • While loop

  • Arrays

  • Assert

  • Arrays

  • Exceptions

  • List

  • ArrayList

  • Hasttable

  • Map

  • Set

  • Exercises

  • Context

  • Context TestCase

  • SetProperty Method

  • GetProperty Method

  • Accessing properties from Context

  • Accessing request and response from Context variable

  • Xml Holder

  • Accessing nodevalues with Xml Holder

  • Exercises on above functionalities

  • Parsing Xml With XmlHolder

  • Groovy Utils Xml Holder

  • SetNodeValue property

  • getXml Method

  • Update the XML

  • TestRunner

  • Scope of testRunner

  • Traverse to Project level using testRunner

  • Traverse to Test Suite level using testRunner

  • Accessing the project level properties from TestRunner

Restfull Webservices

  • Introduction to Rest

  • Overview of Rest Architecure

  • Rest Advantages

  • Difference between SoapProtocol/Rest

  • Http Methods Get,Post

  • Crud Operations

  • Rest Services Exposed by google/Twitter

  • Rest Resources

  • Multiple Representations

  • Rest methods/Requests

PL/SQL basics

  • Introduction to Programming Languages

  • Introduction to PL/SQL

  • The Advantages of PL/SQL

  • PL/SQL Architecture

  • PL/SQL Data types

  • Variable and Constants

  • Using Built_in Functions

  • Conditional and Unconditional Statements

  • Simple if, if… else, nested if..else, if..else Ladder

  • Selection Case, Simple Case, GOTO Label   and EXIT

  • Iterations in PL/SQL

    • Simple LOOP,WHILE LOOP,FOR LOOP   and NESTED LOOPS

    • SQL within PL/SQL

    • Composite Data types (Complete)

    • Cursor Management in PL/SQL

    • Implicit Cursors

    • Explicit Cursors

    • Cursor Attributes

    • Cursor with Parameters

EXCEPTIONS in PL/SQL

  • Types of exceptions :

  • User Defined Exceptions

  • Pre Defined Exceptions

  • RAISE_APPLICATION_ERROR

  • PRAGMA_AUTONOMOUS_TRANSACTION

  • SQL Error Code Values

Database Triggers in PL/SQL

  • Types of Triggers

  • Row Level Triggers

  • Statement Level Triggers

  • DDL Triggers

  • Trigger Auditing

Advanced Soapui with PL/SQL

  • Conversion service

  • Rapidly test service

  • Reusable PL/SQL code to call the service

bottom of page