[New] Ultimate Aws Certified Database Specialty 2022 (updated 1/2023)

Pass the AWS Certified Database Specialty Certification DBS-C01. Learn RDS, Aurora, DynamoDB, DMS, ElastiCache in depth

What you'll learn

FULLY UPDATED FOR DBS-C01: Pass the AWS Certified Database Specialty Exam

All 550+ slides available as downloadable PDF

Learn the AWS Database services in depth to ace your certification exam

Requirements

It's recommended to hold at least one AWS associate-level certification, e.g. AWS Certified Solutions Architect Associate or AWS Certified Developer Associate

Better to have some experience dealing with databases

Description

Welcome! We're here to help you prepare and PASS the new AWS Certified Database Specialty exam.COURSE LAUNCHED IN AUGUST 2020. –––––––––––––––––-The AWS Certified Database Specialty certification is a very challenging certification for AWS. It's great at assessing how well you understand the AWS databases, and their integrations and troubleshooting. We want to help YOU pass the AWS Certified Database Specialty certification with flying colors. This AWS Certified Database Specialty course is the first comprehensive course on this new AWS certification.It covers in-depth all the topics on the AWS Certified Database Specialty DBS-C01 examIt's packed with practical knowledge on how to use AWS databases inside and outWe are going to learn by doingIt teaches you how to prepare for the AWS examIt's fast-paced and to the point All 550+ slides available as downloadable PDF~~~ TOPICS COVERED ~~~Amazon DynamoDB and DAXAmazon RDS and AuroraAmazon RedshiftAmazon ElastiCacheAmazon DocumentDBAmazon NeptuneAmazon ElasticSearch ServiceAmazon TimestreamAmazon QLDBAmazon DMS and SCTAWS CloudFormationOther services: KMS, CloudWatch, VPC, CloudTrail, Lambda, SMS, Secrets Manager…IF YOU WANT TO MAXIMIZE YOUR CHANCES OF PASSING THE AWS CERTIFIED DATABASE SPECIALTY EXAM…THIS IS THE COURSE FOR YOU!–––––––––––––––––-InstructorsMy name is Stéphane Maarek, I am passionate about Cloud Computing, and I will be your instructor in this course. I teach about AWS certifications, focusing on helping my students improve their professional proficiencies in AWS.I have already taught 1,500,000+ students and gotten 500,000+ reviews throughout my career in designing and delivering these certifications and courses!I'm delighted to welcome Riyaz Sayyad as my co-instructor for this course!Riyaz is an AWS Certified Database Specialist, Developer, and an expert IT Consultant. He has been working in the IT industry for the last 16+ years. He has deep knowledge about AWS databases, and he is 3x AWS Certified. He's a rising star on Udemy and I'm thrilled to have created this course with himWith AWS becoming the centerpiece of today's modern IT architectures, I have decided it is time for students to learn how to be an AWS Database Specialist. So, let’s kick start the course! You are in good hands!––––––––––––––––-This course also comes with:Lifetime access to all future updatesA responsive instructor in the Q&A SectionUdemy Certificate of Completion Ready for DownloadA 30 Day "No Questions Asked" Money Back Guarantee!Join me in this course if you want to pass the AWS Certified Database Specialty Certification DBS-C01 and master the AWS platform!

Overview

Section 1: Introduction

Lecture 1 Course Introduction + Exam Breakdown

Lecture 2 About your instructors

Lecture 3 Purpose Built Databases

Section 2: Code & Slides Download

Lecture 4 Code & Slides Download

Section 3: Quick refresher on the basics

Lecture 5 Types of data

Lecture 6 Relational databases

Lecture 7 Non-relational databases

Section 4: Amazon RDS and Aurora

Lecture 8 Amazon RDS overview

Lecture 9 RDS pricing model

Lecture 10 Instance type, storage type and storage auto scaling for RDS

Lecture 11 RDS parameter groups

Lecture 12 RDS option groups

Lecture 13 RDS - Hands on

Lecture 14 RDS security - Network

Lecture 15 RDS security - IAM

Lecture 16 Rotating RDS DB credentials

Lecture 17 Windows authentication in RDS for SQL Server

Lecture 18 RDS encryption in transit and at rest

Lecture 19 RDS backups

Lecture 20 Copying and sharing RDS snapshots

Lecture 21 How to encrypt an unencrypted RDS database

Lecture 22 DB restore options in RDS

Lecture 23 Exporting RDS DB snapshot to S3

Lecture 24 RDS backup and restore - Hands on

Lecture 25 RDS Multi-AZ deployments and read replicas

Lecture 26 Read replica use cases

Lecture 27 Promoting a read replica to a standalone DB instance

