English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 11.5 Hours | 5.31 GB
Build Python Utilities from Scratch to automate Rest API’s with SQL Integration,Batch Jobs Automation,Web Scrapping etc
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
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
Table of Contents
What will you learn from this course – MUST WATCH
1 FAQ’s about the course
2 Installing Python library, Pip Client and Pycharm Editor
3 Important note for MAC Users
4 Important Note before watching next section
Learn Python Programming Basics from Scratch
5 Python hello world Program with Basics
6 Datatypes in python and how to get the Type at run time
7 List Datatype and its operations to manipulate
8 Get Social with Rahul Shetty
9 Tuple and Dictionary Data types in Python with examples
10 How to Create Dictionaries at run time and add data into it
11 If else condition in python with working examples
12 How loops work in Python and importance of code idendation
13 Programming examples using for loop – 1
14 Programming examples using While loop – 2
15 What are functions How to use them in Python
16 OOPS Principles Classes and objects in Python
17 What is Constructor and its role in Object oriented programming
18 Inheritance concepts with examples in Python
19 Strings and its functions in python
20 How to read text file content using Python
21 Importance of readLine and readLines Methods in python
22 Writing Data into File using Python
23 Code Download
Read and Write to Json Files and parsing using Python Methods
24 Where to download the code files
25 How to Parse Json Strings in Python – Example
26 Parse content in Json file into Dictionary – Example
27 Parsing complex Json with nested Structure and extract values
28 Compare two Json Schemas using Python Dictionaries with example
API Automation Testing with Python Requests Library
29 Install Python requests Library for API Automation
30 Understanding Get http request calls and get response using Json method
31 Validating response status codes and headers using response object
32 Understand automating Post http request with Payload and headers
33 End to end automation flow of API calls using Python
Setting up Global Properties and OAuth Mechanism for API Testing
34 Setting global configurations using Python Config object
35 Optimizing resources and payload from externally as reusable data
36 Authenticating API’s using Python Automation auth method- Example
37 Section 3- 5 Code Download
API Testing Request Library Miscellaneous Concepts
38 Importance of Session Managing in API Testing
39 Send and Manage cookies for API request calls
40 Time out and Redirection attributes in making request calls
41 Sending Attachments through Post request call using Files Dictionary object
42 Code Snippet download
Build SQL Utility to interact with Database Tables from Python Code
43 Setting up MYSQL Instance to drive the data from Python Code
44 Setup Database with the Example Table Data and start Connection
45 SQL Queries download
46 Executing Queries on to Database from Python Code
47 Iterate over database table results set from Python and parse the results
48 Create Connection utility and pass the SQL connection externally into test
Integrate Database utilities to API Test for End to end Automation
49 Integrate Database results into API Test Data to build functional flow
50 Code Download
BDD Framework Development for API Automation from Scratch
51 What are the BDD tools we use to Automate in Python Language
52 Install Behave and download Python Professional edition
53 Create Step Definition file with auto generated syntaxes and annotations
54 Implement API Automation actual logic into step Definitions
55 Implement Hooks for the scenarios by defining environment.py file
56 Implement Parameterization to the Test Scenarios using Example outline Keywords
57 Use Tagging mechanism to run selected tests in framework
58 Best practices to write reusable step definitions code for API test Scenarios
59 Integrate Tagging and hooks to build generalize BDD code for Python API Tests
60 Generate Allure reports for Python API BDD Framework
61 Complete Code Download
Read and Write to CSV files with Parsing using Python methods
62 Parsing and reading the CSV files using Python csv package
63 Building a logic to get the data from CSV based on conditional query
64 Parsing and writing back to CSV files using Python csv package
65 Where to download code files
Python paramiko Utility to communicate with AWS Linux Servers
66 Setting up AWS Linux EC2 Instance for solving the project
67 Setting up SSH connection in AWS Linux instances
68 Install Paramiko Package to establish connection to Servers
Execute Batch Jobs on Linux Servers through Python SSH Utilities
69 Execute commands on Linux Servers from your local machine using Python code
70 SFTP Connection to upload and download from server using Python Paramiko
71 Example in running batch commands on Linux Servers using Python code
Web Scrapping to extract content for DataScience Projects using Python
72 What is Web Scrapping in Python
73 Beautiful Soap package for Scrapping the content on web pages
74 find and findAll methods to parse html content from web pages
75 Scrapping Sub urls with href attribute concatenation to requests url
76 End to end example of Web scrapping with Python
77 Extracting the content from page based on the visible text scrapper
Download the Full course Code files
78 Download complete Project Code
Bonus!! Student Special -Must WATCH
79 Bonus lecture- Next Steps from here – Reach me
Resolve the captcha to access the links!