Setting up MYSQL Instance to drive the data from Python Code

Python SDET-BackEnd /Rest API Automation from Scratch

What will you learn from this course? - MUST WATCH

Learn Python Programming Basics from Scratch

Python hello world Program with Basics (8:33)
Datatypes in python and how to get the Type at run time (6:37)
List Datatype and its operations to manipulate (16:07)
Get Social with Rahul Shetty
Tuple and Dictionary Data types in Python with examples (10:37)
How to Create Dictionaries at run time and add data into it (3:49)
If else condition in python with working examples (9:54)
How loops work in Python and importance of code idendation (11:18)
Programming examples using for loop - 1 (5:09)
Programming examples using While loop - 2 (13:12)
What are functions? How to use them in Python ... (13:08)
OOPS Principles : Classes and Objects in Python... (9:10)
What is Constructor and its role in Object oriented programming ... (17:03)
Inheritance concepts with examples in Python... (15:01)
Strings and its functions in Python (12:20)
How to read text files content using Python (8:26)
Importance of readLine and readLines Methods in python (9:35)
Writing Data into File using Python (10:28)
Code Download
Quiz - Test your Python Basic Knowledge!

Read and Write to Json Files and parsing using Python Methods

API Automation Testing with Python Requests Library

Install Python requests Library for API Automation (8:47)
Understanding Get http request calls and get response using Json method (14:54)
Validating response status codes and headers using response object (11:02)
Understand automating Post http request with Payload and headers (14:24)
End to end automation flow of API calls using Python (11:01)

Setting up Global Properties and OAuth Mechanism for API Testing

API Testing Request Library Miscellaneous Concepts

Importance of Session Managing in API Testing (8:29)
Send and Manage cookies for API request calls (11:39)
Time out and Redirection attributes in making request calls (7:04)
Sending Attachments through Post request call using Files Dictionary object (9:56)
Code Snippet download

Build SQL Utility to interact with Database Tables from Python Code

Setting up MYSQL Instance to drive the data from Python Code (4:49)
Setup Database with the Example Table Data and start Connection (9:17)
SQL Queries Download
Executing Queries on to Database from Python Code
Iterate over database table results set from Python and parse the results (12:29)
Create Connection utility and pass the SQL connection externally into test (11:54)
Section 7 Quiz

Integrate Database utilities to API Test for End to end Automation

BDD Framework Development for API Automation from Scratch

What are the BDD tools we use to Automate in Python Language (7:04)
Install Behave and download Python Professional edition (10:03)
Create Step Definition file with auto generated syntaxes and annotations (6:30)
Implement API Automation actual logic into step Definitions (12:18)
Implement Hooks for the scenarios by defining environment.py file (8:41)
Implement Parameterization to the Test Scenarios using Example outline Keywords (11:45)
Use Tagging mechanism to run selected tests in framework (3:34)
Best practices to write reusable step definitions code for API test Scenarios (14:41)
Integrate Tagging and hooks to build generalize BDD code for Python API Tests (8:37)
Generate Allure reports for Python API BDD Framework (10:59)
Complete Code Download

Read and Write to CSV files with Parsing using Python methods

Python paramiko Utility to communicate with AWS Linux Servers

Execute Batch Jobs on Linux Servers through Python SSH Utilities

Execute commands on Linux Servers from your local machine using Python code (9:18)
SFTP Connection to upload and download from server using Python Paramiko (9:42)
Example in running batch commands on Linux Servers using Python code (16:30)
Section 10 & 11 Quiz

Web Scrapping to extract content for DataScience Projects using Python

What is Web Scrapping in Python? (4:59)
Beautiful Soap package for Scrapping the content on web pages (12:30)
find and findAll methods to parse html content from web pages (13:09)
Scrapping Sub urls with href attribute concatenation to requests url (11:59)
End to end example of Web scrapping with Python (8:09)
Extracting the content from page based on the visible text scrapper (6:00)
Section 12 Quiz

Download the Full course Code files

Lesson content locked

If you're already enrolled, you'll need to login.