Clear learning paths with practical projects

IN PREPARATION

SQL for Data Analysts

Mode: Udemy; also included in the offline Data Analyst Programme

Designed for reporting, analytics and business-data roles.

Fee: Udemy price announced at launch. Offline access is through the complete Data Analyst Programme.

Topics covered

• SQL Server, SSMS and relational database fundamentals
• SELECT statements, filtering, sorting and calculated columns
• Aggregate functions, GROUP BY, HAVING and business summaries
• Joins, set operators, subqueries and common table expressions
• Window functions, date functions, string functions and NULL handling
• Views, reusable queries, reporting scenarios and dashboard-ready datasets
• Practice exercises, an analytics project and interview questions

IN PREPARATION

Power BI

Mode: Udemy; also included in the offline Data Analyst Programme

End-to-end business intelligence and reporting skills.

Fee: Udemy price announced at launch. Offline access is through the complete Data Analyst Programme.

Topics covered

• Power BI Desktop, data sources and Power Query transformations
• Star schema, relationships and dimensional modelling
• DAX measures, calculated columns and time intelligence
• Interactive reports, drill-through, tooltips and bookmarks
• Dashboard design, accessibility and storytelling
• Power BI Service, workspaces, refresh, sharing and security
• Performance optimisation, reporting projects and interview preparation

IN PREPARATION

Python for Data Engineering

Mode: Udemy only

Programming foundations for data processing and automation.

Fee: Udemy price announced at launch. Not currently available offline.

Topics covered

• Python syntax, data types, conditions and loops
• Functions, modules, packages and virtual environments
• Lists, dictionaries, sets and comprehensions
• Files, CSV, JSON, exception handling and logging
• Object-oriented foundations and reusable utilities
• APIs, database connectivity and data-processing automation
• Exercises, mini projects and interview scenarios

IN PREPARATION

PySpark for Data Engineering

Mode: Udemy only

Distributed data processing with practical engineering patterns.

Fee: Udemy price announced at launch. Not currently available offline.

Topics covered

• Spark architecture, sessions, DataFrames and Spark SQL
• Reading and writing CSV, JSON, Parquet and Delta formats
• Transformations, joins, aggregations and window functions
• Null handling, schema management and data-quality checks
• Partitioning, caching, shuffles and performance optimisation
• Reusable pipelines, testing and troubleshooting
• Practical projects and interview scenarios

PLANNED

SQL for Data Engineers

Mode: Udemy

A separate advanced SQL track for engineering workloads.

Fee: To be announced at launch.

Topics covered

• T-SQL, DDL, DML, TCL, constraints and database objects
• Keys, normalisation, ACID properties and transaction handling
• Views, stored procedures, parameters and user-defined functions
• Data warehousing, fact tables, dimension tables and schemas
• Incremental processing and slowly changing dimensions using SQL
• Indexes, execution plans, query tuning and performance patterns
• Advanced scenarios, an end-to-end project and interview questions

PLANNED

Amazon QuickSight and AWS Analytics

Mode: Udemy

Cloud business intelligence using AWS analytics services.

Fee: To be announced at launch.

Topics covered

• Data sources, datasets, preparation and SPICE
• Calculated fields, parameters, filters and controls
• Visuals, dashboards, themes and storytelling
• Row-level security, sharing and embedding
• Integration with common AWS data services
• Projects and interview preparation

PLANNED

Tableau

Mode: Udemy

Visual analytics and dashboard development.

Fee: To be announced at launch.

Topics covered

• Data connections, relationships and preparation
• Calculated fields, table calculations and level-of-detail expressions
• Charts, parameters, actions and interactive dashboards
• Performance, publishing, permissions and refresh
• Business projects and interview scenarios

PLANNED

Azure Data Engineering

Mode: Udemy

End-to-end batch and streaming solutions on Azure.

Fee: To be announced at launch.

Topics covered

• ADLS Gen2 and secure data-lake design
• Azure Data Factory pipelines and orchestration
• Azure Databricks and Delta Lake
• Azure Synapse Analytics and serving layers
• Event Hubs and streaming architecture
• Monitoring, security, projects and interview preparation

PLANNED

Snowflake Data Engineer

Mode: Udemy

Cloud data warehousing and analytics engineering.

Fee: To be announced at launch.

Topics covered

• Snowflake architecture, storage and virtual warehouses
• Loading, unloading, stages, file formats and Snowpipe
• Streams, tasks, dynamic tables and incremental processing
• Performance, clustering, security and cost management
• Snowpark, dbt, projects and interview preparation

PLANNED

Microsoft Fabric Data Engineer

Mode: Udemy

Unified data engineering and analytics on Microsoft Fabric.

Fee: To be announced at launch.

Topics covered

• OneLake, Lakehouse and Data Warehouse
• Data Factory pipelines and Dataflows Gen2
• Spark notebooks and Delta tables
• Real-Time Intelligence and event processing
• Semantic models and Power BI integration
• Security, monitoring, projects and certification preparation