Automate Table Creation • Insert & Query Data • Master AWS DynamoDB

Amazon DynamoDB is a fully managed NoSQL database service from AWS.
It’s designed for fast performance, auto-scaling, and multi-AZ reliability.
Ideal for apps that require massive read/write throughput and low-latency performance.

In this project, you’ll learn to:

• ✅ Create and configure DynamoDB tables
• ✅ Add and edit data using the AWS Console
• ✅ Query information using PartiQL (SQL for DynamoDB)
• ✅ Understand Local & Global Secondary Indexes

• AWS DynamoDB

• 🏗️ Create DynamoDB tables
• ✍️ Add and edit table rows
• 🔍 Query information using PartiQL
• 🧩 Configure Local & Global Indexes

1. Go to AWS Management Console.
2. Sign in with your AWS credentials.
3. In the search bar, type DynamoDB → Select it.

Provisioned Capacity:

• Read: 10
• Write: 2

✅ Go to Create Table → Enter details → Choose Customize settings → Click Create Table

🎉 You’ve successfully created your first DynamoDB table!

Table name: Thread
Partition key: ForumName (String)
Sort key: Subject (String)

Local Secondary Index (LSI):

Sort Key: CreationDate (String)
Projection: All

Provisioned Capacity:

• Read: 10
• Write: 2

✅ Click Create Table

Table name: Reply
Partition key: ID (String)
Sort key: CreationDate (String)

Global Secondary Indexes (GSI):

1️⃣ GSI #1

Partition key: ID (String)
Sort key: Sticky (String)
Projection: All

2️⃣ GSI #2

Partition key: AuthorId (String)
Sort key: CreationDate (String)
Projection: All

Provisioned Capacity:

• Read: 10
• Write: 5

✅ Click Create Table

⚙️ Now you have DynamoDB tables with LSI and GSI for optimized performance.

1. Go to Explore items → Select Forum.
2. Click Create item.
3. Enter attributes:
   • Name (Partition Key)
   • Description (String)
4. Click Create item and repeat 3–4 times.

Now repeat for Thread Table:

• Required attributes:
  • ForumName (Partition Key)
  • Subject (Sort Key)
  • CreationDate (String)

✅ Add at least 4 entries.

1. Go to Explore items → Select Forum.
2. Click on any item → Update value → Save & Close.

⚠️ Changing partition key recreates the item.

PartiQL = SQL-compatible language for DynamoDB.

1. Go to PartiQL Editor → Select Thread.
2. Click Scan Table → Editor auto-generates:

   SELECT * FROM "Thread"

3. Click Run to execute.

To query specific data:

SELECT * FROM "Thread" WHERE "Subject" = 'Intro to cool stuff'

✅ You’ll see only matching records.

1. Go to Tables → Select Thread.
2. Click Delete → Type confirm → Delete.
3. Refresh the list.

✅ Table deleted successfully.

• ✅ Creating and configuring DynamoDB tables
• ✅ Managing Local & Global Indexes
• ✅ Inserting and editing data
• ✅ Querying data with PartiQL
• ✅ Deleting tables safely

🧑‍💻 Mahesh Shelke
🚀 DevOps & Cloud Practitioner | AWS | CI/CD | Serverless | Python Developer

📫 Connect With Me:

• 🌐 GitHub
• 💼 LinkedIn

“Build • Automate • Scale — with AWS DynamoDB”