AWS Certified Database - Specialty

What’s included

$14.99 / $24.99

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.

4.59

Pay once, own it forever

Video Courses

Introduction

Lectures	Duration
1. Purpose Built Databases	4m

1. Purpose Built Databases

Quick refresher on the basics

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

1. Types of data

2. Relational databases

3. Non-relational databases

Amazon RDS and Aurora

Lectures	Duration
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

1. Amazon RDS overview

2. RDS pricing model

3. Instance type, storage type and storage auto scaling for RDS

4. RDS parameter groups

5. RDS option groups

6. RDS - Hands on

14m

7. RDS security - Network

8. RDS security - IAM

9. Rotating RDS DB credentials

10. Windows authentication in RDS for SQL Server

11. RDS encryption in transit and at rest

12. RDS backups

13. Copying and sharing RDS snapshots

14. How to encrypt an unencrypted RDS database

15. DB restore options in RDS

16. Exporting RDS DB snapshot to S3

17. RDS backup and restore - Hands on

18. RDS Multi-AZ deployments and read replicas

19. Read replica use cases

20. Promoting a read replica to a standalone DB instance

21. RDS Multi-AZ failover and replica promotion - Demo

14m

22. Enabling writes on a read replica

23. RDS read replica capabilities

24. RDS Second-tier replicas and replica promotion - Demo

25. Cross-region read replicas in RDS

26. RDS replicas with an external database

27. RDS disaster recovery strategies

28. Troubleshooting replica issues in RDS

29. Performance hit on new read replicas

30. Scaling and sharding in RDS

31. RDS monitoring

32. RDS event subscriptions, recommendations and logs

33. Exporting RDS logs to S3

34. RDS Enhanced Monitoring

35. RDS Performance Insights

10m

36. CloudWatch Application Insights

37. RDS on VMware

38. RDS - Good things to know

39. Aurora overview

40. Aurora architecture

41. Aurora Parallel Query

42. Aurora Serverless

43. Data API for Aurora Serverless

44. Aurora multi-master

45. Aurora cross region replicas and Aurora Global database

46. Reliability features in Aurora

47. Aurora pricing model

48. Aurora security - Network, IAM and encryption

49. Parameter groups in Aurora and Aurora Serverless

50. Creating an Aurora database - Hands on

51. Creating an Aurora Serverless database - Hands on

52. Using Data API with Aurora Serverless database - Hands on

53. Scaling options in Aurora

54. Aurora monitoring and advanced auditing

55. Monitoring in RDS and Aurora - Demo

56. Exporting Aurora logs

57. Database activity streams in Aurora

58. Troubleshooting storage issues in Aurora

59. Aurora benchmarking

60. Exporting data from Aurora into S3

61. Aurora backups and backtracking

62. Aurora backups vs snapshots vs backtrack

63. Aurora backup, restore, PITR and backtrack - Demo

64. Cloning databases in Aurora

65. Aurora failovers

66. Cluster Cache Management (CCM) in Aurora PostgreSQL

67. Simulating fault tolerance or resiliency in Aurora

68. Simulating failovers in Aurora - Demo

69. Aurora failover priorities in action - Demo

10m

70. Fast failover in Aurora PostgreSQL

71. Cluster replication options for Aurora MySQL

72. Aurora replicas vs RDS MySQL replicas

73. Comparison of RDS deployments

74. How to invoke Lambda functions from Aurora MySQL

75. How to load data from S3 into Aurora MySQL

76. RDS / Aurora – Good things to know

Amazon DynamoDB and DAX

Lectures	Duration
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

1. DynamoDB overview

2. Working with DynamoDB - Hands on

11m

3. DynamoDB basics

4. DynamoDB consistency

5. DynamoDB pricing model

6. DynamoDB throughput

7. Calculating capacity units

8. DynamoDB burst capacity and adaptive capacity

9. DynamoDB local secondary index (LSI)

10. DynamoDB global secondary index (GSI)

11. Choosing between LSI and GSI

12. Simple design patterns with DynamoDB

13. Errors and exceptions in DynamoDB

14. DynamoDB partitions

15. DynamoDB partition behavior example

16. Scaling options in DynamoDB

17. DynamoDB scaling and partition behavior

18. DynamoDB best practices

19. DynamoDB best practices (contd.)

20. Large object patterns and table operations

21. DynamoDB accelerator (DAX)

22. DAX architecture

23. DAX operations

24. Implementing DAX - Hands on

25. DynamoDB backup and restore

26. DynamoDb backup and restore - Hands on

27. Continuous backup with PITR

28. Continuous backup with PITR - Hands on

29. DynamoDB encryption

30. DynamoDB streams

31. DynamoDB TTL

32. DynamoDB TTL - Hands on

33. TTL use cases

34. DynamoDB global tables

35. DynamoDB global tables - Hands on

36. Fine-grained access control and Web-identity federation in DynamoDB

37. CloudWatch contributor insights for DynamoDB

Amazon Redshift

Lectures	Duration
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

1. Redshift overview

2. Creating a Redshift cluster - Hands on

3. Redshift architecture

4. Loading data into Redshift

5. Loading data from S3 into Redshift - Hands on

6. More ways to load data into Redshift

7. Redshift Spectrum

8. Querying S3 data with Redshift Spectrum - Hands on

9. Redshift federated query

10. Star schema in data warehouses

11. Redshift fundamentals

12. Redshift Workload Management (WLM)

13. Redshift concurrency scaling

14. Redshift scaling

15. Redshift backup, restore and cross-region snapshots

16. Redshift Multi-AZ deployment alternative

