DP-200 - Training - Implementing an Azure Data Solution

Training for Microsoft Official Course (MOC) DP-200 - Implementing an Azure Data Solution

About the course

This course provides students with the skills and knowledge required to successfully create and maintain the cloud and edge portions of an Azure IoT solution. The course includes full coverage of the core Azure IoT services such as IoT Hub, Device Provisioning Services, Azure Stream Analytics, Time Series Insights, and more. In addition to the focus on Azure PaaS services, the course includes sections on IoT Edge, device management, monitoring and troubleshooting, security concerns, and Azure IoT Central.

Microsoft Labs and Workshops

• Azure Cosmos DB Workshop (2 days)
• Azure Databricks NYC Taxi Workshop
• SQL Server and Azure SQL Labs and Workshops
• SQL Ground-to-Cloud Workshop

Software list to run the course and workshop labs available here

Microsoft Samples

• Azure Event Hubs

  • Microsoft Azure Event Hubs samples and data generators

• Azure SQL Database

  • Azure SQL Database Code Samples

• Azure Synapse Analytics (formerly SQL DW)

  • Load data from Azure blob storage using polybase
  • Load data from Azure blob storage with polybase
  • Load data to Azure SQL Data Warehouse

• Azure Stream Analytics

  • Microsoft Azure Stream Analytics data samples and data generators

Resources

Free eBooks

• An Easier Path to the Cloud for Your Legacy SQL Server Data, Microsoft, 2019-07-09
• Azure Data Factory: SSIS in the Cloud, Joshuma Owen, Pragmatic Works, 2018-05-10
• Azure Databricks for Data Engineering, Databricks Whitepapers
• Build better apps, get your data where it needs to be, and get it there fast, 2017-10-11
• Developer’s Guide to Getting Started with Azure Cosmos DB, 2019-12-06
• Getting started with Apache Spark on Azure Databricks, 2019-03-01
• Getting started with Apache Spark on Azure Databricks, Microsoft, 2018
• Getting Started with Apache Spark on Azure Databricks, Databricks Whitepapers
• Guide to NoSQL with Azure Cosmos DB, 2018-01-10, Caston Hillar and Daron Yondem, Packt
• Introduction to Azure SQL Data Warehouse, 2018-04-27
• Migrating SQL Server to Azure SQL Database Managed Instance—A Step-by-Step Guide, Microsoft, 2019-07-09
• Modernize your data warehouse to the cloud, 2018-04-27
• Professional Azure SQL Database Administration, Second Edition, Ahmad Osama, Packt, 2019-07-11
• Solve your big data and AI challenges with an Azure Databricks, Microsoft, 2019-03-01
• Solve your big data and AI challenges with an Azure Databricks, Microsoft, 2018
• Three Practical Use Cases with Azure Databricks, Databricks Whitepapers

Videos

• No information / available when possible

---

Companion Material and Resources for Class delivery by Ricardo Cabral

Artificial intelligence (AI)

• AI-050: Develop Generative AI Solutions with Azure OpenAI Service
• AI-102: Designing and Implementing a Microsoft Azure AI Solution

DevOps

• AZ-400: Microsoft Azure DevOps Solutions
• AZ-2008: DevOps Foundations The Core Principles and Practices

Microsoft Azure Administrator

• AZ-104: Microsoft Azure Administrator
• AZ-300: Microsoft Azure Architect Technologies

Microsoft Azure Developer

• AZ-204: Developing Solutions for Microsoft Azure

Microsoft Azure Database

• DP-900: Microsoft Azure Data Fundamentals

Microsoft C#

• 20483: Programming in C#
• 20484: Essentials of Developing Windows Store Apps Using C#

Microsoft 365

• MS-500: Microsoft 365 Security Administration
• M365SharePointPT: Colaboração e Partilha entre Utilizadores com Microsoft 365 SharePoint
• Microsoft SharePoint Power User: SharePoint Online Power User

Microsoft Power Platform

• PL-100: Microsoft Power Platform App Maker
• PL-200: Microsoft Power Platform Functional Consultant
• PL-400: Microsoft Power Platform Developer

Microsoft PowerShell

• AZ-040: Automating Administration with PowerShell
• Microsoft Windows PowerShell Training

Microsoft SQL Server

• DP-080: Querying Data with Microsoft Transact-SQL
• Fundamentos de SQL: Introdução aos Fundamentos de SQL com Transact-SQL

Microsoft Teams

• MS-700: Managing Microsoft Teams
• MS-720: Microsoft Teams Voice Engineer

Microsoft Windows Client

• MD-101: Managing Modern Desktops
• MD-102: Endpoint Administrator

Microsoft Windows Server

• AZ-801: Configuring Windows Server Hybrid Advanced Services

---

You can follow me at:

---