Module 1: Introduction to Azure Cosmos DB
Lessons
- 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
Lessons
- 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
Lessons
- 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
Lessons
- 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
Lessons
- Reporting Services Enhancements
- PowerBI Enhancements
- Mobile Report Publisher
Lab : Implementing PowerBI
+ See more details
Module 5: Designing and Implementing a Graph Database
Lessons
- 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
Lessons
- 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
Lessons
- 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
Lessons
- Administering reporting services
- Reporting services configuration
- Reporting services performance
Lab : Administering reporting services
- Authorize access to reports
+ See more details