Table Storage

Official Documentation

Service Description

Microsoft Azure Table Storage is another NoSQL database in the Microsoft Azure platform. Despite what the name suggests, it is not a table-based relational database system but instead a memory for storing large semi-structured data sets in the cloud that require only a primary key for access and do not require complex relational database operations. From a single key (consisting of two mandatory attributes: partition key and row key), it is possible to read entities that consist of freely definable, typed properties (a property consists of a name, a type (e.g., string, integer), and a value).

Using the primary key values, Microsoft Azure can consolidate entries into partitions and distribute these automatically to various storage media to optimize performance. The data is automatically stored in triplicate, in a high-availability way, and can be accessed via RESTful interfaces. Alternative means of access include .NET, Java, and PHP class libraries. Although Table Storage has less functionality than SQL Database in terms of data management and complex access operations, it does provide affordable storage of semi-structured data and enables efficient, high-performance access to this data. Data sets of up to 500 terabytes per storage account are supported.

Getting Started

  1. Azure Storage Performance, Scalability and Security
    4/29/2015, Video, 0:56:44
  2. Azure205x - Microsoft Azure Storage
    5/30/2017, Mva
  3. Blobs and Tables: New Azure-Consistent Storage for your Datacenter
    5/19/2015, Video, 1:20:35
  4. Microsoft Azure Storage Explorer
    6/20/2016, Tool



Latest Content

Subscribe to News about Table Storage

Title  
Video
Video
Video
Video
Blog
Video
Blog
Blog
Video
Video
Blog
Blog
more...


Azure Documentation

1. Cosmos DB Documentation
2. Overview
     2.1. About Azure Cosmos DB
     2.2. 20 days of tips
3. Quickstarts
     3.1. DocumentDB
          3.1.1. .NET
          3.1.2. Java
          3.1.3. Node.js
          3.1.4. Python
          3.1.5. Xamarin
     3.2. MongoDB
          3.2.1. Node.js
          3.2.2. .NET
          3.2.3. Java
          3.2.4. Golang
     3.3. Graph
          3.3.1. .NET
          3.3.2. Gremlin console
          3.3.3. Java
          3.3.4. Node.js
     3.4. Table
          3.4.1. .NET
4. Tutorials
     4.1. 1 - Create
          4.1.1. DocumentDB
          4.1.2. MongoDB with .NET
          4.1.3. MongoDB with Angular
          4.1.4. MongoDB with React
          4.1.5. Table
          4.1.6. Graph
     4.2. 2 - Import
          4.2.1. DocumentDB
          4.2.2. MongoDB
     4.3. 3 - Query
          4.3.1. DocumentDB
          4.3.2. MongoDB
          4.3.3. Table
          4.3.4. Graph
     4.4. 4 - Distribute globally
          4.4.1. DocumentDB
          4.4.2. MongoDB
          4.4.3. Table
          4.4.4. Graph
     4.5. 5 - Develop locally
          4.5.1. Use the emulator
          4.5.2. Export certificates
     4.6. 6 - Integrate with Functions
          4.6.1. HTTP trigger
5. Samples
     5.1. Azure CLI
     5.2. PowerShell
6. Concepts
     6.1. Serverless database
     6.2. Global distribution
     6.3. Partitioning
     6.4. Consistency
     6.5. Throughput
     6.6. Multi-model APIs
          6.6.1. DocumentDB
          6.6.2. MongoDB
          6.6.3. Table
          6.6.4. Graph
     6.7. Security
     6.8. TCO
     6.9. Use cases
          6.9.1. Social media apps
