[NEW] Ultimate AWS Certified Database Specialty – 2020

Introduction
1 Course Introduction + Exam Breakdown
2 About your instructors
3 Purpose Built Databases

Code & Slides Download
4 Code & Slides Download

Quick refresher on the basics
5 Types of data
6 Relational databases
7 Non-relational databases

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

Amazon DynamoDB and DAX
84 DynamoDB overview
85 Working with DynamoDB – Hands on
86 DynamoDB basics
87 DynamoDB consistency
88 DynamoDB pricing model
89 DynamoDB throughput
90 Calculating capacity units
91 DynamoDB burst capacity and adaptive capacity
92 DynamoDB local secondary index (LSI)
93 DynamoDB global secondary index (GSI)
94 Choosing between LSI and GSI
95 Simple design patterns with DynamoDB
96 Errors and exceptions in DynamoDB
97 DynamoDB partitions
98 DynamoDB partition behavior example
99 Scaling options in DynamoDB
100 DynamoDB scaling and partition behavior
101 DynamoDB best practices
102 DynamoDB best practices (contd.)
103 Large object patterns and table operations
104 DynamoDB accelerator (DAX)
105 DAX architecture
106 DAX operations
107 Implementing DAX – Hands on
108 DynamoDB backup and restore
109 DynamoDb backup and restore – Hands on
110 Continuous backup with PITR
111 Continuous backup with PITR – Hands on
112 DynamoDB encryption
113 DynamoDB streams
114 DynamoDB TTL
115 DynamoDB TTL – Hands on
116 TTL use cases
117 DynamoDB global tables
118 DynamoDB global tables – Hands on
119 Fine-grained access control and Web-identity federation in DynamoDB
120 CloudWatch contributor insights for DynamoDB

Amazon Redshift
121 Redshift overview
122 Creating a Redshift cluster – Hands on
123 Redshift architecture
124 Loading data into Redshift
125 Loading data from S3 into Redshift – Hands on
126 More ways to load data into Redshift
127 Redshift Spectrum
128 Querying S3 data with Redshift Spectrum – Hands on
129 Redshift federated query
130 Star schema in data warehouses
131 Redshift fundamentals
132 Redshift Workload Management (WLM)
133 Redshift concurrency scaling
134 Redshift scaling
135 Redshift backup, restore and cross-region snapshots
136 Redshift Multi-AZ deployment alternative
137 Redshift availability and durability
138 Redshift security
139 Enhanced VPC routing in Redshift
140 Redshift monitoring
141 Redshift pricing
142 Redshift related services – Athena and Quicksight
143 AQUA for Redshift

Amazon ElastiCache
144 ElastiCache overview
145 Caching strategies
146 Redis architecture and Multi-AZ auto-failover
147 Redis backup and restore
148 Redis scaling and replication
149 Creating a Redis cluster – Hands on
150 Redis global datastore
151 Redis – Good things to know
152 Redis best practices
153 Redis use cases
154 Memcached overview
155 Memcached architecture
156 Memcached auto discovery
157 Memcached scaling
158 Creating a Memcached cluster – Hands on
159 Choosing between Redis and Memcached
160 ElastiCache security
161 ElastiCache logging and monitoring
162 ElastiCache pricing

Amazon DocumentDB (with MongoDB compatibility)
163 DocumentDB overview
164 What and why about document databases
165 DocumentDB architecture
166 DocumentDB backup and restore
167 DocumentDB scaling
168 DocumentDB security
169 DocumentDB pricing
170 DocumentDB monitoring
171 DocumentDB performance management
172 Creating a DocumentDB cluster – Hands on

Amazon Neptune
173 Neptune overview
174 Neptune architecture
175 Creating a Neptune cluster – Hands on
176 Bulk loading graph data into Neptune
177 Bulk loading graph data into Neptune from S3 – Hands on
178 Neptune Workbench
179 Querying Neptune via Jupyter Notebooks – Hands on
180 Neptune replication and high availability
181 Neptune backup and restore
182 Neptune scaling
183 Database cloning in Neptune
184 Neptune security
185 Neptune monitoring
186 Query queuing in Neptune
187 Neptune service errors
188 SPARQL federated query
189 Neptune streams
190 Neptune pricing

