Microsoft On-Demand: Implementing an Azure Data Solution (DP-200) Course Outline
Note: scheduled release date: second quarter 2021
*** Note: This is a Microsoft On-Demand (self -study) course, 180-day 24/7 access via the internet ***
(Applicable State and Local taxes may be added for On-Demand purchases, depending on your location.)
About This Course
We have assembled a complete package of self-study materials that cover all of the topics that are included in Microsoft's 3-day, official Instructor-led course. With these resources, you have a flexible platform that allows you to gain the knowledge you need for your job. If you also want certification, see the additional Exam Pak option--you can purchase that for $250, a 50% discount.
Audience profile
The primary audience for this course is data professionals, data architects, and business intelligence professionals who want to learn about the data platform technologies that exist on Microsoft Azure.
The secondary audience for this course is individuals who develop applications that deliver content from the data platform technologies that exist on Microsoft Azure.
Prerequisites
In addition to their professional experience, students who take this training should have technical knowledge equivalent to the Azure Fundamentals course.
Your course includes:
Microsoft Official E-Learning
We will be your guide through the official Microsoft Learn content directing you through this training platform which provides interactive learning modules with reading, hands-on experiences, knowledge checks and short videos.
Additional Expert Videos
Our subject matter experts provide an additional path through the Microsoft course objectives. We've assembled hours of video instruction where you can learn along with our experts.
Auditing Instructor-Led Training
With ONLC's Microsoft On-Demand training, you can also "Audit" a full instructor-led class. This gives you another perspective on how the content is presented. As a companion to the ILT course, you will receive the Microsoft Official Curriculum. (You must contact our office to reserve a seat in an upcoming class.) Note: Auditors will be able to see and hear the instructor’s presentation, however the instructor will not be able to hear you and you will not have direct access to the live instructor or lab machines.
Interested in Getting Certification? Check out our Exam Pak option!
Prepare for you Microsoft Certification by purchasing our Exam Pak for $250--a savings of 50%.
Additional Exam Pak Option includes:
24/7 Online Support
Need assistance while you are learning? Chat with our 24/7 online support specialists. And, with your permission, the expert can even take over your computer to provide assistance. (90-day access.)
Microsoft Exam Reference Guide
When you are ready for certification, begin your preparation with the Exam Reference Guide from Microsoft Press. We provide you with a copy of this book that focuses on the critical skills and knowledge measured on the Microsoft Certification exam.
Practice Exam Software
You may study at your own pace with this web-based practice exam. Exam-like questions are designed to help you prepare for your certification exam by validating your knowledge and reinforcing key concepts.
Exam Voucher with Exam-Pass Guarantee
Prepare for your exam using the practice software. Once you have achieved an 85% or above score, contact us and we will provide you with an exam voucher. Didn't pass the first time? Not a problem--you will get a second voucher with our Exam-Pass Guarantee - For details, click on the link below:
Exam Pass Guarantee
**Please call our office to order the Exam Pak. Note: Exam Paks are available at the discounted $250 price only when they are purchased at the same time as your Microsoft On-Demand class.**
Do You Still Prefer a Live, Instructor-led Class?
Already know Microsoft On-Demand, self-study training is not right for you? We also offer this same course content in a live, instructor-led format. For details, click on the link below:
DP-200: Implementing an Azure Data Solution Instructor-led Training Class
Course Outline
Module 1: Azure for the Data Engineer
Explain the evolving world of data
Survey the services in the Azure Data Platform
Identify the tasks that are performed by a Data Engineer
Describe the use cases for the cloud in a Case Study
Identify the evolving world of data
Determine the Azure Data Platform Services
Identify tasks to be performed by a Data Engineer
Finalize the data engineering deliverables
Module 2: Working with Data Storage
Choose a data storage approach in Azure
Create an Azure Storage Account
Explain Azure Data Lake storage
Upload data into Azure Data Lake
Choose a data storage approach in Azure
Create a Storage Account
Explain Data Lake Storage
Upload data into Data Lake Store
Module 3: Enabling Team Based Data Science with Azure Databricks
Explain Azure Databricks and Machine Learning Platforms
Describe the Team Data Science Process
Provision Azure Databricks and workspaces
Perform data preparation tasks
Explain Azure Databricks and Machine Learning Platforms
Describe the Team Data Science Process
Provision Azure Databricks and Workspaces
Perform Data Preparation Tasks
Module 4: Building Globally Distributed Databases with Cosmos DB
Create an Azure Cosmos DB database built to scale
Insert and query data in your Azure Cosmos DB database
Provision a .NET Core app for Cosmos DB in Visual Studio Code
Distribute your data globally with Azure Cosmos DB
Create an Azure Cosmos DB
Insert and query data in Azure Cosmos DB
Build a .Net Core App for Azure Cosmos DB using VS Code
Distribute data globally with Azure Cosmos DB
Module 5: Working with Relational Data Stores in the Cloud
SQL Database and SQL Data Warehouse
Provision an Azure SQL database to store data
Provision and load data into Azure SQL Data Warehouse
Explain SQL Database and SQL Data Warehouse
Create an Azure SQL Database to store data
Provision and load data into Azure SQL Data Warehouse
Module 6: Performing Real-Time Analytics with Stream Analytics
Explain data streams and event processing
Querying streaming data using Stream Analytics
How to process data with Azure Blob and Stream Analytics
How to process data with Event Hubs and Stream Analytics
Explain data streams and event processing
Querying streaming data using Stream Analytics
Process data with Azure Blob and Stream Analytics
Process data with Event Hubs and Stream Analytics
Module 7: Orchestrating Data Movement with Azure Data Factory
Explain how Azure Data Factory works
Create Linked Services and datasets
Create pipelines and activities
Azure Data Factory pipeline execution and triggers
Explain how Data Factory Works
Create Linked Services and Datasets
Create Pipelines and Activities
Azure Data Factory Pipeline Execution and Triggers
Module 8: Securing Azure Data Platforms
Configuring Network Security
Configuring Authentication
Configuring Authorization
Auditing Security
Configure network security
Configure Authentication
Configure Authorization
Explore SQL Server Books Online
Module 9: Monitoring and Troubleshooting Data Storage and Processing
Data Engineering troubleshooting approach
Azure Monitoring Capabilities
Troubleshoot common data issues
Troubleshoot common data processing issues
Explain the Data Engineering troubleshooting approach
Explain the monitoring capabilities that are available
Troubleshoot common data storage issues
Troubleshoot common data processing issues
Module 10: Integrating and Optimizing Data Platforms
Integrating data platforms
Optimizing data stores
Optimize streaming data
Manage disaster recovery
Integrate Data Platforms
Optimize Data Stores
Optimize Streaming Data
Manage Disaster recovery
View outline in Word
GDP200
Facebook
LinkedIn