Lecture 28 RDS Multi-AZ failover and replica promotion - Demo

Lecture 29 Enabling writes on a read replica

Lecture 30 RDS read replica capabilities

Lecture 31 RDS Second-tier replicas and replica promotion - Demo

Lecture 32 Cross-region read replicas in RDS

Lecture 33 RDS replicas with an external database

Lecture 34 RDS disaster recovery strategies

Lecture 35 Troubleshooting replica issues in RDS

Lecture 36 Performance hit on new read replicas

Lecture 37 Scaling and sharding in RDS

Lecture 38 RDS monitoring

Lecture 39 RDS event subscriptions, recommendations and logs

Lecture 40 Exporting RDS logs to S3

Lecture 41 RDS Enhanced Monitoring

Lecture 42 RDS Performance Insights

Lecture 43 CloudWatch Application Insights

Lecture 44 RDS on VMware

Lecture 45 RDS - Good things to know

Lecture 46 Aurora overview

Lecture 47 Aurora architecture

Lecture 48 Aurora Parallel Query

Lecture 49 Aurora Serverless

Lecture 50 Data API for Aurora Serverless

Lecture 51 Aurora multi-master

Lecture 52 Aurora cross region replicas and Aurora Global database

Lecture 53 Reliability features in Aurora

Lecture 54 Aurora pricing model

Lecture 55 Aurora security - Network, IAM and encryption

Lecture 56 Parameter groups in Aurora and Aurora Serverless

Lecture 57 Creating an Aurora database - Hands on

Lecture 58 Creating an Aurora Serverless database - Hands on

Lecture 59 Using Data API with Aurora Serverless database - Hands on

Lecture 60 Scaling options in Aurora

Lecture 61 Aurora monitoring and advanced auditing

Lecture 62 Monitoring in RDS and Aurora - Demo

Lecture 63 Exporting Aurora logs

Lecture 64 Database activity streams in Aurora

Lecture 65 Troubleshooting storage issues in Aurora

Lecture 66 Aurora benchmarking

Lecture 67 Exporting data from Aurora into S3

Lecture 68 Aurora backups and backtracking

Lecture 69 Aurora backups vs snapshots vs backtrack

Lecture 70 Aurora backup, restore, PITR and backtrack - Demo

Lecture 71 Cloning databases in Aurora

Lecture 72 Aurora failovers

Lecture 73 Cluster Cache Management (CCM) in Aurora PostgreSQL

Lecture 74 Simulating fault tolerance or resiliency in Aurora

Lecture 75 Simulating failovers in Aurora - Demo

Lecture 76 Aurora failover priorities in action - Demo

Lecture 77 Fast failover in Aurora PostgreSQL

Lecture 78 Cluster replication options for Aurora MySQL

Lecture 79 Aurora replicas vs RDS MySQL replicas

Lecture 80 Comparison of RDS deployments

Lecture 81 How to invoke Lambda functions from Aurora MySQL

Lecture 82 How to load data from S3 into Aurora MySQL

Lecture 83 RDS / Aurora – Good things to know

Section 5: Amazon DynamoDB and DAX

Lecture 84 DynamoDB overview

Lecture 85 Working with DynamoDB - Hands on

Lecture 86 DynamoDB basics

Lecture 87 DynamoDB consistency

Lecture 88 DynamoDB pricing model

Lecture 89 DynamoDB throughput

Lecture 90 Calculating capacity units

Lecture 91 DynamoDB burst capacity and adaptive capacity

Lecture 92 DynamoDB local secondary index (LSI)

Lecture 93 DynamoDB global secondary index (GSI)

Lecture 94 Choosing between LSI and GSI

Lecture 95 Simple design patterns with DynamoDB

Lecture 96 Errors and exceptions in DynamoDB

Lecture 97 DynamoDB partitions

Lecture 98 DynamoDB partition behavior example

Lecture 99 Scaling options in DynamoDB

Lecture 100 DynamoDB scaling and partition behavior

Lecture 101 DynamoDB best practices

Lecture 102 DynamoDB best practices (contd.)

Lecture 103 Large object patterns and table operations

Lecture 104 DynamoDB accelerator (DAX)

Lecture 105 DAX architecture

Lecture 106 DAX operations

Lecture 107 Implementing DAX - Hands on

Lecture 108 DynamoDB backup and restore

Lecture 109 DynamoDb backup and restore - Hands on

Lecture 110 Continuous backup with PITR

Lecture 111 Continuous backup with PITR - Hands on

Lecture 112 DynamoDB encryption

Lecture 113 DynamoDB streams

Lecture 114 DynamoDB TTL

Lecture 115 DynamoDB TTL - Hands on