Amazon Elasticsearch Service
191 Amazon Elasticsearch Service overview
192 ElasticSearch Service patterns
193 Elasticsearch Service – Multi-AZ
194 Logging options in Elasticsearch Service
195 ElasticSearch Service pricing
196 ElasticSearch Service – Hands on

Amazon Timestream
197 Timestream overview
198 Timestream pricing

Amazon QLDB
199 QLDB overview
200 QLDB architecture
201 QLDB views
202 Working with QLDB
203 Data verification in QLDB
204 Creating a QLDB ledger – Hands on
205 Data verification in QLDB – Hands on
206 QLDB backup and restore (an alternative)
207 QLDB streams
208 QLDB high availability, durability and an alternative to CRR
209 QLDB security
210 QLDB monitoring
211 QLDB pricing

Amazon Keyspaces (for Apache Cassandra)
212 Keyspaces overview
213 Migrating from Cassandra to Keyspaces
214 Read and write consistency in Keyspaces
215 Keyspaces pricing
216 Working with Keyspaces – Hands on

Comparing AWS Databases
217 Comparison of AWS Databases

Database Migration, DMS and SCT
218 Database migration overview
219 DMS sources and targets
220 DMS architecture and overview
221 Migration with DMS in action – Hands on
222 SCT overview
223 Workload Qualification Framework (WQF)
224 DMS tasks and task assessment reports
225 DMS migration types
226 DMS – Good things to know
227 Migrating large tables and LOBs with DMS
228 DW migration with SCT
229 Migration playbooks
230 DMS monitoring
231 DMS validation
232 DMS statistics and control tables
233 DMS security – IAM, encryption and networking
234 DMS pricing
235 DMS general best practices
236 DMS migration architectures to minimize downtime
237 Migrating large databases
238 Migrating to RDS databases
239 Migrating to Aurora
240 Migrating Redis workloads to ElastiCache
241 Migrating to DocumentDB
242 Streaming use cases for DMS

Monitoring, Logging and Encryption
243 Encryption and Snapshots
244 Database Logging
245 Secrets Manager
246 Active Directory with RDS Microsoft SQL Server

CloudFormation and Automation
247 Section Structure
248 CloudFormation Overview
249 CloudFormation Create Stack Hands On
250 CloudFormation Update and Delete Stack Hands On
251 YAML Crash Course
252 CloudFormation Resources
253 CloudFormation Parameters
254 CloudFormation Mappings
255 CloudFormation Outputs
256 CloudFormation Conditions
257 CloudFormation Intrinsic Functions
258 CloudFormation Rollbacks
259 CloudFormation ChangeSets, Nested Stacks & StackSet
260 === CloudFormation Lectures for DB Specialty Exam ===
261 CloudFormation with RDS
262 CloudFormation – RDS DB Updates
263 CloudFormation – RDS Protections
264 CloudFormation – with Aurora
265 CloudFormation – Parameters
266 CloudFormation – SSM Parameter Store
267 CloudFormation – Secrets Manager Part 1
268 CloudFormation – Secrets Manager Part 2
269 CloudFormation – Advanced Concepts and Cleanup

VPC – Networking
270 VPC Section Structure
271 VPC, Subnets, IGW and NAT
272 NACL, SG, VPC Flow Logs
273 VPC Peering, Endpoints, VPN, DX
274 VPC Cheat Sheet & Closing Comments
275 Extra Bastion Hosts

Other Topics
276 AWS Lambda Architectures
277 Server Migration Service
278 EBS-optimized instances
279 Transferring large amount of data into AWS
280 Disaster Recovery

Exam preparation
281 Exam Guide & Sample Questions
282 Sample question 1
283 Sample question 2
284 Sample question 3
285 Sample question 4
286 Sample question 5
287 Sample question 6
288 Sample question 7
289 Sample question 8
290 Sample question 9
291 Sample question 10
292 Exam Strategy How to tackle exam questions
293 Additional Resources

Congratulations
294 Congratulations & Next Steps
295 Bonus Lecture Special discounts for our other courses