Amazon DynamoDB: Build out NoSQL Databases in the AWS Cloud

Set up your AWS account by creating a password, adding a payment method, verifying your phone number, and selecting the basic support plan, so you’re up and running in minutes.

Compare SQL and NoSQL databases, covering schema needs, typing, normalization versus denormalization, and when to use relational versus non-relational models, including key-value, document, and graph stores.

Explore how DynamoDB, Amazon’s managed NoSQL service, achieves high availability with three facilities per region. Understand its key-value and document data model, replication consistency options, auto scaling, and security features.

Explore three access methods for DynamoDB—the console, the AWS CLI, and language SDKs—and authenticate to create and manage tables.

Duolingo uses DynamoDB to power a 31 billion-item table with 24k read units and 3.3k write units per second, enabling a small team to scale for millions of users.

Explore the DynamoDB pricing model, including the free tier, provisioned capacity with read and write units, data storage costs, reserved capacity, global tables, data transfer, backups, and point-in-time recovery.

Control costs by sizing read and write capacity to match needs, avoid over provisioning, enable billing alarms, and use the AWS cost calculator to estimate DynamoDB usage.

Create a billing alarm in AWS by setting up an AWS budget of $10 and configuring email alerts for actual and forecast costs to help monitor AWS spending.

Log into the AWS console and create your first DynamoDB table, grocery store items, with stock_code as the primary key and one read and one write capacity unit.

Add data to a DynamoDB table in the AWS Console, create items with unique primary keys, and explore attributes, simple and complex types (strings, numbers, lists, maps), and booleans.

Create a DynamoDB table for bookstore with book ID as primary key and two read, one write capacity; populate books with year, country, author maps for two, additions list.

Review assignment 4.1 by examining a DynamoDB bookstore inventory table with two read and one write capacity units, a numeric primary partition key book id, and delete table and code.

Learn to back up DynamoDB using point-in-time recovery and on-demand backups, restore to specific times or from backups, and safely delete tables to manage costs.

Explore identity and access management for DynamoDB by managing users, groups, and permissions; learn the differences between console access and programmatic access using access keys.

Create a programmatic user in IAM, enable programmatic access, attach DynamoDB full access, download the credentials, and use them to interact with DynamoDB.

Set up the command line interface to interact with DynamoDB, install the AWS CLI in a virtual environment, and configure credentials to authenticate and manage tables.

Explore how partition keys and sort keys form compound primary keys in DynamoDB, enabling efficient data partitioning and range-based queries.

Learn to list, describe, and edit DynamoDB tables via the CLI, including creating a compound primary key with hash and range keys, adding items, and deleting tables.

Learn how to create and delete DynamoDB tables using the CLI, define partition and sort keys, set provisioned throughput, and create tables from a file.

Create an IAM user with programmatic access, grant read-only DynamoDB permission, list tables via the CLI with the created access keys, and attempt a delete-table operation to explore outcomes.

Learn to create a read-only IAM user for DynamoDB, attach a read-only policy, test access with list and describe, and apply the principle of least privilege.

Using the Python SDK, you install the library, set up credentials, and interact with DynamoDB from a notebook; inspect and delete tables and explore basic table operations.

Create a household notes table in DynamoDB using a compound key of household email and member name, then add reminder items with put item.

Explore DynamoDB expressions to reference nested items, project specific attributes with projection expressions, and apply conditional expressions for put, update, and delete actions.

Use conditional expressions with DynamoDB update_item to add data to a notes list under a compound key of household email and member, only when the list size is ≤ 3.

Build a cloud-based storage note-taking app with DynamoDB, backing up local notes to the cloud, and managing households and user notes via a command-driven interface.

Master DynamoDB concepts, including NoSQL models, key-value and document storage, partition keys and sort keys, high availability, security with IAM, encryption, and billing alarms.