Book Image

Guide to NoSQL with Azure Cosmos DB

By : Gaston C. Hillar, Daron Yöndem
Book Image

Guide to NoSQL with Azure Cosmos DB

By: Gaston C. Hillar, Daron Yöndem

Overview of this book

Cosmos DB is a NoSQL database service included in Azure that is continuously adding new features and has quickly become one of the most innovative services found in Azure, targeting mission-critical applications at a global scale. This book starts off by showing you the main features of Cosmos DB, their supported NoSQL data models and the foundations of its scalable and distributed architecture. You will learn to work with the latest available tools that simplify your tasks with Cosmos DB and reduce development costs, such as the Data Explorer in the Azure portal, Microsoft Azure Storage Explorer, and the Cosmos DB Emulator. Next, move on to working with databases and document collections. We will use the tools to run schema agnostic queries against collections with the Cosmos DB SQL dialect and understand their results. Then, we will create a first version of an application that uses the latest .NET Core SDK to interact with Cosmos DB. Next, we will create a second version of the application that will take advantage of important features that the combination of C# and the .NET Core SDK provides, such as POCOs and LINQ queries. By the end of the book, you will be able to build an application that works with a Cosmos DB NoSQL document database with C#, the .NET Core SDK, LINQ, and JSON.
Table of Contents (13 chapters)
Title Page
Packt Upsell
Contributors
Preface
Index

Test your knowledge


Let's see whether you can answer the following questions correctly:

  1. Which of the following queries is valid in the Cosmos DB SQL dialect?
    1. SELECT g.* FROM Games g WHERE g.id == '5'
    2. SELECT g.* FROM Games g WHERE g.id = '5'
    3. SELECT * FROM Games g WHERE g.id = '5'
  1. The IS_DEFINED built-in type-checking function does what exactly?
    1. Returns a Boolean indicating whether the property received as an argument has been assigned a value
    2. Returns the number of times a property has been assigned a value in the array expression received as an argument
    3. Returns a Boolean indicating whether the property received as an argument has been defined as required for the collection that contains the document
  2. Which of the following queries retrieves all the levels flattened into a single array?
    1. SELECT * FROM l IN Games.levels
    2. SELECT FLAT * FROM Games.levels
    3. SELECT * FROM Games.levels[0]
  3. Which of the following queries returns an array with a single value without a key?
    1. SELECT TOP 1 SUM(ARRAY_LENGTH(g.highestScores...