Overview
In this online training course, students will be taught the fundamental skills for deploying AWS database resources, managing those resources, and migrating them to additional regions or database engines. We’ll explore workload-specific database design, discuss how different database types are best leveraged, and dive into services like RDS, Aurora, and DynamoDB.
This course can be used in order to prepare for the AWS Certified Database Specialty exam.
COURSE INSTRUCTOR: Faisal Khan, AWS, Check Point, Cybersecurity, Cisco
COURSE DIFFICULTY: Intermediate
COURSE DURATION: 10h 1m
After completing this online training course, students will be able to:
-
Describe RDS Security
-
Better utilize Aurora, its features, parameters, and scaling
-
Better understand DynamoDB
-
Better understand Redshift
-
Better understand ElastiCache and Redis
-
Better understand Document DB
-
Better understand Neptune
-
Utilize Database migration and Database Migration Service (DMS)
AWS Certified Database – Specialty is intended for individuals with experience and expertise working with on-premises and AWS Cloud-based relational and non-relational databases.
- Five years of experience with common database technologies
- Two years of hands-on experience and expertise working with on-premises and AWS Cloud-based relational and NoSQL databases
- Ability to understand and differentiate the key features of AWS database services
- Ability to analyze needs and requirements to design and recommend appropriate database solutions by using AWS services
- Course Introduction
- Purpose Built Database
- The Basics
- Introduction to Amazon RDS
- RDS Security
- Introduction to Aurora
- Aurora Architecture
- Aurora Features and Pricing
- Parameter Groups in Aurora
- Scaling in Aurora
- Monitoring and Performance in Aurora
- Aurora Data Preservations and Backups
- Cluster Replication
- Aurora – Good Things to Know
- DynamoDB Overview
- DynamoDB Indexes
- DynamoDB Partitions
- DynamoDB Scaling
- DynamoDB Tips and Best Practices
- DynamoDB Accelerator (DAX)
- Implementing DAX
- Backup and Restore in DynamoDB
- DynamoDB Encryption and Streams
- Time To Live (TTL)
- DynamoDB Global Tables
- DynamoDB Access Control
- Redshift
- Loading Data into Redshift
- Redshift Schema and Table Design
- Redshift Data
- Redshift Workload Management and Scaling
- Redshift Backup and Restore
- Redshift Security and VPC Routing
- Redshift Monitoring, Logging and Pricing
- Athena, Aqua, and Quicksightd
- ElastiCache Introduction
- Redis Architecture and Failure Protection
- Redis Scaling and Replication
- Redis Tips, Best Practices, and Use Cases
- Introduction to Memcached
- ElastiCache Security
- ElastiCache Logging, Monitoring, and Pricing
- DocumentDB Introduction
- DocumentDB Data Protection
- DocumentDB Scaling and Security
- Pricing, Monitoring, and Performance Management
- Introduction to Neptune
- Loading Data and Querying in Neptune
- Data Protecting and Scaling in Neptune
- Neptune Security and Monitoring
- Neptune Querying, Streaming and Pricing
- Amazon Elasticsearch Service
- Timestream
- QLDB
- Keyspaces
- Comparing AWS Databases
- Database Migration
- Database Migration Service (DMS)
- Schema Conversion Tool (SCT)
- DMS Tasks and Migrations
- DMS Monitoring, Logs, and Table Statistics
- DMS Security and Networking
- DMS Pricing and Best Practices
- Migration Approaches
- Migrating to
- Key Management Service
- Database Logging, Secrets Manager, and Active Directory
- Cloud Formation
- Cloud Formation Resources
- Cloud Formation Parameters and Mapping
- Cloud Formation Outputs, References, and Conditions
- Intrinsic Functions
- Cloud Formation Stacks
- CloudFormation for DB Specialty Exam
- VPC Primer
- Lambda
- Service Migration Services and EBS
- Business Continuity and Disaster Recovery