Welcome to ONLC Training Centers

Microsoft On-Demand: Implementing an Azure Data Solution (DP-200) Course

Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.


Microsoft On-Demand: Implementing an Azure Data Solution (DP-200) Course

 

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

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

Attend hands-on, instructor-led Microsoft On-Demand: Implementing an Azure Data Solution (DP-200) training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Azure Courses and select the one that's right for you.

GENERAL INFO

Class Format
Class Policies
Student Reviews


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com