AWS Certified Data Engineer Associate (DEA-C01) Cert Prep
12h 58mIntermediate2025-06-04
Authors
Digital Cloud Training
Course details
The AWS Certified Data Engineer - Associate (DEA-C01) exam validates your ability to implement data pipelines and to monitor, troubleshoot, and optimize cost and performance issues in accordance with best practices. This course helps you prepare for the examine, and outlines the tasks you need to know, including how to: ingest and transform data, and orchestrate data pipelines while applying programming concepts; choose an optimal data store, design data models, catalog data schemas, and manage data lifecycles; operationalize, maintain, and monitor data pipelines; analyze data and ensure data quality; and implement appropriate authentication, authorization, data encryption, privacy and governance.
Skills covered
Data EngineeringCloud ServicesCloud PlatformsCert PrepCloud ComputingData Science
Concepts
0. Introduction
- 01 - Welcome and how to use this course
- 02 - The DEA-C01 exam
- 03 - Hands-on practice - AWS Free Tier vs. sandbox
1. AWS Accounts and Identity Access Management (IAM)
- 04 - Introduction
- 05 - AWS account overview
- 06 - Hands-on learning - Create your AWS Free Tier account
- 07 - Hands-on learning - Set up an account with a budget and alarm
- 08 - AWS IAM
- 09 - Hands-on learning - Create an IAM user and group
- 10 - IAM authentication and multi-factor authentication (MFA)
- 11 - Hands-on learning - Enable MFA
- 12 - Access control methods - RBAC and ABAC
- 13 - Hands-on learning - Switch IAM roles
2. Data Pipelines
- 14 - Introduction
- 15 - Data pipelines overview
- 16 - The three Vs
- 17 - Types of data
- 18 - Batch vs. streaming
- 19 - OLAP vs. OTAP
- 20 - Data formats
- 21 - Data modeling
- 22 - Data warehouses
- 23 - Data lakes
- 24 - Design considerations
- 25 - State management and replayability
- 26 - Use cases
- 27 - Distributed computing
- 28 - Data pipelines on AWS
3. SQL Primer
- 29 - Introduction
- 30 - Using SQL with AWS
- 31 - Hands-on learning - Create a SQL environment
- 32 - SQL commands
- 33 - SQL data types
- 34 - Data definition language (DDL)
- 35 - Data query language (DQL)
- 36 - SQL operators
- 37 - Displaying results
- 38 - SQL functions
- 39 - SQL joins
- 40 - SQL constraints
- 41 - Data manipulation language
- 42 - Hands-on learning - Query a database
4. Data Ingestion
- 43 - Introduction
- 44 - Data ingestion scenarios
- 45 - AWS Database Migration Service
- 46 - Schema conversion
- 47 - Change data capture
- 48 - AWS DataSync
- 49 - AWS Storage Gateway
- 50 - AWS Snow Family
- 51 - AWS Transfer Family
- 52 - AWS Glue
- 53 - AWS Glue Data Catalog
- 54 - Hands-on learning - Create an AWS Glue Data Catalog
- 55 - AWS Glue Crawler
- 56 - Hands-on learning - Create an AWS Glue Crawler
- 57 - Amazon Kinesis Data Streams
- 58 - Hands-on learning - Create a data stream
- 59 - Consumer throughput
- 60 - Reading data with AWS Lambda
- 61 - AWS Lambda concurrency
- 62 - Using Amazon EFS with AWS Lambda
- 63 - Hands-on learning - Create and use an AWS Lambda function
- 64 - Amazon Kinesis Client Library (KCL)
- 65 - Amazon MSK
- 66 - Amazon Data Firehose
- 67 - Hands-on learning - Configure an Amazon Data Firehose stream
- 68 - Amazon DynamoDB Streams
- 69 - AWS Glue Schema Registry
- 70 - Amazon AppFlow
- 71 - Consume data APIs
- 72 - Data exchange
5. Data Transformation
- 73 - Introduction
- 74 - Common scenarios
- 75 - Amazon EMR introduction
- 76 - Apache Hadoop
- 77 - Hadoop frameworks
- 78 - Apache Spark
- 79 - Amazon EMR architecture
- 80 - Hands-on learning - Launch an Amazon EMR cluster
- 81 - Amazon EMR serverless
- 82 - Amazon EMR on EKS
- 83 - Amazon EMR Studio
- 84 - Hands-on learning - Use Amazon EMR Studio
- 85 - Container services for batch processing
- 86 - AWS Batch
- 87 - Amazon Managed Service for Apache Flink
- 88 - AWS Glue DataBrew
- 89 - Hands-on learning - Create an AWS Glue DataBrew project
6. Data Storage
- 90 - Introduction
- 91 - Storage platforms
- 92 - Aligning to access patterns
- 93 - Cost and performance comparisons
- 94 - Amazon RDS
- 95 - Amazon Aurora
- 96 - Hands-on learning - Create an Amazon RDS database
- 97 - Amazon DynamoDB
- 98 - DynamoDB partitions and primary keys
- 99 - Hands-on learning - Practice creating DynamoDB tables
- 100 - DynamoDB LSI and GSI
- 101 - Hands-on learning - Create an LSI and a GSI
- 102 - Hands-on learning - Add a time to live (TTL) to items
- 103 - Amazon S3 for data lakes
- 104 - Amazon S3 storage classes
- 105 - Amazon S3 lifecycle policies
- 106 - Amazon S3 versioning and replication
- 107 - Hands-on learning - Configure replication and lifecycle
- 108 - Amazon S3 performance optimization
- 109 - Server access logging
- 110 - Using Amazon S3 for staging data
- 111 - Amazon S3 access points
- 112 - Other database services
7. Data Analytics
- 113 - Introduction
- 114 - Analytics services
- 115 - Amazon Redshift
- 116 - Hands-on learning - Launch an Amazon Redshift cluster
- 117 - Amazon Redshift serverless
- 118 - Schema design for Amazon Redshift
- 119 - Loading data into Amazon Redshift
- 120 - Hands-on learning - Use the Amazon Redshift COPY command
- 121 - Unloading Amazon Redshift data
- 122 - Hands-on learning - Unload data to Amazon S3
- 123 - Column compression
- 124 - Distribution styles
- 125 - Maintaining tables
- 126 - Amazon Redshift federated queries
- 127 - Amazon Redshift Spectrum
- 128 - Amazon Redshift materialized views
- 129 - Transform data with stored procedures
- 130 - Workload management
- 131 - Zero-ETL integrations
- 132 - Streaming ingestion
- 133 - Amazon Athena
- 134 - Partitioning data
- 135 - Creating views
- 136 - Hands-on learning - Create and query tables using Athena
- 137 - AWS Lake Formation
- 138 - Hands-on learning - Create a data lake
- 139 - Amazon QuickSight
- 140 - Hands-on learning - Create a QuickSight dashboard
- 141 - Amazon OpenSearch
8. Orchestration
- 142 - Introduction
- 143 - Serverless services and event-driven architecture
- 144 - Amazon Simple Queue Service (SQS)
- 145 - Amazon Simple Notification Service (SNS)
- 146 - AWS Step Functions
- 147 - Hands-on learning - Create a state machine for data analytics
- 148 - Amazon S3 event notifications
- 149 - Amazon EventBridge
- 150 - Hands-on learning - Create an event bus and rule
- 151 - Amazon Managed Workflows for Apache Airflow
- 152 - Hands-on learning - Orchestrate EMR tasks using Amazon MWAA
- 153 - AWS CloudFormation
- 154 - Hands-on learning - Create an AWS Glue Catalog with partitions
- 155 - AWS Serverless Application Model (SAM)
- 156 - Hands-on learning - Run a SAM app using CloudShell
- 157 - AWS Cloud Development Kit (CDK)
- 158 - CI CD overview
- 159 - AWS CodeCommit and CodePipeline
- 160 - Hands-on learning - Install Git
- 161 - Hands-on learning - Deploy an AWS Glue job with CodePipeline
9. Maintenance and Monitoring
- 162 - Introduction
- 163 - Amazon CloudWatch overview
- 164 - Hands-on learning - Create a custom metric
- 165 - Hands-on learning - Create an Amazon CloudWatch alarm
- 166 - Amazon CloudWatch Logs Insights
- 167 - Hands-on learning - Query Amazon CloudWatch logs
- 168 - DynamoDB capacity units
- 169 - DynamoDB performance and throttling
- 170 - RDS performance optimization
- 171 - RDS Proxy
- 172 - Amazon Redshift performance optimization
10. Security and Governance
- 173 - Introduction
- 174 - AWS Key Management Service (KMS)
- 175 - Virtual private cloud (VPC) overview
- 176 - Defining VPC Classless Interdomain Routing (CIDR) blocks
- 177 - Hands-on learning - Create a custom VPC
- 178 - Security groups and network ACLs
- 179 - Hands-on learning - Configure security groups and NACLs
- 180 - VPC peering
- 181 - Hands-on learning - Configure VPC peering
- 182 - VPC endpoints
- 183 - Hands-on learning - Create a VPC endpoint
- 184 - AWS Systems Manager Parameter Store
- 185 - AWS Secrets Manager
- 186 - Hands-on learning - Work with secrets
- 187 - AWS Config
- 188 - AWS CloudTrail
- 189 - Hands-on learning - Create a CloudTrail trail
- 190 - AWS CloudTrail Lake
- 191 - Hands-on learning - Query CloudTrail Lake events
- 192 - Amazon RDS security
- 193 - Amazon Redshift security
- 194 - Database audit logging
- 195 - AWS Audit Manager
- 196 - Amazon Macie