Section 1 : Introduction

Lecture 1 Course Introduction + Exam Breakdown 3:17
Lecture 2 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf
Lecture 3 Purpose Built Databases 3:30

Section 2 : Code & Slides Download

Lecture 4 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf

Section 3 : Quick refresher on the basics

Lecture 5 Types of data 5:4
Lecture 6 Relational databases 6:28
Lecture 7 Non-relational databases 6:42

Section 4 : Amazon RDS and Aurora

Lecture 8 mp4 4:21
Lecture 9 RDS pricing model 1:25
Lecture 10 Instance type, storage type and storage auto scaling for RDS 4:5
Lecture 11 RDS parameter groups 4:23
Lecture 12 RDS option groups 2:7
Lecture 13 RDS - Hands on 14:18
Lecture 14 RDS security - Network 3:0
Lecture 15 RDS security - IAM 6:0
Lecture 16 Rotating RDS DB credentials 1:21
Lecture 17 Windows authentication in RDS for SQL Server 3:24
Lecture 18 RDS encryption in transit and at rest 5:26
Lecture 19 RDS backups 4:13
Lecture 20 Copying and sharing RDS snapshots 2:0
Lecture 21 How to encrypt an unencrypted RDS database 1:51
Lecture 22 DB restore options in RDS 4:16
Lecture 23 Exporting RDS DB snapshot to S3 1:35
Lecture 24 RDS backup and restore - Hands on 4:33
Lecture 25 RDS Multi-AZ deployments and read replicas 8:33
Lecture 26 Read replica use cases 1:0
Lecture 27 Promoting a read replica to a standalone DB instance 3:7
Lecture 28 RDS Multi-AZ failover and replica promotion - Demo 13:44
Lecture 29 Enabling writes on a read replica 1:4
Lecture 30 RDS read replica capabilities 1:50
Lecture 31 RDS Second-tier replicas and replica promotion - Demo 6:48
Lecture 32 Cross-region read replicas in RDS 1:20
Lecture 33 RDS replicas with an external database 2:13
Lecture 34 RDS disaster recovery strategies 5:31
Lecture 35 Troubleshooting replica issues in RDS 5:42
Lecture 36 Performance hit on new read replicas 1:49
Lecture 37 Scaling and sharding in RDS 2:50
Lecture 38 RDS monitoring 3:55
Lecture 39 RDS event subscriptions, recommendations and logs 4:53
Lecture 40 Exporting RDS logs to S3 1:41
Lecture 41 RDS Enhanced Monitoring 1:42
Lecture 42 RDS Performance Insights 10:28
Lecture 43 CloudWatch Application Insights 0:41
Lecture 44 RDS on VMware 1:17
Lecture 45 RDS - Good things to know 2:20
Lecture 46 Aurora overview 4:6
Lecture 47 Aurora architecture 8:22
Lecture 48 Aurora Parallel Query 2:31
Lecture 49 Aurora Serverless 5:6
Lecture 50 Data API for Aurora Serverless 1:49
Lecture 51 Aurora multi-master 1:31
Lecture 52 Aurora cross region replicas and Aurora Global database 2:23
Lecture 53 Reliability features in Aurora 3:16
Lecture 54 Aurora pricing model 2:41
Lecture 55 Aurora security - Network, IAM and encryption 2:33
Lecture 56 Parameter groups in Aurora and Aurora Serverless
Lecture 57 Creating an Aurora database - Hands on 8:32
Lecture 58 Creating an Aurora Serverless database - Hands on 5:3
Lecture 59 Using Data API with Aurora Serverless database - Hands on 2:12
Lecture 60 Scaling options in Aurora 4:39
Lecture 61 Aurora monitoring and advanced auditing 3:34
Lecture 62 Monitoring in RDS and Aurora - Demo 3:46
Lecture 63 Exporting Aurora logs 0:48
Lecture 64 Database activity streams in Aurora 0:54
Lecture 65 Troubleshooting storage issues in Aurora 2:35
Lecture 66 Aurora benchmarking 0:47
Lecture 67 Exporting data from Aurora into S3 1:48
Lecture 68 Aurora backups and backtracking 3:32
Lecture 69 Aurora backups vs snapshots vs backtrack 1:38
Lecture 70 Aurora backup, restore, PITR and backtrack - Demo 3:28
Lecture 71 Cloning databases in Aurora 3:29
Lecture 72 Aurora failovers 3:56
Lecture 73 Cluster Cache Management (CCM) in Aurora PostgreSQL 3:5
Lecture 74 Simulating fault tolerance or resiliency in Aurora 5:56
Lecture 75 Simulating failovers in Aurora - Demo 1:30
Lecture 76 Aurora failover priorities in action - Demo 10:20
Lecture 77 Fast failover in Aurora PostgreSQL 5:37
Lecture 78 Cluster replication options for Aurora MySQL 5:19
Lecture 79 Aurora replicas vs RDS MySQL replicas 2:53
Lecture 80 Comparison of RDS deployments 4:33
Lecture 81 How to invoke Lambda functions from Aurora MySQL 2:9
Lecture 82 How to load data from S3 into Aurora MySQL 1:51
Lecture 83 RDS Aurora – Good things to know 2:54

