PROJECT 01
API to database ETL
Pull data from a public REST API every day, clean it with pandas and load it incrementally into a SQL database.
requestspandasSQLAlchemy
01 / OVERVIEW
What this course is about
This course teaches Python the way data engineers use it every day. You start with the language basics, then clean data with pandas, pull data from APIs, load it into databases, automate boring tasks and test your code. The final weeks bring it together in an ETL pipeline you can put on GitHub and talk about in interviews.
You learn by doing: every week has hands-on exercises on Google Classroom, and every module ends with something you built yourself.
01
Write clean Python
Functions, modules, error handling and readable code that others can maintain.
02
Wrangle data with pandas
Clean, merge, reshape and aggregate messy data sets quickly.
03
Work with APIs and databases
Call REST APIs, handle pagination and auth, and load data into SQL.
04
Automate repetitive work
Scripts for files, Excel reports, emails and scheduled jobs.
05
Test your code
pytest, fixtures, type hints and linting, the habits teams expect.
06
Build a real ETL pipeline
Extract, transform and load with logging, config and tests.
02 / CURRICULUM
Week by week
A clear plan from the first session to the last. The pace adapts to you: if you already know a topic we move faster, and if something needs more time we take it.
WEEKS 1 TO 2Python foundations5 topics
- Setup with VS Code and virtual environments
- Variables, numbers and strings
- Lists, dictionaries, sets and tuples
- Conditions and loops
- Writing functions
WEEK 3Writing reliable code5 topics
- Modules and packages
- Errors and exceptions
- Reading and writing files
- Comprehensions and lambdas
- Code style and naming
WEEK 4OOP and the standard library5 topics
- Classes and objects
- Inheritance and dataclasses
- datetime, pathlib and json
- csv and logging
- Working with config files
WEEKS 5 TO 6Data analysis with pandas and NumPy5 topics
- DataFrames and Series
- Cleaning and missing values
- Merge, join and concat
- groupby, pivot and melt
- Large files in chunks
WEEK 7APIs and databases5 topics
- HTTP and REST basics
- requests, pagination and auth
- Parsing JSON responses
- SQLAlchemy and pyodbc
- Loading data into SQL
WEEK 8Automation5 topics
- Scheduling scripts
- Environment variables and secrets
- Excel reports with openpyxl
- Email and alert notifications
- Command line tools with argparse
WEEK 9Testing and code quality5 topics
- pytest and fixtures
- Type hints
- Linting with ruff
- Git workflow for Python projects
- Debugging techniques
WEEKS 10 TO 11ETL capstone5 topics
- Design an API to database pipeline
- Incremental loads
- Logging and retries
- Tests and documentation
- Intro to PySpark concepts
WEEK 12Interview prep4 topics
- Python interview questions
- Easy and medium coding problems
- Data manipulation challenges
- Mock interview with feedback
03 / PROJECTS
What you will build
Real projects you can put on GitHub and explain with confidence in interviews.
PROJECT 02
Excel report automation
Replace a manual weekly Excel report with a script that builds the workbook and emails it automatically.
openpyxlSchedulingEmail
PROJECT 03
Data quality checker
A command line tool that validates CSV files against rules and produces a clear report, fully tested.
argparsepytestLogging
04 / TOOLS
Tools and technologies
The same tools used by data teams in real companies.
Python 3VS CodeJupyterpandasNumPyrequestsSQLAlchemypytestGit and GitHub
05 / IS IT FOR YOU
Who this course is for
Who it is for
- Beginners who want to learn programming for data
- SQL users who want to automate and build pipelines
- Analysts moving from Excel to code
- Anyone preparing for data engineering roles
What you need
- No programming experience needed
- Basic SQL helps but is not required
- A laptop and time to practise between sessions
Roles it leads to
- Python Developer
- Data Engineer
- Data Analyst
- Automation Engineer
06 / HOW YOU LEARN
What you get
Live and one-to-one
Every session is just you and me, never a batch. No recordings, so we can talk openly about your code.
3 sessions a week
Each session is 1 hour 15 minutes, on weekdays, weekends or both. We agree the schedule before starting.
Google Classroom
Assignments, projects, quizzes, interview questions and homework, all organised in one place.
Real projects
You build projects like the ones companies run, and get feedback on your code and design.
Interview preparation
Common questions, live coding practice and mock interviews with honest feedback.
Job placement support
CV, LinkedIn, applications and interviews. I stay with you until you are hired, as long as you do the work.
07 / PRICING
Simple pricing
You pay for your time with me, not per course. All prices are in US dollars.
Estimated total for Python Developer at the typical pace (3 months)
About 600 USD
Full refund if it is not right for you after the first session. Go faster and it costs less.About 600 USD
08 / YOUR MENTOR
Hikmat Ullah
Senior Data Engineer at Algo · Lahore, Pakistan
I build data platforms with Snowflake, Azure Databricks, Azure Data Factory and Microsoft Fabric every day, and I have been mentoring since 2021. I teach what I use at work, and I stay with you until you land the job.
7+years in data
100+students trained
80+placed in jobs
1:1always, never a batch
09 / FAQ
Questions about Python Developer
Is this course for web development?+
No. It focuses on Python for data: pandas, APIs, databases, automation and pipelines. That is what data engineering and analytics jobs need.
Do I need SQL first?+
It is not required, but SQL and Python together are what most data jobs ask for. Many students take SQL Developer first, then this course.
Will I learn PySpark here?+
You get an introduction to the PySpark way of thinking at the end. Full PySpark is covered in the Azure Databricks Engineer course.
How much does it cost?+
200 USD per month whichever course you choose. You can also pay 100 USD every 15 days or 50 USD per week. All prices are in US dollars wherever you live.
What is the refund policy?+
If the training is not right for you after the first session, you get a full refund. After that, payments already used for completed sessions are not refunded, but unused prepaid time can be refunded.
Is there a job guarantee?+
Yes. As long as you attend your sessions and complete the assignments and projects, I keep helping you with CV, LinkedIn, mock interviews and job applications until you are hired.
Can I join from another country or time zone?+
Yes. Students join from many countries. We pick session times that work for your time zone before we start.
10 / KEEP GOING
Related courses
2 months
SQL Developer
From your first SELECT to stored procedures, data models and fast queries.
View course → 3 monthsAzure Databricks Engineer
PySpark, Delta Lake, medallion architecture and Unity Catalog on Azure.
View course → 3 weeksGit & GitHub
Version control, branching, pull requests and CI, the way real teams work.
View course →START WHEN YOU ARE READY
Start the Python Developer course
Tell me your goals and your time zone. We plan your schedule together, and your first session can start this week.