Free Workshop on API Testing with Data-Driven: Test Smarter, Not Harder
Isha presents an Extensive and highly interactive “Free Workshop on API Testing with Data-Driven: Test Smarter, Not Harder” by our industry expert with 8 years of hands-on experience.
About the Instructor:
| Rahul has 8 years of experience in Automation Testing. He has worked on various projects which involves Selenium, Cucumber BDD, Data Driven Framework, API Testing using Postman and Rest Assured, Integrating of Code with various database such as SQL, MSSQL, postgresql etc. Interested in becoming a full stack tester and decent developer where I can improve my skills all the time. He has handled various online batches over past 2 years and trained a lot of students from scratch |
Free Workshop Date and Timings:
Learners in India: 24th November @ 7:30 PM to 9:00 PM (IST)
Learners in US: 24th November @ 9 AM to 10:30 AM (EST)
Learners in UK: 24th November @ 2:00 PM to 3:30 PM (BST)
Duration: 1 Hour & 30 Minutes
How can I enroll for this Free Workshop?
OR
Call or WhatsApp on +91-9133190573 to register for a free workshop
Learn and discuss during this Free Workshop:
1. Introduction to Data-Driven Testing :
- Overview:
- What is data-driven testing?
- Why use a database for API testing?
- Scenarios where MS SQL as a data source is beneficial.
2. Setup of Environment:
- Maven Project for JDBC and Rest Assured
- MS SQL AND Java 21
3. Database Fundamentals:
- Creating a DB
- Creating a SQL User
- CRUD Operations
- Connecting with DB and fetching the results from the DB
4. Designing a Data-Driven API Test Framework
- Framework Structure:
- Create reusable methods for database connections.
- API request and response handling using REST Assured.
- Fetching the data dynamically
- Passing the data to the API for testing the API with different sets of data
5.Hands-On Examples:
- Example 1: Testing a GET API with query parameters.
-
-
- Fetch parameters dynamically from the database.
- Validate response fields.
-
-
- Example 2: Testing a POST API with database-driven payload.
-
-
- Retrieve payloads from the database.
- Validate database updates after API call.
-
-
- Example 3: Loop through multiple test cases dynamically:
-
-
- Use data rows for different scenarios (valid/invalid cases).
-
-
6. Q&A and Wrap-Up
Bonus Content: Jayway Expressions
Tools to be installed are MSSQL , JDK 21
