AWS Certified Database - Specialty

Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.

$14.99/$24.99

Introduction

1. Purpose Built Databases
4m

Quick refresher on the basics

1. Types of data
5m
2. Relational databases
6m
3. Non-relational databases
7m

Amazon RDS and Aurora

1. Amazon RDS overview
4m
2. RDS pricing model
1m
3. Instance type, storage type and storage auto scaling for RDS
4m
4. RDS parameter groups
4m
5. RDS option groups
2m
6. RDS - Hands on
14m
7. RDS security - Network
3m
8. RDS security - IAM
6m
9. Rotating RDS DB credentials
1m
10. Windows authentication in RDS for SQL Server
3m
11. RDS encryption in transit and at rest
5m
12. RDS backups
4m
13. Copying and sharing RDS snapshots
2m
14. How to encrypt an unencrypted RDS database
2m
15. DB restore options in RDS
4m
16. Exporting RDS DB snapshot to S3
2m
17. RDS backup and restore - Hands on
5m
18. RDS Multi-AZ deployments and read replicas
9m
19. Read replica use cases
1m
20. Promoting a read replica to a standalone DB instance
3m
21. RDS Multi-AZ failover and replica promotion - Demo
14m
22. Enabling writes on a read replica
1m
23. RDS read replica capabilities
2m
24. RDS Second-tier replicas and replica promotion - Demo
7m
25. Cross-region read replicas in RDS
1m
26. RDS replicas with an external database
2m
27. RDS disaster recovery strategies
6m
28. Troubleshooting replica issues in RDS
6m
29. Performance hit on new read replicas
2m
30. Scaling and sharding in RDS
3m
31. RDS monitoring
4m
32. RDS event subscriptions, recommendations and logs
5m
33. Exporting RDS logs to S3
2m
34. RDS Enhanced Monitoring
2m
35. RDS Performance Insights
10m
36. CloudWatch Application Insights
1m
37. RDS on VMware
1m
38. RDS - Good things to know
2m
39. Aurora overview
4m
40. Aurora architecture
8m
41. Aurora Parallel Query
3m
42. Aurora Serverless
5m
43. Data API for Aurora Serverless
2m
44. Aurora multi-master
2m
45. Aurora cross region replicas and Aurora Global database
2m
46. Reliability features in Aurora
3m
47. Aurora pricing model
3m
48. Aurora security - Network, IAM and encryption
3m
49. Parameter groups in Aurora and Aurora Serverless
4m
50. Creating an Aurora database - Hands on
9m
51. Creating an Aurora Serverless database - Hands on
2m
52. Using Data API with Aurora Serverless database - Hands on
2m
53. Scaling options in Aurora
5m
54. Aurora monitoring and advanced auditing
4m
55. Monitoring in RDS and Aurora - Demo
4m
56. Exporting Aurora logs
1m
57. Database activity streams in Aurora
1m
58. Troubleshooting storage issues in Aurora
3m
59. Aurora benchmarking
1m
60. Exporting data from Aurora into S3
2m
61. Aurora backups and backtracking
4m
62. Aurora backups vs snapshots vs backtrack
2m
63. Aurora backup, restore, PITR and backtrack - Demo
3m
64. Cloning databases in Aurora
3m
65. Aurora failovers
4m
66. Cluster Cache Management (CCM) in Aurora PostgreSQL
3m
67. Simulating fault tolerance or resiliency in Aurora
6m
68. Simulating failovers in Aurora - Demo
1m
69. Aurora failover priorities in action - Demo
10m
70. Fast failover in Aurora PostgreSQL
6m
71. Cluster replication options for Aurora MySQL
5m
72. Aurora replicas vs RDS MySQL replicas
3m
73. Comparison of RDS deployments
5m
74. How to invoke Lambda functions from Aurora MySQL
2m
75. How to load data from S3 into Aurora MySQL
2m
76. RDS / Aurora – Good things to know
3m

Amazon DynamoDB and DAX

