API and Database Testing with Specflow and C#

Understanding and building API and database testing from groundup
4.3 (83 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
5,946 students enrolled
Start Learning Now
  • Lectures 10
  • Length 1.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English

Course Description

Understanding API and database testing with Specflow and C# course is designed in such a way that one can learn 

  • What is API and database testing
  • Different tools available to perform API and database testing
  • Why we choose Visual studio as the tool for API and database testing
  • 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#
  • Connecting with Microsoft SQL database server to test data using simple queries
  • 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 couple of hours

What are the 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

What am I going to get from this course?

  • 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

Who is the target audience?

  • This course is for both testers and developers
  • Any manual test engineer with good knowledge in SQL can also learn this course

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Introduction to API and Database Testing

In this video we will be talking about Setting stage ready for API and Database Testing with Specflow and C#.

We will also talk about the functionality of EmployeeApp v1.0 and the PFService WCF application which we discussed in our Udemy course

Section 2: Writing code to consume and test API services
Part 2 - Writing simple code to consume API service in console application
Part 3 - Understanding and writing simple test for API with C#
Part 4 - Writing API test with Specflow C#

In this video we will talk about writing API test with Specflow C#. This video is a continuation of Part 4

Section 3: Database testing for API services
Part 6 - Database testing of WCF API using Specflow and C#

In this video we will discuss working with Database Testing of WCF API using Specflow and C#. This video is a continuation of Part 6.


In this video we will discuss how to test database of a WCF API using SQL Stored Procedures.

In this video we will write a simple Stored procedure which performs updation of existing data in a table from Specflow c#


In this video we will be discussing about Database testing of API with Mock Stored Procedure using Specflow and C#

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Mr Karthik KK, Software Architect, Consultant and Youtuber

I am Karthik K.K. I do consulting, blogging and researching on various different tools and technologies which inspires my interest. I have been into Software Automation Testing for over 10+ years now and my interest in learning new stuffs which enables automation has never been compromised.

Due to my passion in automation testing I got fully exposed to tools and languages like

Desktop & Web : QTP, Selenium, Specflow, VS Coded UI, Ranorex ,Test Complete and Cucumber
Mobile : Appium, Robotium,Calabash, Espresso, Selendroid
Languages : C#, Java, Ruby, Powershell, Javascript, VBScript 
Cloud Tools : Azure, Dockers
Misc Tools: Mockito, Rest-assured, Bound-Box,FluentAutomation
Interested in: MVC, Entity framework, LINQ, Fakes, Distributed deployment, SAAS

Ready to start learning?
Start Learning Now