AWS Certified Database – Specialty (DBS-C01) Certification Guide: A comprehensive guide to becoming an AWS Certified Database specialist

by Kate Gawron

Length: 472 pages
Edition: 1
Language: English
Publisher: Packt Publishing
Publication Date: 2022-05-13
ISBN-10: 1803243104
ISBN-13: 9781803243108
Sales Rank: #306354 (See Top 100 Books)

0 ratings

Print Book Look Inside

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.

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 Aurora's 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

Data Modeling & Design Data Processing

Donate to keep this site alive

To access the Link, solve the captcha.

How to download source code?

1. Go to: https://github.com/PacktPublishing

2. In the Find a repository… box, search the book title: AWS Certified Database – Specialty (DBS-C01) Certification Guide: A comprehensive guide to becoming an AWS Certified Database specialist, sometime you may not get the results, please search the main title.