Training Video Course

AWS Certified Database - Specialty: AWS Certified Database - Specialty

PDFs and exam guides are not so efficient, right? Prepare for your Amazon examination with our training course. The AWS Certified Database - Specialty course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Amazon certification exam. Pass the Amazon AWS Certified Database - Specialty test with flying colors.

Rating
4.57rating
Students
139
Duration
16:30:00 h
$16.49
$14.99

Curriculum for AWS Certified Database - Specialty Certification Video Course

Name of Video Time
Play Video: Purpose Built Databases
1. Purpose Built Databases
4:00
Name of Video Time
Play Video: Types of data
1. Types of data
5:00
Play Video: Relational databases
2. Relational databases
6:00
Play Video: Non-relational databases
3. Non-relational databases
7:00
Name of Video Time
Play Video: Amazon RDS overview
1. Amazon RDS overview
4:00
Play Video: RDS pricing model
2. RDS pricing model
1:00
Play Video: Instance type, storage type and storage auto scaling for RDS
3. Instance type, storage type and storage auto scaling for RDS
4:00
Play Video: RDS parameter groups
4. RDS parameter groups
4:00
Play Video: RDS option groups
5. RDS option groups
2:00
Play Video: RDS - Hands on
6. RDS - Hands on
14:00
Play Video: RDS security - Network
7. RDS security - Network
3:00
Play Video: RDS security - IAM
8. RDS security - IAM
6:00
Play Video: Rotating RDS DB credentials
9. Rotating RDS DB credentials
1:00
Play Video: Windows authentication in RDS for SQL Server
10. Windows authentication in RDS for SQL Server
3:00
Play Video: RDS encryption in transit and at rest
11. RDS encryption in transit and at rest
5:00
Play Video: RDS backups
12. RDS backups
4:00
Play Video: Copying and sharing RDS snapshots
13. Copying and sharing RDS snapshots
2:00
Play Video: How to encrypt an unencrypted RDS database
14. How to encrypt an unencrypted RDS database
2:00
Play Video: DB restore options in RDS
15. DB restore options in RDS
4:00
Play Video: Exporting RDS DB snapshot to S3
16. Exporting RDS DB snapshot to S3
2:00
Play Video: RDS backup and restore - Hands on
17. RDS backup and restore - Hands on
5:00
Play Video: RDS Multi-AZ deployments and read replicas
18. RDS Multi-AZ deployments and read replicas
9:00
Play Video: Read replica use cases
19. Read replica use cases
1:00
Play Video: Promoting a read replica to a standalone DB instance
20. Promoting a read replica to a standalone DB instance
3:00
Play Video: RDS Multi-AZ failover and replica promotion - Demo
21. RDS Multi-AZ failover and replica promotion - Demo
14:00
Play Video: Enabling writes on a read replica
22. Enabling writes on a read replica
1:00
Play Video: RDS read replica capabilities
23. RDS read replica capabilities
2:00
Play Video: RDS Second-tier replicas and replica promotion - Demo
24. RDS Second-tier replicas and replica promotion - Demo
7:00
Play Video: Cross-region read replicas in RDS
25. Cross-region read replicas in RDS
1:00
Play Video: RDS replicas with an external database
26. RDS replicas with an external database
2:00
Play Video: RDS disaster recovery strategies
27. RDS disaster recovery strategies
6:00
Play Video: Troubleshooting replica issues in RDS
28. Troubleshooting replica issues in RDS
6:00
Play Video: Performance hit on new read replicas
29. Performance hit on new read replicas
2:00
Play Video: Scaling and sharding in RDS
30. Scaling and sharding in RDS
3:00
Play Video: RDS monitoring
31. RDS monitoring
4:00
Play Video: RDS event subscriptions, recommendations and logs
32. RDS event subscriptions, recommendations and logs
5:00
Play Video: Exporting RDS logs to S3
33. Exporting RDS logs to S3
2:00
Play Video: RDS Enhanced Monitoring
34. RDS Enhanced Monitoring
2:00
Play Video: RDS Performance Insights
35. RDS Performance Insights
10:00
Play Video: CloudWatch Application Insights
36. CloudWatch Application Insights
1:00
Play Video: RDS on VMware
37. RDS on VMware
1:00
Play Video: RDS - Good things to know
38. RDS - Good things to know
2:00
Play Video: Aurora overview
39. Aurora overview
4:00
Play Video: Aurora architecture
40. Aurora architecture
8:00
Play Video: Aurora Parallel Query
41. Aurora Parallel Query
3:00
Play Video: Aurora Serverless
42. Aurora Serverless
5:00
Play Video: Data API for Aurora Serverless
43. Data API for Aurora Serverless
2:00
Play Video: Aurora multi-master
44. Aurora multi-master
2:00
Play Video: Aurora cross region replicas and Aurora Global database
45. Aurora cross region replicas and Aurora Global database
2:00
Play Video: Reliability features in Aurora
46. Reliability features in Aurora
3:00
Play Video: Aurora pricing model
47. Aurora pricing model
3:00
Play Video: Aurora security - Network, IAM and encryption
48. Aurora security - Network, IAM and encryption
3:00
Play Video: Parameter groups in Aurora and Aurora Serverless
49. Parameter groups in Aurora and Aurora Serverless
4:00
Play Video: Creating an Aurora database - Hands on
50. Creating an Aurora database - Hands on
9:00
Play Video: Creating an Aurora Serverless database - Hands on
51. Creating an Aurora Serverless database - Hands on
2:00
Play Video: Using Data API with Aurora Serverless database - Hands on
52. Using Data API with Aurora Serverless database - Hands on
2:00
Play Video: Scaling options in Aurora
53. Scaling options in Aurora
5:00
Play Video: Aurora monitoring and advanced auditing
54. Aurora monitoring and advanced auditing
4:00
Play Video: Monitoring in RDS and Aurora - Demo
55. Monitoring in RDS and Aurora - Demo
4:00
Play Video: Exporting Aurora logs
56. Exporting Aurora logs
1:00
Play Video: Database activity streams in Aurora
57. Database activity streams in Aurora
1:00
Play Video: Troubleshooting storage issues in Aurora
58. Troubleshooting storage issues in Aurora
3:00
Play Video: Aurora benchmarking
59. Aurora benchmarking
1:00
Play Video: Exporting data from Aurora into S3
60. Exporting data from Aurora into S3
2:00
Play Video: Aurora backups and backtracking
61. Aurora backups and backtracking
4:00
Play Video: Aurora backups vs snapshots vs backtrack
62. Aurora backups vs snapshots vs backtrack
2:00
Play Video: Aurora backup, restore, PITR and backtrack - Demo
63. Aurora backup, restore, PITR and backtrack - Demo
3:00
Play Video: Cloning databases in Aurora
64. Cloning databases in Aurora
3:00
Play Video: Aurora failovers
65. Aurora failovers
4:00
Play Video: Cluster Cache Management (CCM) in Aurora PostgreSQL
66. Cluster Cache Management (CCM) in Aurora PostgreSQL
3:00
Play Video: Simulating fault tolerance or resiliency in Aurora
67. Simulating fault tolerance or resiliency in Aurora
6:00
Play Video: Simulating failovers in Aurora - Demo
68. Simulating failovers in Aurora - Demo
1:00
Play Video: Aurora failover priorities in action - Demo
69. Aurora failover priorities in action - Demo
10:00
Play Video: Fast failover in Aurora PostgreSQL
70. Fast failover in Aurora PostgreSQL
6:00
Play Video: Cluster replication options for Aurora MySQL
71. Cluster replication options for Aurora MySQL
5:00
Play Video: Aurora replicas vs RDS MySQL replicas
72. Aurora replicas vs RDS MySQL replicas
3:00
Play Video: Comparison of RDS deployments
73. Comparison of RDS deployments
5:00
Play Video: How to invoke Lambda functions from Aurora MySQL
74. How to invoke Lambda functions from Aurora MySQL
2:00
Play Video: How to load data from S3 into Aurora MySQL
75. How to load data from S3 into Aurora MySQL
2:00
Play Video: RDS / Aurora – Good things to know
76. RDS / Aurora – Good things to know
3:00
Name of Video Time
Play Video: DynamoDB overview
1. DynamoDB overview
3:00
Play Video: Working with DynamoDB - Hands on
2. Working with DynamoDB - Hands on
11:00
Play Video: DynamoDB basics
3. DynamoDB basics
7:00
Play Video: DynamoDB consistency
4. DynamoDB consistency
5:00
Play Video: DynamoDB pricing model
5. DynamoDB pricing model
6:00
Play Video: DynamoDB throughput
6. DynamoDB throughput
4:00
Play Video: Calculating capacity units
7. Calculating capacity units
4:00
Play Video: DynamoDB burst capacity and adaptive capacity
8. DynamoDB burst capacity and adaptive capacity
6:00
Play Video: DynamoDB local secondary index (LSI)
9. DynamoDB local secondary index (LSI)
4:00
Play Video: DynamoDB global secondary index (GSI)
10. DynamoDB global secondary index (GSI)
3:00
Play Video: Choosing between LSI and GSI
11. Choosing between LSI and GSI
3:00
Play Video: Simple design patterns with DynamoDB
12. Simple design patterns with DynamoDB
4:00
Play Video: Errors and exceptions in DynamoDB
13. Errors and exceptions in DynamoDB
3:00
Play Video: DynamoDB partitions
14. DynamoDB partitions
5:00
Play Video: DynamoDB partition behavior example
15. DynamoDB partition behavior example
6:00
Play Video: Scaling options in DynamoDB
16. Scaling options in DynamoDB
4:00
Play Video: DynamoDB scaling and partition behavior
17. DynamoDB scaling and partition behavior
4:00
Play Video: DynamoDB best practices
18. DynamoDB best practices
4:00
Play Video: DynamoDB best practices (contd.)
19. DynamoDB best practices (contd.)
4:00
Play Video: Large object patterns and table operations
20. Large object patterns and table operations
5:00
Play Video: DynamoDB accelerator (DAX)
21. DynamoDB accelerator (DAX)
3:00
Play Video: DAX architecture
22. DAX architecture
2:00
Play Video: DAX operations
23. DAX operations
4:00
Play Video: Implementing DAX - Hands on
24. Implementing DAX - Hands on
6:00
Play Video: DynamoDB backup and restore
25. DynamoDB backup and restore
7:00
Play Video: DynamoDb backup and restore - Hands on
26. DynamoDb backup and restore - Hands on
3:00
Play Video: Continuous backup with PITR
27. Continuous backup with PITR
2:00
Play Video: Continuous backup with PITR - Hands on
28. Continuous backup with PITR - Hands on
4:00
Play Video: DynamoDB encryption
29. DynamoDB encryption
4:00
Play Video: DynamoDB streams
30. DynamoDB streams
3:00
Play Video: DynamoDB TTL
31. DynamoDB TTL
2:00
Play Video: DynamoDB TTL - Hands on
32. DynamoDB TTL - Hands on
5:00
Play Video: TTL use cases
33. TTL use cases
1:00
Play Video: DynamoDB global tables
34. DynamoDB global tables
5:00
Play Video: DynamoDB global tables - Hands on
35. DynamoDB global tables - Hands on
6:00
Play Video: Fine-grained access control and Web-identity federation in DynamoDB
36. Fine-grained access control and Web-identity federation in DynamoDB
6:00
Play Video: CloudWatch contributor insights for DynamoDB
37. CloudWatch contributor insights for DynamoDB
1:00
Name of Video Time
Play Video:  Redshift overview
1. Redshift overview
3:00
Play Video: Creating a Redshift cluster - Hands on
2. Creating a Redshift cluster - Hands on
9:00
Play Video: Redshift architecture
3. Redshift architecture
2:00
Play Video: Loading data into Redshift
4. Loading data into Redshift
3:00
Play Video: Loading data from S3 into Redshift - Hands on
5. Loading data from S3 into Redshift - Hands on
7:00
Play Video: More ways to load data into Redshift
6. More ways to load data into Redshift
2:00
Play Video: Redshift Spectrum
7. Redshift Spectrum
3:00
Play Video: Querying S3 data with Redshift Spectrum - Hands on
8. Querying S3 data with Redshift Spectrum - Hands on
8:00
Play Video: Redshift federated query
9. Redshift federated query
1:00
Play Video: Star schema in data warehouses
10. Star schema in data warehouses
2:00
Play Video: Redshift fundamentals
11. Redshift fundamentals
9:00
Play Video: Redshift Workload Management (WLM)
12. Redshift Workload Management (WLM)
3:00
Play Video: Redshift concurrency scaling
13. Redshift concurrency scaling
2:00
Play Video: Redshift scaling
14. Redshift scaling
2:00
Play Video: Redshift backup, restore and cross-region snapshots
15. Redshift backup, restore and cross-region snapshots
3:00
Play Video: Redshift Multi-AZ deployment alternative
16. Redshift Multi-AZ deployment alternative
4:00
Play Video: Redshift availability and durability
17. Redshift availability and durability
2:00
Play Video: Redshift security
18. Redshift security
3:00
Play Video: Enhanced VPC routing in Redshift
19. Enhanced VPC routing in Redshift
4:00
Play Video: Redshift monitoring
20. Redshift monitoring
3:00
Play Video: Redshift pricing
21. Redshift pricing
1:00
Play Video: Redshift related services - Athena and Quicksight
22. Redshift related services - Athena and Quicksight
3:00
Play Video: AQUA for Redshift
23. AQUA for Redshift
2:00
Name of Video Time
Play Video: ElastiCache overview
1. ElastiCache overview
5:00
Play Video: Caching strategies
2. Caching strategies
5:00
Play Video: Redis architecture and Multi-AZ auto-failover
3. Redis architecture and Multi-AZ auto-failover
5:00
Play Video: Redis backup and restore
4. Redis backup and restore
2:00
Play Video: Redis scaling and replication
5. Redis scaling and replication
6:00
Play Video: Creating a Redis cluster - Hands on
6. Creating a Redis cluster - Hands on
5:00
Play Video: Redis global datastore
7. Redis global datastore
3:00
Play Video: Redis - Good things to know
8. Redis - Good things to know
2:00
Play Video: Redis best practices
9. Redis best practices
2:00
Play Video: Redis use cases
10. Redis use cases
3:00
Play Video: Memcached overview
11. Memcached overview
2:00
Play Video: Memcached architecture
12. Memcached architecture
1:00
Play Video: Memcached auto discovery
13. Memcached auto discovery
2:00
Play Video: Memcached scaling
14. Memcached scaling
2:00
Play Video: Creating a Memcached cluster - Hands on
15. Creating a Memcached cluster - Hands on
4:00
Play Video: Choosing between Redis and Memcached
16. Choosing between Redis and Memcached
2:00
Play Video: ElastiCache security
17. ElastiCache security
4:00
Play Video: ElastiCache logging and monitoring
18. ElastiCache logging and monitoring
1:00
Play Video: ElastiCache pricing
19. ElastiCache pricing
1:00
Name of Video Time
Play Video: DocumentDB overview
1. DocumentDB overview
2:00
Play Video: What and why about document databases
2. What and why about document databases
2:00
Play Video: DocumentDB architecture
3. DocumentDB architecture
3:00
Play Video: DocumentDB backup and restore
4. DocumentDB backup and restore
2:00
Play Video: DocumentDB scaling
5. DocumentDB scaling
1:00
Play Video: DocumentDB security
6. DocumentDB security
2:00
Play Video: DocumentDB pricing
7. DocumentDB pricing
1:00
Play Video: DocumentDB monitoring
8. DocumentDB monitoring
3:00
Play Video: DocumentDB performance management
9. DocumentDB performance management
1:00
Play Video: Creating a DocumentDB cluster - Hands on
10. Creating a DocumentDB cluster - Hands on
5:00
Name of Video Time
Play Video: Neptune overview
1. Neptune overview
5:00
Play Video: Neptune architecture
2. Neptune architecture
3:00
Play Video: Creating a Neptune cluster - Hands on
3. Creating a Neptune cluster - Hands on
13:00
Play Video: Bulk loading graph data into Neptune
4. Bulk loading graph data into Neptune
2:00
Play Video: Bulk loading graph data into Neptune from S3 - Hands on
5. Bulk loading graph data into Neptune from S3 - Hands on
14:00
Play Video: Neptune Workbench
6. Neptune Workbench
1:00
Play Video: Querying Neptune via Jupyter Notebooks - Hands on
7. Querying Neptune via Jupyter Notebooks - Hands on
5:00
Play Video: Neptune replication and high availability
8. Neptune replication and high availability
2:00
Play Video: Neptune backup and restore
9. Neptune backup and restore
2:00
Play Video: Database cloning in Neptune
10. Database cloning in Neptune
2:00
Play Video: Neptune security
11. Neptune security
2:00
Play Video: Neptune monitoring
12. Neptune monitoring
1:00
Play Video: Query queuing in Neptune
13. Query queuing in Neptune
1:00
Play Video: Neptune service errors
14. Neptune service errors
2:00
Play Video: SPARQL federated query
15. SPARQL federated query
1:00
Play Video: Neptune streams
16. Neptune streams
2:00
Play Video: Neptune pricing
17. Neptune pricing
1:00
Name of Video Time
Play Video: Amazon Elasticsearch Service overview
1. Amazon Elasticsearch Service overview
3:00
Play Video: ElasticSearch Service patterns
2. ElasticSearch Service patterns
2:00
Play Video: Elasticsearch Service - Multi-AZ
3. Elasticsearch Service - Multi-AZ
1:00
Play Video: Logging options in Elasticsearch Service
4. Logging options in Elasticsearch Service
1:00
Play Video: ElasticSearch Service pricing
5. ElasticSearch Service pricing
1:00
Play Video: ElasticSearch Service - Hands on
6. ElasticSearch Service - Hands on
4:00
Name of Video Time
Play Video: Timestream overview
1. Timestream overview
4:00
Play Video: Timestream pricing
2. Timestream pricing
1:00
Name of Video Time
Play Video: QLDB overview
1. QLDB overview
2:00
Play Video: QLDB architecture
2. QLDB architecture
3:00
Play Video: QLDB views
3. QLDB views
2:00
Play Video: Working with QLDB
4. Working with QLDB
2:00
Play Video: Data verification in QLDB
5. Data verification in QLDB
2:00
Play Video: Creating a QLDB ledger - Hands on
6. Creating a QLDB ledger - Hands on
12:00
Play Video: Data verification in QLDB - Hands on
7. Data verification in QLDB - Hands on
3:00
Play Video: QLDB backup and restore (an alternative)
8. QLDB backup and restore (an alternative)
1:00
Play Video: QLDB streams
9. QLDB streams
1:00
Play Video: QLDB high availability, durability and an alternative to CRR
10. QLDB high availability, durability and an alternative to CRR
1:00
Play Video: QLDB security
11. QLDB security
1:00
Play Video: QLDB monitoring
12. QLDB monitoring
1:00
Play Video: QLDB pricing
13. QLDB pricing
1:00
Name of Video Time
Play Video: Keyspaces overview
1. Keyspaces overview
3:00
Play Video: Migrating from Cassandra to Keyspaces
2. Migrating from Cassandra to Keyspaces
1:00
Play Video: Read and write consistency in Keyspaces
3. Read and write consistency in Keyspaces
1:00
Play Video: Keyspaces pricing
4. Keyspaces pricing
3:00
Play Video: Working with Keyspaces - Hands on
5. Working with Keyspaces - Hands on
5:00
Name of Video Time
Play Video: Comparison of AWS Databases
1. Comparison of AWS Databases
6:00
Name of Video Time
Play Video: Database migration overview
1. Database migration overview
5:00
Play Video: DMS sources and targets
2. DMS sources and targets
2:00
Play Video: DMS architecture and overview
3. DMS architecture and overview
4:00
Play Video: Migration with DMS in action - Hands on
4. Migration with DMS in action - Hands on
12:00
Play Video: SCT overview
5. SCT overview
3:00
Play Video: Workload Qualification Framework (WQF)
6. Workload Qualification Framework (WQF)
1:00
Play Video: DMS tasks and task assessment reports
7. DMS tasks and task assessment reports
2:00
Play Video: DMS migration types
8. DMS migration types
1:00
Play Video: DMS - Good things to know
9. DMS - Good things to know
1:00
Play Video: Migrating large tables and LOBs with DMS
10. Migrating large tables and LOBs with DMS
5:00
Play Video: DW migration with SCT
11. DW migration with SCT
5:00
Play Video: Migration playbooks
12. Migration playbooks
3:00
Play Video: DMS monitoring
13. DMS monitoring
2:00
Play Video: DMS validation
14. DMS validation
2:00
Play Video: DMS statistics and control tables
15. DMS statistics and control tables
3:00
Play Video: DMS security - IAM, encryption and networking
16. DMS security - IAM, encryption and networking
5:00
Play Video: DMS pricing
17. DMS pricing
1:00
Play Video: DMS general best practices
18. DMS general best practices
1:00
Play Video: DMS migration architectures to minimize downtime
19. DMS migration architectures to minimize downtime
6:00
Play Video: Migrating large databases
20. Migrating large databases
2:00
Play Video: Migrating to RDS databases
21. Migrating to RDS databases
8:00
Play Video: Migrating to Aurora
22. Migrating to Aurora
6:00
Play Video: Migrating Redis workloads to ElastiCache
23. Migrating Redis workloads to ElastiCache
4:00
Play Video: Migrating to DocumentDB
24. Migrating to DocumentDB
7:00
Play Video: Streaming use cases for DMS
25. Streaming use cases for DMS
4:00
Name of Video Time
Play Video: Encryption and Snapshots
1. Encryption and Snapshots
3:00
Play Video: Database Logging
2. Database Logging
5:00
Play Video: Secrets Manager
3. Secrets Manager
1:00
Play Video: Active Directory with RDS Microsoft SQL Server
4. Active Directory with RDS Microsoft SQL Server
2:00
Name of Video Time
Play Video: CloudFormation Overview
1. CloudFormation Overview
7:00
Play Video: CloudFormation Create Stack Hands On
2. CloudFormation Create Stack Hands On
6:00
Play Video: CloudFormation Update and Delete Stack Hands On
3. CloudFormation Update and Delete Stack Hands On
8:00
Play Video: YAML Crash Course
4. YAML Crash Course
4:00
Play Video: CloudFormation Resources
5. CloudFormation Resources
6:00
Play Video: CloudFormation Parameters
6. CloudFormation Parameters
5:00
Play Video: CloudFormation Mappings
7. CloudFormation Mappings
3:00
Play Video: CloudFormation Outputs
8. CloudFormation Outputs
3:00
Play Video: CloudFormation Conditions
9. CloudFormation Conditions
2:00
Play Video: CloudFormation Intrinsic Functions
10. CloudFormation Intrinsic Functions
6:00
Name of Video Time
Play Video: VPC Section Structure
1. VPC Section Structure
1:00
Play Video: VPC, Subnets, IGW and NAT
2. VPC, Subnets, IGW and NAT
5:00
Play Video: NACL, SG, VPC Flow Logs
3. NACL, SG, VPC Flow Logs
5:00
Play Video: VPC Peering, Endpoints, VPN, DX
4. VPC Peering, Endpoints, VPN, DX
6:00
Play Video: VPC Cheat Sheet & Closing Comments
5. VPC Cheat Sheet & Closing Comments
3:00
Name of Video Time
Play Video: AWS Lambda Architectures
1. AWS Lambda Architectures
4:00
Play Video: Server Migration Service
2. Server Migration Service
2:00
Play Video: EBS-optimized instances
3. EBS-optimized instances
2:00
Play Video: Transferring large amount of data into AWS
4. Transferring large amount of data into AWS
2:00
Play Video: Disaster Recovery
5. Disaster Recovery
12:00
Name of Video Time
Play Video: Exam Guide & Sample Questions
1. Exam Guide & Sample Questions
2:00
Play Video: Sample question 1
2. Sample question 1
4:00
Play Video: Sample question 2
3. Sample question 2
4:00
Play Video: Sample question 3
4. Sample question 3
3:00
Play Video: Sample question 4
5. Sample question 4
2:00
Play Video: Sample question 5
6. Sample question 5
3:00
Play Video: Sample question 6
7. Sample question 6
2:00
Play Video: Sample question 7
8. Sample question 7
4:00
Play Video: Sample question 8
9. Sample question 8
4:00
Play Video: Sample question 9
10. Sample question 9
5:00
Play Video: Sample question 10
11. Sample question 10
4:00
Play Video: Exam Strategy: How to tackle exam questions
12. Exam Strategy: How to tackle exam questions
1:00
Play Video: Additional Resources
13. Additional Resources
1:00

