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

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

by Kate Gawron
Released May 2022
Publisher(s): Packt Publishing
ISBN: 9781803243108

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Pass the AWS Certified Database- Specialty Certification exam with the help of practice tests

Key Features

  • Understand different AWS database technologies and when to use them
  • Master the management and administration of AWS databases using both the console and command line
  • Complete, up-to-date coverage of DBS-C01 exam objectives to pass it on the first attempt

Book Description

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.

What you will learn

  • Become familiar with the AWS Certified Database – Specialty exam format
  • Explore AWS database services and key terminology
  • Work with the AWS console and command line used for managing the databases
  • Test and refine performance metrics to make key decisions and reduce cost
  • Understand how to handle security risks and make decisions about database infrastructure and deployment
  • Enhance your understanding of the topics you've learned using real-world hands-on examples
  • Identify and resolve common RDS, Aurora, and DynamoDB issues

Who this book is for

This AWS certification book is for database administrators and IT professionals who perform complex big data analysis as well as students looking to get AWS Database Specialty certified. A solid understanding of cloud computing, specifically AWS services, is a must. Knowledge of basic administration tasks such as logging in and running SQL queries will be helpful.

Table of contents

  1. AWS Certified Database – Specialty (DBS-C01) Certification Guide
  2. Contributors
  3. About the author
  4. About the reviewers
  5. Preface
    1. Who this book is for
    2. What this book covers
    3. To get the most out of this book
    4. Download the example code files
    5. Download the color images
    6. Conventions used
    7. Get in touch
    8. Share Your Thoughts
  6. Part 1: Introduction to Databases on AWS
  7. Chapter 1: AWS Certified Database – Specialty Overview
    1. Exam format
    2. Exam domains
      1. Workload-specific database design
      2. Deployment and migration
      3. Management and operations
      4. Monitoring and troubleshooting
    3. Database security
    4. Exam tips
    5. Summary
  8. Chapter 2: Understanding Database Fundamentals
    1. On-premises versus cloud databases
      1. Scalability
      2. Costs
      3. Security and access
      4. Compliance
      5. Performance and reliability
    2. SQL databases versus NoSQL
      1. SQL databases
      2. NoSQL databases
    3. Relational database management systems
      1. Row-orientated databases
      2. Column-orientated databases
    4. Key-value and document databases
      1. Key-value databases
      2. Document databases
    5. Graph and ledger databases
      1. Graph databases
      2. Ledger databases
    6. Summary
    7. Further reading
  9. Chapter 3: Understanding AWS Infrastructure
    1. Technical requirements
    2. Virtual private cloud overview
    3. VPC networking
      1. Subnets
      2. Route tables, NAT gateways, and internet gateways
      3. Security groups
      4. Network Access Control Lists (NACLs)
      5. Endpoints
    4. Introducing AWS identity and access management
    5. Building a VPC
      1. Using the AWS Console
      2. Using the AWS Command-Line Interface
    6. Summary
    7. Cheat sheet
    8. Review questions
    9. Further reading
  10. Part 2: Workload-Specific Database Design
  11. Chapter 4: Relational Database Service
    1. Technical requirements
    2. Overview of RDS
      1. Supported databases
      2. Compute
      3. Database administration limitations
      4. Service limits
    3. Understanding replicas and multi-AZ
      1. Multi-AZ
      2. Single-AZ versus multi-AZ failures
      3. Read replicas
    4. Configuring backups and running restores
      1. RDS automated backups
      2. Snapshots
      3. Restores
    5. Maintaining an RDS instance
      1. Checking database logs
      2. Maintaining storage and compute
      3. Parameter and option groups
      4. Upgrading an RDS instance
      5. Encryption
    6. Understanding RDS pricing
    7. Deploying an RDS instance
      1. Provisioning an RDS instance
      2. Taking a snapshot and restoring
      3. Modifying a parameter group
      4. Deleting RDS instances
    8. Summary
    9. Cheat sheet
    10. Review
    11. Further reading
  12. Chapter 5: Amazon Aurora
    1. Technical requirements
    2. Overview of the Amazon Aurora service
      1. Supported databases
      2. Compute and limitations
      3. Service limits
    3. Understanding Aurora clusters and replicas
      1. Aurora clusters
      2. Read replicas
      3. Endpoints
    4. Backing up and restoring Aurora
      1. Backing up an Aurora cluster
      2. Restoring an Aurora cluster
      3. Copying and sharing a snapshot
      4. Migrating from RDS to Aurora
    5. Using Aurora's Global Database and Serverless options
      1. Aurora Global Database
      2. Aurora Serverless
    6. Understanding Aurora pricing
      1. Aurora Serverless pricing
      2. Global tables pricing
    7. Deploying an Aurora cluster
      1. Provisioning an Aurora cluster
      2. Adding a read replica auto-scaling policy
      3. Adding global databases
    8. Summary
    9. Cheat sheet
    10. Review
    11. Further reading
  13. Chapter 6: Amazon DynamoDB
    1. Technical requirements
    2. Overview of DynamoDB
      1. DynamoDB tables
    3. Querying and scanning a DynamoDB table
      1. Partitions
    4. Working with DynamoDB records
      1. PutItem
      2. GetItem
      3. UpdateItem
      4. DeleteItem
      5. ExecuteStatement
      6. Query
      7. Scan
    5. Understanding consistency modes
    6. Understanding high availability and backups
      1. Global tables
      2. Backup and restore
    7. Understanding DynamoDB advanced features
      1. DynamoDB Streams
      2. CloudTrail
      3. TTL
      4. DAX
    8. Maintaining and monitoring a DynamoDB table
    9. Understanding DynamoDB pricing and limits
      1. Request units
      2. Storage
      3. Additional features
    10. Deploying and querying a DynamoDB table
      1. Provisioning a DynamoDB table
      2. Adding items
      3. Querying and scanning the table
      4. Creating a new index
    11. Summary
    12. Cheat sheet
    13. Review
    14. Further reading
  14. Chapter 7: Redshift and DocumentDB
    1. Technical requirements
    2. Overview of Amazon Redshift
      1. Redshift architecture
    3. Performance tuning and maintaining a Redshift cluster
      1. Massively parallel processing
      2. Columnar data storage
      3. Data compression
      4. Query optimizer
      5. Result caching
      6. Compiled code
    4. Connecting Redshift to other AWS services
      1. Redshift Spectrum
      2. Amazon Kinesis Data Firehose
      3. Amazon QuickSight
    5. Deploying a Redshift cluster
      1. Configuring Redshift Spectrum
    6. Overview of DocumentDB
      1. DocumentDB architecture
    7. Performance tuning and maintaining DocumentDB
      1. Read replicas
      2. Global clusters
      3. DocumentDB Index Tool
      4. Parameter groups
      5. Time to live (TTL)
    8. Deploying a DocumentDB cluster
    9. Summary
    10. Cheat sheet
    11. Review
    12. Further reading
  15. Chapter 8: Neptune, Quantum Ledger Database, and Timestream
    1. Technical requirements
    2. Overview of Amazon Neptune
      1. Neptune architecture and features
    3. Working with Neptune
      1. Managing a Neptune cluster
    4. Deploying a Neptune cluster
    5. Overview of Amazon QLDB
      1. QLDB architecture
    6. Accessing a QLDB database
    7. Deploying a QLDB database
    8. Overview of Amazon Timestream
      1. Timestream architecture
    9. Accessing a Timestream database
    10. Loading data into Timestream
    11. Deploying a Timestream database
    12. Summary
    13. Cheat sheet
    14. Review
    15. Further reading
  16. Chapter 9: Amazon ElastiCache
    1. Technical requirements
    2. Understanding database caching
    3. An overview of Amazon ElastiCache
    4. Redis versus Memcached
      1. Redis
      2. Memcached
      3. Redis versus Memcached
    5. Adding caching to a database system
    6. Summary
    7. Cheat sheet
    8. Review
    9. Further reading
  17. Part 3: Deployment and Migration and Database Security
  18. Chapter 10: The AWS Schema Conversion Tool and AWS Database Migration Service
    1. Technical requirements
    2. Overview of SCT
    3. Assessing a database using SCT
      1. Multi-server assessments
    4. Converting a database using SCT
    5. Overview of DMS
    6. Setting up DMS
      1. Replication instances
      2. Endpoints
      3. DMS tasks
    7. Running a DMS task via SCT
    8. Monitoring and tuning DMS
      1. Performance tuning
    9. Running a DMS task via SCT
      1. The SCT data extraction agent
      2. Using AWS Snowball
    10. Converting and migrating a database to AWS
      1. Setting up
      2. Converting the database schema
      3. Migrating the data
    11. Summary
    12. Cheat sheet
    13. Review
    14. Further reading
  19. Chapter 11: Database Task Automation
    1. Technical requirements
    2. Overview of automation techniques
    3. Understanding AWS automation
      1. AWS command-line interface (AWS CLI)
      2. AWS CloudFormation
      3. AWS Cloud Development Kit (AWS CDK)
    4. Creating infrastructure using CloudFormation
      1. Using the CloudFormation console
      2. Using the CloudFormation AWS CLI
    5. AWS Glue
    6. Amazon Athena
    7. Querying data within an S3 bucket using AWS Glue and Amazon Athena
    8. Summary
    9. Cheat sheet
    10. Review
    11. Further reading
  20. Chapter 12: AWS Database Security
    1. Technical requirements
    2. Database encryption
      1. AWS Key Management Service (KMS)
      2. Managing RDS encryption
      3. Encrypting data in transit
    3. Working with RDS encryption
      1. Encrypting an existing RDS instance
      2. Migrating an encrypted database to a different region
    4. Implementing database and VPC access controls
      1. Subnets and bastion hosts
      2. Security groups and NACLs
    5. Auditing databases
      1. Enabling auditing for an RDS MySQL database
    6. Configuring AWS Key Management Service and Secrets Manager
    7. Summary
    8. Cheat sheet
    9. Review
    10. Further reading
  21. Part 4: Monitoring and Optimization
  22. Chapter 13: CloudWatch and Logging
    1. Technical requirements
    2. Overview of CloudWatch and logging
    3. Working with CloudWatch
    4. Understanding Performance Insights
    5. Understanding RDS Enhanced Monitoring
    6. Configuring CloudWatch monitoring and alerts
      1. Creating a CloudWatch dashboard
    7. Summary
    8. Cheat sheet
    9. Review
    10. Further reading
  23. Chapter 14: Backup and Restore
    1. Technical requirements
    2. Understanding RTO and RPO
      1. RTO
      2. RPO
      3. Using RTO and RPO together
    3. Working with maintenance windows
    4. Creating backup plans with AWS Backup
    5. Summary
    6. Cheat sheet
    7. Review
    8. Further reading
  24. Chapter 15: Troubleshooting Tools and Techniques
    1. Technical requirements
    2. Using Trusted Advisor
    3. Troubleshooting techniques
    4. Resolving common errors
      1. RDS connection issues
      2. RDS security issues
      3. Resetting the DB instance owner password
      4. RDS DB instance outage or reboot
      5. RDS DB parameter changes not taking effect
      6. RDS DB instance running out of storage
      7. RDS insufficient DB instance capacity
      8. Auditing changes
    5. Summary
    6. Cheat sheet
    7. Review
    8. Further reading
  25. Part 5: Assessment
  26. Chapter 16: Exam Practice
  27. Chapter 17: Answers
    1. Chapter 3
    2. Chapter 4
    3. Chapter 5
    4. Chapter 6
    5. Chapter 7
    6. Chapter 8
    7. Chapter 9
    8. Chapter 10
    9. Chapter 11
    10. Chapter 12
    11. Chapter 13
    12. Chapter 14
    13. Chapter 15
    14. Chapter 16
    15. Why subscribe?
  28. Other Books You May Enjoy
    1. Packt is searching for authors like you
    2. Share Your Thoughts

Product information

  • Title: AWS Certified Database - Specialty (DBS-C01) Certification Guide
  • Author(s): Kate Gawron
  • Release date: May 2022
  • Publisher(s): Packt Publishing
  • ISBN: 9781803243108