17. Redshift availability and durability

18. Redshift security

19. Enhanced VPC routing in Redshift

20. Redshift monitoring

21. Redshift pricing

22. Redshift related services - Athena and Quicksight

23. AQUA for Redshift

Amazon ElastiCache

Lectures	Duration
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

1. ElastiCache overview

2. Caching strategies

3. Redis architecture and Multi-AZ auto-failover

4. Redis backup and restore

5. Redis scaling and replication

6. Creating a Redis cluster - Hands on

7. Redis global datastore

8. Redis - Good things to know

9. Redis best practices

10. Redis use cases

11. Memcached overview

12. Memcached architecture

13. Memcached auto discovery

14. Memcached scaling

15. Creating a Memcached cluster - Hands on

16. Choosing between Redis and Memcached

17. ElastiCache security

18. ElastiCache logging and monitoring

19. ElastiCache pricing

Amazon DocumentDB (with MongoDB compatibility)

Lectures	Duration
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

1. DocumentDB overview

2. What and why about document databases

3. DocumentDB architecture

4. DocumentDB backup and restore

5. DocumentDB scaling

6. DocumentDB security

7. DocumentDB pricing

8. DocumentDB monitoring

9. DocumentDB performance management

10. Creating a DocumentDB cluster - Hands on

Amazon Neptune

Lectures	Duration
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

1. Neptune overview

2. Neptune architecture

3. Creating a Neptune cluster - Hands on

13m

4. Bulk loading graph data into Neptune

5. Bulk loading graph data into Neptune from S3 - Hands on

14m

6. Neptune Workbench

7. Querying Neptune via Jupyter Notebooks - Hands on

8. Neptune replication and high availability

9. Neptune backup and restore

10. Database cloning in Neptune

11. Neptune security

12. Neptune monitoring

13. Query queuing in Neptune

14. Neptune service errors

15. SPARQL federated query

16. Neptune streams

17. Neptune pricing

Amazon Elasticsearch Service

Lectures	Duration
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

1. Amazon Elasticsearch Service overview

2. ElasticSearch Service patterns

3. Elasticsearch Service - Multi-AZ

4. Logging options in Elasticsearch Service

5. ElasticSearch Service pricing

6. ElasticSearch Service - Hands on

Amazon Timestream

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

1. Timestream overview

2. Timestream pricing

Amazon QLDB

Lectures	Duration
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

1. QLDB overview

2. QLDB architecture

3. QLDB views

4. Working with QLDB

5. Data verification in QLDB

6. Creating a QLDB ledger - Hands on

12m

7. Data verification in QLDB - Hands on

8. QLDB backup and restore (an alternative)

9. QLDB streams

10. QLDB high availability, durability and an alternative to CRR

11. QLDB security

12. QLDB monitoring

13. QLDB pricing

Amazon Keyspaces (for Apache Cassandra)

Lectures	Duration
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

1. Keyspaces overview

2. Migrating from Cassandra to Keyspaces

3. Read and write consistency in Keyspaces

4. Keyspaces pricing

5. Working with Keyspaces - Hands on

Comparing AWS Databases

Lectures	Duration
1. Comparison of AWS Databases	6m

1. Comparison of AWS Databases

Database Migration, DMS and SCT

Lectures	Duration
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

1. Database migration overview

2. DMS sources and targets

3. DMS architecture and overview

4. Migration with DMS in action - Hands on

12m

5. SCT overview

6. Workload Qualification Framework (WQF)

7. DMS tasks and task assessment reports

8. DMS migration types

9. DMS - Good things to know

10. Migrating large tables and LOBs with DMS

11. DW migration with SCT

12. Migration playbooks

13. DMS monitoring

14. DMS validation

15. DMS statistics and control tables

16. DMS security - IAM, encryption and networking

17. DMS pricing

18. DMS general best practices

19. DMS migration architectures to minimize downtime

20. Migrating large databases

21. Migrating to RDS databases

22. Migrating to Aurora

23. Migrating Redis workloads to ElastiCache

24. Migrating to DocumentDB

25. Streaming use cases for DMS

Monitoring, Logging and Encryption

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

1. Encryption and Snapshots

2. Database Logging

3. Secrets Manager

4. Active Directory with RDS Microsoft SQL Server

CloudFormation and Automation

Lectures	Duration
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

1. CloudFormation Overview

2. CloudFormation Create Stack Hands On

3. CloudFormation Update and Delete Stack Hands On

4. YAML Crash Course

5. CloudFormation Resources

6. CloudFormation Parameters

7. CloudFormation Mappings

8. CloudFormation Outputs

9. CloudFormation Conditions

10. CloudFormation Intrinsic Functions

VPC - Networking

Lectures	Duration
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

1. VPC Section Structure

2. VPC, Subnets, IGW and NAT

3. NACL, SG, VPC Flow Logs

4. VPC Peering, Endpoints, VPN, DX

5. VPC Cheat Sheet & Closing Comments

Lectures	Duration
1. AWS Lambda Architectures	4m
2. Server Migration Service	2m
3. EBS-optimized instances	2m
4. Transferring large amount of data into AWS	2m
5. Disaster Recovery	12m

Exam preparation

Lectures	Duration
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

1. Exam Guide & Sample Questions

2. Sample question 1

3. Sample question 2

4. Sample question 3

5. Sample question 4

6. Sample question 5

7. Sample question 6

8. Sample question 7

9. Sample question 8

10. Sample question 9

11. Sample question 10

12. Exam Strategy: How to tackle exam questions

13. Additional Resources