<ol>
	<li>
	This lab walks you through the steps to create an unencrypted instance with the Encrypt option.
	</li>
	<li>
	You will practice this lab by not enabling the encryption of DB Instance while creating.
	</li>
</ol>

<ol>
	<li>
	This lab walks you through the steps to export the RDS DB snapshot to S3.
	</li>
	<li>
	In this lab, you will practice creating an Amazon RDS DB Instance, Amazon S3 Bucket, AWS KMS Key.
	</li>
</ol>

<ol>
<li>
This lab walks you through Amazon Quantum Ledger Database features. We will create a few tables in QLDB Ledger to store information and then query that information from the table and view the update history of the table.
</li>
<li>
You will practice using Amazon Quantum Ledger Database (QLDB).
</li>
</ol>

<ol>
	<li>
	This lab walks you through to create a table in Amazon DynamoDB and enable the TTL (Time To Live) feature. Next we will insert two values to the table, one with expiration time and the other with no expiration time and see whether the items in the table get deleted after the TTL gets expired.
	</li>
	<li>
	You will practice the lab using DynamoDB Table.
	</li>
	<li>Duration: 45 minutes</li>
</ol>

<ul>
	<li>
	This lab walks you through the steps to create Amazon DynamoDB backup and restore using the 2 methods provided (PITR &amp; On-Demand).
	</li>
	<li>
	You will practice the lab using the following AWS Services.
	</li>
	<li>
	IAM - used to create roles which hold the required permission to work.
	</li>
	<li>
	S3 - used to store .csv files which hold the data that is inserted into DynamoDB tables.
	</li>
	<li>
	DynamoDB - used to create tables, store data and work with backup and restore tasks.
	</li>
	<li>
	Lambda - used to trigger the data insertion from S3 to Dynamodb.
	</li>
</ul>

<ol>
	<li>
	This lab walks you through to create an Amazon Timestream database and then create a table in that database. Next we will insert some values to the table using a Lambda function and then list them.
	</li>
	<li>
	You will be practicing this lab using the Amazon Timestream Database and Lambda function.
	</li>
</ol>

&nbsp;

<h1>Lab Details</h1>

<ol>
	<li>
	This lab walks you through the steps to launch and configure a DynamoDB DAX Cluster in the Amazon cloud.
	</li>
	<li>
	You will practice using Amazon Machine Images to launch Amazon EC2 Instances and use key pairs for SSH authentication to log into your instance then you will create a Go application followed by a sample DynamoDB table.
	</li>
	<li>
	You will run GetItem, Query, and Scan command to note down the timings with the DynamoDB table. And, then run the same command&nbsp;with DAX Cluster and check the duration of GetItem, Query, and Scan.
	</li>
	<li>
	Duration:&nbsp;60 minutes
	</li>
	<li>
	AWS Region:&nbsp;US East (N. Virginia) us-east-1
	</li>
</ol>

<ol>
	<li>
	This lab walks you through the steps to create an Aurora DB Cluster, store DB credentials in Secret Manager, working with Query Editor and execute code from Lambda and get the database details.
	</li>
	<li>
	Each of the AWS Services used in the lab plays an important role for you to proceed with the lab.
	</li>
</ol>

This lab walks you through the steps to launch the Amazon Aurora RDS DB instance with multi-AZ enabled and simulate failover.

This lab walks you through the creation and testing of an Amazon Relational Database Service (Amazon RDS) database. We will create an RDS MySql Database and test the connection using MySQL Workbench.

