Learn DynamoDB

Learn DynamoDB

Learn DynamoDB the right way — a structured curriculum from the fundamentals through data modeling, indexes, expressions, PartiQL, tooling, and internals.

DynamoDB fundamentals, from when to use it to data types, DynamoDB JSON, item size and limits, item actions, composite keys, collections and consistency.

0 of 10 readQuiz
When to Use DynamoDB (and When Not To)
When to use DynamoDB and when not to. The access-pattern, scale and cost signals that favor it over a relational database, and what to pair it with otherwise.
Beginner10 min read
DynamoDB Data Types: Every Type, with Examples
DynamoDB's ten data types: scalars (S, N, B, BOOL, NULL), documents (M, L) and sets (SS, NS, BS), how they look in DynamoDB JSON, and which can be a key.
Beginner7 min read
DynamoDB JSON & Marshalling
DynamoDB JSON and marshalling. Why every value is wrapped in a type tag, how it differs from plain JSON, and how to convert between the two in code.
Beginner7 min read
The DynamoDB Item Size Limit (400 KB)
The DynamoDB 400 KB item size limit, what counts toward it, what a big item costs, and how to split, compress or offload an item that keeps growing.
Beginner7 min read
DynamoDB Limits and Quotas, Verified on the Live Service
The DynamoDB limits and quotas that shape designs, which ones you can raise, the way around each, and the live service's verbatim error for the probed ones.
Intermediate13 min read
DynamoDB Item-Based Actions
DynamoDB item-based actions: GetItem, PutItem, UpdateItem and DeleteItem each address one item by its full primary key, and differ from Query and Scan.
Beginner7 min read
DynamoDB Composite Primary Key: Partition + Sort Key
A DynamoDB composite primary key is a partition key plus a sort key. The pair must be unique, and the sort key lets one Query read a sorted range.
Beginner9 min read
DynamoDB Item Collections
What a DynamoDB item collection is (every item sharing a partition key), why it's the unit of one Query, and the 10 GB limit an LSI adds.
Beginner8 min read
DynamoDB Strongly vs Eventually Consistent Reads
DynamoDB strongly consistent vs eventually consistent reads: what each guarantees, the 2× read cost of ConsistentRead, and why a GSI is eventual-only.
Intermediate7 min read
Knowledge checkTake the quiz
Check what you’ve learned in this section.

DynamoDB data modeling — modeling from access patterns, single-table design, the type attribute, denormalization, and when one table is the wrong call.

0 of 7 readQuiz

Modeling relationships in DynamoDB without joins. One-to-many, the adjacency list pattern, many-to-many, composite sort keys, and reference counts.

0 of 6 readQuiz

Querying and sorting DynamoDB — Query vs Scan, pagination, filter expressions, why Scan is slow, parallel scans, and sort-key strategies including zero-padding.

0 of 10 readQuiz
DynamoDB Query vs Scan: Which to Use, and Why
Query vs Scan in DynamoDB. Query reads one item collection and bills what its key condition selects; Scan bills the whole table before any filter runs.
Beginner9 min read
DynamoDB Pagination: LastEvaluatedKey Explained
How DynamoDB pagination works: loop on LastEvaluatedKey and ExclusiveStartKey, why Limit is not a page size, and how to expose a safe stateless cursor.
Beginner9 min read
DynamoDB Filtering Strategies
DynamoDB filtering strategies compared (partition key, sort key, sparse indexes, FilterExpression) and which one actually cuts your read bill.
Intermediate9 min read
Why a DynamoDB Scan Is Slow and Expensive
Why a DynamoDB Scan is slow and expensive, what it actually bills you for, and how to turn a reflexive Scan into a keyed Query that costs a fraction.
Beginner6 min read
DynamoDB Parallel Scans
How DynamoDB parallel scans split a full-table read across workers with Segment and TotalSegments, when they help, and when Export to S3 is the better job.
Advanced8 min read
DynamoDB Sort Key Strategies: 3 Patterns, When to Use Each
DynamoDB sort key strategies for range reads. Design a sort key whose byte order matches your read order, so one Query serves many access patterns.
Intermediate6 min read
How to Query DynamoDB in Descending Order
Query DynamoDB in descending order with ScanIndexForward=false or PartiQL ORDER BY DESC. Newest-first results, why order follows the sort key, the cost.
Beginner6 min read
Sorting DynamoDB on a Changing Attribute
Sorting DynamoDB on a changing attribute. Why a key attribute is immutable, the delete-and-put pattern, re-keying, and moving the value to a GSI sort key.
Intermediate8 min read
Zero-Padding Sort Keys in DynamoDB
Why "10" sorts before "2" in a DynamoDB string sort key, and how fixed-width zero-padding makes lexicographic byte order match numeric order.
Intermediate5 min read
Knowledge checkTake the quiz
Check what you’ve learned in this section.

What a global secondary index costs in DynamoDB: GSI write amplification at list price, a GSI vs LSI vs filter decision table, and the limits that bind.

