Interactive Mentor-Led Cohorts

(02) 8902 0900contact@aumtrend.comWhatsApp / Viber
AUM Training
HomeCourses
Who We Serve
About UsContact
LMS Portal
LEVEL 2 — APPLICATIONS
14 Hours (7 Days × 2 Hours)
View Full Curriculum

Intermediate Python & Business Applications

By the end of Level 2, participants will be able to develop intermediate-level Python applications, work efficiently with structured data, interact with databases and APIs, automate data-processing tasks, and build reusable Python solutions following good programming practices.

Live Interactive Syllabus
14 Hours (7 Days × 2 Hours)
•
Instructor-Led Online
•
7 Hands-on Coding Labs
What you'll master in Level 2
Target Competency Outcome

By the end of Level 2, participants will be able to develop intermediate-level Python applications, work efficiently with structured data, interact with databases and APIs, automate data-processing tasks, and build reusable Python solutions following good programming practices.

Training Objectives & Core Deliverables

Write reusable, maintainable functions and custom exception classes.

Consolidate multiple datasets with advanced NumPy and Pandas operations.

Model business entities using Object-Oriented Programming (OOP) classes.

Connect Python to relational databases (SQLite/MySQL) and execute safe CRUD operations.

Consume REST APIs and automate end-to-end data pipelines.

Day-by-Day Training Schedule & Live Labs
7 Live Sessions • 100% Hands-on
Day 1
Intermediate Python Programming
Live Session
Topics Explored:
Function design and parameter patterns
*args and **kwargs
Lambda review, map() and filter()
Nested and advanced comprehensions
Iterables, iterators and generators
Scope and namespaces (LEGB)
Exception handling & raising exceptions
Custom exception classes
Reusable code principles
Hands-on Lab Exercise

Build reusable functions to normalize records, validate transaction amounts and summarize sales; generate large record streams with a generator; define custom validation errors.

Assignment / Deliverable

Assignment: create a small reusable data-processing utility module.

Learning Outcome: Write reusable, maintainable functions; understand iteration and scope; handle invalid business data robustly.

Day 2
Advanced NumPy & Pandas
Live Session
Topics Explored:
Array creation and indexing
Broadcasting and reshaping
Vectorization and boolean masks
Advanced loc/iloc selection
merge, join and concat
Multi-key GroupBy, aggregation and transform
Pivot tables and crosstabs
Datetime parsing and time-based analysis
Data transformation and validation
Hands-on Lab Exercise

Combine sales, customers and products datasets; resolve key mismatches; calculate monthly revenue and category performance; build a pivot-style management report.

Assignment / Deliverable

Assignment: generate a consolidated sales performance report from three source files.

Learning Outcome: Consolidate datasets; use vectorized operations; perform multi-table analysis and time-based reporting.

Day 3
Object-Oriented Programming
Live Session
Topics Explored:
Classes and objects
__init__ constructors
Instance and class attributes
Instance, class and static methods
Inheritance and method overriding
Encapsulation and naming conventions
Polymorphism
Composition and object relationships
Reusable class design & separation of responsibilities
Hands-on Lab Exercise

Build an Employee Management or Inventory Management application with add/search/update/display operations; model employees/products as objects and apply validation.

Assignment / Deliverable

Assignment: extend the application with input validation and a report/export feature.

Learning Outcome: Model business entities using classes; apply OOP concepts to create reusable, structured code.

Day 4
Python Database Programming I
Live Session
Topics Explored:
Relational database concepts and tables
Database drivers and connection lifecycle
Connecting Python to SQLite or MySQL
Executing SELECT queries and cursor usage
Parameterized queries
CRUD patterns (Create, Read, Update, Delete)
Fetching one, many, or all records
SQL injection prevention
Hands-on Lab Exercise

Connect to a sample employee or inventory database; implement create, read, update and delete operations; search with parameters; handle connection and query errors.

Assignment / Deliverable

Assignment: create a command-line employee lookup and update utility.

Learning Outcome: Connect Python to a relational database; execute safe parameterized queries; implement core CRUD operations.

Day 5
Python Database Programming II
Live Session
Topics Explored:
Database transactions
commit and rollback mechanics
Context and connection cleanup
Data integrity
Inserting and updating records in batches
Fetching query results into Pandas DataFrames
Bulk data handling
Basic database application structure
Error handling around database operations
Hands-on Lab Exercise

Develop a Python business database application that stores transactions, supports updates, retrieves records into Pandas and produces a summary report; demonstrate rollback on a failed operation.

Assignment / Deliverable

Assignment: deliver a database-backed inventory or employee application with a short README.

Learning Outcome: Use transactions safely; exchange data between SQL and Pandas; build a small database-backed application.

Day 6
REST APIs & Data Integration
Live Session
Topics Explored:
Client-server and REST concepts
Endpoints, resources and URI structure
HTTP GET/POST/PUT/PATCH/DELETE
Status codes, headers and query parameters
JSON request and response bodies
Using the requests library
Timeouts and response validation
Pagination and API error handling
Responsible API usage and rate limits
Hands-on Lab Exercise

Consume a public or instructor-provided API; inspect JSON; extract selected fields; handle timeouts and non-success status codes; transform API data into a DataFrame or CSV.

Assignment / Deliverable

Assignment: build an API data collector that saves selected fields to CSV/JSON.

