Understand what API testing is all about
Understand what database testing is
How to perform API and database testing with C#
Leverage the power of BDD in API and database testing
Requirements
- Good understanding on C#
- Experience in working with automation framework (Since we will use one)
- Basic concepts on BDD and Specflow as we use them as well
Description
Understanding API and database testing with Specflow and C# course is designed in such a way that one can learn
· What are API and database testing
- Understanding what are API
- How to test API
- How to test Databases
· Different tools available to perform API and database testing
o Will go through different tools available for API testing
· Why did we choose Visual studio as the tool for API and database testing
o Understand Visual studio for API testing
o How Visual studio helps in developing better codes
· Consuming a WCF API Web service using a Windows Console application from Visual Studio 2015
· Writing simple code to test the Web service with and without using Specflow C#
o Understand the power of Visual studio and Specflow to write code in Specflow C#
o Power of Specflow of automation testing and writing code with Specflow
· Connecting with Microsoft SQL database server to test data using simple queries
o Understand how to connect with SQL Server database via Visual studio code in C# language.
· Database testing using Stored procedures and C#
· Database testing using Mock stored procedure to test database data with API without user-defined data
· Finally, this course, is simple yet focused on the topic and yet easy to complete in a couple of hours
Who this course is for:
- This course is for both testers and developers
- Any manual test engineer with good knowledge in SQL can also learn this course
Course content
3 sections • 10 lectures • 1h 43m total lengthExpand all sections
Introduction to API and Database Testing2 lectures • 12min
- Introduction05:02
- Part 1 – Setting stage ready for API and Database Testing with Specflow and C#06:40
Writing code to consume and test API services4 lectures • 40min
- Part 2 – Writing simple code to consume API service in console application16:12
- Part 3 – Understanding and writing simple test for API with C#06:11
- Part 4 – Writing API test with Specflow C#11:22
- Part 5 – Writing API test with Specflow C# (Cont)06:27
Database testing for API services4 lectures • 51min
- Part 6 – Database testing of WCF API using Specflow and C#11:02
- Part 7 – Database testing of WCF API using Specflow and C# (Cont)11:07
- Part 8 – Database Testing for WCF API using SQL Stored Procedures11:49
- Part 9 – Database testing of API with Mock Stored Procedure17:24