Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.
  • Labs icon Lab
  • A Cloud Guru
Azure icon
Labs

Creating an Azure Storage Table

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.

Azure icon
Labs

Path Info

Level
Clock icon Intermediate
Duration
Clock icon 30m
Published
Clock icon Jun 05, 2020

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Table of Contents

  1. Challenge

    Log in to the Azure Portal

    Log in to the Azure Portal using the provided credentials. Be sure to use an InPrivate or incognito window and use the lab credentials and not your work or personal credentials.

  2. Challenge

    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 Region (location), use the same location as the lab-provided resource group location. This is important.
    6. Leave all other defaults. Click Review + create.
    7. Verify all is well, and click Create.
    8. Once the deployment is complete, click Go to resource.
  3. Challenge

    Create an Azure Storage Table

    1. On the resource overview page, click Table Service on the main page or in the left-hand menu select Tables.
    2. Click +Table.
    3. Provide the Table name actraining, and click OK.
  4. Challenge

    Insert Data into the Table

    1. In the left-hand menu, scroll to the top section and click Storage Browser.
    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
  5. Challenge

    Query for Students

    1. Under the Query Builder header, select Add Filter.
    2. Filter by a PartitionKey of Students.
    3. Execute the query by clicking the Apply button.
    4. Notice it brought back only our student.

The Cloud Content team comprises subject matter experts hyper focused on services offered by the leading cloud vendors (AWS, GCP, and Azure), as well as cloud-related technologies such as Linux and DevOps. The team is thrilled to share their knowledge to help you build modern tech solutions from the ground up, secure and optimize your environments, and so much more!

What's a lab?

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.

Provided environment for hands-on practice

We will provide the credentials and environment necessary for you to practice right within your browser.

Guided walkthrough

Follow along with the author’s guided walkthrough and build something new in your provided environment!

Did you know?

On average, you retain 75% more of your learning if you get time for practice.

Start learning by doing today

View Plans