1. DynamoDB overview
3m
2. Working with DynamoDB - Hands on
11m
3. DynamoDB basics
7m
4. DynamoDB consistency
5m
5. DynamoDB pricing model
6m
6. DynamoDB throughput
4m
7. Calculating capacity units
4m
8. DynamoDB burst capacity and adaptive capacity
6m
9. DynamoDB local secondary index (LSI)
4m
10. DynamoDB global secondary index (GSI)
3m
11. Choosing between LSI and GSI
3m
12. Simple design patterns with DynamoDB
4m
13. Errors and exceptions in DynamoDB
3m
14. DynamoDB partitions
5m
15. DynamoDB partition behavior example
6m
16. Scaling options in DynamoDB
4m
17. DynamoDB scaling and partition behavior
4m
18. DynamoDB best practices
4m
19. DynamoDB best practices (contd.)
4m
20. Large object patterns and table operations
5m
21. DynamoDB accelerator (DAX)
3m
22. DAX architecture
2m
23. DAX operations
4m
24. Implementing DAX - Hands on
6m
25. DynamoDB backup and restore
7m
26. DynamoDb backup and restore - Hands on
3m
27. Continuous backup with PITR
2m
28. Continuous backup with PITR - Hands on
4m
29. DynamoDB encryption
4m
30. DynamoDB streams
3m
31. DynamoDB TTL
2m
32. DynamoDB TTL - Hands on
5m
33. TTL use cases
1m
34. DynamoDB global tables
5m
35. DynamoDB global tables - Hands on
6m
36. Fine-grained access control and Web-identity federation in DynamoDB
6m
37. CloudWatch contributor insights for DynamoDB
1m

Amazon Redshift

1. Redshift overview
3m
2. Creating a Redshift cluster - Hands on
9m
3. Redshift architecture
2m
4. Loading data into Redshift
3m
5. Loading data from S3 into Redshift - Hands on
7m
6. More ways to load data into Redshift
2m
7. Redshift Spectrum
3m
8. Querying S3 data with Redshift Spectrum - Hands on
8m
9. Redshift federated query
1m
10. Star schema in data warehouses
2m
11. Redshift fundamentals
9m
12. Redshift Workload Management (WLM)
3m
13. Redshift concurrency scaling
2m
14. Redshift scaling
2m
15. Redshift backup, restore and cross-region snapshots
3m
16. Redshift Multi-AZ deployment alternative
4m
17. Redshift availability and durability
2m
18. Redshift security
3m
19. Enhanced VPC routing in Redshift
4m
20. Redshift monitoring
3m
21. Redshift pricing
1m
22. Redshift related services - Athena and Quicksight
3m
23. AQUA for Redshift
2m

Amazon ElastiCache

1. ElastiCache overview
5m
2. Caching strategies
5m
3. Redis architecture and Multi-AZ auto-failover
5m
4. Redis backup and restore
2m
5. Redis scaling and replication
6m
6. Creating a Redis cluster - Hands on
5m
7. Redis global datastore
3m
8. Redis - Good things to know
2m
9. Redis best practices
2m
10. Redis use cases
3m
11. Memcached overview
2m
12. Memcached architecture
1m
13. Memcached auto discovery
2m
14. Memcached scaling
2m
15. Creating a Memcached cluster - Hands on
4m
16. Choosing between Redis and Memcached
2m
17. ElastiCache security
4m
18. ElastiCache logging and monitoring
1m
19. ElastiCache pricing
1m

Amazon DocumentDB (with MongoDB compatibility)

1. DocumentDB overview
2m
2. What and why about document databases
2m
3. DocumentDB architecture
3m
4. DocumentDB backup and restore
2m
5. DocumentDB scaling
1m
6. DocumentDB security
2m
7. DocumentDB pricing
1m
8. DocumentDB monitoring
3m
9. DocumentDB performance management
1m
10. Creating a DocumentDB cluster - Hands on
5m

Amazon Neptune

