Tech Study DeckTechnical study guides and structured courses
Menu

Course curriculum

AWS Certified Data Engineer Associate 2026 - Hands On!

1 module30 lessons

Curriculum

Modules and lessons

← Course library
Module 01

AWS Certified Data Engineer Associate 2026 - Hands On!

30 lessons
  1. 01AWS Data Engineer Associate: Data Engineering Fundamentals IntroductionReview the AWS Certified Data Engineer Associate fundamentals of data structures, modeling, sampling, Git, and SQL before studying AWS services.Open lesson →
  2. 02Structured, Unstructured, and Semi-Structured Data: AWS Data Engineering FundamentalsLearn how to distinguish structured, unstructured, and semi-structured data using schemas, preprocessing needs, and examples such as CSV, JSON, media files, email, and logs.Open lesson →
  3. 03AWS Data Engineering Fundamentals: Volume, Velocity, and VarietyLearn how data volume, velocity, and variety influence AWS data engineering architecture, processing patterns, transfer methods, and service decisions.Open lesson →
  4. 04AWS Certified Data Engineer Associate: Data Warehouses, Data Lakes, and LakehousesCompare AWS data warehouses, data lakes, and lakehouses, including ETL versus ELT, schema handling, S3, Glue, Athena, Redshift, and Redshift Spectrum.Open lesson →
  5. 05What Is a Data Mesh? AWS Data Engineering FundamentalsLearn how data mesh uses domain ownership, data products, federated governance, and AWS services such as Glue and Lake Formation to support decentralized data management.Open lesson →
  6. 06Managing and Orchestrating AWS ETL PipelinesLearn how ETL and ELT pipelines extract, transform, and load data while handling integrity, timing, missing values, failures, and AWS orchestration services.Open lesson →
  7. 07AWS Data Engineering: Common Data Sources and Data FormatsLearn how JDBC, ODBC, APIs, files, streams, CSV, JSON, Avro, and Parquet support different AWS data engineering ingestion and analytics scenarios.Open lesson →
  8. 08AWS Data Modeling, Data Lineage, and Schema Evolution ReviewReview star schemas, data lineage, Spline Agent, Amazon Neptune, and AWS Glue Schema Registry for AWS Certified Data Engineer Associate preparation.Open lesson →
  9. 09Database Performance Optimization: Indexing, Partitioning, and CompressionLearn how indexing, partitioning, compression, and columnar compression improve database performance while balancing scan volume, storage, disk I/O, CPU usage, and data lifecycle needs.Open lesson →
  10. 10Data Sampling Techniques for AWS Data EngineeringLearn when to use random, stratified, and systematic data sampling, including subgroup representation, fixed intervals, tradeoffs, and common assessment traps.Open lesson →
  11. 11AWS Data Engineering: Data Skew MechanismsLearn how data skew, celebrity hotspots, and temporal imbalance affect distributed partitioning, plus practical mitigation and monitoring strategies.Open lesson →
  12. 12AWS Data Validation and Profiling: Completeness, Consistency, Accuracy, and IntegrityLearn how to validate data completeness, consistency, accuracy, and integrity, including null analysis, cross-source checks, sanity checks, and foreign key validation.Open lesson →
  13. 13SQL Aggregations, Grouping, Sorting, and Pivoting | AWS Data Engineer AssociateReview SQL aggregations, conditional filtering, grouping, sorting, and pivoting patterns for AWS Certified Data Engineer Associate preparation.Open lesson →
  14. 14SQL JOIN Types: Inner, Left, Right, Full Outer, and Cross JoinsLearn how SQL inner, left, right, full outer, and cross joins determine matched rows, unmatched rows, NULL values, and Cartesian-product size.Open lesson →
  15. 15SQL Regular Expressions: Operators, Anchors, and Pattern Matching BasicsLearn the SQL regular-expression operators, anchors, alternatives, character ranges, repetition syntax, and metacharacter shortcuts used for practical pattern matching.Open lesson →
  16. 16AWS Certified Data Engineer Associate: AWS Console UI UpdateUnderstand the AWS Console visual redesign, distinguish styling changes from workflow changes, and follow older course recordings in the updated interface.Open lesson →
  17. 17Set Up an AWS Billing Alarm with AWS BudgetsLearn how to create an AWS zero spend or monthly cost budget notification to detect unexpected charges and protect against forgotten running resources.Open lesson →
  18. 18Amazon S3 Buckets, Objects, Keys, and Upload Constraints | AWS Certified Data Engineer Associate 2026Learn Amazon S3 buckets, regional scope, object keys and prefixes, metadata, tags, multipart uploads, archival, and data-lake use cases.Open lesson →
  19. 19Amazon S3 Hands-On: Buckets, Objects, Access, and Console WorkflowsLearn Amazon S3 bucket creation, naming namespaces, secure defaults, object uploads, public versus pre-signed URLs, folders, and deletion workflows.Open lesson →
  20. 20Amazon S3 Public Object Access with Bucket PoliciesLearn how to configure S3 Block Public Access and a bucket policy to expose objects through public URLs while avoiding broad data exposure.Open lesson →
  21. 21Amazon S3 Versioning: Safe Updates, Recovery, and RollbackLearn how Amazon S3 Versioning protects against accidental overwrites and deletes, supports rollback, handles delete markers, and treats pre-existing objects.Open lesson →
  22. 22Amazon S3 Versioning: Delete Markers, Version IDs, and Object RollbackLearn how Amazon S3 Versioning handles overwrites, null version IDs, delete markers, permanent deletion, and object rollback.Open lesson →
  23. 23Amazon S3 Replication: CRR and SRR Study GuideLearn how Amazon S3 CRR and SRR replication differ, including versioning prerequisites, IAM permissions, asynchronous behavior, and practical use cases.Open lesson →
  24. 24Amazon S3 Replication: Batch Replication, Delete Markers, and Chaining LimitsLearn how Amazon S3 replication handles new, existing, and failed objects, delete markers, version-ID deletions, and multi-bucket replication limits.Open lesson →
  25. 25Amazon S3 Storage Classes: Selection, Retrieval, and Lifecycle Study GuideCompare Amazon S3 storage classes, retrieval behavior, availability, durability, lifecycle transitions, and practical selection criteria.Open lesson →
  26. 26Amazon S3 Storage Classes and Lifecycle TransitionsLearn how to select Amazon S3 storage classes, evaluate access and resilience tradeoffs, change object classes, and automate transitions with Lifecycle rules.Open lesson →
  27. 27AWS S3 Express One Zone: High-Performance Single-AZ StorageLearn how S3 Express One Zone uses single-AZ directory buckets to deliver high performance, low latency, and lower cost while trading off multi-AZ availability.Open lesson →
  28. 28Amazon S3 Lifecycle Rules: Storage Transitions, Expiration, and AnalyticsLearn how Amazon S3 Lifecycle Rules automate storage-class transitions, expiration, version retention, multipart-upload cleanup, and S3 Analytics planning.Open lesson →
  29. 29Amazon S3 Lifecycle Rules: Storage Transitions, Version Expiration, and CleanupLearn how Amazon S3 lifecycle rules transition current and non-current object versions, expire data, delete old versions, and clean up incomplete uploads.Open lesson →
  30. 30AWS S3 Event Notifications and EventBridge: Destinations, Filtering, and PermissionsLearn how AWS S3 Event Notifications use SNS, SQS, Lambda, and EventBridge, including filtering, resource policies, delivery timing, and routing decisions.Open lesson →