Course 20777A: Implementing Microsoft Azure Cosmos DB Solutions - CTU Training Solutions

This course retired.

Course 20777A: Implementing Microsoft Azure Cosmos DB Solutions

This three-day instructor-led course is aimed at database professionals who are looking to implement a Cosmos DB solution.
Duration: 3 Days   |   Location : Online
Course Prerequisites:
In addition to their professional experience, students who attend this training should already have the follow... Show More

Virtual Interactive Lecturer-led Teaching (VILT)

Virtual instruction environments are designed to simulate the traditional classroom or learning experience. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.

Module 1: Introduction to Azure Cosmos DB

Describe the purpose and architecture of Cosmos DB.

  • Review of NoSQL database structures
  • Migrating data and applications to Cosmos DB
  • Managing data in Cosmos DB

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

  • Creating and configuring a Cosmos DB database
  • Migrating data from a Mongo DB database to Cosmos DB
  • Using the SQL API to access data
  • Protecting data in a Cosmos DB database

See fewer details

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.

  • Document models in Cosmos DB
  • Querying data in a SQL API database
  • Querying and maintaining data programmatically

Lab : Designing and implementing SQL API database applications

  • Design the document structure & partitioning strategy for the product catalog for the retail system
  • Importing product catalog data
  • Querying product catalog information
  • Maintaining stock levels in the product catalog

+ See more details

Module 3: Implementing Server Side Operations

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

  • Server-side programming with Cosmos DB
  • Creating and using stored procedures
  • Using triggers to maintain data integrity

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

  • 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.

+ See more details

Module 4: Optimizing and monitoring performance

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

  • Optimizing database performance
  • Monitoring the performance of a database

Lab : Tuning a database and monitoring performance

  • 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

+ See more details

Module 5: What’s New in SQL Server Reporting and BI

This module introduces reporting and BI enhancements and new features in SQL Server 2016.

  • Reporting Services Enhancements
  • PowerBI Enhancements
  • Mobile Report Publisher

Lab : Implementing PowerBI

+ See more details

Module 5: Designing and Implementing a Graph Database

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

  • Graph database models in Cosmos DB
  • Designing Graph database models for efficient operation

Lab : Designing and implementing a Graph database

  • Implementing a recommendations engine for customers
  • Recording product purchase information
  • Query a Graph database to obtain analytics

+ See more details

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.

  • Integrating Cosmos DB with Azure search to optimize queries
  • Analyzing data in a Cosmos DB database using Apache Spark
  • Visualizing data in a Cosmos DB database

Lab : Querying and Analyzing Big Data with Cosmos DB

  • Extending product search capabilities
  • Performing end-of-month processing
  • Visualizing sales data
  • Exploring sales data

+ See more details

Module 7: Implementing Stream Processing with Cosmos DB

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

  • Working with the Cosmos DB change feed
  • Integrating Cosmos DB into streaming solutions

Lab : Using Cosmos DB with stream processing

  • Handling orders
  • Maintaining stock analytic data
  • Displaying rolling revenue for a given time period

+ See more details

Module 8: Administering Reporting Services

System administrators take responsibility for the configuration and day-to-day operations of IT systems. In SQL Server Reporting Services (SSRS), administrative tasks include the configuration of the web portal and web service, branding the web portal, and ensuring that access to sensitive reports is carefully controlled. Administrators also monitor and optimize performance.

  • Administering reporting services
  • Reporting services configuration
  • Reporting services performance

Lab : Administering reporting services

  • Authorize access to reports

+ See more details

Open chat
Need Help?
How can we assist you today?