API and Database Testing with Specflow and C#

Understanding and building API and database testing from groundup
Rating: 4.2 out of 5 (529 ratings)
20,525 students
API and Database Testing with Specflow and C#
Rating: 4.2 out of 5 (530 ratings)
20,525 students
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 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 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 length
  • Introduction
    05:02
  • Part 1 - Setting stage ready for API and Database Testing with Specflow and C#
    06:40
  • 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
  • Part 5 - Writing API test with Specflow C# (Cont)
    06:27
  • 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 Procedures
    11:49
  • Part 9 - Database testing of API with Mock Stored Procedure
    17:24

Instructor
Software Architect, Consultant,Youtuber and Best Seller
Karthik KK
  • 4.3 Instructor Rating
  • 18,193 Reviews
  • 203,793 Students
  • 25 Courses

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 13 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