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