Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Learning Azure DocumentDB

By : Riccardo Becker

Learning Azure DocumentDB

By: Riccardo Becker

Overview of this book

Learning DocumentDB adopts a practical, step-by-step approach to help you learn the basics of DocumentDB and use your new-found abilities in real-life scenarios and enterprise solutions. We start with the absolute basics, such as setting up a DocumentDB environment, and guide you through managing your databases, and executing simple and complex queries. Next, we explain how to work with DocumentDB using the open REST protocol, and demonstrate how JavaScript works with DocumentDB. We’ll also show you how to authenticate and execute queries. Moving on, you’ll find out how to use DocumentDB from within Node.js to kick-start your Node.js projects. Next, you’ll discover how to increase the performance of your DocumentDB database and fine-tune it. Finally, you’ll get to grips with using DocumentDB in conjunction with other services offered from the Microsoft Azure platform.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Getting Started with DocumentDB

1. Getting Started with DocumentDB

What is DocumentDB?

Exploring the data model

DocumentDB versus other databases

Understanding the price model

Building your first application

Summary

2. Setting up and Managing Your Database

2. Setting up and Managing Your Database

Managing your keys

Using resource tokens

Managing alerts

Summary

3. Basic Querying

3. Basic Querying

Creating resources

Reading resources

Updating documents

Deleting documents

Summary

4. Advanced Querying

4. Advanced Querying

Using the SELECT statement

Using the FROM clause

Using the WHERE clause

Using built-in functions

Building stored procedures

Building triggers

Building user-defined functions

Using LINQ to DocumentDB

Summary

5. Using REST to Access Your Database

5. Using REST to Access Your Database

Understanding the basics of REST

Querying DocumentDB resources

Getting all databases

Adding a document

Summary

6. Using Node.js to Access Your Database

6. Using Node.js to Access Your Database

Introducing Node.js

Utilizing DocumentDB from Node.js

Summary

7. Advanced Techniques

7. Advanced Techniques

Introducing indexes

Partitioning data

Managing performance

Using transactions

Setting consistency levels

Summary

8. Putting Your Database at the Heart of Azure Solutions

8. Putting Your Database at the Heart of Azure Solutions

Introducing an Internet of Things scenario

Increasing search capabilities

Enhancing security

Migrating data

Summary

Index

Index

Using the FROM clause

The FROM clause is an optional clause, unless you want to apply filtering (by using the WHERE clause). The WHERE clause is used to specify the source(s) upon which the query needs to be executed. Mostly, the WHERE clause is used to select a collection. The FROM clause is needed when you want to query a collection.

Another example of using the SELECT statement without the FROM clause is the following code snippet:

SELECT CONTAINS(UPPER("Riccardo"), UPPER("ri"))

This SELECT statement only operates on string values and uses some of the built-in functions that DocumentDB provides (CONTAINS and UPPER). The output of this SELECT statement is as follows:

[
  {
    "$1": true
  }
]

Potentially, you could use DocumentDB only for its built-in functions, but it would be an expensive solution.

Aliasing

Collections can be aliased by applying the AS operator:

SELECT p.FirstName, p.LastName FROM PersonInformation AS p

Once we decide to use aliasing, we can no...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Learning Azure DocumentDB

Search

Your notes and bookmarks