<h1 dir="ltr" style="color: rgb(85, 85, 85);">Lab Details</h1><ol><li dir="ltr">This lab walks you through the steps to migrate a database from RDS Postgres to RDS MySQL using AWS DMS.</li><li dir="ltr">Duration:&nbsp;&nbsp;90 minutes</li><li dir="ltr">AWS Region:&nbsp;US East (N. Virginia) us-east-1</li></ol><h1 style="margin-left: -18pt; color: rgb(85, 85, 85); text-align: justify;">&nbsp; &nbsp;&nbsp;Prerequisites</h1><h2 dir="ltr" style="color: rgb(85, 85, 85); margin-left: 40px;">DBeaver Setup</h2><ul style="margin-left: 40px;"><li dir="ltr">Windows and Mac users need to download and install from&nbsp;<a href="https://dbeaver.io/download/" target="_blank">https://dbeaver.io/download/</a><a href="https://dbeaver.io/download/" target="_blank">&nbsp;</a></li></ul><h1 dir="ltr" style="margin-left: -18pt; color: rgb(85, 85, 85); text-align: justify;">&nbsp; &nbsp;&nbsp;Introduction</h1><h2 dir="ltr" style="color: rgb(85, 85, 85); margin-left: 4.5pt;">Amazon RDS</h2><ul><li dir="ltr">Amazon Relational Database Service (Amazon RDS)&nbsp; is a Relational Database service that offers high availability and throughput.</li><li dir="ltr">Amazon RDS comes with great features that include&nbsp;Multi-AZ&nbsp;feature and&nbsp;Read Replica&nbsp;that ensures no data loss.</li><li dir="ltr">Amazon RDS also provides you high scalability where you can scale up and scale down depending on your needs.</li><li dir="ltr">Amazon RDS provides you with six familiar database engines which include<a href="https://aws.amazon.com/rds/aurora/">&nbsp;</a>MySQL, Amazon Aurora, PostgreSQL, MariaDB, Oracle Database and SQL Server.</li></ul><h2 dir="ltr" style="color: rgb(85, 85, 85);">Difference between PostgreSQL and MySQL database</h2><ul><li dir="ltr">PostgreSQL is an object-relational database management system whereas MySQL is a relational database management system.</li><li dir="ltr">PostgreSQL is only supported by Windows, Mac OS X, Linux, and BSD but not by UNIX, z/OS, Symbian, AmigaOS. Whereas MySQL is supported by the following operating system, Windows, Mac OS X, Linux, BSD, UNIX, z/OS, Symbian, AmigaOS.</li><li dir="ltr">PostgreSQL is a product of the Global Development Group while MySQL is the product of Oracle Corporation.</li><li dir="ltr">PostgreSQL provides complete backup online, On the other hand, MySQL, mysqldump, and XtraBackup tools provide backup.</li><li dir="ltr">PostgreSQL provides data domain objects while MySQL does not offer data domain objects.</li></ul><h2 dir="ltr" style="color: rgb(85, 85, 85); margin-left: 4.5pt;">Amazon DMS</h2><ul><li dir="ltr">AWS Database Migration Service (AWS DMS) helps you migrate databases to AWS quickly and securely.&nbsp;</li><li dir="ltr">The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database.&nbsp;</li><li dir="ltr">The AWS Database Migration Service can migrate your data to and from the most widely used commercial and open-source databases.</li></ul><h1 dir="ltr" style="color: rgb(85, 85, 85);">Architecture Diagram</h1><h1 dir="ltr" style="color: rgb(85, 85, 85);"><img src="https://play.whizlabs.com/frontend/web/media/task_id_10081/task_10081_-_page_1_36_59.png" style="height: 490px; margin-left: 0px; margin-top: 0px; width: 788px;"></h1><h1 dir="ltr" style="color: rgb(85, 85, 85);">Task Details</h1><ol><li dir="ltr">Sign in to AWS Management Console.</li><li dir="ltr">Create two Security Groups for RDS Instances</li><li dir="ltr">Create a RDS PostgreSQL Instance</li><li dir="ltr">Create a RDS MySQL Instance</li><li dir="ltr">Connecting to an Amazon PostgreSQL RDS Database on a DB Instance</li><li dir="ltr">Execute Database Operations</li><li dir="ltr">Create a Replication Instance in DMS</li><li dir="ltr">Create a Source Endpoint in DMS</li><li dir="ltr">Create a Target Endpoint in DMS</li><li dir="ltr">Create a Database Migration Task</li><li dir="ltr">Connecting to an Amazon MySQL RDS Database on a DB Instance</li><li dir="ltr">Testing Database Operations</li><li>Validation of the lab</li></ol><h1 dir="ltr" style="color: rgb(85, 85, 85);">Launching Lab Environment</h1><ol><li dir="ltr">To launch the lab environment, Click on the&nbsp;<img src="https://play.whizlabs.com/frontend/web/media/task_id_10081/start_lab.png" style="height: 36px; margin-left: 0px; margin-top: 0px; width: 218px;">&nbsp;button.</li><li dir="ltr">Please wait until the cloud environment is provisioned. It will take less than a minute to provision.</li><li dir="ltr">Once the Lab is started, you will be provided with&nbsp;IAM user name,&nbsp;Password,&nbsp;Access&nbsp;Key, and&nbsp;Secret&nbsp;Access&nbsp;Key.</li></ol><div dir="ltr" style="margin-left: 0pt;"><table style="border: none; table-layout: fixed; width: 468pt;"><tbody><tr><td style="vertical-align: top;"><div dir="ltr" style="background: rgb(238, 238, 238); border: 1px solid rgb(204, 204, 204); padding: 5px 10px;">Note&nbsp;: You can only start one lab at any given time</div></td></tr></tbody></table></div>

<ol>
	<li>
	This lab walks you through the steps of connecting Amazon EC2 with Amazon RDS Instance.&nbsp;
	</li>
	<li>
	We will create a EC2 instance under public subnet and an Amazon RDS in new Subnet Group.
	</li>
</ol>

This lab walks you through the creation and testing of an Amazon Aurora database. We will create an Aurora MySQL Database and test the connection.

