AWS Certified Solutions Architect Associate (SAA-C03): Storage, Databases, Machine Learning, and Big Data Analytics

Course Description

This course provides an in-depth understanding of AWS data services, including storage, databases, analytics, and machine learning. Learners will explore relational databases using Amazon RDS and Aurora, including high availability, scaling, backups, and security.

The course also covers NoSQL databases like DynamoDB, including global tables, streams, caching, and performance optimization. Learners will explore other specialized databases such as DocumentDB, Neptune, and Timestream for specific use cases.

In addition, the course dives into data transfer and migration services, including AWS DataSync, Storage Gateway, and Database Migration Service (DMS). Learners will also explore big data and analytics services such as Amazon Redshift, EMR, Glue, and Athena for processing and analyzing large datasets.

Finally, the course introduces AWS machine learning services, including SageMaker and AI services for vision, speech, and language processing. Through demos and real-world scenarios, learners will gain the skills needed to design data-driven architectures and prepare for the AWS Certified Solutions Architect – Associate (SAA-C03) exam.

Who is this course for

• AWS certification aspirants (Solutions Architect Associate)

• Cloud engineers working with data and storage

• Data engineers and analysts using AWS services

• Developers building data-driven applications

• Beginners exploring machine learning on AWS

Course Objectives

By the end of this course, learners will be able to:

• Design and manage relational and NoSQL databases on AWS

• Choose appropriate storage and database solutions for different use cases

• Implement high availability, backup, and recovery strategies for databases

• Use AWS data transfer and migration services effectively

• Design big data and analytics pipelines using AWS services

• Leverage AWS machine learning services for real-world applications

• Optimize performance, scalability, and cost for data workloads

• Apply best practices for data security and governance

• Prepare effectively for the SAA-C03 certification exam

Prerequisites

• Basic understanding of AWS core services (EC2, S3, VPC)

• Familiarity with databases and data concepts (SQL/NoSQL basics)

• Basic knowledge of cloud computing

• No prior machine learning experience required

Course outline

Section 1: Amazon Relational Database Service (RDS)

• Reviewing Relational Databases

• Amazon Relational Database Service (RDS)

• Amazon RDS Networking

• RDS Backups and Maintenance

• Demo: Create an RDS Instance and Enable Automated Backups

• Amazon RDS Multi-AZ and High-availability

• Demo: Creating a Multi-AZ RDS Instance Deployment

• Offloading Read Traffic with Read Replicas

• Demo: Creating an RDS Multi-AZ Cluster Deployment

• Amazon RDS Authentication

• Demo: Using AWS Secrets Manager with Amazon RDS

• Amazon RDS Encryption

• Cost Optimization for Amazon RDS

• RDS Custom

• RDS Proxy

• Module Summary and Exam Tips

Section 2: Amazon Aurora

• Amazon Aurora Overview

• Amazon Aurora Storage

• Replicas in Amazon Aurora

• High-availability and Scaling

• Backing up Amazon Aurora

• Demo: Creating an Amazon Aurora Database - Part 1

• Demo: Creating an Amazon Aurora Database - Part 2

• Aurora Serverless

• Demo: Creating an Amazon Aurora Serverless Database

• Amazon Aurora Global Databases

• Amazon Aurora Machine Learning

• Module Summary and Exam Tips

Section 3: Amazon DynamoDB

• Amazon DynamoDB Overview

• Amazon DynamoDB High-availability and Monitoring

• DynamoDB Capacity Modes

• Demo: Creating an Amazon DynamoDB Table

• DynamoDB Security

• Demo: Using Different KMS Keys for DynamoDB Encryption

• DynamoDB Global Tables

• DynamoDB Streams

• Demo: Triggering Lambda Functions via DynamoDB Streams

• DynamoDB Accelerator (DAX)

• DynamoDB Items Time to Live (TTL)

• Amazon DynamoDB Backups

• Module Summary and Exam Tips

Section 4: Other AWS Databases

• Amazon DocumentDB

• Amazon Neptune

• Amazon Keyspaces (for Apache Cassandra)

• Amazon Quantum Ledger Database (QLDB)

• Amazon Timestream

• Module Summary and Exam Tips

Section 5: Other AWS Storage, Transfer, and Migration Services

• AWS Snow Family

• AWS Storage Gateway - File Gateways

• AWS Storage Gateway - Volume Gateways

• AWS Storage Gateway - Tape Gateways

• AWS Lake Formation

• AWS Transfer Family

• AWS DataSync

• AWS Backup

• Demo: Creating Backups with AWS Backup

• AWS Application and Server Migration Services

• AWS Database Migration Service (DMS)

• Database Schema Conversions

• Module Summary and Exam Tips

Section 6: Big Data and Analytics Services

• Amazon Redshift

• Redshift High Availability, Snapshots, and Performance

• Amazon Redshift Spectrum

• Amazon Elastic MapReduce (EMR)

• AWS Glue

• Amazon Athena

• Demo: Query Logs Using Amazon Athena

• Amazon QuickSight

• Amazon OpenSearch Service

• Module Summary and Exam Tips

Section 7: Machine Learning Services

• Amazon SageMaker

• Amazon Rekognition

• Demo: Recognizing Images Using Amazon Rekognition

• Amazon Polly

• Demo: Generating Text-to-speech with Polly

• Amazon Translate

• Amazon Lex

• Amazon Connect

• Amazon Comprehend

• Amazon Forecast

• Amazon Kendra

• Amazon Textract

• Amazon Personalize

• Amazon Transcribe

• Amazon Fraud Detector

• Module Summary and Exam Tips

Testimonials