Lecture 116 TTL use cases

Lecture 117 DynamoDB global tables

Lecture 118 DynamoDB global tables - Hands on

Lecture 119 Fine-grained access control and Web-identity federation in DynamoDB

Lecture 120 CloudWatch contributor insights for DynamoDB

Section 6: Amazon Redshift

Lecture 121 Redshift overview

Lecture 122 Creating a Redshift cluster - Hands on

Lecture 123 Redshift architecture

Lecture 124 Loading data into Redshift

Lecture 125 Loading data from S3 into Redshift - Hands on

Lecture 126 More ways to load data into Redshift

Lecture 127 Redshift Spectrum

Lecture 128 Querying S3 data with Redshift Spectrum - Hands on

Lecture 129 Redshift federated query

Lecture 130 Star schema in data warehouses

Lecture 131 Redshift fundamentals

Lecture 132 Redshift Workload Management (WLM)

Lecture 133 Redshift concurrency scaling

Lecture 134 Redshift scaling

Lecture 135 Redshift backup, restore and cross-region snapshots

Lecture 136 Redshift Multi-AZ deployment alternative

Lecture 137 Redshift availability and durability

Lecture 138 Redshift security

Lecture 139 Enhanced VPC routing in Redshift

Lecture 140 Redshift monitoring

Lecture 141 Redshift pricing

Lecture 142 Redshift related services - Athena and Quicksight

Lecture 143 AQUA for Redshift

Section 7: Amazon ElastiCache

Lecture 144 ElastiCache overview

Lecture 145 Caching strategies

Lecture 146 Redis architecture and Multi-AZ auto-failover

Lecture 147 Redis backup and restore

Lecture 148 Redis scaling and replication

Lecture 149 Creating a Redis cluster - Hands on

Lecture 150 Redis global datastore

Lecture 151 Redis - Good things to know

Lecture 152 Redis best practices

Lecture 153 Redis use cases

Lecture 154 Memcached overview

Lecture 155 Memcached architecture

Lecture 156 Memcached auto discovery

Lecture 157 Memcached scaling

Lecture 158 Creating a Memcached cluster - Hands on

Lecture 159 Choosing between Redis and Memcached

Lecture 160 ElastiCache security

Lecture 161 ElastiCache logging and monitoring

Lecture 162 ElastiCache pricing

Section 8: Amazon DocumentDB (with MongoDB compatibility)

Lecture 163 DocumentDB overview

Lecture 164 What and why about document databases

Lecture 165 DocumentDB architecture

Lecture 166 DocumentDB backup and restore

Lecture 167 DocumentDB scaling

Lecture 168 DocumentDB security

Lecture 169 DocumentDB pricing

Lecture 170 DocumentDB monitoring

Lecture 171 DocumentDB performance management

Lecture 172 Creating a DocumentDB cluster - Hands on

Section 9: Amazon Neptune

Lecture 173 Neptune overview

Lecture 174 Neptune architecture

Lecture 175 Creating a Neptune cluster - Hands on

Lecture 176 Bulk loading graph data into Neptune

Lecture 177 Bulk loading graph data into Neptune from S3 - Hands on

Lecture 178 Neptune Workbench

Lecture 179 Querying Neptune via Jupyter Notebooks - Hands on

Lecture 180 Neptune replication and high availability

Lecture 181 Neptune backup and restore

Lecture 182 Neptune scaling

Lecture 183 Database cloning in Neptune

Lecture 184 Neptune security

Lecture 185 Neptune monitoring

Lecture 186 Query queuing in Neptune

Lecture 187 Neptune service errors

Lecture 188 SPARQL federated query

Lecture 189 Neptune streams

Lecture 190 Neptune pricing

Section 10: Amazon Elasticsearch Service

Lecture 191 Amazon ElasticSearch Service is now Amazon OpenSearch Service

Lecture 192 Amazon Elasticsearch Service overview

Lecture 193 ElasticSearch Service patterns

Lecture 194 Elasticsearch Service - Multi-AZ

Lecture 195 Logging options in Elasticsearch Service

Lecture 196 ElasticSearch Service pricing

Lecture 197 ElasticSearch Service - Hands on

Section 11: Amazon Timestream

Lecture 198 Timestream overview

Lecture 199 Timestream pricing

Section 12: Amazon QLDB

Lecture 200 QLDB overview

Lecture 201 QLDB architecture

Lecture 202 QLDB views

Lecture 203 Working with QLDB

Lecture 204 Data verification in QLDB

Lecture 205 Creating a QLDB ledger - Hands on

Lecture 206 Data verification in QLDB - Hands on

Lecture 207 QLDB backup and restore (an alternative)

Lecture 208 QLDB streams

