Book Image

AWS Certified Database – Specialty (DBS-C01) Certification Guide

By : Kate Gawron
5 (1)
Book Image

AWS Certified Database – Specialty (DBS-C01) Certification Guide

5 (1)
By: Kate Gawron

Overview of this book

The AWS Certified Database – Specialty certification is one of the most challenging AWS certifications. It validates your comprehensive understanding of databases, including the concepts of design, migration, deployment, access, maintenance, automation, monitoring, security, and troubleshooting. With this guide, you'll understand how to use various AWS databases, such as Aurora Serverless and Global Database, and even services such as Redshift and Neptune. You’ll start with an introduction to the AWS databases, and then delve into workload-specific database design. As you advance through the chapters, you'll learn about migrating and deploying the databases, along with database security techniques such as encryption, auditing, and access controls. This AWS book will also cover monitoring, troubleshooting, and disaster recovery techniques, before testing all the knowledge you've gained throughout the book with the help of mock tests. By the end of this book, you'll have covered everything you need to pass the DBS-C01 AWS certification exam and have a handy, on-the-job desk reference guide.
Table of Contents (24 chapters)
1
Part 1: Introduction to Databases on AWS
Free Chapter
2
Chapter 1: AWS Certified Database – Specialty Overview
5
Part 2: Workload-Specific Database Design
12
Part 3: Deployment and Migration and Database Security
16
Part 4: Monitoring and Optimization
20
Part 5: Assessment
21
Chapter 16: Exam Practice

Connecting Redshift to other AWS services

One of the main benefits a data warehouse offers is that it provides a single location for all the data required for reporting and analytics. Your users don't need to go to multiple different places for the information as it's all in one place. AWS offers several methods that allow you to load data from other sources quickly and efficiently. First, let's look at Redshift Spectrum, which offers connectivity from an S3 bucket.

Redshift Spectrum

Redshift Spectrum is a feature that allows you to query data from an S3 bucket directly from Redshift using a SQL query. Before Spectrum was released, you would have had to load the data from S3 into Redshift before it could be queried, but now, you can query it in situ. To use Redshift Spectrum, you must configure your S3 bucket as an external table that you can then call in a query. You can even use joins to create a complex query involving multiple S3 buckets and files, as well...