Data Engineering with SQL & Python
Build ETL pipelines, data warehouses, and automated data workflows for enterprise analytics.
📦 On-Demand
⏱️ 4 days
Advanced
Data Engineering Certificate
Course Overview
Learn to design and build data pipelines that transform raw data into analytics-ready datasets. Covers advanced SQL, Python for data engineering, ETL/ELT patterns, data warehouse design, Apache Airflow for orchestration, and cloud data platforms. Ideal for teams building modern data infrastructure.
What You'll Learn
✓
Design star and snowflake schema data warehouses
✓
Build ETL/ELT pipelines with Python
✓
Write advanced SQL for data transformation
✓
Orchestrate workflows with Apache Airflow
✓
Implement data quality checks
✓
Work with cloud data platforms
Course Syllabus
- • Window functions and CTEs
- • Recursive queries
- • Performance tuning and indexing
- • Star schema and snowflake design
- • Slowly changing dimensions
- • Data vault modelling basics
🛠️ Hands-On: Design a data warehouse schema for a retail company
- • pandas for data transformation
- • Working with APIs and web data
- • File format handling (CSV, JSON, Parquet)
- • Database connectivity with SQLAlchemy
- • Error handling and logging
- • Unit testing data pipelines
🛠️ Hands-On: Build an ETL pipeline to load API data into a database
- • Apache Airflow: DAGs, operators, sensors
- • Scheduling and monitoring workflows
- • Data quality validation frameworks
- • Introduction to cloud data warehouses
- • dbt for data transformation
- • CI/CD for data pipelines
🛠️ Hands-On: Build and schedule a complete data pipeline with Airflow
Who Should Attend
Data engineers, BI developers, data analysts moving into engineering, and backend developers working with data-intensive applications.
Prerequisites
Intermediate SQL and basic Python. Understanding of databases required.
Skills You'll Gain
SQL
Python
ETL
Data Warehousing
Apache Airflow
Data Modelling
Key Takeaways
🏆
Build production data pipelines
🏆
Design data warehouse schemas
🏆
Orchestrate complex workflows
🏆
Implement data quality frameworks
Certificate of Completion
Upon completing this program, you will receive a Data Engineering Certificate that you can share on LinkedIn and with employers.
Related Programs
Information Technology
Certificate
Tableau Data Visualisation
Build interactive visual analytics and dashboards with Tableau Desktop and Server.
On-Demand
Intermediate
3 days
Tableau
Data Visualisation
Dashboards
+2
View Details & Inquire
Information Technology
Certificate
Network Administration & Security
Configure, manage, and secure enterprise networks — routing, switching, firewalls, and VPNs.
On-Demand
Intermediate
4 days
Networking
Routing
Switching
+3
View Details & Inquire
Information Technology
Certificate
Linux System Administration
Manage Linux servers: installation, users, permissions, networking, scripting, and services.
On-Demand
Intermediate
3 days
Linux
Bash
System Administration
+2
View Details & Inquire
Information Technology
Certificate
Database Administration with MySQL/PostgreSQL
Install, configure, optimise, backup, and secure relational databases for production environments.
On-Demand
Intermediate
3 days
MySQL
PostgreSQL
Database Admin
+2
View Details & Inquire
Request Training
Our team will get back to you within 24 hours
Thank you! Our training team will contact you within 24 hours.