1. Neptune overview
5m
2. Neptune architecture
3m
3. Creating a Neptune cluster - Hands on
13m
4. Bulk loading graph data into Neptune
2m
5. Bulk loading graph data into Neptune from S3 - Hands on
14m
6. Neptune Workbench
1m
7. Querying Neptune via Jupyter Notebooks - Hands on
5m
8. Neptune replication and high availability
2m
9. Neptune backup and restore
2m
10. Database cloning in Neptune
2m
11. Neptune security
2m
12. Neptune monitoring
1m
13. Query queuing in Neptune
1m
14. Neptune service errors
2m
15. SPARQL federated query
1m
16. Neptune streams
2m
17. Neptune pricing
1m

Amazon Elasticsearch Service

1. Amazon Elasticsearch Service overview
3m
2. ElasticSearch Service patterns
2m
3. Elasticsearch Service - Multi-AZ
1m
4. Logging options in Elasticsearch Service
1m
5. ElasticSearch Service pricing
1m
6. ElasticSearch Service - Hands on
4m

Amazon Timestream

1. Timestream overview
4m
2. Timestream pricing
1m

Amazon QLDB

1. QLDB overview
2m
2. QLDB architecture
3m
3. QLDB views
2m
4. Working with QLDB
2m
5. Data verification in QLDB
2m
6. Creating a QLDB ledger - Hands on
12m
7. Data verification in QLDB - Hands on
3m
8. QLDB backup and restore (an alternative)
1m
9. QLDB streams
1m
10. QLDB high availability, durability and an alternative to CRR
1m
11. QLDB security
1m
12. QLDB monitoring
1m
13. QLDB pricing
1m

Amazon Keyspaces (for Apache Cassandra)

1. Keyspaces overview
3m
2. Migrating from Cassandra to Keyspaces
1m
3. Read and write consistency in Keyspaces
1m
4. Keyspaces pricing
3m
5. Working with Keyspaces - Hands on
5m

Comparing AWS Databases

1. Comparison of AWS Databases
6m

Database Migration, DMS and SCT

1. Database migration overview
5m
2. DMS sources and targets
2m
3. DMS architecture and overview
4m
4. Migration with DMS in action - Hands on
12m
5. SCT overview
3m
6. Workload Qualification Framework (WQF)
1m
7. DMS tasks and task assessment reports
2m
8. DMS migration types
1m
9. DMS - Good things to know
1m
10. Migrating large tables and LOBs with DMS
5m
11. DW migration with SCT
5m
12. Migration playbooks
3m
13. DMS monitoring
2m
14. DMS validation
2m
15. DMS statistics and control tables
3m
16. DMS security - IAM, encryption and networking
5m
17. DMS pricing
1m
18. DMS general best practices
1m
19. DMS migration architectures to minimize downtime
6m
20. Migrating large databases
2m
21. Migrating to RDS databases
8m
22. Migrating to Aurora
6m
23. Migrating Redis workloads to ElastiCache
4m
24. Migrating to DocumentDB
7m
25. Streaming use cases for DMS
4m

Monitoring, Logging and Encryption

1. Encryption and Snapshots
3m
2. Database Logging
5m
3. Secrets Manager
1m
4. Active Directory with RDS Microsoft SQL Server
2m

CloudFormation and Automation

1. CloudFormation Overview
7m
2. CloudFormation Create Stack Hands On
6m
3. CloudFormation Update and Delete Stack Hands On
8m
4. YAML Crash Course
4m
5. CloudFormation Resources
6m
6. CloudFormation Parameters
5m
7. CloudFormation Mappings
3m
8. CloudFormation Outputs
3m
9. CloudFormation Conditions
2m
10. CloudFormation Intrinsic Functions
6m

VPC - Networking

1. VPC Section Structure
1m
2. VPC, Subnets, IGW and NAT
5m
3. NACL, SG, VPC Flow Logs
5m
4. VPC Peering, Endpoints, VPN, DX
6m
5. VPC Cheat Sheet & Closing Comments
3m

Exam preparation

1. Exam Guide & Sample Questions
2m
2. Sample question 1
4m
3. Sample question 2
4m
4. Sample question 3
3m
5. Sample question 4
2m
6. Sample question 5
3m
7. Sample question 6
2m
8. Sample question 7
4m
9. Sample question 8
4m
10. Sample question 9
5m
11. Sample question 10
4m
12. Exam Strategy: How to tackle exam questions
1m
13. Additional Resources
1m