0 of 8 readQuiz

DynamoDB expressions: expression attribute names and values and when you must use them, then condition, update, key condition, and projection expressions.

0 of 6 readQuiz

DynamoDB writes and operations. Batch writes and deletes, ReturnValues, atomic counters, uniqueness across attributes, zero-downtime migrations and hot partitions.

0 of 8 readQuiz
DynamoDB Batch Operations
DynamoDB batch operations. BatchGetItem reads 100 items per call, BatchWriteItem writes 25, a batch is not a transaction, and how to retry leftovers.
Intermediate8 min read
How to Delete Multiple Items in DynamoDB
How to delete multiple items in DynamoDB with BatchWriteItem, TransactWriteItems, PartiQL batches and TTL, and why there is no DELETE ... WHERE statement.
Beginner9 min read
DynamoDB ReturnValues: Get the Old or New Item
DynamoDB ReturnValues hands back the old or new item from PutItem, UpdateItem or DeleteItem without a second read. The five options and when each helps.
Intermediate5 min read
DynamoDB Atomic Counters: How ADD Works, and When It Doesn't
How DynamoDB atomic counters work with an ADD update expression, why they aren't idempotent, and how to make an increment safe to retry.
Intermediate7 min read
DynamoDB Uniqueness on Multiple Attributes
How to enforce a unique constraint on multiple DynamoDB attributes, unique email AND username, with marker items and a condition-guarded TransactWriteItems.
Advanced6 min read
DynamoDB Migrations Without Downtime
DynamoDB migrations without downtime. Add a new entity type and access pattern to a live table with an online GSI, a guarded backfill and dual-writes.
Advanced6 min read
DynamoDB Hot Partitions: How to Find and Fix Them
A DynamoDB hot partition is one partition key taking more traffic than one partition serves. Find the key with Contributor Insights and shard it out.
Intermediate11 min read
Knowledge checkTake the quiz
Check what you’ve learned in this section.

PartiQL and SQL on DynamoDB: what PartiQL is, what it cannot do, the native ways around it, and how DynoTable's Workbench runs JOIN, GROUP BY and aggregates.

0 of 7 readQuiz

DynamoDB tooling: DynamoDB Local, LocalStack, the best GUI clients, viewing and editing data, copying tables, CSV export and MCP servers.

0 of 13 read
How to Run DynamoDB Local with Docker
Run DynamoDB Local with Docker for offline development and tests: start the container, point the SDK at the local endpoint, and create a table.
Beginner7 min read
How to Connect to DynamoDB Local and LocalStack
How to connect a GUI to DynamoDB Local and LocalStack: endpoint, fake creds, common errors. Browse and query local tables visually with DynoTable.
Intermediate8 min read
DynamoDB Books Worth Reading in 2026
The two DynamoDB books worth your money in 2026, what each one costs, and exactly which DynamoDB features each was published too early to cover.
Beginner6 min read
How to View, Browse and Edit DynamoDB Data
How to browse, filter and edit DynamoDB data, and which API operation each action runs: Scan, Query, GetItem, PutItem, UpdateItem, DeleteItem.
Beginner7 min read
Copy a DynamoDB Table to Another Account/Region
Copy a DynamoDB table to another account or region: export the data, then load it with scan plus write, S3 export/import, AWS Backup, or global tables.
Beginner12 min read
How to Export a DynamoDB Table to CSV (4 Ways)
How to export a DynamoDB table to CSV: a filtered export in DynoTable, an AWS CLI scan with jq, the managed S3 export plus Athena, or a script.
Beginner14 min read
Generate TypeScript Types from DynamoDB
DynamoDB stores no item schema, so DescribeTable cannot give you types. Hand-write an interface, use a schema-first library, or infer from real items.
Intermediate8 min read
How to Query DynamoDB with AI (Natural Language)
How to query DynamoDB in plain language. The API has no natural-language endpoint, so compare LLM-drafted PartiQL, MCP agents and schema-aware tools.
Beginner6 min read
DynamoDB MCP server: Claude Code, Cursor, Codex
Give an AI agent live access to DynamoDB over MCP. Compare the AWS, community and DynoTable servers, run any of them read-only, and keep reads cheap.
Intermediate12 min read
DynamoDB MCP for Claude Code
Connect Claude Code to DynamoDB over MCP. The exact claude mcp add command, which scope to use, the login step, and how to keep AWS keys out of the agent.
Intermediate9 min read
DynamoDB MCP for Cursor
Connect Cursor to DynamoDB over MCP. The mcp.json config, project vs global file, enabling and approving the server, and how to keep AWS keys out of your repo.
Intermediate7 min read
DynamoDB MCP for Codex
Connect OpenAI Codex to DynamoDB over MCP. The ~/.codex/config.toml entry, the mcp_servers snake_case trap, transport choice, login and timeouts.
Intermediate6 min read
ExtendDB: Run the DynamoDB API on Your Database
ExtendDB is an open-source AWS adapter that serves the DynamoDB API from a database you run, such as PostgreSQL. Your AWS SDKs work unchanged.
Intermediate7 min read

