Azure Cosmos DB: Table API

Course details

Azure supports many flavors of NoSQL databases, including the popular key-value table approach. This is the simplest type of NoSQL database—each entry is identified by a unique key, yet the data format is flexible, and the data store is extremely scalable. There are two ways to provision NoSQL table-based data in Azure: Azure Table Storage and Cosmos DB Table API. There are advantages to both, and in this course instructor Walt Ritscher describes the differences between the two service models, so you can choose the best model for your data. Most of this course looks at the Cosmos DB option, and Walt shows you how to provision a Cosmos DB database and edit data in the tables, how to access the data with the REST API and the .NET SDKs, and how to query and manipulate the data. Finally, he looks at how to scale out the database to other Azure regions.

Concepts

0. Introduction

01 - NoSQL table data in Cosmos DB
02 - What you should know
03 - Programming setup and configuration
04 - How to access the sample code on GitHub

1. Getting Started

05 - Cosmo DB API types
06 - Table storage basics
07 - Table storage versus Cosmos DB Table API
08 - SQL API vs. Table API
09 - Resource model
10 - Partitioning data

2. Create Tables in Azure Portal

11 - Create database account
12 - Examine the database account
13 - Create a table in the Azure portal
14 - Examine the sample data
15 - Add data to table in Azure Data Explorer
16 - Query data in Azure Data Explorer

3. Data Operations and Queries

17 - Choose an SDK
18 - Open the sample project
19 - Configure DB connection info with .json files
20 - Load configuration data
21 - Connect to the database
22 - Work with Tables
23 - Get table rows with TableClient
24 - Get table rows with typed entity class
25 - Update, insert, and delete rows
26 - Work with single row
27 - Query data with LINQ expression
28 - Batch operations

4. Migrate from Table Storage

29 - Install Table Explorer and the Data Transfer tools
30 - The legacy project
31 - Migrate data
32 - Guidance on API differences
33 - Change the connection string
34 - Change the code

Conclusion

35 - Next steps

Azure Cosmos DB: Table API

Authors

Walt Ritscher