Amazon AWS Certified Database - Specialty Exam Dumps, Practice Test Questions

100% Latest & Updated Amazon AWS Certified Database - Specialty Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!

Amazon AWS Certified Database - Specialty Premium Bundle
$69.97
$49.99

AWS Certified Database - Specialty Premium Bundle

  • Premium File: 359 Questions & Answers. Last update: Mar 29, 2024
  • Training Course: 275 Video Lectures
  • Study Guide: 552 Pages
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

AWS Certified Database - Specialty Premium Bundle

Amazon AWS Certified Database - Specialty Premium Bundle
  • Premium File: 359 Questions & Answers. Last update: Mar 29, 2024
  • Training Course: 275 Video Lectures
  • Study Guide: 552 Pages
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates
$69.97
$49.99

Free AWS Certified Database - Specialty Exam Questions & AWS Certified Database - Specialty Dumps

File Name Size Votes
File Name
amazon.braindumps.aws certified database - specialty.v2024-01-28.by.axel.137q.vce
Size
5.25 MB
Votes
1
File Name
amazon.realtests.aws certified database - specialty.v2021-12-28.by.christopher.126q.vce
Size
3.85 MB
Votes
1
File Name
amazon.passcertification.aws certified database - specialty.v2021-10-13.by.austin.111q.vce
Size
4.06 MB
Votes
1
File Name
amazon.selftesttraining.aws certified database - specialty.v2021-08-31.by.aiden.80q.vce
Size
263.95 KB
Votes
1
File Name
amazon.certkey.aws certified database - specialty.v2021-05-28.by.austin.94q.vce
Size
232.55 KB
Votes
1
File Name
amazon.selftestengine.aws certified database - specialty.v2021-02-26.by.alexander.87q.vce
Size
210.71 KB
Votes
2

