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

Amazon Athena

Amazon Athena is a serverless, data querying service. It is designed to allow you to run queries against data stored within an AWS S3 bucket without needing to import it into a database first. Athena uses a SQL programming language called Presto, which supports common SQL syntax such as joins and where clauses. Athena can connect to data within an S3 bucket on its own, or it can use a schema that's been created by AWS Glue. If you do not use AWS Glue, then Athena cannot use indexes or partitions to help speed up your queries, so Athena without Glue is only suitable for smaller datasets.

Athena offers a lot of benefits around querying data without you having to import it into a database first, but it also has some restrictions that you'll need to know for the Database Specialty exam. Let's look at some of the benefits and limitations of using Amazon Athena: