AWS Certified Database Study Guide

AWS Certified Database Study Guide

by Matheus Arrais, Rene Martinez Bravet, Leonardo Ciccone, Angie Nobre Cocharero, Erika Kurauchi, Hugo Rozestraten
Released May 2023
Publisher(s): Sybex
ISBN: 9781119778950

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

Validate your AWS Cloud database skills!

AWS Certified Database Study Guide: Specialty (DBS-C01) Exam focuses on helping you to understand the basic job role of a database administrator / architect and to prepare for taking the certification exam. This is your opportunity to take the next step in your career by expanding and validating your skills on the AWS Cloud, and performing a database-focused role. AWS is the frontrunner in cloud computing products and services, and this study guide will help you to gain an understanding of core AWS services, uses, and basic AWS database design and deployment best practices. AWS offers more than relational and nonrelation databases, they offer purpose built databases, which allow you to utilize database services prebuilt to meet your business requirements. If you are looking to take the Specialty (DBS-C01) exam, this Study Guide is what you need for comprehensive content and robust study tools that will help you gain the edge on exam day and throughout your career.

AWS Certified Database certification offers a great way for IT professionals to achieve industry recognition as cloud experts. This new study guide is perfect for you if you perform a database-focused role and want to pass the DBS-C01 exam to prove your knowledge of how to design and deploy secure and robust database applications on AWS technologies. IT cloud professionals who hold AWS certifications are in great demand, and this certification could take your career to the next level!

  • Master all the key concepts you need to pass the AWS Certified Database Specialty (DBS-C01) Exam
  • Further your career by demonstrating your cloud computing expertise and your knowledge of databases and database services
  • Understand the concept of purpose built databases, allowing you to pick the right tool for the right job.
  • Review deployment and migration, management and operations, monitoring and troubleshooting, database security, and more
  • Access the Sybex online learning environment and test bank for interactive study aids and practice questions

Readers will also get one year of FREE access after activation to Sybex’s superior online interactive learning environment and test bank, including hundreds of questions, a practice exam, electronic flashcards, and a glossary of key terms.

