Book Image

Learning Azure DocumentDB

By : Becker
Book Image

Learning Azure DocumentDB

By: 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.
Table of Contents (10 chapters)
9
Index

Chapter 4. Advanced Querying

This chapter will guide you through more advanced querying techniques. We will also focus on using built-in functions and creating triggers, stored procedures, and working with transactions. Finally, we will also create user-defined functions and demonstrate how to apply them in advanced queries.

Each section will discuss different querying techniques, showing both the DocumentDB SQL statements as well as the output.

In this chapter, we will cover the following topics:

  • Learn about the SELECT, FROM, and WHERE statements in detail
  • Learn how to apply operators in your queries
  • Demonstrate how to use built-in functions
  • Outline how to build stored procedures, triggers, and user-defined functions
  • Discuss using LINQ to DocumentDB
  • Learn how to work with transactions

At the time of writing, DocumentDB does not support aggregate functions like SUM or COUNT. Also, no GROUP BY is supported yet.