Introduction to Azure DocumentDB
This course teaches Azure DocumentDB, Microsoft's NoSQL database that works with schema-free JSON documents, uses a SQL grammar for querying, and supports a server-side programming environment for stored procedures, triggers, and user-defined functions.
What you'll learn
This course teaches developers how to use DocumentDB — a fully managed and massively scalable NoSQL document database service that runs on Microsoft Azure. We start with a brief introduction to NoSQL and DocumentDB and then learn how to use the Azure portal to create a DocumentDB database account and add JSON documents to a database. You’ll also learn how to use the DocumentDB migration tool to import documents from many different data sources. Then you’ll see how to use the rich SQL grammar to query for documents and how to program client applications using the REST API and the .NET and NodeJS SDK. Then learn about the DocumentDB server-side programming model that supports stored procedures, triggers, and user-defined functions in JavaScript, with full transactional consistency. We also explore additional topics, including custom index policies, attachments, tunable consistency, and partitioning.
Table of contents
- Getting Started 1m
- Demo: Creating a DocumentDB Account, Database, and Collection 7m
- DocumentDB Resource Model 4m
- Understanding Collections 2m
- Adding Documents to a Collection 1m
- Demo: Creating Documents with the Azure Portal 7m
- DocumentDB Data Migration Tool 2m
- Demo: Preparing to Migrate Data from SQL Server 6m
- Demo: Importing Documents with the Data Migration Tool 12m
- Module Summary 1m
- Connecting to DocumentDB 1m
- Master Keys 2m
- Users, Permissions, and Resource Tokens 1m
- Programming with the REST API 2m
- Demo: Programming with the REST API 11m
- Programming with the .NET SDK 3m
- Demo: Getting Started with the .NET SDK 7m
- Demo: .NET SDK - Working with Collections 4m
- Demo: .NET SDK - Working with Documents 11m
- Demo: .NET SDK - Working with Users and Permissions 6m
- DocumentDB and JavaScript 1m
- Programming with the Node.js SDK 1m
- Demo: Getting Started with the Node.js SDK 8m
- Demo: Using Promises with the Node.js SDK 7m
- JavaScript SDK 4m
- Module Summary 1m
- Server-side Programming Model 5m
- Creating Stored Procedures 2m
- Demo: Simple Stored Procedure 5m
- Demo: More Stored Procedures 16m
- Demo: Bulk Insert Stored Procedure 8m
- Demo: Select Count Stored Procedure 9m
- Demo: Bulk Delete Stored Procedure 9m
- Creating Triggers 2m
- Demo: Working with Pre-triggers 5m
- Demo: Working with Post-triggers 4m
- Creating User-defined Functions 2m
- Demo: Working with User-defined-functions 5m
- Module Summary 1m
- ID-based Routing 2m
- Demo: ID-based Routing 6m
- Custom Indexing 9m
- Demo: Custom Indexing 6m
- Attachments 3m
- Demo: Attachments 3m
- Tunable Consistency 6m
- Partitioning Large Datasets 6m
- Spillover Partitioning 2m
- Range Partitioning 2m
- Lookup Partitioning 2m
- Demo: Range Partitioning 4m
- Next Steps 2m
- Module Summary 2m
About the author
Leonard Lobel (Microsoft MVP, SQL Server) is the chief technology officer and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., one of only 40 Microsoft National Systems Integrators in the United States. For more than 25 years, Tallan has been providing cutting-edge custom web/application development, business intelligence, customer relationship management, and int... more