Table of contents

  1. Cover
  2. Title Page
  3. Copyright
  4. Dedication
  5. Acknowledgments
  6. About the Authors
  7. About the Technical Editor
  8. Table of Exercises
  9. Introduction
    1. What Does This Book Cover?
    2. Interactive Online Learning Environment and Test Bank
    3. AWS Certified Database Study Guide – Specialty (DBS-C01) Exam Objectives
    4. Objective Map
    5. How to Contact the Publisher
    6. Assessment Test
    7. Answers to Assessment Test
  10. PART I: Workload-Specific Database Design
    1. Chapter 1: Databases—from Your Server to AWS Cloud
      1. Databases from the Beginning
      2. Databases on Premises
      3. Databases in the Cloud
      4. Summary
    2. Chapter 2: Basic AWS Concepts
      1. AWS Global Infrastructure
      2. Networking
      3. Security
      4. Storage at AWS
      5. Operations
      6. Monitoring and Logging
      7. Summary
    3. Chapter 3: Purpose-Built Databases
      1. Data store Concepts
      2. Purpose-Built Databases on AWS
      3. Summary
      4. Exam Essentials
      5. Review Questions
  11. PART II: Management and Operations, Database Security, Monitoring and Troubleshooting per Workload
    1. Chapter 4: Relational Databases on AWS
      1. Relational Databases
      2. Structured Query Language
      3. Install and Manage Databases Yourself
      4. Managed Services for Relational Databases
      5. Amazon Aurora Cloud-Native Relational Database
      6. Summary
      7. Exam Essentials
      8. Exercises
      9. Review Questions
    2. Chapter 5: Low-Latency Response Time for Your Apps and APIs
      1. Getting Started with Modern Applications and NoSQL Databases
      2. Amazon DynamoDB
      3. Amazon Keyspaces
      4. Summary
      5. Exam Essentials
      6. Exercises
      7. Review Questions
    3. Chapter 6: Document Databases in the Cloud
      1. Introducing Document Databases
      2. Getting Started with Amazon DocumentDB
      3. Creating an Amazon DocumentDB Cluster
      4. Amazon DocumentDB Architecture
      5. Security
      6. Backup and Restore
      7. Performance and Scaling
      8. Compatibility between Amazon DocumentDB and MongoDB
      9. Migrating from MongoDB to Amazon DocumentDB
      10. Amazon DocumentDB Monitoring
      11. Developing with Amazon DocumentDB
      12. When to Use DynamoDB vs. DocumentDB
      13. Amazon DocumentDB Pricing
      14. Summary
      15. Exam Essentials
      16. Exercises
      17. Review Questions
    4. Chapter 7: Better Places Than Databases to Store Large Objects
      1. Databases and Large Objects
      2. Introducing Amazon S3
      3. Costs of Amazon S3 vs. Elastic Block Storage
      4. Moving LOBs to Amazon S3
      5. Indexing LOBs in Amazon S3
      6. Additional S3 Features
      7. Security
      8. Summary
      9. Exam Essentials
      10. Exercises
      11. Review Questions
    5. Chapter 8: Deliver Valuable Information at the Speed Your Business Needs
      1. Information Latency
      2. Data Warehouses
      3. Amazon Redshift
      4. Time-Series Databases
      5. Amazon Timestream
      6. Amazon OpenSearch Service
      7. Summary
      8. Exam Essentials
      9. Exercises
      10. Review Questions
    6. Chapter 9: Discovering Relationships Using Graph Databases
      1. Graph Databases
      2. Amazon Neptune
      3. Summary
      4. Exam Essentials
      5. Review Questions
    7. Chapter 10: Immutable Database and Traceable Transactions
      1. Amazon Quantum Ledger Database
      2. Summary
      3. Exam Essentials
      4. Exercises
      5. Review Questions
    8. Chapter 11: Caching Data with In-Memory Databases
      1. Built-in Database Cache
      2. Local Application Cache
      3. In-Memory Databases
      4. Caching Use Cases
      5. Remote Cache Strategies
      6. Caching Data in AWS
      7. Caching Data with ElastiCache
      8. Amazon MemoryDB for Redis
      9. Summary
      10. Exam Essentials
      11. Exercises
      12. Review Questions
  12. PART III: Deployment and Migration
    1. Chapter 12: Migrating Your Data to AWS
      1. Network Communication and Data Migration
      2. Database Migration to AWS
      3. AWS Schema Conversion Tool
      4. AWS Data Migration Service
      5. Other AWS Services for Data Migration
      6. Choosing the Migration Path
      7. Summary
      8. Exam Essentials
      9. Exercises
      10. Review Questions
    2. Chapter 13: Disaster Recovery
      1. Understanding and Planning Disaster Recovery Requirements
      2. Recovery Point Objective and Recovery Time Objective
      3. Challenges in Disaster Recovery
      4. Managing Disaster Recovery Strategies
      5. Summary
      6. Exam Essentials
      7. Review Questions
    3. Chapter 14: Save Time and Reduce Errors Automating Your Infrastructure
      1. AWS CloudFormation
      2. AWS Systems Manager Parameter Store
      3. AWS Secrets Manager
      4. Summary
      5. Exam Essentials
      6. Review Questions
  13. Appendix: Answers to Review Questions
    1. Chapter 3: Purpose-Built Databases
    2. Chapter 4: Relational Databases on AWS
    3. Chapter 5: Low-Latency Response Time for Your Apps and APIs
    4. Chapter 6: Document Databases in the Cloud
    5. Chapter 7: Better Places Other Than Databases to Store Large Objects
    6. Chapter 8: Deliver Valuable Information at the Speed Your Business Needs
    7. Chapter 9: Discovering Relationships Using Graph Databases
    8. Chapter 10: Immutable Database and Traceable Transactions
    9. Chapter 11: Caching Data with In-Memory Databases
    10. Chapter 12: Migrating Your Data to AWS
    11. Chapter 13: Disaster Recovery
    12. Chapter 14: Save Time and Reduce Errors Automating Your Infrastructure
  14. Index
  15. End User License Agreement

Product information

  • Title: AWS Certified Database Study Guide
  • Author(s): Matheus Arrais, Rene Martinez Bravet, Leonardo Ciccone, Angie Nobre Cocharero, Erika Kurauchi, Hugo Rozestraten
  • Release date: May 2023
  • Publisher(s): Sybex
  • ISBN: 9781119778950