Helion


Szczegóły ebooka

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

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


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.

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