Scribd
Upload
5 views3 pages

API Testing & DB TestingCourse

The document outlines a 15 to 20-day course on API and Database Testing, covering topics such as web application architecture, API testing methodologies, and the use of tools like Postman. It also includes details on database testing phases, methodologies, and essential SQL coding standards. The course aims to equip participants with the necessary skills for effective API and database testing.

Uploaded by

ssrao.msit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views3 pages

API Testing & DB TestingCourse

The document outlines a 15 to 20-day course on API and Database Testing, covering topics such as web application architecture, API testing methodologies, and the use of tools like Postman. It also includes details on database testing phases, methodologies, and essential SQL coding standards. The course aims to equip participants with the necessary skills for effective API and database testing.

Uploaded by

ssrao.msit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

API Testing & Database Testing

Course Content

Duration : 15 to 20 days

API introduction

 Introduction to web application architecture

 Introduction to APIs

 Introduction to Web-Services

 How does an API works

 What is API testing?


1.
1. What does API Testing involve
2. Validation techniques used in API Testing
3. API Testing Steps
4. Understanding URI, End points, Resources, Http verbs
5. GUI tools available for API Testing
6. Command-line tools available for API Testing
7. Best Practices for API Testing

 Advantages of API

 API vs Web-Services

 Introduction to API architecture, REST API, SOAP API

 Understanding how REST API architecture works

 Understanding how SOAP API architecture works

 Understanding the HTTP methods GET, POST, PUT, DELETE, PATCH, OPTIONS,

HEAD, and Few more


Introduction to Postman API Testing Tool

 What is Postman tool

 Installation of Native Postman tool

 Installation of Postman tool as Chrome Add-on


 Introduction to Postman landscape

 Introduction to Postman Settings

API Testing using Postman


Creating First API request using Postman

 Functional Testing of Web Services

 Understanding History

 Setting up Test Project with REST APIs

 Validating responses with Postman client

 Validating the body of the first JSON response

 Examples of validating response headers and status codes

 Understanding query parameters on sending request Validating status code

 Validating Response time

Database Testing:
What is Database Application?

Testing the Application vs. Testing the DMBS

Back End vs. Front End Testing

QA’ ing Data

Who is responsible?

What should be test in the Database?

Knowledge required for the Database Tester

Database Testing Phases

Database Testing Methodologies

Structural Database Testing

Functional Database Testing

SQL Coding Standards

what you need to know


SQL Basics : Select, Insert, Update and Delete

Using the select Statement to Test data

Using the insert Statement to generate Test data

Testing for application accuracy using the Update and Delete Statements

Testing for basic data integrity using Constraints

Joining Tables
Inner join, Outer Joins, Self Joins.
Using SQL Queries for Data Verification.

SQL SyntaxSQL SelectSQL Select DistinctSQL WhereSQL And, Or, NotSQL


Order BySQL Insert IntoSQL Null ValuesSQL UpdateSQL DeleteSQL Select TopSQL Min and MaxSQL
Count, Avg, SumSQL LikeSQL WildcardsSQL InSQL BetweenSQL AliasesSQL JoinsSQL Inner JoinSQL
Left JoinSQL Right JoinSQL Full JoinSQL Self JoinSQL UnionSQL Group BySQL HavingSQL ExistsSQL
Any, AllSQL Select IntoSQL Insert Into SelectSQL CaseSQL Null FunctionsSQL Stored ProceduresSQL
CommentsSQL Operators

You might also like