Python Sdet Rest Api Automation

  1. Home
  2. Api-testing
  3. Python Sdet Rest Api Automation

Tags: API Testing

Build Python Utilities from Scratch to automate Rest API’s with SQL Integration,Batch Jobs Automation,Web Scrapping etc

Last updated 2022-01-10 | 4.6

- Get Complete knowledge on Back end automation with Python which is must to become Python SDET
- Understanding the API Automation from Scratch with Python Requests Library
- Knowledge on implementing Database readers to communicate with DB from Python code

What you'll learn

Get Complete knowledge on Back end automation with Python which is must to become Python SDET
Understanding the API Automation from Scratch with Python Requests Library
Knowledge on implementing Database readers to communicate with DB from Python code
Establishing Connection with Linux Servers through Python Paramiko Library
Implement BDD Automation Framework for Python API Testcases from Scratch
Execute Batch Jobs in AWS Linux Servers and download the files to local using Python
Integrate the Database resutls to API and build dynamic Json Payloads
Knowledge on Web Scrapping to extract content from Web pages for Data science work

* Requirements

* None- Everything including Python basics are taught from Scratch in the course

Description

***You will be mastered in Python Back End Automation even if you have never programmed before in Python***
This Python SDET course starts from scratch teaching Python Basics and then drive you through many important utilities of Python like API Testing, BDD API Automation Framework, Database Validations,  CSV Readers, Json Parsers, Batch Jobs execution from Linux Servers, SSH connection to upload and download files, Web scrapping for data science work etc
As Python SDET, One should aware of many modules of python to perform end to end backend/Server side automation and this course comes us one single package which explains all the modules from scratch.

By end of this course, You can confidently implement any Python Automation Jobs or clear any interview related to Python testing.

Below is the high level content this course covers :

Json Parsers with Python modules
Read and Write to Json files with Python
API Automation using requests Library
Understand Crud operations GET,POST, DELETE,PUT API operations automation
Parsing API responses with Python utilities
Database interactions  with Python SQL Connector
BDD Automation Framework development from Scratch
Read the multiple result sets of database tables from Python
Integrating Database readers with API calls to build payload
CSV Parser with Python modules
Read and Write to CSV files with Python
Interacting with AWS Linux Servers
Establishing SSH connection to Linux using Python Paramiko
Sending the commands and executing the jobs in Server through Python
Uploading and downloading the files of batch Jobs from Servers with paramiko
IMportance of Web scrapping in Data science projects
Techniques to apply web scrapping to extract content from web pages


Wish you all the Best with your new Python SDET Journey :)









Who this course is for:

  • Manual testers, Non-programming aware testers interested in learning Automation
  • Freshers/Graduates who want to kick start their Career in IT World

Course content

15 sections • 85 lectures

What will you learn from this course? - MUST WATCH 4 lectures

FAQ's about the course Preview 10:07

Installing Python library, Pip Client and Pycharm Editor Preview 17:03

Important note for MAC Users Preview 04:05

Important Note before watching next section Preview 00:24

Learn Python Programming Basics from Scratch 19 lectures

Python hello world Program with Basics Preview 08:33

Datatypes in python and how to get the Type at run time Preview 06:37

List Datatype and its operations to manipulate Preview 16:07

Tuple and Dictionary Data types in Python with examples Preview 10:37

How to Create Dictionaries at run time and add data into it Preview 03:49

If else condition in python with working examples Preview 09:54

How loops work in Python and importance of code idendation Preview 11:18

Programming examples using for loop - 1 Preview 05:09

Programming examples using While loop - 2 Preview 13:12

What are functions? How to use them in Python Preview 13:08

OOPS Principles : Classes and objects in Python Preview 09:10

What is Constructor and its role in Object oriented programming Preview 17:03

Inheritance concepts with examples in Python Preview 15:01

Strings and its functions in python Preview 12:20

How to read text file content using Python Preview 08:26

Importance of readLine and readLines Methods in python Preview 09:35

Writing Data into File using Python Preview 10:28

Code Download Preview 00:02

Quiz - Test your Python Basic Knowledge!

Read and Write to Json Files and parsing using Python Methods 6 lectures

Where to download the code files? Preview 00:04

How to Parse Json Strings in Python? - Example Preview 10:04

Parse content in Json file into Dictionary - Example Preview 13:23

