Our Data Architecture Course is a 3-day, instructor-led training course for data engineers, database administrators, big data specialists, data analysts, data scientists and cloud architects who want to design scalable, secure and effective data solutions. This practical data architecture training course explores how to structure, model, integrate and manage data across traditional, modern, cloud-native and hybrid environments.
This Data Architecture course helps delegates build confidence with end-to-end data architecture design, from data modelling and database selection through to pipelines, governance, security and AI/ML workflows. Topics include Entity-Relationship Diagrams, schema optimisation, relational databases, modern data warehouses, NoSQL databases, data lakes, Delta Lakes, OLTP and OLAP, Lambda and Kappa architectures, ETL and ELT pipelines, real-time processing with Kafka, data quality, data governance, data security and scalable architectures for artificial intelligence and machine learning.

Course Schedule
3 days
9:00am - 5:00pm
Online Live
£1,895 per delegate
3 days
8:00am - 4:00pm
Online Live
£1,895 per delegate
3 days
9:00am - 5:00pm
Online Live
£1,895 per delegate
3 days
8:00am - 4:00pm
Online Live
£1,895 per delegate
3 days
8:00am - 4:00pm
Online Live
£1,895 per delegate
3 days
8:00am - 4:00pm
Online Live
£1,895 per delegate
Course Code: GK840040
Duration: 3 days
Target Audience
This course is ideal for Data Engineers, Database Administrators, Big Data Specialists, Data Analysts and Scientists, and Cloud Architects who are looking to enhance their skills in data architecture and management.
Course Objectives
- Understand the principles and responsibilities of Data Architecture.
- Design efficient data models and Entity-Relationship Diagrams (ERDs).
- Solve real-world data modeling challenges and optimize schemas.
- Compare and integrate structured, unstructured, and hybrid data solutions.
- Architect cloud-native and hybrid systems, integrating ETL/ELT pipelines.
- Build real-time processing systems with tools like Kafka.
- Apply best practices in data governance, quality, and security.
- Design scalable architectures for AI/ML workflows.
- Create end-to-end data architectures for business use cases.
Course Content
- Data Architecture Fundamentals
- Introduction to Data Architecture
- Data Modeling Concepts
- Relational vs Modern Data Warehouses
- NoSQL Databases
- Data Lakes and Delta Lakes
- Data Design Concepts
- Cloud Data Architectures
- OLTP vs. OLAP
- Lambda and Kappa Architectures
- ETL vs. ELT
- Data Pipelines for AI/ML
- AI, Data Governance, Security, and Management
- Scalable Data Architectures for AI/ML
- Deployment and Optimization of AI/ML Systems
- Data Governance and Quality
- Data Security Best Practices
Course Prerequisites
- Familiarity with database systems, SQL, and basic data management concepts.
- Working knowledge of at least one programming language (e.g., Python, Java, or Scala).
- Basic understanding of data engineering or data analysis workflows.
- Awareness of ETL processes and data integration principles.
- Familiarity with cloud platforms (e.g., AWS, Azure, or Google Cloud) or interest in transitioning to cloud-based systems.
- Awareness of big data concepts and tools (e.g., Hadoop, Spark) but no hands-on experience required.
- Understanding of basic data modeling techniques (e.g., star schema, snowflake schema).
- Awareness of data governance and security concepts.
- Familiarity with modern data architectures, such as data lakes or warehouses.
Public Schedule
Private Virtual Training (Teams / Zoom)
n/a
Private Onsite Training (at your offices)
n/a
Note
All prices exclude VAT at 20%.
VAT registration number: 450 4347 14
You may also like...
Learn how to protect data accuracy, consistency and reliability. Explore data integrity risks, governance, auditing and best practices on this 1-day course.
1 day
Learn to turn complex data into compelling stories. Explore visual design, chart selection, ethical data use and AI tools on this 1-day live online course.
1 day
Take the 1-day AI for the Enterprise course live online. Learn to integrate AI into business strategy, manage change and adopt AI responsibly.