7. How To Guides
     7.1. Develop
          7.1.1. DocumentDB API
               7.1.1.1. Resources
               7.1.1.2. SQL queries
               7.1.1.3. SQL query performance
               7.1.1.4. SQL playground
               7.1.1.5. Partitioning
               7.1.1.6. Stored procedures, triggers, and UDFs
               7.1.1.7. Performance testing
               7.1.1.8. Performance tips
               7.1.1.9. Multi-master setup
               7.1.1.10. DateTimes
               7.1.1.11. Modeling document data
               7.1.1.12. Tutorials
                    7.1.1.12.1. Write your first app
                         7.1.1.12.1.1. .NET
                         7.1.1.12.1.2. .NET Core
                         7.1.1.12.1.3. Java
                         7.1.1.12.1.4. Node.js
                         7.1.1.12.1.5. C++
                    7.1.1.12.2. Build a web app
                         7.1.1.12.2.1. .NET
                         7.1.1.12.2.2. Xamarin
                         7.1.1.12.2.3. Node.js
                         7.1.1.12.2.4. Java
                         7.1.1.12.2.5. Python Flask
               7.1.1.13. Samples
                    7.1.1.13.1. .NET samples
                    7.1.1.13.2. Node.js samples
                    7.1.1.13.3. Python samples
               7.1.1.14. Resources
                    7.1.1.14.1. SQL grammar cheat sheet
                    7.1.1.14.2. Stack Overflow
                    7.1.1.14.3. Videos
                    7.1.1.14.4. Service updates
                    7.1.1.14.5. Community portal
                    7.1.1.14.6. Schema agnostic indexing paper
                    7.1.1.14.7. Retire S1, S2, S3
          7.1.2. MongoDB API
               7.1.2.1. Connect to your MongoDB account
               7.1.2.2. Using MongoChef
               7.1.2.3. Using Robomongo
               7.1.2.4. Angular tutorial series
                    7.1.2.4.1. Part 2 - Create Node app
                    7.1.2.4.2. Part 3 - Add Angular UI
                    7.1.2.4.3. Part 4 - Create Cosmos DB
                    7.1.2.4.4. Part 5 - Connect to Cosmos DB
                    7.1.2.4.5. Part 6 - Write to the app
               7.1.2.5. Additional tutorials
                    7.1.2.5.1. Node.js console app
          7.1.3. Graph API
               7.1.3.1. Gremlin support
          7.1.4. Table API
               7.1.4.1. Table storage overview
               7.1.4.2. Table storage design guide
               7.1.4.3. Table storage REST APIs
               7.1.4.4. Tutorials
                    7.1.4.4.1. .NET
                    7.1.4.4.2. F#
                    7.1.4.4.3. Node.js
                    7.1.4.4.4. Java
                    7.1.4.4.5. Node.js
                    7.1.4.4.6. C++
                    7.1.4.4.7. PHP
                    7.1.4.4.8. Python
                    7.1.4.4.9. Ruby
          7.1.5. Change feed
          7.1.6. Geospatial
          7.1.7. Indexing
          7.1.8. Connected Service in Visual Studio
     7.2. Manage
          7.2.1. Cost-effective reads and writes
          7.2.2. Expire data automatically
          7.2.3. Back up and restore
          7.2.4. Regional failover
          7.2.5. Set throughput
          7.2.6. Monitor SLAs
          7.2.7. Use metrics
          7.2.8. Diagnostic logging
          7.2.9. Manage keys and consistency
          7.2.10. Azure Storage Explorer
          7.2.11. Security
               7.2.11.1. Encryption at rest
               7.2.11.2. Firewall support
               7.2.11.3. Securing access to data
     7.3. Integrate
          7.3.1. Connect to Spark
          7.3.2. Connect to Spark GraphX
          7.3.3. Deploy a website with Azure App Service
          7.3.4. Application logging with Logic Apps
          7.3.5. Bind to Azure Functions
          7.3.6. Analyze data with Hadoop
          7.3.7. Integrate with Azure Search
          7.3.8. Move data with Azure Data Factory
          7.3.9. Analyze real-time data with Azure Stream Analytics
          7.3.10. Get changed HL7 FHIR record using Logic Apps
          7.3.11. Process sensor data in real time
          7.3.12. Visualize your data with Power BI
          7.3.13. Leverage the ODBC driver for data visualization
          7.3.14. Use Spring Boot Starter with DocumentDB APIs
8. Reference
     8.1. Code samples
     8.2. DocumentDB APIs
          8.2.1. Java
          8.2.2. .NET
          8.2.3. .NET Change feed
          8.2.4. .NET Core
          8.2.5. Node.js
          8.2.6. Python
          8.2.7. REST
          8.2.8. REST Resource Provider
          8.2.9. SQL
     8.3. Table APIs
          8.3.1. .NET
          8.3.2. Python
     8.4. Graph APIs
          8.4.1. .NET
9. Resources
     9.1. Azure Roadmap
     9.2. Try Azure Cosmos DB for free
     9.3. Pricing
     9.4. FAQ
     9.5. Stack Overflow
     9.6. Data consistency explained through baseball

Online Training Content

Date Title
5/30/2017 Azure205x - Microsoft Azure Storage
5/24/2017 Developing NoSQL Solutions in Azure
3/7/2015 Microsoft Azure Fundamentals: Storage and Data
12/23/2014 You've Got Documents! A MongoDB Jump Start
2/13/2014 Windows Azure Storage - Design and Implementation Jump Start
2/13/2014 Windows Azure Storage - Design and Implementation Jump Start

Tools

Tool Description
Cloud Combine Cloud Combine is IDE for cloud services that works in a way you expect. It supports Microsoft Azure, Amazon AWS and Google Cloud as well as golden classics such as FTP.
Azure Management Studio One tool to manage your Microsoft Azure cloud storage, diagnostics data and application workflows.
Microsoft Azure Storage Explorer Microsoft Azure Storage Explorer (Preview) is a standalone app from Microsoft that allows you to easily work with Azure Storage data on Windows, OSX and Linux.

Videos

Date Title Length
5/10/2017 Demystifying Cloud Data Services for an App Developer 0:33:50
5/4/2017 How Johnson Controls built an intelligent cloud solution at scale 1:04:34
2/22/2017 Customize table columns in Microsoft Azure Storage Explorer 0:04:04
12/28/2016 Storage Explorer table query 0:03:44
4/27/2016 Introduction to Azure Table Storage 0:29:09
3/31/2016 Introduction to Azure Table Storage 0:29:08
3/31/2016 Introduction to Azure Table Storage 0:29:08
5/19/2015 Blobs and Tables: New Azure-Consistent Storage for your Datacenter 1:20:35
5/14/2015 Azure Table Storage 101 with Jai Haridas 0:00:00
5/4/2015 Building Performance Applications Using Microsoft Azure Storage 0:00:00

Page 1 of 2