AWS DynamoDB Schema Design | How to choose the right key

AWS DynamoDB Tutorial. DynamoDB is a powerful fully managed NoSQL database. Part of the complexity in using the service is related to choosing a partition key that not only serves your access patterns, but prevents you from having scaling related headaches in the future. In this video, I talk about the factors you should consider when choosing a partition key. I start out by briefly talking about why choosing the right key is important, followed by defining partition and sort keys. Afterwards we go into key partitioning behavior and a feature called adaptive capacity. Finally, I conclude with some general guidance on when you should choose one key structure over another.

Looking to get hands on experience building on AWS with a REAL project? Check out my course - The AWS Learning Accelerator! https://courses.beabetterdev.com/cour...

00:25 Why picking the right key is important
01:10 Primary Key, Partition Key, Sort Key
09:24 When to use what key

🎉SUPPORT BE A BETTER DEV🎉
Become a Patron:   / beabetterdev  

📚 MY RECOMMENDED READING LIST FOR SOFTWARE DEVELOPERS📚
Clean Code - https://amzn.to/37T7xdP
Clean Architecture - https://amzn.to/3sCEGCe
Head First Design Patterns - https://amzn.to/37WXAMy
Domain Driver Design - https://amzn.to/3aWSW2W
Code Complete - https://amzn.to/3ksQDrB
The Pragmatic Programmer - https://amzn.to/3uH4kaQ
Algorithms - https://amzn.to/3syvyP5
Working Effectively with Legacy Code - https://amzn.to/3kvMza7
Refactoring - https://amzn.to/3r6FQ8U

🎙 MY RECORDING EQUIPMENT 🎙
Shure SM58 Microphone - https://amzn.to/3r5Hrf9
Behringer UM2 Audio Interface - https://amzn.to/2MuEllM
XLR Cable - https://amzn.to/3uGyZFx
Acoustic Sound Absorbing Foam Panels - https://amzn.to/3ktIrY6
Desk Microphone Mount - https://amzn.to/3qXMVIO
Logitech C920s Webcam - https://amzn.to/303zGu9
Fujilm XS10 Camera - https://amzn.to/3uGa30E
Fujifilm XF 35mm F2 Lens - https://amzn.to/3rentPe
Neewer 2 Piece Studio Lights - https://amzn.to/3uyoa8p

💻 MY DESKTOP EQUIPMENT 💻
Dell 34 inch Ultrawide Monitor - https://amzn.to/2NJwph6
Autonomous ErgoChair 2 - https://bit.ly/2YzomEm
Autonomous SmartDesk 2 Standing Desk - https://bit.ly/2YzomEm
MX Master 3 Productivity Mouse - https://amzn.to/3aYwKVZ
Das Keyboard Prime 13 MX Brown Mechanical- https://amzn.to/3uH6VBF
Veikk A15 Drawing Tablet - https://amzn.to/3uBRWsN

📚 References:
Getting started with AWS:    • Introduction to AWS | A Complete Beginner ...  

DynamoDB Global Secondary Indexes -    • What is a DynamoDB GSI (Global Secondary I...  
DynamoDB Local Secondary Indexes -    • What is a DynamoDB LSI (Local Secondary In...  
DynamoDB Accelerator (DAX) -    • Improve DynamoDB Performance with DAX  
SQL vs NoSQL explained -    • SQL vs NoSQL Explained  
Choosing the right key - https://aws.amazon.com/blogs/database...
Understanding Adaptive Capacity - https://docs.aws.amazon.com/amazondyn...

☁Topics covered include:
Primary Key
Partition Key
Sort Key
Range Key
Partitions,
Partition Splitting
Read Capacity Units (RCU)
Write Capacity Units (WCU)
Throttling
Adaptive Capacity
Burst Capacity

🌎 Find me here:
Twitter -   / beabetterdevv  
Instagram -   / beabetterdevv  
Patreon - Donations help fund additional content -   / beabetterdev  

#DynamoDB
#PartitionKey
#SortKey