Data Engineering for AI course
the pipelines AI depends on.
A five-day, hands-on course in Cardiff or live online. If you live in Wales and have been made redundant or are under notice, the Welsh Government's ReAct+ grant can pay the full £1,500 fee.
- Duration
- 5 days
- Level
- Beginner to intermediate
- Format
- Cardiff or online
- Course fee
- £1,500
When your grant is approved before the course starts. ReAct+ can also help with travel and childcare costs while you train.
What the course covers.
AI projects succeed or fail on their data. Data engineers build the pipelines that collect, clean and move that data so analysts and AI systems can trust it. Demand for these skills is growing across Wales and the UK.
This course covers SQL, Python pipelines, scheduling and data quality, then shows how to prepare documents and data for AI, including embeddings and vector databases.
- SQL
- PostgreSQL
- Python
- dbt
- Airflow
- Vector databases
- Data quality tests
Who it's for
- Analysts and report writers who want to move into engineering
- Career changers with strong spreadsheet skills
- Developers who want to specialise in data
Before you start
Comfortable with spreadsheets. Some Python helps but is not essential.
By Friday, you'll be able to
- Write SQL to query, join and aggregate data
- Design simple, reliable data models
- Build extract, transform and load pipelines in Python
- Schedule pipelines and test data quality
- Prepare documents and embeddings for AI search
- Apply UK GDPR and access controls to data
Five days, day by day.
Each day mixes short explanations with hands-on labs. Day five is for finishing and presenting your project.
- Day 1
SQL and data modelling
- Querying with SELECT and JOIN
- Aggregations and window functions
- Tables, keys and relationships
- Modelling for reporting
- Day 2
Pipelines in Python
- Extract, transform and load
- Cleaning and validation
- Working with APIs and files
- Loading into PostgreSQL
- Day 3
Running pipelines reliably
- Transformations with dbt
- Scheduling with Airflow
- Data quality tests
- Monitoring and alerts
- Day 4
Data for AI
- Preparing documents for AI
- Embeddings and chunking
- Vector databases
- Keeping AI data fresh
- Day 5
Governance and delivery
- UK GDPR and data minimisation
- Lineage and documentation
- Access control
- Project demo
A tested data pipeline
Pulls public data from an API, cleans and models it in PostgreSQL, runs quality checks on a schedule and feeds a small AI search index.
Roles this course prepares you for
- Junior data engineer
- Data analyst
- BI developer
- AI data specialist
What you leave with
A working project in your own GitHub portfolio and an Apex Training Wales certificate of completion.
How to get your place fully funded.
ReAct+ is a Welsh Government grant for people affected by redundancy. Your Working Wales adviser makes the application, and we give them the course details they need.
Check you're eligible
Aged 20 or over, living in Wales, with the right to work in the UK, and under notice of redundancy or made redundant in the last six months.
Speak to Working Wales
Call free on 0800 028 4844 or book an appointment online. Tell your adviser you'd like to take Data Engineering for AI.
We send your course details
Contact us and we'll provide the course outline and fee your adviser needs for your ReAct+ application.
Start once approved
When your grant is approved, we confirm your start date. The £1,500 fee is covered, so there's nothing to pay.
Eligibility and grant amounts from Working Wales. Final funding decisions are made by the Welsh Government.
About the course and the funding.
Is this course suitable if I've never coded?
How is data engineering different from data science?
Who is eligible for ReAct+ funding?
Will I have to pay anything?
Can ReAct+ help with travel or childcare?
What if I'm not eligible for ReAct+?
Ready to retrain in AI? Let's check your funding.
Tell us which course you're interested in and your situation. We'll explain the next steps and send your adviser everything they need.