ERD and Access patterns | Pragmatic Paths

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Amazon DynamoDB Data Modeling for Architects & Developers

Introductions

Your Instructor (1:13)
Getting the most from this course (4:31)

Tools, Local Development Environment

Setup Local DynamoDB and NoSQL Workbench (5:26)
Exercise: NoSQL Workbench walkthrough (6:00)
Exercise: Use CLI, Workbench with Local Table (2:35)
Setup IDE and Git Repository (2:13)

Amazon DynamoDB Fundamentals

DynamoDB : A Logical View (6:15)
Table capacity fundamentals (8:09)
Table capacity modes (8:50)
Exercise: Try out the capacity modes (1:01)
Item Attributes & Data Types (10:31)
Exercise: Create a test model (0:58)
DynamoDB Operations (5:58)
Control Plane Operations (4:42)

CRUD: Create API

Writes : Under the hood (6:13)
API: PutItem, BatchWriteItem, Condition Expressions (7:14)
Exercise: Add Items to Student Table (1:26)

CRUD: Retrieve API

Reads : Under the hood (7:24)
API: GetItem, BatchGetItem, Scan (10:08)
Queries : Under the hood (6:15)
Queries & Key Condition Expression (4:22)

CRUD: Update & Delete API

Update & Delete : Under the hood (3:38)
API: UpdateItem (8:26)
API: DeleteItem (2:28)

CRUD : PartiQL Queries

CRUD : PartiQL Statements & API (8:18)

DynamoDB Secondary Indexes

Indexes : Under the hood (13:06)
Local Secondary Index (LSI) (4:56)
Hands-On: Local Secondary Index (5:10)
Global Secondary Index (GSI) (5:44)
Hands-On: Global Secondary Index (3:05)
Hands-On: Model the game player (4:30)

Single Table Design

Single Table Vs. Multiple Table Design (8:09)
Single table modeling process (3:22)

Case Study : ACME Bank

ACME Bank Transformation Journey (3:19)
ERD and Access patterns (3:42)

Modeling : Entities

How to model an entity? (7:00)
Hands-On: Design the Customer Entity (4:40)

Modeling : Primary Keys

Patterns for primary key (10:57)
Hands-On: Apply best practices for key (3:35)

Modeling : One to Many Relationships

Patterns for one-to-many relationships (7:52)
Analyze : Customer-Account Relationship (5:21)
Hands-On: Embedding with Secondary Index (4:12)

Modeling : Secondary Indexes

Hands-On: Add index for accessing customer on account (3:04)
Hands-On: Model the transaction entity (4:30)
Analysis : Taking advantage of sparse indexes (6:39)
Hands-On: Add a sparse index for Customer-Txns (5:53)
Analysis : Taking advantage of Index Overloading (1:55)
Hands-On: Implement Overloaded GSI for Customer & Transaction (5:15)

Modeling : Many-to-Many Relationship

Adjacency List Pattern (5:51)
Analysis : Customer-Offer Relationship (3:44)
Hands-On: Apply adjacency pattern to customer-offer relationship (4:30)

Modeling : Preventing Hot Partitions

Hot Partitions & Sharding patterns (8:44)
Hands-On : Address hot partition issue (4:51)

Modeling : Efficient Scans

Hands-On: Experimenting with parallel scan (6:36)
Analysis : Scan Vs. GSI for for txns in date range (4:05)

ACID Transactions

What are ACID Transactions? (6:45)
API: TransactWriteItems (4:16)
Hands-On: TransactWriteItems API (6:33)
TransactWriteItems Idempotence (7:21)
API : TransactGetItems (2:43)

Modeling : Transactions

Hands-On : Running counters (4:32)
Hands-On : Credit Transactions (8:31)
Hands-On: Debit Transaction (4:31)

DynamoDB Streams

DynamoDB Streams (10:09)
Shards & Stream Reader Application (8:31)
Hands-On: Experiment with Streams API (0:23)
Hands-On: Tryout API with Python (3:04)

Time to Live (TTL)

Time to Live feature (4:19)
Hands-On: Try out TTL (2:05)

Modeling : DynamoDB Streams

Modeling : Setup daily report (8:52)
Modeling : Archival of Transactions (5:08)

ERD and Access patterns

Complete and Continue

Discussion

0 comments