Skip to main content

Creating an Azure Storage Table

Hands-On Lab

 

Photo of Landon Fowler

Landon Fowler

Database Training Architect II

Length

00:30:00

Difficulty

Intermediate

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.

What are Hands-On Labs?

Hands-On Labs are scenario-based learning environments where learners can practice without consequences. Don't compromise a system or waste money on expensive downloads. Practice real-world skills without the real-world risk, no assembly required.

Creating an Azure Storage Table

Introduction

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.

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. Set the following values:
    • Resource group: Select the one listed
    • Storage account name: Create a globally unique name
    • Location: (US) West US
  4. Click Review + create.
  5. Verify all is well, and click Create.
  6. Once the deployment is complete (it should just take a couple minutes), click Go to resource.

Create an Azure Storage Table

  1. Click the Tables card (or click Tables in the left-hand menu).
  2. Click + Table.
  3. Give it the name "actraining".
  4. Click OK.

Insert Data into the Table

  1. Click Storage Explorer in the left-hand menu.
  2. Expand TABLES.
  3. Click actraining.
  4. Click Add.
  5. Enter the following values:
    • PartitionKey: Staff
    • RowKey: 7777
  6. Click Add Property, and enter the following values:
    • Property Name: FullName
    • Value: Landon Fowler
  7. Click Add Property, and enter the following values:
    • Property Name: FieldOfStudy
    • Value: Databases
  8. Click Insert.
  9. Click Add.
  10. Enter the following values:
    • PartitionKey: Students
    • RowKey: 8888
    • FullName: Jesse Hoch
    • FieldOfStudy: Linux
  11. Click Insert.

Query for Students

  1. Click Query.
  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 brings back only our student.

Conclusion

Congratulations on successfully completing this hands-on lab!