This lab walks you through the step by step procedure on how to migrate existing MySQL database on the EC2 instance to AWS RDS instance by using AWS Database Migration Service

Prepare for the AWS Certified Database - Specialty exam and validate your knowledge of AWS database services and expertise in using database technology.
<ul>
<li>3 full-length AWS Certified Database Specialty practice exams with over 140 unique practice questions to get a complete idea of the AWS Certified Database Specialty certification exam pattern.</li>
<li>9+ hands-on labs developed by our certified AWS experts that help you to gain practical skills to recommend, design, and maintain optimal AWS database solutions.</li>
<li>By the end of this course, you will become confident and gain the expertise to pass the AWS Certified Database Specialty certification exam.</li>
</ul>
NOTE: AWS Certified Database Specialty Certification exam will retire on April 29, 2024.

AWS Certified Database Specialty

AWS Certified Database Specialty practice test is designed by experts to simulate the real exam scenario. The questions are based on the exam syllabus outlined by official documentation. The questions that appear in each practice test are unique and not repeated in other practice tests. These practice tests are provided to the candidates to gain more confidence in exam preparation and self-evaluate them against the exam content.

Practice Tests

Millions of aspirants have become certified with our practice tests. Give your preparation a new edge with Whizlabs AWS Certified Database - Specialty Practice Tests.

AWS Certified Database - Specialty Practice Tests - Whizlabs

Free Test

Preparing for AWS Certified Database - Specialty certification exam? Check your current preparation level with AWS Certified Database - Specialty Free Test. Try now!

AWS Certified Database - Specialty Free Test - Whizlabs

AWS Certified Database Specialty-Retired

Pass AWS Certified Database - Specialty Certification in 1st Attempt. Trained 3M+ professionals since 20 years. Start with Free Trial!

AWS Certified Database - Specialty Certification  - Whizlabs

Practice Exams and Hands-on Labs

2 Full-length Mock Exams (130 unique AWS Certified Database - Specialty certification exam practice questions

1 section quiz covering the most important topics for the exam (Amazon Aurora)

Access to labs to test your knowledge on AWS environment. Covering all the important topics like Amazon CloudSearch, etc.

Our Course come with the unlimited access for 1 year

Our support team consists of AWS Experts, ready to clarify all your questions.

AWS Certified Database - Specialty Exam Feedback

AWS Certification Training Courses

AWS Cloud Practitioner certification demonstrates and validates your knowledge on the overall understanding of AWS Cloud Platfoliyo

Google Cloud Certifications

DevOps Certifications

Hello There,
Thank you for reaching out to us.
I hope our courses are helpful in your journey!
Please feel free to reach out to us for further assistance, if needed.&nbsp;
Regards, Aiswarya
&nbsp;

I will write the feedback as soon as I am able to complete the course

Review your products

It is indeed our pleasure to be able to support and help you in your journey!!!

I passed the exam. The practice test was very useful. The explanation is concise, the links are expedient.  

AWS Certified Database Specialty Practice Test

Dear Prakesh,
Thank you for writing to us. I am glad to know that you are satisfied with our learning materials and thank you for the detailed feedback. Please feel free to reach out to us for further assistance, if needed.
Regards, Mathura R

Passed the DB specialty exams yesterday. The hands-on labs and practice tests were very useful.

Great product

Thanks to this course, I was able to pass the DBS exam. I was a bit worried about the lower number of questions compared to other exams, but I believe it ended up covering everything. If you already have qualifications in SAP or other specialties, I think studying in this course should be sufficient.

Good Course!

This course really helped me with the actual exam. There are somethings that need to be improved but a great tool none the less.

Definitely Helped

Dear&nbsp; Elan, Thank you for writing to us. I am glad to know that you are satisfied with our learning materials and thank you for the detailed feedback. Please feel free to reach out to us for further assistance, if needed.
Regards, Mathura R

Elon Musk

Had a lot of benefit from these Practice Exams

Good Practice Exam

The mock exams helped learn about the subject and the details. I would strongly recommend taking the exams until you get 90% or so in score and which should be based on understanding not memorizing the answers. Please provide feedback to the instructors as they are responsive and they to take action right away. In addition to this, review AWS documentation thoroughly for latest updates. 

Great set of questions and labs

THE BEST PART IS PRACTICE MODE. It really helps to get immediate feedback to a question. My only negitive feed back is minor. because I use these tests like flash cards, I wish the order of questions would be randomized. Also the answers... after a while you remember that the correct anwer is the third one. But definitly worth every penny. I used Whizlabs to pass the archect exam and I am sure this is going to help me pass the DBA exam as well. 

Questions are great.

Some individual exams are not as extensive as thr exam, but rather go deeper on individual databases.

Definitely helpful and recommended 

some individual exams are not as extensive as thr exam, but rather go deeper on individual databases.