You're reading from AWS Certified Database – Specialty (DBS-C01) Certification Guide A comprehensive guide to becoming an AWS Certified Database specialist

Product type Paperback

Published in May 2022

Publisher Packt

ISBN-13 9781803243108

Length 472 pages

Edition 1st Edition

Tools

AWS

Concepts

IT Certification

Author (1):

Kate Gawron

View More author details

Table of Contents (24) Chapters

Preface

1. Part 1: Introduction to Databases on AWS

2. Chapter 1: AWS Certified Database – Specialty Overview FREE CHAPTER

3. Chapter 2: Understanding Database Fundamentals

4. Chapter 3: Understanding AWS Infrastructure

5. Part 2: Workload-Specific Database Design

6. Chapter 4: Relational Database Service

7. Chapter 5: Amazon Aurora

8. Chapter 6: Amazon DynamoDB

9. Chapter 7: Redshift and DocumentDB

10. Chapter 8: Neptune, Quantum Ledger Database, and Timestream

11. Chapter 9: Amazon ElastiCache

12. Part 3: Deployment and Migration and Database Security

13. Chapter 10: The AWS Schema Conversion Tool and AWS Database Migration Service

14. Chapter 11: Database Task Automation

15. Chapter 12: AWS Database Security

16. Part 4: Monitoring and Optimization

17. Chapter 13: CloudWatch and Logging

18. Chapter 14: Backup and Restore

19. Chapter 15: Troubleshooting Tools and Techniques

20. Part 5: Assessment

21. Chapter 16: Exam Practice

22. Chapter 17: Answers

23. Other Books You May Enjoy

Assessing a database using SCT

SCT allows you to assess various source databases to check how much effort it takes to convert to either an open source target database that AWS supports in RDS, Amazon DynamoDB, or Amazon Redshift, or to assess a migration from an on-premises Oracle database to RDS Oracle, or from an on-premises Microsoft SQL Server to RDS Microsoft SQL Server.

To run the assessment, you must download the SCT program for your operating system from AWS and install it. Then, you must provide the connection and login details for the source database. SCT will show you a list of all the schemas/users it finds and you can choose the ones to assess, which lets you filter out unused or old schemas.

Once the report is complete, it will show the following information:

A summary of the source database
The license evaluation of the source database, including an assessment of whether you can change to a standard edition license from an enterprise edition one