🛠️ Automate Everything with Python
Automation with Python Course
Master Python automation — web scraping, browser automation with Selenium and
Playwright, task scheduling, data pipelines, file processing, REST API automation,
CI/CD scripting, and RPA for enterprise workflows.
Tools & Technologies Covered
🐍 Python 3.x
🌐 Selenium
🎭 Playwright
🕷️ BeautifulSoup / Scrapy
⏰ APScheduler / schedule
📄 openpyxl / xlrd
📧 smtplib / email automation
🔧 PyAutoGUI
🔄 Celery & Redis
🐳 Docker
🚀 GitHub Actions CI/CD
🤖 RPA with Python
Course Summary
| Course Name |
Automation with Python |
| Duration |
35 Hours (Online / Classroom) |
| Prerequisites |
Basic Python — variables, loops, functions, OOP |
| Target Audience |
QA engineers, developers, analysts, and anyone wanting to eliminate repetitive tasks |
| Certificate |
Yes — Industry-recognised certificate upon completion |
| Mode |
Online & Classroom — with recorded sessions for lifetime access |
📋 Detailed Course Syllabus
🟢 File & System Automation
- Working with
os and pathlib — files, directories, paths
- Reading and writing text, CSV, JSON, XML files programmatically
- Excel automation with
openpyxl — read, write, format, charts
- PDF manipulation with
PyPDF2 / reportlab — merge, split, generate
- Bulk file renaming, moving, copying, zipping with
shutil
- Watching directories for file changes with
watchdog
- Running shell commands from Python with
subprocess
- Scheduling tasks with
schedule library and APScheduler
- Cron-style scheduling — hourly, daily, weekly jobs
- Sending emails with
smtplib and email module — plain text and HTML
- Sending email with attachments — reports, Excel files
- Gmail / Outlook automation — SMTP configuration
- Reading emails with IMAP — filtering, downloading attachments
- WhatsApp / SMS automation with Twilio API
🟡 Web Scraping & Browser Automation
- HTTP requests with
requests library — GET, POST, sessions, headers
- HTML parsing with
BeautifulSoup4 — find(), find_all(), CSS selectors
- Extracting tables, lists, links, and images from web pages
- Handling pagination — scraping multiple pages
- Scrapy framework — spiders, pipelines, item loaders, settings
- Storing scraped data — CSV, JSON, databases
- Respecting
robots.txt and polite scraping practices
- Selenium setup — WebDriver, Chrome, headless mode
- Locating elements — ID, name, XPath, CSS selector, link text
- Interacting with elements — click, type, select, submit forms
- Handling waits — implicit, explicit, fluent waits with
WebDriverWait
- Handling alerts, popups, iframes, and multiple windows/tabs
- Taking screenshots and scrolling the page
- Automating login flows, form submissions, and data extraction
- Playwright Python setup —
playwright install, sync and async API
- Navigating, clicking, filling forms, and waiting for elements
- Auto-waiting — Playwright vs Selenium reliability comparison
- Network interception — mocking API responses in tests
- Page Object Model (POM) for maintainable automation
- Visual regression testing with screenshots
- Playwright Codegen — recording scripts automatically
- Running tests in parallel with multiple browsers (Chromium, Firefox, WebKit)
🟠 Data Pipelines & API Automation
- ETL (Extract, Transform, Load) pipeline design with Python
- Data extraction from APIs, databases, FTP, and cloud storage
- Data transformation with Pandas — cleaning, reshaping, aggregation
- Loading data to databases — SQLAlchemy, PostgreSQL, MySQL
- Apache Airflow introduction — DAGs, operators, scheduling
- Automating report generation — Excel, PDF, email delivery
- Error handling and retry logic in pipelines
- Automating REST APIs with
requests — authentication, pagination, error handling
- API testing automation — automated test suites for REST endpoints
- Webhooks — receiving and processing webhook events
- Automating Slack, Teams, Jira, GitHub via their REST APIs
- Cloud storage automation — uploading/downloading from Azure Blob / AWS S3
- Google Sheets API — reading and writing spreadsheets programmatically
- Polling and event-driven integrations
🟥 CI/CD & Desktop Automation
- Writing Python scripts for GitHub Actions workflows
- Automating build, test, and deployment pipelines
- Docker automation — building and pushing images via Python SDK
- Azure CLI / AWS CLI automation with Python
- Infrastructure as Code helpers — scripting Terraform/Ansible interactions
- Automated code quality checks —
flake8, black, mypy in CI
- Slack / Teams notifications on build success or failure
📦 Project Options:
- Job Portal Scraper — Scrapy + PostgreSQL + daily email report
- E2E Test Suite — Playwright POM for a web application
- Automated Reporting Bot — API data → Excel → email schedule
- CI/CD Pipeline Automation — GitHub Actions + Docker + cloud deploy
✅ Must-Include:
- Scheduled / triggered execution
- Error handling with retries
- Logging and alerting
- Docker containerisation
- README with setup instructions
