API and Database Testing with Specflow and C#
4.0 (102 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.
6,495 students enrolled
Wishlisted Wishlist

Please confirm that you want to add API and Database Testing with Specflow and C# to your Wishlist.

Add to Wishlist

API and Database Testing with Specflow and C#

Understanding and building API and database testing from groundup
4.0 (102 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.
6,495 students enrolled
Created by Mr Karthik KK
Last updated 3/2016
English
Price: Free
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
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
View Curriculum
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 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


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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 10 Lectures Collapse All 10 Lectures 01:43:16
+
Introduction to API and Database Testing
2 Lectures 11:42
Introduction
05:02

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

Part 1 - Setting stage ready for API and Database Testing with Specflow and C#
06:40
+
Writing code to consume and test API services
4 Lectures 40:12
Part 2 - Writing simple code to consume API service in console application
16:12

Part 3 - Understanding and writing simple test for API with C#
06:11

Part 4 - Writing API test with Specflow C#
11:22

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

Part 5 - Writing API test with Specflow C# (Cont)
06:27
+
Database testing for API services
4 Lectures 51:22
Part 6 - Database testing of WCF API using Specflow and C#
11:02

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.

Part 7 - Database testing of WCF API using Specflow and C# (Cont)
11:07

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#

Part 8 - Database Testing for WCF API using SQL Stored Procedures
11:49

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

Part 9 - Database testing of API with Mock Stored Procedure
17:24
About the Instructor
Mr Karthik KK
4.3 Average rating
1,439 Reviews
24,300 Students
15 Courses
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