AWS DynamoDB – Complete Guide (incl Schema Designing)

Course Curriculum

Chapter 1: Difference of SQL and NoSQL Databases

Lecture 1: This Is How This Course Is Structured…

Lecture 2: Difference of SQL and NoSQL Databases

Chapter 2: Basic concepts of DynamoDB

Lecture 1: Basic concepts of DynamoDB

Chapter 3: Accessing DynamoDB(CLI, Web console and NoSQL Workbench)

Lecture 1: Using the DynamoDB web console

Lecture 2: Why you should use Workbench tool and, how?

Lecture 3: Using the AWS CLI V2

Chapter 4: Things you should know before start modeling DynamoDB schemas

Lecture 1: The most common anti-patterns

Lecture 2: DynamoDB OnDemand and ProvisionedCapacity

Lecture 3: Availability, Durability and Consistency Model

Lecture 4: Read Request Units and Write Request Units

Lecture 5: DynamoDB Pricing and Free tier

Lecture 6: Pricing example

Chapter 5: Model an Order processing app using AWS NoSQL Workbench

Lecture 1: Key schema design

Lecture 2: Design the DB schema using NoSQL Workbench tool

Lecture 3: Implementing the main access patterns

Lecture 4: Code auto generation with Workbench tool

Lecture 5: Gift – Fetching the last 14 days orders

Chapter 6: Build a social media Gaming App

Lecture 1: Understanding the data model

Lecture 2: Cloud9 environment setup

Lecture 3: Fetch games and players

Lecture 4: Find open games by map

Lecture 5: Transactional writes – practical usage

Lecture 6: Conditional write – practical usage

Lecture 7: Two important GSI access patterns

Lecture 8: Cleaning and wrapping up

Chapter 7: Build a photo sharing app

Lecture 1: Planning the main data model and access patterns

Lecture 2: Key schema design and background setup

Lecture 3: Creating table and bulk load items

Lecture 4: Fetch user and photos

Lecture 5: Fetch photo and its reactions (using GSI table)

Lecture 6: Partial normalization

Lecture 7: Transactional writes – follow a user

Lecture 8: Transactional writes – add a reaction to photo

Chapter 8: Useful DynamoDB design patterns.

Lecture 1: How to use sort keys for data organization and retrieval

Lecture 2: Two more sort key patterns.

Chapter 9: Implement proper pagination using DynamoDB

Lecture 1: How the pagination works in DynamoDB

Lecture 2: implementing pagination using lambda

Lecture 3: Fixing CORS issues guide

Lecture 4: Exclusive – Go backward and forward using pagination from the UI

Chapter 10: Leaderboard – implement using DDB streams

Lecture 1: Leaderboard – Find the highest scores for each game

Lecture 2: Find the highest scores across all games

Lecture 3: Write sharding to improve performance on leaderboard

Chapter 11: Using CloudFormation templates

Lecture 1: Create table using Cloudformation

Lecture 2: Cloudformation with auto scaling

Chapter 12: DynamoDB Streams and Triggers

Lecture 1: DDB Streams and Triggers Introduction

Lecture 2: Simple application using Triggers and Streams

Chapter 13: Advanced DynamoDB

Lecture 1: DAX -DynamoDB Accelerator

Lecture 2: TTL – Time to Live

Lecture 3: Global Tables

Chapter 14: Backups, Restore and Point In Time Recovery

Lecture 1: On Demand Backups and Restore

Lecture 2: Point In Time Recovery (PITR – Continuous backups)

Chapter 15: Security Best Practices for DynamoDB

Lecture 1: Introduction to Security Best Practices

Lecture 2: Monitoring and Controlling access to your data

Lecture 3: Limiting network access and Encryption KMS