DynamoDB operations and cost: transactions, Streams, TTL, on-demand vs provisioned capacity, global tables and backup/PITR, taught on one running SaaS.

0 of 12 readQuiz
DynamoDB Cost Model: Why SQL Can Hide the Bill
Why SQL over DynamoDB can hide the bill: how joins, arbitrary WHERE filters and aggregates compile to Scans, and what one full Scan costs.
Intermediate4 min read
DynamoDB Transactions: All-or-Nothing Writes Across Items
DynamoDB transactions with TransactWriteItems — up to 100 all-or-nothing actions, a 4 MB limit, double write capacity, and how conflicts cancel.
Advanced9 min read
DynamoDB Streams: React to Every Item Change
DynamoDB Streams: the 24-hour change log, StreamViewType, per-item ordering, Lambda triggers, and the Kinesis path to keep changes longer or archive them in S3.
Advanced9 min read
DynamoDB TTL: How Expiring Items Get Deleted
DynamoDB TTL auto-deletes items once a Unix-epoch timestamp attribute passes, typically within a few days, and those deletes cost no write capacity.
Intermediate6 min read
DynamoDB On-Demand vs Provisioned Capacity
DynamoDB On-Demand vs Provisioned capacity: pay-per-request against provisioned throughput, the ~29% utilization break-even, and a worked monthly bill.
Intermediate8 min read
DynamoDB On-Demand Throughput: Measured
DynamoDB on-demand throughput, measured live: a fresh table's 4,000 writes/s ceiling, 12,762 reads/s with no throttle, and how the ceiling grew under load.
Intermediate5 min read
How to Set Up DynamoDB Auto Scaling
Set up DynamoDB auto scaling on provisioned capacity: console and CLI steps, picking target utilization and min/max, and the limits that still throttle.
Intermediate9 min read
DynamoDB Throttling and How to Fix It
Why DynamoDB throttles: the four documented causes, the 3,000 read and 1,000 write units per partition limit, the on-demand ramp, and the fix for each.
Intermediate10 min read
DynamoDB Table Size and Item Count
Get a DynamoDB table size and item count from the free DescribeTable estimate, which lags up to six hours, or an exact count with Scan Select COUNT.
Beginner5 min read
DynamoDB Global Tables: Multi-Region Replication Explained
DynamoDB Global Tables: multi-Region active-active replication, last-writer-wins conflicts, the MREC and MRSC consistency modes, RPO, and the 99.999% SLA.
Advanced7 min read
DynamoDB Backup and Point-in-Time Recovery Guide
DynamoDB backup and point-in-time recovery: on-demand snapshots vs continuous PITR, the 1-to-35-day window, the restore commands, and what to re-apply after.
Intermediate8 min read
Knowledge checkTake the quiz
Check what you’ve learned in this section.

DynamoDB internals. How partition keys, physical partitions, adaptive capacity, storage, request routing and GSIs work, and how they differ from the Dynamo paper.

0 of 8 readQuiz
How DynamoDB Partition Keys Work
How DynamoDB partition keys work. The hash that maps a key to a physical partition, why your key choice decides throughput, and how to avoid hot partitions.
Intermediate8 min read
DynamoDB physical partitions
DynamoDB physical partitions: the 10 GB, 3,000 read and 1,000 write unit ceilings, how partitions split, and why a hot key throttles with capacity to spare.
Advanced8 min read
DynamoDB Adaptive Capacity: What It Does and What It Cannot
DynamoDB burst and adaptive capacity, how they absorb spikes and boost a hot partition automatically, and the per-item ceiling neither of them can raise.
Advanced6 min read
How DynamoDB storage internals work
How DynamoDB stores data. Partition-key hashing, the B-tree that keeps a partition's items in key order, and leader-based quorum replication across three AZs.
Advanced8 min read
How DynamoDB Request Routing Works
How DynamoDB request routing works: a router fleet authenticates each request, hashes the key and sends it to a replica of the owning partition.
Advanced7 min read
How a DynamoDB GSI Is Stored Internally
How a DynamoDB GSI is stored. Its own partitions, asynchronous updates from the base table, projected attributes only, and capacity separate from the table.
Advanced9 min read
From the Dynamo Paper to DynamoDB
The 2007 Dynamo paper versus DynamoDB. What the ring, sloppy quorums and vector clocks did, and what the 2022 DynamoDB paper says replaced them.
Advanced7 min read
Knowledge checkTake the quiz
Check what you’ve learned in this section.

More DynamoDB resources

Ready to put this into practice?

Browse, query, and model your own DynamoDB tables — DynoTable’s SQL Workbench and AI agent run on your AWS. Free 30-day trial, no credit card — then the Free plan with no time limit.