AWS Certified Data Engineer - Associate
Prepare for the DEA-C01 exam and validate your ability to implement data pipelines and optimize cost and performance.
Course Content
4 modules · 82 lessons
Module 1: Data Ingestion and Transformation
Perform data ingestion, transformation, and orchestrate pipelines. (34% of exam)
Data Ingestion
Read data from streaming and batch sources.
- Lesson Kinesis Data Streams Overview 10 min
- Quiz Kinesis Data Streams Overview Quiz 5 questions
- Lesson Amazon MSK Streaming 10 min
- Quiz Amazon MSK Streaming Quiz 5 questions
- Lesson S3 Batch Ingestion 10 min
- Quiz S3 Batch Ingestion Quiz 5 questions
- Lesson DMS Database Migration 10 min
- Quiz DMS Database Migration Quiz 5 questions
- Lesson EventBridge Schedulers 10 min
- Quiz EventBridge Schedulers Quiz 5 questions
- Lesson S3 Event Notifications 10 min
- Quiz S3 Event Notifications Quiz 5 questions
- Lesson Lambda with Kinesis 10 min
- Quiz Lambda with Kinesis Quiz 5 questions
- Lesson Throttling and Rate Limits 10 min
- Quiz Throttling and Rate Limits Quiz 5 questions
Data Transformation
Transform and process data using AWS services.
- Lesson AWS Glue ETL Jobs 10 min
- Quiz AWS Glue ETL Jobs Quiz 5 questions
- Lesson EMR Data Processing 10 min
- Quiz EMR Data Processing Quiz 5 questions
- Lesson Lambda Transformations 10 min
- Quiz Lambda Transformations Quiz 5 questions
- Lesson Redshift Data Processing 10 min
- Quiz Redshift Data Processing Quiz 5 questions
- Lesson Parquet and Data Formats 10 min
- Quiz Parquet and Data Formats Quiz 5 questions
- Lesson JDBC and ODBC Connections 10 min
- Quiz JDBC and ODBC Connections Quiz 5 questions
Pipeline Orchestration
Orchestrate data pipelines using workflow services.
- Lesson Step Functions Workflows 10 min
- Quiz Step Functions Workflows Quiz 5 questions
- Lesson Amazon MWAA Airflow 10 min
- Quiz Amazon MWAA Airflow Quiz 5 questions
- Lesson Glue Workflows 10 min
- Quiz Glue Workflows Quiz 5 questions
- Lesson EventBridge Orchestration 10 min
- Quiz EventBridge Orchestration Quiz 5 questions
Programming Concepts
Apply programming concepts for data engineering.
- Lesson Python for Data Engineering 10 min
- Quiz Python for Data Engineering Quiz 5 questions
- Lesson SQL Best Practices 10 min
- Quiz SQL Best Practices Quiz 5 questions
- Lesson IaC with CloudFormation 10 min
- Quiz IaC with CloudFormation Quiz 5 questions
- Lesson SAM for Serverless 10 min
- Quiz SAM for Serverless Quiz 5 questions
- Lesson CI/CD for Data Pipelines 10 min
- Quiz CI/CD for Data Pipelines Quiz 5 questions
Module 2: Data Store Management
Choose data stores, catalog data, and manage lifecycles. (26% of exam)
Choosing Data Stores
Select appropriate storage for cost and performance.
- Lesson Amazon Redshift Overview 10 min
- Quiz Amazon Redshift Overview Quiz 5 questions
- Lesson DynamoDB for Data Engineering 10 min
- Quiz DynamoDB for Data Engineering Quiz 5 questions
- Lesson S3 Data Lake Storage 10 min
- Quiz S3 Data Lake Storage Quiz 5 questions
- Lesson RDS and Aurora 10 min
- Quiz RDS and Aurora Quiz 5 questions
- Lesson Open Table Formats Iceberg 10 min
- Quiz Open Table Formats Iceberg Quiz 5 questions
Data Cataloging
Build and manage data catalogs.
Data Lifecycle Management
Manage data lifecycle and versioning.
Schema Design
Design data models and handle schema evolution.
- Lesson Redshift Schema Design 10 min
- Quiz Redshift Schema Design Quiz 5 questions
- Lesson DynamoDB Data Modeling 10 min
- Quiz DynamoDB Data Modeling Quiz 5 questions
- Lesson Schema Conversion Tool 10 min
- Quiz Schema Conversion Tool Quiz 5 questions
- Lesson Data Lineage Tracking 10 min
- Quiz Data Lineage Tracking Quiz 5 questions
- Lesson Partitioning Strategies 10 min
- Quiz Partitioning Strategies Quiz 5 questions
Module 3: Data Operations and Support
Automate, analyze, and ensure data quality. (22% of exam)
Data Automation
Automate data processing using AWS services.
Data Analysis
Analyze and visualize data.
- Lesson Amazon QuickSight 10 min
- Quiz Amazon QuickSight Quiz 5 questions
- Lesson Athena SQL Analysis 10 min
- Quiz Athena SQL Analysis Quiz 5 questions
- Lesson Athena Spark Notebooks 10 min
- Quiz Athena Spark Notebooks Quiz 5 questions
- Lesson Data Aggregation Techniques 10 min
- Quiz Data Aggregation Techniques Quiz 5 questions
Pipeline Monitoring
Monitor and troubleshoot data pipelines.
- Lesson CloudWatch Logging 10 min
- Quiz CloudWatch Logging Quiz 5 questions
- Lesson CloudTrail Auditing 10 min
- Quiz CloudTrail Auditing Quiz 5 questions
- Lesson Pipeline Troubleshooting 10 min
- Quiz Pipeline Troubleshooting Quiz 5 questions
- Lesson Performance Optimization 10 min
- Quiz Performance Optimization Quiz 5 questions
Data Quality
Ensure data quality and consistency.
Advanced Analytics
Perform advanced data analysis and visualization.
Module 4: Data Security and Governance
Apply security, encryption, and governance. (18% of exam)
Authentication
Implement authentication mechanisms.
Authorization
Apply authorization and access control.
- Lesson Lake Formation Permissions 10 min
- Quiz Lake Formation Permissions Quiz 5 questions
- Lesson Redshift Access Control 10 min
- Quiz Redshift Access Control Quiz 5 questions
- Lesson Fine-Grained Access 10 min
- Quiz Fine-Grained Access Quiz 5 questions
- Lesson Least Privilege Policies 10 min
- Quiz Least Privilege Policies Quiz 5 questions
Data Encryption
Implement encryption at rest and in transit.
Data Governance
Implement data privacy and governance.
- Lesson Amazon Macie PII Detection 10 min
- Quiz Amazon Macie PII Detection Quiz 5 questions
- Lesson Data Sharing Strategies 10 min
- Quiz Data Sharing Strategies Quiz 5 questions
- Lesson AWS Config Compliance 10 min
- Quiz AWS Config Compliance Quiz 5 questions
- Lesson Data Sovereignty 10 min
- Quiz Data Sovereignty Quiz 5 questions
Audit and Logging
Prepare logs for audit and compliance.
- Lesson CloudTrail Lake 10 min
- Quiz CloudTrail Lake Quiz 5 questions
- Lesson CloudWatch Logs Insights 10 min
- Quiz CloudWatch Logs Insights Quiz 5 questions
- Lesson OpenSearch Log Analysis 10 min
- Quiz OpenSearch Log Analysis Quiz 5 questions
- Lesson Centralized Logging 10 min
- Quiz Centralized Logging Quiz 5 questions
- Lesson SageMaker Data Catalog 10 min
- Quiz SageMaker Data Catalog Quiz 5 questions