Lecture 209 QLDB high availability, durability and an alternative to CRR

Lecture 210 QLDB security

Lecture 211 QLDB monitoring

Lecture 212 QLDB pricing

Section 13: Amazon Keyspaces (for Apache Cassandra)

Lecture 213 Keyspaces overview

Lecture 214 Migrating from Cassandra to Keyspaces

Lecture 215 Read and write consistency in Keyspaces

Lecture 216 Keyspaces pricing

Lecture 217 Working with Keyspaces - Hands on

Section 14: Comparing AWS Databases

Lecture 218 Comparison of AWS Databases

Section 15: Database Migration, DMS and SCT

Lecture 219 Database migration overview

Lecture 220 DMS sources and targets

Lecture 221 DMS architecture and overview

Lecture 222 Migration with DMS in action - Hands on

Lecture 223 SCT overview

Lecture 224 Workload Qualification Framework (WQF)

Lecture 225 DMS tasks and task assessment reports

Lecture 226 DMS migration types

Lecture 227 DMS - Good things to know

Lecture 228 Migrating large tables and LOBs with DMS

Lecture 229 DW migration with SCT

Lecture 230 Migration playbooks

Lecture 231 DMS monitoring

Lecture 232 DMS validation

Lecture 233 DMS statistics and control tables

Lecture 234 DMS security - IAM, encryption and networking

Lecture 235 DMS pricing

Lecture 236 DMS general best practices

Lecture 237 DMS migration architectures to minimize downtime

Lecture 238 Migrating large databases

Lecture 239 Migrating to RDS databases

Lecture 240 Migrating to Aurora

Lecture 241 Migrating Redis workloads to ElastiCache

Lecture 242 Migrating to DocumentDB

Lecture 243 Streaming use cases for DMS

Section 16: Monitoring, Logging and Encryption

Lecture 244 Encryption and Snapshots

Lecture 245 Database Logging

Lecture 246 Secrets Manager

Lecture 247 Active Directory with RDS Microsoft SQL Server

Section 17: CloudFormation and Automation

Lecture 248 Section Structure

Lecture 249 CloudFormation Overview

Lecture 250 CloudFormation Create Stack Hands On

Lecture 251 CloudFormation Update and Delete Stack Hands On

Lecture 252 YAML Crash Course

Lecture 253 CloudFormation Resources

Lecture 254 CloudFormation Parameters

Lecture 255 CloudFormation Mappings

Lecture 256 CloudFormation Outputs

Lecture 257 CloudFormation Conditions

Lecture 258 CloudFormation Intrinsic Functions

Lecture 259 CloudFormation Rollbacks

Lecture 260 CloudFormation ChangeSets, Nested Stacks & StackSet

Lecture 261 === CloudFormation Lectures for DB Specialty Exam ===

Lecture 262 CloudFormation with RDS

Lecture 263 CloudFormation - RDS DB Updates

Lecture 264 CloudFormation - RDS Protections

Lecture 265 CloudFormation - with Aurora

Lecture 266 CloudFormation - Parameters

Lecture 267 CloudFormation - SSM Parameter Store

Lecture 268 CloudFormation - Secrets Manager Part 1

Lecture 269 CloudFormation - Secrets Manager Part 2

Lecture 270 CloudFormation - Advanced Concepts and Cleanup

Section 18: VPC - Networking

Lecture 271 VPC Section Structure

Lecture 272 VPC, Subnets, IGW and NAT

Lecture 273 NACL, SG, VPC Flow Logs

Lecture 274 VPC Peering, Endpoints, VPN, DX

Lecture 275 VPC Cheat Sheet & Closing Comments

Lecture 276 Extra: Bastion Hosts

Section 19: Other Topics

Lecture 277 AWS Lambda Architectures

Lecture 278 Server Migration Service

Lecture 279 EBS-optimized instances

Lecture 280 Transferring large amount of data into AWS

Lecture 281 Disaster Recovery

Section 20: Exam preparation

Lecture 282 Exam Guide & Sample Questions

Lecture 283 Sample question 1

Lecture 284 Sample question 2

Lecture 285 Sample question 3

Lecture 286 Sample question 4

Lecture 287 Sample question 5

Lecture 288 Sample question 6

Lecture 289 Sample question 7

Lecture 290 Sample question 8

Lecture 291 Sample question 9

Lecture 292 Sample question 10

Lecture 293 Exam Strategy: How to tackle exam questions

Lecture 294 Additional Resources

Section 21: Congratulations

Lecture 295 Congratulations & Next Steps

Lecture 296 Bonus Lecture

Anyone wanting to acquire the knowledge to pass the AWS Certified Database Specialty Certification