V.le P.A. Pirelli 6, Milano - academy@digi.it - 0269438264

Corsi Microsoft

Cerca un corso

Implementing Microsoft Azure Cosmos DB Solutions

Codice corso: 20777A
Durata corso: 3gg

Introduzione

This three-day instructor-led course is aimed at database professionals who are looking to implement a Cosmos DB solution.

The primary audience for this course is database developers and architects (IT professionals, developers, and information workers) who plan to implement big data solutions on Azure using Cosmos DB.

Obiettivi del corso

After completing this course, students will be able to:

Describe the purpose and architecture of Azure Cosmos DB

Describe how to design documents and collections to meet business requirements, and how to use the SQL API to build applications that use these documents

Describe how to create user-defined functions, stored procedures, and triggers

Describe how to tune a database, and how to monitor performance

Describe how to create efficient Graph database models using Cosmos DB

Describe how to use Azure Search, HDInsight, Azure Databricks, and Power BI with Cosmos DB to query and analyze big data

Describe how to use Cosmos DB as a source and sink for streaming data

Prerequisiti

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

The fundamental concepts of partitioning, replication, and resource governance for building and configuring scalable applications that are agnostic of a Cosmos DB API

A basic working knowledge of the Cosmos DB SQL API

Struttura del Corso

MODULE 1: Introduction to Azure Cosmos DB

Describe the purpose and architecture of Cosmos DB

Lessons

After completing this module, students will be able to:

 

Review of NoSQL database structures

Create and configure a Cosmos DB

Migrate data from a Mongo DB database to a Cosmos DB database.

Describe accessing data using the SQL API

Describe how to protect data in a Cosmos DB

 

Lab : Creating and using a SQL API database in Cosmos DB

MODULE 2: Designing and Implementing SQL API Database Applications

This module describes how to design documents and collections to meet business requirements, and how to use the SQL API to build applications that use these documents

Lessons

After completing this module, students will be able to:

 

Document models in Cosmos DB

Create a Query data in a SQL API database

Create a Query and maintain data programmatically

Design the document structure & partitioning strategy for the product catalog for the retail system

Import product catalog data

Querying product catalog information

Maintain stock levels in the product catalog

 

Lab : Designing and implementing SQL API database applications

MODULE 3: Implementing Server Side Operations

Describe how to create user-defined functions, stored procedures, and triggers

Lessons

After completing this module, students will be able to:

 

Describe how Cosmos DB enables you to implement server-side operations by writing JavaScript code.

Describe how use the JavaScript Query API to implement transactional operations with stored procedures

Describe how use create triggers that you can use to maintain integrity when inserting, updating, and deleting documents

Design and implement the document and collection structure

Implement the shopping cart functionality in the online retail system

Extend the online retail system to create orders from the items in a shopping cart

Extend the online retail system further to enable customers to view orders and backorders

 

Lab : Writing user-defined functions, stored procedures and triggers

 

MODULE 4: Optimizing and monitoring performance

Describe how to optimize a database, and how to monitor performance.

Lessons

After completing this module, students will be able to:

 

Describe how to tune the configuration of a database and collections for best performance

Describe how to assess the performance of a document database and identify options for improving throughput

Gathering execution statistics

Examining how the different consistency models can impact throughput and latency

Investigate the effects of triggers on performance

Monitoring performance and tuning the partition key

 

Lab : Tuning a database and monitoring performance

MODULE 5: Designing and Implementing a Graph Database

This module describes how to create efficient graph database models using Cosmos DB

Lessons

After completing this module, students will be able to:

 

Describe the features that Cosmos DB provides for implementing graph databases

Design NoSQL graph structures that support business requirements and enable efficient operations

Implemente a recommendations engine for customers

Recorde product purchase information

Query a Graph database to obtain analytics

 

Lab : Designing and implementing a Graph database

 

MODULE 6: Querying and Analyzing Big Data with Cosmos DB

This module describes how to use Azure Search and HDInsight with Cosmos DB to query and analyze big data

Lessons

After completing this module, students will be able to:

 

Describe how to integrate Cosmos DB with Azure Search to perform efficient query processing over big data.

Describe how to analyze big data held in Cosmos DB using Apache Spark.

Describe how to visualize data in Cosmos DB using Jupyter notebooks, Power BI, and Azure Databricks

Extende product search capabilities

Performe end-of-month processing

Visualize sales data

Explore sales data

 

Lab : Querying and Analyzing Big Data with Cosmos DB

 

MODULE 7: Implementing Stream Processing with Cosmos DB

This module describes how to use Cosmos DB as a source and sink for streaming data

Lessons

After completing this module, students will be able to:

 

Describe the Cosmos DB change feed, and how to use it to process data efficiently.

Explain how to incorporate Cosmos DB into streaming solutions such as Apache Kafka, Apache Spark, and Azure Stream Analytics

Handling orders

Maintaining stock analytic data

Displaying rolling revenue for a given time period

 

Lab : Using Cosmos DB with stream processing

 

 

 

P.IVA 06249920965
C.C.I.A.A. REA: MI - 1880014
Cap. Soc. € 12.000,00

Contatti

V.le P.A. Pirelli 6,20126 Milano
Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo.
Tel.: +39 02 694 382 64
Fax.: +39 02 694 382 35

© Copyright 2020 DI.GI. Academy
Privacy Policy | Cookie Policy