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

Overview of Amazon Redshift

Amazon Redshift is a data warehouse managed service that's offered by AWS as an enterprise-class relational database query and management system. A data warehouse is a special type of database that's designed to handle large data loads and provide rapid response times to complex queries. Amazon Redshift uses a combination of massively parallel queries, columnar data storage, and data compression to maximize the query's speeds while minimizing storage costs. For more general information on columnar databases, please refer to Chapter 2, Understanding Database Fundamentals.

Let's take a closer look at the architecture of a Redshift cluster.

Redshift architecture

Similar to RDS Aurora, Redshift operates a cluster topology, which allows it to use multiple nodes to scale and split (or shard) the workload. The following diagram shows a high-level view of how Redshift is deployed:

Figure 7.1 – Redshift cluster...