Amazon AWS Certified Database - Specialty Training Course

Want verified and proven knowledge for AWS Certified Database - Specialty? Believe it's easy when you have ExamSnap's AWS Certified Database - Specialty certification video training course by your side which along with our Amazon AWS Certified Database - Specialty Exam Dumps & Practice Test questions provide a complete solution to pass your exam Read More.

Amazon RDS and Aurora

28. Troubleshooting replica issues in RDS

Now, the replica lag, as we just talked about, can impact your recovery. So how do you troubleshoot high replica lag? So, any asynchronous replication will always have some replica lag Asynchronous replication does not have any replication lag. But in the case of asynchronous replication, you'll always see some replica lag. In cloud watch, you can also monitor the replicable metrics. It's going to show you how many seconds behind the master your replica is lagging. It typically reports that this is seconds behind master values. And there are various reasons why replication delays occur. They could be due to long-running queries on the master instance. You can view your slow query lock to see what the long-running queries that are running on the instance. Another reason for high replica lag could be that you're using a smaller instance than required.

The instance class size or storage is not sufficient. And if you're using parallel queries on the primary instance, that also results in higher replica lag. Now let's look at how to troubleshoot the replication errors. So there could be errors in replication. How do you troubleshoot them? What are the recommendations? Let's have a look at that. The recommendation from AWS is that the size of your replica should match your source database. The storage size as well as the instance class size should be the same as the source database. And you should use compatible database parameter group settings for the source as well as for the replica. For example, the maximum allowed packet size for read replica must be the same as that of the source database instance. This is just one example, but in general, the parameter group settings for the source and the replica should be the same or compatible. You can monitor the application state of your replica instance and if it shows an error, then you can see the details in the replication error field. Apart from this, you can also subscribe to Audiusevents to get alerts on any replica issues. Then writing to tables on a read replica. We have discussed this before that you can set the read only parameter to zero to make your read Replica write able. But remember to use it only for maintenance purposes.

Like, you want to create some indexes only on the replica. Then you set the read-only mode to zero to make your replica readable. And once you're done with your maintenance task, remember to set the read-only parameter back to one. Another important thing to note here is that if you write to the tables on the read replica, it might make them incompatible with the source database and break the replication. So, as I said, you should set the read-only parameter back to one immediately after completing your maintenance tasks. And replication is only supported with transactional storage engines like Innov. Inodb is a storage engine used in MySQL. Another engine that MySQL provides is my isam. And this is not very compatible with replication, and it's likely to cause replication errors. ODB is more common in use. In general, if you want to use replication, you should consider using inodb. Again, unsafe non-deterministic queries like Sydney can also break replication, so you should avoid using such queries. And finally, after you review the replication errors, if you find that these are not major errors, and if these are not a cause for concern, you can simply skip those errors.

Or another option is to delete and recreate the replica. All right, now how do you troubleshoot the read Replica issues? For example, in MySQL, replica issues are the errors or data inconsistencies between the source and the replica. And this could happen due to bin log events or inodb. Redo logs aren't flushed during replication or source instance failures. So if something like this happens, the only way is to delete and recreate the replica. There are some recommendations to prevent these issues from happening. So what you could do is set certain parameters. For example, if you sync binlock equal to one, or innov flash lockapp to your x commit equal to one, or in ODBsupport for XA, you can set it to one. And these settings are the recommendations from AWS. They might affect the performance of your database. So it's a good idea to test before implementing this in production. And from an exam perspective, you don't have to know the names of these parameters, but just remember that you have certain options to address the replica issues in my sequel. Alright, let's continue.