Section 5 : Amazon DynamoDB and DAX

Lecture 84 DynamoDB overview 3:18
Lecture 85 Working with DynamoDB - Hands on 10:55
Lecture 86 DynamoDB basics 6:59
Lecture 87 DynamoDB consistency 4:34
Lecture 88 DynamoDB pricing model
Lecture 89 DynamoDB throughput 4:18
Lecture 90 Calculating capacity units 4:19
Lecture 91 DynamoDB burst capacity and adaptive capacity 6:19
Lecture 92 DynamoDB local secondary index (LSI) 4:28
Lecture 93 DynamoDB global secondary index (GSI) 2:58
Lecture 94 Choosing between LSI and GSI 2:59
Lecture 95 Simple design patterns with DynamoDB 3:42
Lecture 96 Errors and exceptions in DynamoDB 2:59
Lecture 97 DynamoDB partitions 4:31
Lecture 98 DynamoDB partition behavior example 5:30
Lecture 99 Scaling options in DynamoDB 4:8
Lecture 100 DynamoDB scaling and partition behavior 3:46
Lecture 101 DynamoDB best practices 4:6
Lecture 102 DynamoDB best practices (contd 4:28
Lecture 103 Large object patterns and table operations 5:1
Lecture 104 DynamoDB accelerator (DAX) 2:46
Lecture 105 DAX architecture 1:59
Lecture 106 DAX operations 3:37
Lecture 107 Implementing DAX - Hands on
Lecture 108 DynamoDB backup and restore 7:9
Lecture 109 DynamoDb backup and restore - Hands on 3:3
Lecture 110 Continuous backup with PITR 2:9
Lecture 111 Continuous backup with PITR - Hands on 4:8
Lecture 112 DynamoDB encryption 3:37
Lecture 113 DynamoDB streams 3:21
Lecture 114 DynamoDB TTL 2:15
Lecture 115 DynamoDB TTL - Hands on 4:32
Lecture 116 TTL use cases 1:12
Lecture 117 DynamoDB global tables 5:0
Lecture 118 DynamoDB global tables - Hands on
Lecture 119 Fine-grained access control and Web-identity federation in DynamoDB 5:40
Lecture 120 CloudWatch contributor insights for DynamoDB 1:10

Section 6 : Amazon Redshift

Lecture 121 Redshift overview 3:4
Lecture 122 Creating a Redshift cluster - Hands on
Lecture 123 Redshift architecture 2:30
Lecture 124 Loading data into Redshift 3:13
Lecture 125 Loading data from S3 into Redshift - Hands on 6:44
Lecture 126 More ways to load data into Redshift 1:32
Lecture 127 Redshift Spectrum 3:22
Lecture 128 Querying S3 data with Redshift Spectrum - Hands on 7:39
Lecture 129 Redshift federated query 1:0
Lecture 130 Star schema in data warehouses 2:9
Lecture 131 Redshift fundamentals 8:50
Lecture 132 Redshift Workload Management (WLM) 3:17
Lecture 133 Redshift concurrency scaling 1:32
Lecture 134 Redshift scaling 2:13
Lecture 135 Redshift backup, restore and cross-region snapshots 3:19
Lecture 136 Redshift Multi-AZ deployment alternative 1:3
Lecture 137 Redshift availability and durability 2:14
Lecture 138 Redshift security 3:15
Lecture 139 Enhanced VPC routing in Redshift 3:33
Lecture 140 Redshift monitoring 2:44
Lecture 141 Redshift pricing 1:16
Lecture 142 Redshift related services - Athena and Quicksight 2:44
Lecture 143 AQUA for Redshift 1:45

Section 7 : Amazon ElastiCache

Lecture 144 ElastiCache overview 4:40
Lecture 145 Caching strategies 4:48
Lecture 146 Redis architecture and Multi-AZ auto-failover 4:46
Lecture 147 Redis backup and restore 1:41
Lecture 148 Redis scaling and replication 5:55
Lecture 149 Creating a Redis cluster - Hands on 4:45
Lecture 150 Redis global datastore 2:42
Lecture 151 Redis - Good things to know 1:30
Lecture 152 Redis best practices 2:2
Lecture 153 Redis use cases 2:40
Lecture 154 Memcached overview 1:34
Lecture 155 Memcached architecture 1:4
Lecture 156 Memcached auto discovery 1:30
Lecture 157 Memcached scaling 1:41
Lecture 158 Creating a Memcached cluster - Hands on 4:9
Lecture 159 Choosing between Redis and Memcached 2:15
Lecture 160 ElastiCache security 3:59
Lecture 161 ElastiCache logging and monitoring 1:13
Lecture 162 ElastiCache pricing 1:5

Section 8 : Amazon DocumentDB (with MongoDB compatibility)

Lecture 163 DocumentDB overview 1:50
Lecture 164 What and why about document databases 2:22
Lecture 165 DocumentDB architecture 4:25
Lecture 166 DocumentDB backup and restore 2:20
Lecture 167 DocumentDB scaling 1:29
Lecture 168 DocumentDB security 1:52
Lecture 169 DocumentDB pricing 1:10
Lecture 170 DocumentDB monitoring 2:41
Lecture 171 DocumentDB performance management 0:45
Lecture 172 Creating a DocumentDB cluster - Hands on 4:54

Section 9 : Amazon Neptune

Lecture 173 Neptune overview 5:9
Lecture 174 Neptune architecture 3:15
Lecture 175 Creating a Neptune cluster - Hands on 12:44
Lecture 176 Bulk loading graph data into Neptune 1:56
Lecture 177 Bulk loading graph data into Neptune from S3 - Hands on 14:11
Lecture 178 Neptune Workbench 0:58
Lecture 179 Querying Neptune via Jupyter Notebooks - Hands on 4:44
Lecture 180 Neptune replication and high availability 1:48
Lecture 181 Neptune backup and restore 2:22
Lecture 182 Neptune scaling 0:50
Lecture 183 Database cloning in Neptune 1:34
Lecture 184 Neptune security 2:17
Lecture 185 Neptune monitoring 1:29
Lecture 186 Query queuing in Neptune 1:17
Lecture 187 Neptune service errors 1:30
Lecture 188 SPARQL federated query 1:26
Lecture 189 Neptune streams 1:30
Lecture 190 Neptune pricing 1:12

Section 10 : Amazon Elasticsearch Service

Lecture 191 Amazon Elasticsearch Service overview 2:40
Lecture 192 ElasticSearch Service patterns 2:19
Lecture 193 Elasticsearch Service - Multi-AZ 1:27
Lecture 194 Logging options in Elasticsearch Service 0:31
Lecture 195 ElasticSearch Service pricing 1:22
Lecture 196 ElasticSearch Service - Hands on 3:52

Section 11 : Amazon Timestream

Lecture 197 Timestream overview 4:24
Lecture 198 Timestream pricing 1:16

Section 12 : Amazon QLDB

Lecture 199 QLDB overview 2:10
Lecture 200 QLDB architecture 3:16
Lecture 201 QLDB views 1:53
Lecture 202 Working with QLDB 2:2
Lecture 203 Data verification in QLDB 1:55
Lecture 204 Creating a QLDB ledger - Hands on 12:15
Lecture 205 Data verification in QLDB - Hands on 3:17
Lecture 206 QLDB backup and restore (an alternative) 1:7
Lecture 207 QLDB streams 0:51
Lecture 208 QLDB high availability, durability and an alternative to CRR 1:20
Lecture 209 QLDB security 1:25
Lecture 210 QLDB monitoring 0:52
Lecture 211 QLDB pricing 0:43

Section 13 : Amazon Keyspaces (for Apache Cassandra)

Lecture 212 Keyspaces overview 3:15
Lecture 213 Migrating from Cassandra to Keyspaces 1:1
Lecture 214 Read and write consistency in Keyspaces 1:0
Lecture 215 Keyspaces pricing 3:13
Lecture 216 Working with Keyspaces - Hands on 5:28

Section 14 : Comparing AWS Databases

Lecture 217 Comparison of AWS Databases 5:38

Section 15 : Database Migration, DMS and SCT

Lecture 218 Database migration overview 5:27
Lecture 219 DMS sources and targets 2:10
Lecture 220 DMS architecture and overview 3:44
Lecture 221 Migration with DMS in action - Hands on 11:55
Lecture 222 SCT overview 3:18
Lecture 223 Workload Qualification Framework (WQF) 1:16
Lecture 224 DMS tasks and task assessment reports 1:57
Lecture 225 DMS migration types 1:18
Lecture 226 DMS - Good things to know 1:18
Lecture 227 Migrating large tables and LOBs with DMS 5:13
Lecture 228 DW migration with SCT 5:27
Lecture 229 Migration playbooks 3:25
Lecture 230 DMS monitoring 1:46
Lecture 231 DMS validation 1:57
Lecture 232 DMS statistics and control tables 3:18
Lecture 233 DMS security - IAM, encryption and networking 5:18
Lecture 234 DMS pricing 0:28
Lecture 235 DMS general best practices 1:16
Lecture 236 DMS migration architectures to minimize downtime 6:6
Lecture 237 Migrating large databases 1:46
Lecture 238 Migrating to RDS databases 8:25
Lecture 239 Migrating to Aurora 6:1
Lecture 240 Migrating Redis workloads to ElastiCache 4:14
Lecture 241 Migrating to DocumentDB 6:34
Lecture 242 Streaming use cases for DMS 3:45

Section 16 : Monitoring, Logging and Encryption

Lecture 243 Encryption and Snapshots 3:27
Lecture 244 Database Logging 5:26
Lecture 245 Secrets Manager 1:20
Lecture 246 Active Directory with RDS Microsoft SQL Server 2:19

Section 17 : CloudFormation and Automation

Lecture 247 Section Structure Text
Lecture 248 CloudFormation Overview 7:6
Lecture 249 CloudFormation Create Stack Hands On 6:9
Lecture 250 CloudFormation Update and Delete Stack Hands On 7:30
Lecture 251 YAML Crash Course 3:37
Lecture 252 CloudFormation Resources 6:28
Lecture 253 CloudFormation Parameters 5:0
Lecture 254 CloudFormation Mappings 2:53
Lecture 255 mp4 3:8
Lecture 256 CloudFormation Conditions 2:7
Lecture 257 CloudFormation Intrinsic Functions 5:31
Lecture 258 CloudFormation Rollbacks 5:45
Lecture 259 CloudFormation ChangeSets, Nested Stacks & StackSet 3:26
Lecture 260 === CloudFormation Lectures for DB Specialty Exam === Text
Lecture 261 CloudFormation with RDS 6:25
Lecture 262 CloudFormation - RDS DB Updates 8:9
Lecture 263 CloudFormation - RDS Protections 11:18
Lecture 264 CloudFormation - with Aurora 5:40
Lecture 265 CloudFormation - Parameters 4:34
Lecture 266 CloudFormation - SSM Parameter Store 6:8
Lecture 267 CloudFormation - Secrets Manager Part 1 6:17
Lecture 268 CloudFormation - Secrets Manager Part 2 4:10
Lecture 269 CloudFormation - Advanced Concepts and Cleanup 1:1

Section 18 : VPC - Networking

Lecture 270 VPC Section Structure Text
Lecture 271 VPC, Subnets, IGW and NAT 5:24
Lecture 272 NACL, SG, VPC Flow Logs 4:36
Lecture 273 VPC Peering, Endpoints, VPN, DX 5:50
Lecture 274 VPC Cheat Sheet & Closing Comments 2:34
Lecture 275 Extra Bastion Hosts 1:23

Section 19 : Other Topics

Lecture 276 AWS Lambda Architectures 4:13
Lecture 277 Server Migration Service 1:45
Lecture 278 EBS-optimized instances 2:29
Lecture 279 Transferring large amount of data into AWS 1:33
Lecture 280 Disaster Recovery 11:30

Section 20 : Exam preparation

Lecture 281 Exam Guide & Sample Questions 2:19
Lecture 282 Sample question 1 3:59
Lecture 283 Sample question 2 3:46
Lecture 284 Sample question 3 3:26
Lecture 285 Sample question 4 2:21
Lecture 286 Sample question 5 3:17
Lecture 287 Sample question 6 2:27
Lecture 288 Sample question 7 4:21
Lecture 289 Sample question 8 3:37
Lecture 290 Sample question 9 5:19
Lecture 291 Sample question 10 4:16
Lecture 292 Exam Strategy How to tackle exam questions 1:3
Lecture 293 Additional Resources 1:9

Section 21 : Congratulations

Lecture 294 Congratulations & Next Steps 0:58