AWS DynamoDB in the Console - Creating Tables, Items, and Indexes

30 minutes
  • 3 Learning Objectives

About this Hands-on Lab

Welcome to this live AWS environment for learning the fundamentals of using DynamoDB in the AWS console. This lab provides you with essential exposure to database concepts such as partition and sort keys, how to add, delete, and update items, as well as attributes inside of a DynamoDB table. Indexes give access to alternate query patterns and can speed up queries. Secondary keys allow efficient access to data with attributes other than the primary key. You can create one or more secondary indexes on a table. Query or Scan requests can be done against those indexes. In the lab, you will add local and global secondary indexes, and use the local secondary index to query for items in your table.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Create a DynamoDB Table

Use the AWS DynamoDB console to create a DynamoDB table named MusicNotes. Set the provisioned throughput for the new table to 1 Read Capacity Unit (RCU) and Write Capacity Unit (WCU).

  • Log in to the AWS console with the provided credentials
  • Navigate to the DynamoDB portion of the console
  • Create the MusicNotes DynamoDB table with a local secondary index
Add Items to Your Table

After creating your DynamoDB MusicNotes table add some items to it.

  • Create the DynamoDB table (in the previous step)
  • Add items to the table with the Artist and SongTitle attributes as well as adding a few with the Rating attribute
  • Query for the items using the AWS DynamoDB Console
Add a Global Secondary Index to your Table

Using the AWS Console, add a Global Secondary Index to your table.

  • Select your DynamoDB table
  • Open the indexes section of the DynamoDB console
  • Create a global secondary index for your table

Additional Resources

Log in to the live AWS environment using the credentials provided. Make sure you're in the N. Virginia (us-east-1) region throughout the lab.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?