29. Performance hit on new read replicas

Now, this is kind of an important thing to know that when you create a new replica, you might experience slow performance on the replica. This occurs frequently because RDS snapshots are EBSnapshots that are stored in S3. And when you create your new replica, what happens when these EBS volumes are loaded lazily in the background? So only when you read certain data, that data gets loaded into the database, and other data still resides on S 3. It doesn't get loaded into the database until you specifically query that data. This is something that is called a first touch penalty. So when you query any data, it takes longer to retrieve it the first time. So how do you work around this? The simple option is, if your database is small, you can simply run the select star from table so you get all the data from S Three into your database. Another option is to initiate a full table scan with vacuum analysis options. This is supported in postgres sequel. And another reason for performance issues besides this lazy loading thing is that there could be an empty buffer pool. So the buffer pool is the cache for table and index data, and the master instance will always have this cache. But when you create a new read replica, this cache is going to be empty. So that could be another reason why there is slow performance on a new read replica.

30. Scaling and sharding in RDS

Let's look at the scaling in RDS. So you can have vertical scaling or you can have horizontal scaling. So vertical scaling means scaling up. So you have your RDS instance and you increase the size of your RDS instance. So if you have a single AC instance, when you do scale up, it's not going to be available during the scaling operation. But if you have a multi-AC set up, then you will have minimal downtime during your scaling operation because the scaling operation will first happen on the standby, and then there will be a failover to the standby, and after that, the primary instance will be upgraded. The other way to scale is through horizontal scaling, which is also called scaling out. So, this simply means that you can create additional replicas for your database instance. So, adding more read capacity is how you scale horizontally. So this is kind of useful for reading heavy workloads. And the replicas also act as DR targets, so you can also use them for disaster recovery. Now, apart from this, there is one more option that I would like to discuss, and that is sharding. So what exactly is shading? Sharding is actually horizontal partitioning. So you actually distribute the data across different databases. You can think of it as breaking your database down into smaller chunks.

