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 SELECT statement

As we have seen in the previous chapters, the SELECT statement is the key to using DocumentDB and selecting, finding, and filtering resources inside your collections.

The SELECT statement is described in the following syntax convention:

<select_query> ::=
SELECT <select_specification> 
    [ FROM <from_specification>] 
    [ WHERE <filter_condition> ]
    [ ORDER BY <order_by_specification>]

As you can see, a SELECT statement consists of the SELECT keyword as well as (optionally) the FROM and WHERE clauses.

It is possible to execute only the SELECT statement, as we will see later in this chapter. The following code snippet shows a simple example of only a SELECT statement:

SELECT ABS(-1) returns 
 [
  {
    "$1": 1
  }
]

Selecting some documents

In the previous chapters, we performed some basic querying against our collections. The following snippet is a simple query that returns all the first names inside the collection (the...

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