Python For Automation Course

Lesson 1 • Core Python Syntax Essentials

Cover variables, data types, operators, and control flow constructs. These primitives underpin every automation script written later in the course.

Lesson 2 • Error Handling and Debugging

Use try/except blocks and built-in debugging tools to write resilient scripts. Reliable error handling is critical for unattended automation tasks.

Lesson 3 • Setting Up the Python Environment

Install Python, configure a virtual environment, and choose an IDE suited for automation work. Establishes the baseline toolchain used throughout the course.

Lesson 1 • Reading and Writing Text Files

Open, read, write, and append plain text files using built-in file I/O. Text file manipulation is the entry point for most data-processing automation tasks.

Lesson 2 • Processing CSV and JSON Data Files

Parse and generate CSV and JSON files, the two most common automation data formats. Connects file I/O skills to structured data manipulation.

Lesson 3 • Navigating the File System with os and pathlib

Traverse directories, check paths, and perform file operations using os and pathlib. Builds the navigation skills needed for bulk file automation.

Lesson 1 • Managing Processes and System Resources

Monitor, start, and terminate processes and query system resource usage with psutil. Enables automation scripts that respond to system state.

Lesson 2 • Environment Variables and System Configuration

Read, set, and manage environment variables to configure scripts without hardcoding values. Supports portable, environment-aware automation scripts.

Lesson 3 • Scheduling and Running Automated Tasks

Schedule Python scripts to run at defined intervals using OS-level schedulers and Python libraries. Converts one-off scripts into reliable recurring automation.

Lesson 1 • Consuming and Automating REST APIs

Authenticate with and consume REST APIs to automate data retrieval and submission. Connects web automation to modern service-based architectures.

Lesson 2 • Handling Dynamic and JavaScript-Rendered Pages

Scrape content rendered by JavaScript using Selenium and Playwright. Extends scraping capability beyond static HTML pages.

Lesson 3 • Making HTTP Requests with requests

Send GET, POST, and other HTTP requests and handle responses programmatically. Provides the foundation for all web-based automation in this chapter.

Lesson 4 • Parsing HTML with BeautifulSoup

Navigate and extract data from HTML documents using BeautifulSoup selectors. Transforms raw web pages into structured, usable data.

Lesson 1 • Spreadsheet Data Analysis with pandas

Load, filter, aggregate, and export tabular data using pandas DataFrames. Bridges raw data files with automated reporting and analysis pipelines.

Lesson 2 • PDF Generation and Extraction

Extract text from PDFs and generate new PDF documents using PyPDF2 and reportlab. Enables automation of PDF-heavy administrative workflows.

Lesson 3 • Word Document Automation with python-docx

Generate and edit Word documents including headings, tables, and images using python-docx. Automates contract, report, and letter generation workflows.

Lesson 1 • ORM-Based Data Automation with SQLAlchemy

Define database models as Python classes and automate CRUD operations using SQLAlchemy ORM. Reduces SQL boilerplate and improves script maintainability.

Lesson 2 • Automating Data Pipelines and ETL

Extract data from files and APIs, transform it, and load it into a database in automated pipelines. Applies all prior database skills to real-world data workflows.

Lesson 3 • Connecting to Production Databases

Use SQLAlchemy and database-specific drivers to connect to PostgreSQL and MySQL. Extends automation scripts to enterprise-grade database systems.

Lesson 1 • Sending Emails with smtplib and MIME

Compose and send plain-text and HTML emails with attachments using smtplib. Automates report delivery, alerts, and confirmation messages.

Lesson 2 • SMS and Push Notification Automation

Send SMS and push notifications via third-party APIs to alert users in real time. Extends automation alerts beyond email to mobile channels.

Lesson 3 • Reading and Processing Incoming Email

Connect to mailboxes via IMAP to read, filter, and act on incoming messages. Enables trigger-based automation driven by email events.

Lesson 1 • Packaging and Deploying Automation Scripts

Package scripts as installable tools and deploy them to servers or containers. Transforms local scripts into shareable, deployable automation assets.

Lesson 2 • Testing Automation Scripts

Write unit and integration tests for automation code using pytest and mocking libraries. Ensures scripts behave correctly across environments and edge cases.

Lesson 3 • Structuring Automation Projects

Organise scripts into packages with clear separation of concerns and configuration management. Lays the architectural foundation for maintainable automation codebases.

Lesson 4 • Concurrency and Parallel Execution

Speed up automation tasks using threading, multiprocessing, and async I/O. Enables scripts to handle large workloads within acceptable time constraints.