So you simply split and distribute your data across multiple databases. And each database is called a "shard". Okay? So you can have your data split across multiple chunks and your application can then read or write from individual databases. And you have to really manage this at the application level. RDS doesn't inherently support shouting, you have to manage it at the application level. So mapping or routing logic should be maintained at the application tier. So you can say that shard number one contains the data of customers from one to ten thousand, shard number two contains data from customer number 10,000 to 20,000, and so on. In addition to splitting the load, this also offers some kind of fault tolerance because now there is no single point of failure. As a result, if one shark fails, the other sharks are unaffected. All right, so that's about it. Let's continue to the next lecture.

31. RDS monitoring

Now let's look at RDS monitoring. Now, monitoring in RDS is integrated with Cloud Watch. So you can do the monitoring within the RDS dashboard as well as in the Cloud Watch dashboard. So some of the common metrics that you can monitor are CPU, RAM, disc space consumption, network traffic connections, IOps metrics, and so on. You can also use native database engine logs or database extensions. For example, you can use the PG Auditextension in PostgreSQL for auditing purposes. When you enable this extension, you can really monitor the database activity that's happening on your PostgreSQL database. DML, DCL, and DDL queries can be monitored.

So, DML is a data manipulation language. That is, any insert updates that are happening in your tables correspond to DML. DCL is a data control language. Any access controls changing in your database, like grants and reworks, that's happening in your database fall into DCL. And DDL is a data definition language. So any table structure changes or schema changes fall under DDL. So you can use extensions like PG Audit to keep track of your database activity. And then there are some manual monitoring tools like Trusted Advisor, Cloud Watch, and so on. So you can definitely monitor it using the RDS console. So all the Cloud Watch metrics can be monitored through the RDS console. The AWS Trusted Advisor is a tool that you can use for cost optimization, security fault tolerance, or performance improvement checks. The Trusted Advisor gives you some recommendations that you can implement in your database, and you can also monitor the RDS service health status using Cloud Watch.

