AWS Certified Database - Specialty (DBS-C01)

Focused View

Chris Behrens

18:25:37

12 View

01 Introduction

001 Course Introduction.mp4

02:21

002 What to Know before You Get Started.mp4

02:13

003 AWS Exam Readiness AWS Certified Database - Specialty Digital Training.txt

003 Preparing for the Exam.mp4

09:31

02 Going Back to the Basics

001 Understanding Purpose-Built Databases.mp4

11:16

002 OLTP vs. OLAP and ACID vs. BASE.mp4

09:02

003 Understanding RTO and RPO.mp4

08:19

004 AWS Database Services Overview.mp4

13:45

004 Enter the purpose-built database era.pdf

03 Relational Databases Amazon RDS

001 Introducing Amazon RDS.mp4

10:00

002 Demo RDS Console Walkthrough.mp4

10:10

003 Provisioning RDS Instances.mp4

07:15

004 What Are RDS Parameter Groups and Option Groups.mp4

08:36

005 Cloud Users SQL.txt

005 Demo Provisioning an RDS Instance.mp4

11:07

006 Best Practices for Converting to Multi-AZ.txt

006 Modifying Storage for Amazon RDS DB instances.html

006 Modifying a DB Instance.html

006 RDS Multi-AZ Deployments and Scaling Options.mp4

15:24

006 Understanding DB Instance Statuses.txt

007 Scaling for Read-Heavy Workloads RDS Read Replicas.mp4

15:22

008 Demo Promoting Read Replicas in RDS.mp4

11:54

010 Using Backups and Snapshots.mp4

08:02

011 Sharing and Encrypting RDS Snapshots.mp4

07:13

012 PITR Engine Considerations.html

012 Restoring Options for RDS Snapshots and PITR.mp4

14:29

014 Working with RDS in a VPC.mp4

11:51

015 RDS Pricing Model and Saving Costs.mp4

10:25

016 RDS Exam Question Review.mp4

03:34

04 Relational Databases Amazon Aurora

001 Introducing Amazon Aurora.mp4

12:21

002 Aurora Scaling Options and Managing Connections.mp4

12:39

003 Demo Aurora Console Walkthrough.mp4

09:07

004 What Is Multi-Master.mp4

06:16

005 Aurora Backup Options.mp4

07:14

006 Demo Restoring Aurora Backups vs. Backtracking.mp4

12:39

007 Replicating Aurora Clusters.mp4

14:25

007 Replication with Amazon Aurora MySQL.html

007 Replication with Amazon Aurora PostgreSQL.html

008 Managing Fault Injection Queries.html

008 Understanding Aurora Failovers.mp4

12:07

009 AWS JDBC Driver for PostgreSQL.txt

009 Aurora Priorities and PostgreSQL Fast Failovers.mp4

09:24

010 Demo Simulating Aurora Failovers.mp4

03:22

011 Working with Aurora in a VPC.mp4

05:48

013 MySQL Engine Parallel Query.mp4

07:11

013 Parallel Query Benefits and Limitations.txt

013 Why particular SQL Statements dont Use Parallel Query.txt

014 Cloning Databases in Aurora.mp4

09:21

015 Caching in Aurora Cluster Cache Management.mp4

05:15

016 Comparison of Aurora Serverless v2 and Aurora Serverless v1.txt

016 Introducing Aurora Serverless.mp4

11:42

017 Scaling Aurora Serverless.mp4

11:17

018 Aurora Pricing.txt

018 Aurora Pricing Model.mp4

07:00

019 Aurora Exam Question Review.mp4

03:39

05 Amazon DynamoDB and DAX

001 Introducing Amazon DynamoDB.mp4

08:44

002 DynamoDB Partitions and Primary Keys.mp4

09:28

003 DynamoDB Scaling Options.mp4

10:47

003 Service account and table quotas in Amazon DynamoDB.txt

004 Demo DynamoDB Console Menu Configurations.mp4

14:59

005 Working with DynamoDB Transactions.mp4

09:55

006 Demo DynamoDB Operations and Transactions.mp4

10:59

006 python script for creating a dynamodb table.zip

006 python script for executing transactions.zip

008 Comparing Read and Write Consistency Models.mp4

07:28

009 DynamoDB Modes Provisioned Capacity vs. On-Demand.mp4

12:12

010 Calculating Performance Units RCUWCU.mp4

09:08

011 Best practices for querying and scanning data.html

011 DynamoDB Operations Scans vs. Queries.mp4

10:42

012 Commands for Creating and Populating a DynamoDB Table.txt

012 Demo Scans and Queries.mp4

06:23

012 data json file.zip

013 BatchExecuteStatement API.html

013 BatchGetItem API.html

013 BatchWriteItem API.html

013 DynamoDB Batch Operations and Offloading Large Attributes to S3.mp4