Learning Outcome: Call REST APIs from Python; interpret responses; transform JSON into useful structured data; handle common API failures.

Day 7
Python Automation & Integrated Project
Live Session
Topics Explored:
Pathlib and file/folder operations
Batch file processing and renaming
Logging levels (DEBUG, INFO, WARNING, ERROR) and log files
Application configuration basics
Scheduled execution concepts
Combining API, Pandas and database workflows
Reporting and documentation
Hands-on Lab Exercise

Build an automated workflow that collects API data, validates and transforms it, stores it in a database or file, creates a business report and logs each step; run it with sample inputs and failure cases.

Assignment / Deliverable

Level 2 project: API-to-report automation application with data storage and run logs.

Learning Outcome: Automate a repeatable data workflow; generate reports; use logging and basic scheduling; explain the solution end to end.

Track Portfolio Capstone Project

Level 2 Project — API-to-Report Automation: An application that retrieves data from an API, validates/transforms it, stores it in a database or files, generates a business report and logs execution outcomes.

Detailed Module-wise Curriculum
7 Modules

Function design and parameter patterns

*args and **kwargs

Lambda review, map() and filter()

Nested and advanced comprehensions

Iterables, iterators and generators

Scope and namespaces (LEGB)

Exception handling & raising exceptions

Custom exception classes

Reusable code principles

Lab Practical: Build reusable functions to normalize records, validate transaction amounts and summarize sales; generate large record streams with a generator; define custom validation errors.

Array creation and indexing

Broadcasting and reshaping

Vectorization and boolean masks

Advanced loc/iloc selection

merge, join and concat

Multi-key GroupBy, aggregation and transform

Pivot tables and crosstabs

Datetime parsing and time-based analysis

Data transformation and validation

Lab Practical: Combine sales, customers and products datasets; resolve key mismatches; calculate monthly revenue and category performance; build a pivot-style management report.

Classes and objects

__init__ constructors

Instance and class attributes

Instance, class and static methods

Inheritance and method overriding

Encapsulation and naming conventions

Polymorphism

Composition and object relationships

Reusable class design & separation of responsibilities

Lab Practical: Build an Employee Management or Inventory Management application with add/search/update/display operations; model employees/products as objects and apply validation.

Relational database concepts and tables

Database drivers and connection lifecycle

Connecting Python to SQLite or MySQL

Executing SELECT queries and cursor usage

Parameterized queries

CRUD patterns (Create, Read, Update, Delete)

Fetching one, many, or all records

SQL injection prevention

Lab Practical: Connect to a sample employee or inventory database; implement create, read, update and delete operations; search with parameters; handle connection and query errors.

Database transactions

commit and rollback mechanics

Context and connection cleanup

Data integrity

Inserting and updating records in batches

Fetching query results into Pandas DataFrames

Bulk data handling

Basic database application structure

Error handling around database operations

Lab Practical: Develop a Python business database application that stores transactions, supports updates, retrieves records into Pandas and produces a summary report; demonstrate rollback on a failed operation.

Client-server and REST concepts

Endpoints, resources and URI structure

HTTP GET/POST/PUT/PATCH/DELETE

Status codes, headers and query parameters

JSON request and response bodies

Using the requests library

Timeouts and response validation

Pagination and API error handling

Responsible API usage and rate limits

Lab Practical: Consume a public or instructor-provided API; inspect JSON; extract selected fields; handle timeouts and non-success status codes; transform API data into a DataFrame or CSV.

Pathlib and file/folder operations

Batch file processing and renaming

Logging levels (DEBUG, INFO, WARNING, ERROR) and log files

Application configuration basics

Scheduled execution concepts

Combining API, Pandas and database workflows

Reporting and documentation

Lab Practical: Build an automated workflow that collects API data, validates and transforms it, stores it in a database or file, creates a business report and logs each step; run it with sample inputs and failure cases.
LEVEL 2 — APPLICATIONS COMPETENCY BADGE
Certificate of Technical Competency — Intermediate Python & Business Applications

Complete all live hands-on labs to earn this verifiable competency badge. This credential unlocks progression to Advanced & Production-Ready Python.

LIVE ONLINE COHORT
Admissions Open
Enroll in Intermediate Python & Business Applications
Reserve your seat for upcoming live batches, syllabus consultation & fee structure.
Selected Course Program *
100% Privacy. Official Admissions Desk.

Frequently Asked Questions

Frequently Asked Questions: Python Programming

Find clear answers to common questions about our live interactive classes, cohort schedules, project mentoring, and career assistance.

Yes. Level 1 begins with core Python syntax, basic logic, variables, and data structures. It requires zero prior programming knowledge.

You will build 3 complete portfolio projects: 1) Level 1 Retail/Customer EDA project with visualizations, 2) Level 2 API-to-Report automation tool with SQL database storage, and 3) Level 3 containerized FastAPI production microservice with Docker and PyTest.

Yes. You will learn relational database connectivity (CRUD and transactions), consume external REST APIs, build typed REST APIs with FastAPI, and package applications using Docker.

Still have questions? We're here to help!

Speak directly with our technical advisors to discuss cohorts, curriculum, and career assistance.

FREE 1-ON-1 ACADEMIC GUIDANCE

Ready to Start Your Tech Journey?

Connect with our academic training counsellors. We analyze your background, career goals, and recommend the best live online track for your success.

Call Helpline: (02) 8902 0900WhatsApp or Viber Support