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
andSongTitle
attributes as well as adding a few with theRating
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