Creating an Azure Storage Table

30 minutes
  • 5 Learning Objectives

About this Hands-on Lab

As modern, cloud-based apps have evolved, they’ve required data storage to adapt with them. Often the exact schema needed is not known up front and will probably change over time. Services such as Azure Table Storage have risen to the challenge to meet this need, providing structured NoSQL data storage that is flexible, scalable, and globally distributed. In this hands-on lab scenario, you are the DBA for Awesome Company. A new mobile app is being developed that will require key/attribute storage in the cloud. The needed table will be storing information about the company’s training division and should be partitioned by membership in the Staff or Student groups, be keyed by the individual’s numeric ID, and contain their full names and area of study. Performing the actions of this lab will help you become familiar with how to create, insert into, and select from an Azure Storage Table.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Log in to the Azure Portal

Log in to the Azure Portal using the provided credentials.

Create a Storage Account
  1. Click the three-line menu icon in the top left corner of the page, and click Storage accounts.
  2. Click Add.
  3. Select the resource group the lab created for you.
  4. Provide a storage account name (must be globally unique).
  5. For Location, select the same location as your lab provided resource group.
  6. Click Review + create.
  7. Verify all is well, and click Create.
  8. Once the deployment is complete, click Go to resource.
Create an Azure Storage Table
  1. On the resource overview page, click Tables either on the main page or in the left-hand menu under Table Service.
  2. Click +Table.
  3. Provide the Table name actraining, and click OK.
Insert Data into the Table

Note: The Storage Explorer page may not display correctly unless you enable all cookies for the site in your browser settings.

  1. In the left-hand menu, scroll to the top section and click Storage Explorer.
  2. Expand TABLES, and click on actraining.
  3. Click +Add to add an entity.
  4. Enter the following values:
    • PartitionKey: Staff
    • RowKey: 7777
  5. Click Add Property, and enter the following values:
    • Property Name: FullName
    • Value: Landon Fowler
  6. Click Add Property, and enter the following values:
    • Property Name: FieldOfStudy
    • Value: Databases
  7. Click Insert.
  8. Repeat the steps above, but with the following values:
    • PartitionKey: Students
    • RowKey: 8888
    • FullName: Jesse Hoch
    • FieldOfStudy: Linux
Query for Students
  1. Click the Query button.
  2. Filter by a PartitionKey of Students.
  3. Remove the second filter criteria using the red X.
  4. Execute the query by clicking the green triangle.
  5. Notice it brought back only our student.

Additional Resources

In this hands-on lab scenario, you are the DBA for Awesome Company. A new mobile app is being developed that will require key/attribute storage in the cloud. The needed table will be storing information about the company's training division and should be partitioned by membership in the Staff or Student groups, be keyed by the individual's numeric ID, and contain their full names and area of study. Performing the actions of this lab will help you become familiar with how to create, insert into, and select from an Azure Storage Table.

Note: For the Storage account location, use the same location as the lab provided resource group. Also, the Storage Explorer page may not display correctly unless you enable all cookies for the site in your browser settings.

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?