Parsing complex Json with nested Structure and extract values Preview 10:09

Compare two Json Schemas using Python Dictionaries with example Preview 05:05

Section 3 Quiz - Test your knowledge!

API Automation Testing with Python Requests Library 5 lectures

Install Python requests Library for API Automation Preview 08:47

Understanding Get http request calls and get response using Json method Preview 14:54

Validating response status codes and headers using response object Preview 11:02

Understand automating Post http request with Payload and headers Preview 14:24

End to end automation flow of API calls using Python Preview 11:02

Setting up Global Properties and OAuth Mechanism for API Testing 5 lectures

Setting global configurations using Python Config object Preview 11:43

Optimizing resources and payload from externally as reusable data Preview 06:50

Authenticating API's using Python Automation auth method- Example Preview 11:05

Section 3- 5 Code Download Preview 00:02

Section 4 and 5 Quiz - Test Your API Automation Knowledge!

API Testing Request Library Miscellaneous Concepts 5 lectures

Importance of Session Managing in API Testing Preview 08:29

Send and Manage cookies for API request calls Preview 11:39

Time out and Redirection attributes in making request calls Preview 07:04

Sending Attachments through Post request call using Files Dictionary object Preview 09:56

Code Snippet download Preview 00:07

Build SQL Utility to interact with Database Tables from Python Code 7 lectures

Setting up MYSQL Instance to drive the data from Python Code Preview 04:50

Setup Database with the Example Table Data and start Connection Preview 09:17

SQL Queries download Preview 00:21

Executing Queries on to Database from Python Code Preview 08:30

Iterate over database table results set from Python and parse the results Preview 12:29

Create Connection utility and pass the SQL connection externally into test Preview 11:54

Section 7 Quiz

Integrate Database utilities to API Test for End to end Automation 2 lectures

Integrate Database results into API Test Data to build functional flow Preview 14:20

Code Download Preview 00:01

BDD Framework Development for API Automation from Scratch 11 lectures

What are the BDD tools we use to Automate in Python Language Preview 07:04

Install Behave and download Python Professional edition Preview 10:03

Create Step Definition file with auto generated syntaxes and annotations Preview 06:30

Implement API Automation actual logic into step Definitions Preview 12:18

Implement Hooks for the scenarios by defining environment.py file Preview 08:41

Implement Parameterization to the Test Scenarios using Example outline Keywords Preview 11:45

Use Tagging mechanism to run selected tests in framework Preview 03:34

Best practices to write reusable step definitions code for API test Scenarios Preview 14:41

Integrate Tagging and hooks to build generalize BDD code for Python API Tests Preview 08:37

Generate Allure reports for Python API BDD Framework Preview 10:59

Complete Code Download Preview 00:02

Read and Write to CSV files with Parsing using Python methods 5 lectures

Parsing and reading the CSV files using Python csv package Preview 12:10

Building a logic to get the data from CSV based on conditional query Preview 03:28

Parsing and writing back to CSV files using Python csv package Preview 05:47

Where to download code files? Preview 00:04

Section 9 Quiz

Python paramiko Utility to communicate with AWS Linux Servers 3 lectures

Setting up AWS Linux EC2 Instance for solving the project Preview 16:22

Setting up SSH connection in AWS Linux instances Preview 06:08

Install Paramiko Package to establish connection to Servers Preview 08:03

Execute Batch Jobs on Linux Servers through Python SSH Utilities 4 lectures

Execute commands on Linux Servers from your local machine using Python code Preview 09:18

SFTP Connection to upload and download from server using Python Paramiko Preview 09:42

Example in running batch commands on Linux Servers using Python code Preview 16:30

Section 10 & 11 Quiz

Web Scrapping to extract content for DataScience Projects using Python 7 lectures

What is Web Scrapping in Python? Preview 04:59

Beautiful Soap package for Scrapping the content on web pages Preview 12:30

find and findAll methods to parse html content from web pages Preview 13:09

Scrapping Sub urls with href attribute concatenation to requests url Preview 11:59

End to end example of Web scrapping with Python Preview 08:09

Extracting the content from page based on the visible text scrapper Preview 06:00

Section 12 Quiz

Download the Full course Code files 1 lectures

Download complete Project Code Preview 00:01

BONUS LECTURE 1 lectures

Bonus lecture Preview 01:13