11:16

013 DynamoDB - API Reference.html

013 Getting Started with PartiQL in DynamoDB.html

013 TransactGetItems.html

013 TransactWriteItems.html

014 Demo DynamoDB Batch Operations and Offloading Large Attributes to S3.mp4

09:34

014 DynamoDB Commands.txt

014 json for batch get items command.zip

014 json for creating productcataloga.zip

014 json for creating productcatalogb.zip

015 DynamoDB Local Secondary Index (LSI) and Global Secondary Index (GSI).mp4

13:21

017 On-Demand vs. Continuous PITR Backup.mp4

10:01

018 Commands for Creating a DynamoDB Table and Enabling TTL.txt

018 DynamoDB Time to Live (TTL).mp4

04:19

018 session data items json file.zip

019 Demo Using DynamoDB TTL.mp4

09:48

019 Epoch Converter.txt

019 TTL Commands.txt

020 DynamoDB Global Tables.mp4

07:54

021 DynamoDB Encryption At Rest.html

021 DynamoDB Encryption Client.html

021 Encrypting DynamoDB Tables.mp4

07:48

021 Encryption Options Slide Snapshot.txt

022 DynamoDB VPC Endpoints.mp4

05:43

023 Introducing DynamoDB Streams.mp4

08:38

024 Caching in DynamoDB DAX.mp4

12:21

025 Demo Working with DAX.mp4

10:53

026 DynamoDB Errors and Exceptions.mp4

10:58

026 Item collection size limit in Local Secondary Indexes.txt

027 DynamoDB Pricing Model.mp4

11:56

027 Pricing for On-Demand Capacity.txt

027 Pricing for Provisioned Capacity.txt

028 DynamoDB and DAX Exam Question Review.mp4

03:36

06 Amazon Redshift and Additional Databases

001 Introducing Amazon Redshift.mp4

11:38

002 Redshift Table Design Distribution Styles.mp4

06:43

003 Loading and Unloading Data with Redshift.mp4

04:56

004 Demo Loading Data from S3 to Redshift.mp4

13:15

004 Redshift Commands for Importing Data.txt

004 Redshift Data CSV File.txt

005 Automatic Workload Management (WLM).html

005 Manual Workload Management (WLM).html

005 Redshift Spectrum and Other Things to Know.mp4

12:40

006 Configuring cross-Region Snapshot Copy.txt

006 Redshift Backup and Restore.mp4

07:52

007 Introducing Amazon Neptune.mp4

07:46

008 Loading and Retrieving Data in Neptune.mp4

07:15

010 Amazon DocumentDB QLDB and Timestream Overview.mp4

09:22

011 Redshift and Additional Databases Exam Question Review.mp4

03:46

07 In-Memory Databases Amazon ElastiCache

001 Access Patterns for Accessing an ElastiCache Cluster.txt

001 Introducing In-Memory Databases and Amazon ElastiCache.mp4

07:25

002 Caching Strategies.mp4

07:28

003 Memcached vs. Redis and Redis Cluster Modes.mp4

10:10

003 Redis Persisting Data and AOF Feature.html

004 Demo Creating a Redis Cluster.mp4

14:40

005 ElastiCache Backups and Scaling.mp4

12:00

005 Managing Reserved Memory in Redis.html

007 ElastiCache Pricing Model.mp4

06:47

007 ElastiCache Supported Nodes.html

008 ElastiCache Exam Question Review.mp4

03:04

08 Migrating Databases AWS DMS and AWS SCT

001 AWS Prescriptive Guidance - Oracle Heterogenous Migration Tools.html

001 Moving to managed databases.txt

001 Picking the Right Migration Tool.mp4

12:31

002 Introducing AWS Database Migration Service (DMS).mp4

09:36

003 DMS Sources.html

003 DMS Sources Targets and Transformation Rules.mp4

13:15

003 DMS Targets.html

003 Migration Use Case Scenarios.html

003 Transformation Rules and Actions.html

004 Validating Data Using DMS Validation.mp4

05:06

005 Demo Using DMS to Migrate RDS MySQL to Aurora MySQL.mp4

14:50

007 Introducing AWS Schema Conversion Tool (SCT).mp4

09:27

008 Large Migrations Using DMS and Snowball.mp4

05:26

009 Applying Batch Optimized Apply to Improve CDC Replication.txt

009 DMS Best Practices.html

009 Troubleshooting DMS Tasks.html

009 Troubleshooting DMS Tasks.mp4

12:23

010 Migrating Redis to ElastiCache.mp4

06:41

011 DMS Pricing Model.mp4

06:50

012 DMS and SCT Exam Question Review.mp4

03:42

09 Comparing AWS Database Offerings

001 Comparison of AWS Databases.mp4

08:45

