Database Services for Data Engineering
Description
Comprehensive understanding of AWS database services including RDS, DynamoDB, and specialized databases for data engineering workflows.
Learning Objectives
Learners will master various AWS database services, design appropriate database architectures for different data patterns, implement database integration with data pipelines, and optimize database performance for data engineering workloads.
Topics (6)
RDS engines, Multi-AZ deployments, read replicas, backup strategies, and integration with data pipelines.
DynamoDB concepts, partition key design, global secondary indexes, DynamoDB Streams, and performance optimization.
AWS DMS, database migration strategies, CDC (Change Data Capture), and database integration patterns.
Performance Insights, CloudWatch metrics, query optimization, and database tuning for data workloads.
Database encryption, IAM database authentication, network security, and compliance frameworks for databases.
Graph databases with Neptune, document databases with DocumentDB, time-series data with Timestream, and use case selection.