All right? And apart from this, you also have automated tools for monitoring purposes, like the RDS Event Notifications. So you can subscribe to Audius events anytime your database is modified, updated, or deleted. Whatever happens to your database, you can set up the event notifications. You can also enable the database logs of your database engines, and these can also be exported to Cloud Watch logs. Again, Cloud Watch is an automated tool. Then, apart from this, you also have something called Enhanced Monitoring, which provides a real-time dashboard for your CPU metrics. Then you have performance inside. This is a really handy tool to identify performance bottlenecks. And we're going to go into detail about these tools right now. I'm just listing it here. Then you have RDS recommendations, which are automatically generated for your databases, and you can see them in your RDS console. And you also have Cloud Trail integrated with RDS just like any other AWS service. And all it does is capture the RDS API calls. These are viewable in the Cloud Trail console. Or you can also deliver it as a trail to an S3 bucket. Okay, now you can view up to 90 days of your account activity within the Cloud Trail Console. But if you want to store it for longer, then you should create a trail and deliver that trail to S Three, so you can then access the audit logs in s three. Alright, that's about it. Let's continue.

32. RDS event subscriptions, recommendations and logs

Now let's look at the RDS notifications. They are also called the event subscriptions. These are available within the RDS console. We'll go through a hands-on and look at everything, but for now, just know that these are available in the Arias Console.

