Azure Cosmos Database( Hands-On Learning )

What is Azure Cosmos database ?

Azure Cosmos database is one of the hottest and top paying skills. It is also very beneficial to work on. Azure Cosmos DB is Microsoft's globally distributed, multi-model database service. With a click of a button, Cosmos DB enables you to elastically and independently scale throughput and storage across any number of Azure regions worldwide. You can elastically scale throughput and storage, and take advantage of fast, single-digit-millisecond data access using your favorite API including SQL, MongoDB, Cassandra, Tables, or Gremlin. Cosmos DB provides comprehensive service level agreements (SLAs) for throughput, latency, availability, and consistency guarantees, something no other database service offers.

Objectives:

The primary objective of this courses it to enable attendees to understand and leverage knowledge of Azure Cosmos Database. Create database, collections and performance management with the help of tuning throughput, horizontal partitioning and Indexing. Manipulate data with the help of Visual Studio, .NET and server side coding like, Store procedures, Functions and triggers.

Table of Contents:

Day: 1

Course Overview

• Why and what is NOSL Database?
• Evolution of Cosmos DB
• What is Cosmos Database?

Getting Started with Cosmos DB.

• Cosmos DB Architecture.
• Multiple API’s and Data Models
• Demo: Creating Azure resource and Cosmos DB account
• Demo: Local Emulator, how to install and use.
• Demo: Creating Collections and documents

Performance and Throughput

• How to measure Performance
• What is RU.
• Request units and charges.
• Throughput isolation in globally distributed databases
• Demo: How to Measure Required RU’s
• Demo: Monitoring RU consumption.
• Demo: Allocating RU’s at both Database Collection level.
• Estimating throughput needs

Day 2:

Horizontal partitioning and backup recovery.

• Partitioning Options
• Best practices when choosing a partition key
• Prerequisites for partitioning.
• Automatic backup restore with Azure DB.

Data distribution

• Introduction to data distributions
• Different options available and Failover properties
• Demo: Setting up geo replication and failover
• Demo: Read write Geo replication (Preview)

Consistence levels.

• Distributed databases and consistency.
• Scope of consistency
• Tunable consistency for globally replicated databases
• Demo: how to switch between Consistence level.

SQL API

• Document Database
• Difference between relational and Document DB
• Cosmos DB Hierarchical resource model.
• Recourse Prosperities, Self-Link and URI.
• Data migration and Demo.

Day 3:

Querying with SQL API

• Introduction and Available SDK’s.
• Demo: Importing Sample data to Cosmos DB.
• Demo: Importing data from existing SQL Database using Data migration tool.
• SQL Server operators and functions.
• Demo: Getting Started with SQL Queries.

Indexing in Cosmos Database.

• Introduction
• Demo: Creating different types of indexes.
• Index management.
• Demo on Indexes.

Programming with .NET SDK

• Introduction.
• Working with Database and collections.
• Demo: Querying Documents.
• Demo: Replacing and deleting documents.
• Demo: Working with users and permissions.

Stored procedures, Functions and Triggers.

• Introduction
• Benefits of server side code.
• Demo: Stored procedures.
• Demo: Function
• Demo: Triggers.

If Time permits we will cover below topic as well:

Understand Table API

• Introduction
• How data is stored and how is it different from SQL API.
• Demo: Working with Table API.
• Demo: Migrating data from Azure Table store to Table API or Azure Cosmos DB

Understand and usage of Graph API

• Introduction Graph API.
• Different concepts.
• Comparison between 3 models.
• Demo: Working with Graph DB.