Module 1: Relational Databases and Modern Data Foundations
General Introduction to RDBMS Data Platforms
The Big 4 (Oracle, Microsoft SQL Server, MySQL, PostgreSQL)
OLTP vs. OLAP Architectures
Data Warehousing (DWH)
ETL and Batch Processing
Modern Challenges of Relational Databases
Modern Data Roles (BI, DBA, Data Engineer, Data Scientist, Data Analyst, DataOps)
Data Stakeholders
The Future of Relational Databases
Module 2: Big Data Technologies
The Big Data Revolution
Apache Hadoop Ecosystem
Apache Kafka
Apache Spark
Apache NiFi
Apache Airflow
NoSQL Databases
NewSQL Technologies
Modern Data Formats (Avro, Parquet)
Module 3: Containers and Cloud Platforms
Docker Fundamentals
Kubernetes Architecture
Data Processing in Containers
Cloud Computing Concepts
Public, Private and Hybrid Cloud
SaaS, PaaS and IaaS Models
On-Premise vs. Cloud
Managed Services and Serverless Computing
AWS, Microsoft Azure and Google Cloud Platform
Cloud Storage, Data Lakes and Streaming Services
Module 4: Modern Data Platforms
Applying Data Solutions in the Cloud
Modern Data Warehouse Solutions
Data Lake Architecture
Google BigQuery
Amazon Redshift
Azure Synapse Analytics
Snowflake
Module 5: Data Architecture Principles
Translating Business Requirements into Technical Architecture
Data Platform Scalability
Data Acquisition and Ingestion
Data Transformation
Data Pipelines and Data Flow
Security and Governance
Data Lineage
High Availability and Fault Tolerance
CAP Theorem
Architecture Design Methodology
Platform Selection
Data Validation
Best Practices for Modern Data Projects
Module 6: Hands-on Data Architecture Workshop
Building Data Architecture Solutions
Basic Architecture Scenarios
Intermediate Architecture Scenarios
Advanced Architecture Scenarios
Solution Design Reviews
Architecture Best Practices Workshops