And all it does is allow you to create Cloud Watch alarms to notify you whenever certain metric data crosses a threshold. So it's simply integrated with Cloud Watch and SMS services. So you get the notifications through the SMS service. What you can do is you can send your alarm notifications to an SMS topic. So you can get an email or a text message whenever these events occur. So all you have to do is to subscribe to any of the audience events that you need notification for right now. Event sources can be like snapshot instances, securitygroups, parameter groups, clusters, cluster snapshots, so on almost anything that's there in the Audius architecture, you can get event notifications on that. So you can have notifications on events like database instance creation, deletion, shutdown, restart, backup, recovery failure, and so on. So you can be notified about things that are relevant to your use case. Right, then let's look at the audience recommendations. These are periodic automated suggestions that are generated within your RDS Console.

Okay? You can see certain recommendations like enhanced monitoring are not enabled and databaseclusters with only one database instance. What they are suggesting is that you use multiple instances or you use a multiAZ setup for improved performance and availability. All right, so these are the kinds of recommendations that are available, and they are automatically generated within the RDS Console. All right, now let's look at the logs. The RDS logs Of course, you can view, watch, or download these logs from the RDS Console. You can export them to Cloud Watch logs. Of course, the types of logs are determined by the database engine. Another important thing to remember is that Cloud Watch logs do not expire. If you really want to expire them, you can set the group retention policy from one day to about ten years. If you don't want to expire them, don't expire them unless you want them to. And these logs are accessible from the RDS Console even if you disable the log export to Cloud Watch logs. Okay? Generally, it's a good idea to enable log export.

So the logs are exported from RDS to the Cloud Wash logs, and there are different lock types that can be exported to the Cloud Wash logs, which vary by the database engine. So you can have all the logs for Oracle, you can have an Audit Log for Oracle, MariaDB, and MySQL, and you have the MariaDB Audit Plugin,which you can enable using the Option group. And this will help you audit the database activity. So any DML, DDL, DCL, or queries running on your MySQL or MariaDB can now be audited using the MariaDBaudit plugin; similarly, the PG audit extension, as we just discussed, can audit the database depending on the type of database engine.

So you may want to remember that sometimes it might help in your example, right? Then you have listener login in Oracle. You also have atrace log in in SQL Server. MySQL Maradib, you have error logs in Postgres. You have a Postgres SQL log, which also contains audit logs. Postgres SQL also has an upgrade log. Mariahdb and MySQL have a general log, and they also provide you with a slow query log before we close. One thing I want to emphasise here is that you don't have to know which database engine provides which lock; you don't have to know it by the letter. But it's a good idea to have these things in the back of your mind. They'll help you choose the right responses when questions related to these topics get asked in the examination. All right, so that's about it. Let's continue.

Prepared by Top Experts, the top IT Trainers ensure that when it comes to your IT exam prep and you can count on ExamSnap AWS Certified Database - Specialty certification video training course that goes in line with the corresponding Amazon AWS Certified Database - Specialty exam dumps, study guide, and practice test questions & answers.

Comments (0)

Add Comment

Please post your comments about AWS Certified Database - Specialty Exams. Don't share your email address asking for AWS Certified Database - Specialty braindumps or AWS Certified Database - Specialty exam pdf files.

Add Comment

Purchase Individually

AWS Certified Database - Specialty  Premium File
AWS Certified Database - Specialty
Premium File
359 Q&A
$43.99 $39.99
AWS Certified Database - Specialty  Training Course
AWS Certified Database - Specialty
Training Course
275 Lectures
$16.49 $14.99
AWS Certified Database - Specialty  Study Guide
AWS Certified Database - Specialty
Study Guide
552 Pages
$16.49 $14.99

Only Registered Members can View Training Courses

Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

UP

LIMITED OFFER: GET 30% Discount

This is ONE TIME OFFER

ExamSnap Discount Offer
Enter Your Email Address to Receive Your 30% Discount Code

A confirmation link will be sent to this email address to verify your login. *We value your privacy. We will not rent or sell your email address.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.