002 Comparison of Aurora Replicas and RDS Replicas.mp4

07:15

003 Comparison of Aurora Global Databases to Cross-Region Replicas.mp4

04:21

003 Starting and Stopping Aurora Clusters.html

003 Using Amazon Aurora global databases.txt

004 Comparison of DAX vs. ElastiCache.mp4

02:48

005 Comparing AWS Database Offerings Exam Question Review.mp4

02:22

10 Automation and AWS CloudFormation

001 Creating Database Resources with CloudFormation.mp4

10:45

002 AWS CloudFormation Templates and RDS Deletion Protection.mp4

09:39

003 Demo Using CloudFormation with RDS.mp4

13:36

003 deploying rds instances using cloudformation with deletion protection enabled.zip

003 deploying resources using cloudformation.zip

004 CloudFormation Best Practices and Other Things to Know.mp4

10:12

005 Lambda and Database-Related Use Cases.mp4

09:49

007 Automation and CloudFormation Exam Question Review.mp4

04:03

11 Troubleshooting Auditing and Monitoring

001 Analyzing Amazon RDS Database Workloads with Performance Insights.txt

001 Enhanced Monitoring in RDS.html

001 Introducing Monitoring in Databases.mp4

11:25

002 Introducing Amazon CloudWatch Metrics.mp4

05:40

003 CloudWatch Metrics for Aurora.html

003 CloudWatch Metrics for DynamoDB.html

003 CloudWatch Metrics for RDS.txt

003 CloudWatch Metrics for Redshift.txt

003 Using Amazon CloudWatch Metrics for Databases.mp4

11:48

004 Leveraging Performance Insights.mp4

13:48

004 PI API Reference.html

005 Enhancing DynamoDB Performance with CloudWatch Contributor Insights.mp4

05:17

006 Tools for Auditing Databases in AWS.mp4

14:25

007 RDS Postgres Replication Best Practices.txt

007 Troubleshooting Postgres Replication.txt

007 Troubleshooting Replication Issues in RDS.mp4

12:54

008 Troubleshooting DynamoDB.html

008 Troubleshooting DynamoDB RDS and Aurora Issues.mp4

07:07

008 Troubleshooting RDS and Aurora.html

009 Aurora Storage Issues.txt

009 Troubleshooting Auditing and Monitoring Exam Question Review.mp4

03:47

12 Security and Encryption

001 Introducing Security Layers.mp4

14:43

002 RDS and Aurora Network and Authentication.mp4

07:34

003 AWS IAM Database Authentication.mp4

09:16

004 RDS and Aurora Encryption.mp4

09:04

005 Controlling DynamoDB Access.mp4

08:53

006 Redshift Network Authentication and Encryption.mp4

06:02

007 DMS Network IAM and Encryption.mp4

08:05

008 ElastiCache Network Authentication and Encryption.mp4

07:02

009 Security and Encryption Exam Question Review.mp4

04:25

13 Practice Exam

14 Conclusion and Whats Next

001 Congratulations and Whats Next.mp4

02:46

Description

Introduction to AWS database technologies on a per-service basis in preparation for the AWS Certified Database Specialty (DBS-C01) exam.

What You'll Learn?

In this course, AWS Certified Database - Specialty (DBS-C01), you’ll learn to select the best suited AWS database offering based on your workload. First, we’ll discuss how different database types are best leveraged, and dive into services like RDS, Aurora, and DynamoDB. This course aims to provide the fundamentals required to pass the AWS Certified Database Specialty (DBS-C01) exam by introducing AWS database technologies on a per-service basis. Throughout the course, we’ll go over deploying AWS database resources, managing those resources, and migrating them to additional regions or database engines. We’ll also cover monitoring and troubleshooting — discussing RDS and Aurora features like Performance Insights and Enhanced Monitoring — and how to perform investigations and minimize downtime, thereby increasing availability. We’ll also touch on using services like Redshift for data warehousing and analytical workloads, and discuss popular migration methodologies between engines and services (including lessons on both homogeneous and heterogeneous migrations using AWS Database Migration Service). Going into the AWS Certified Database Specialty exam, it’s important that you feel comfortable performing administrative tasks on database resources — including everything from configuring backups, to cross-region replication, to best-practice migration methodologies. When you’re finished with this course, you’ll have the knowledge required to properly leverage various AWS database offerings, such as RDS, Aurora, Aurora serverless and global database, DynamoDB, Database Migration Service, and even services like Redshift and Neptune. You’ll have a foundational understanding of which database service is best leveraged for a given workload, taking feature availability into account.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Amazon AWS

Chris Behrens

Instructor's Courses

Acloud Guru

View courses Acloud Guru

A Cloud Guru is an online training platform for people interested in Information Technology. Most of the courses offered prepare students to take certification exams for the three major cloud providers.