DP-200: Implementing an Azure Data Solution

Programme Overview

In this course, the students will implement various data platform technologies into solutions that are in-line with business and technical requirements, including on-premises, cloud, and hybrid data scenarios incorporating both relational and NoSQL data. They will also learn how to process data using a range of technologies and languages for both streaming and batch data.


The students will also explore how to implement data security, including authentication, authorization, data policies, and standards. They will also define and implement data solution monitoring for both the data storage and data processing activities. Finally, they will manage and troubleshoot Azure data solutions which includes the optimization and disaster recovery of big data, batch processing, and streaming data solutions.


Who Should Attend

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.


Course Pre-requisites

Azure Fundamentals


Course Details

Certification Exam

Exam DP-200: Implementing an Azure Data Solution

Certification Body

Microsoft

Duration:

3 Days

Course Outlines


Lessons

  • 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

Lessons

  • Choose a data storage approach in Azure
  • Create an Azure Storage Account
  • Explain Azure Data Lake storage
  • Upload data into Azure Data Lake

Lessons

  • Explain Azure Databricks
  • Work with Azure Databricks
  • Read data with Azure Databricks
  • Perform transformations with Azure Databricks

Lessons

  • Create an Azure Cosmos DB database built to scale
  • Insert and query data in your Azure Cosmos DB database
  • Build a .NET Core app for Cosmos DB in Visual Studio Code
  • Distribute data globally with Azure Cosmos DB

Lessons

  • Use Azure SQL Database
  • Describe Azure SQL Data Warehouse
  • Creating and Querying an Azure SQL Data Warehouse
  • Use PolyBase to Load Data into Azure SQL Data Warehouse

Lessons

  • Explain data streams and event processing
  • Data Ingestion with Event Hubs
  • Processing Data with Stream Analytics Jobs

Lessons

  • Explain how Azure Data Factory works
  • Azure Data Factory Components
  • Azure Data Factory and Databricks

Lessons

  • An introduction to security
  • Key security components
  • Securing Storage Accounts and Data Lake Storage
  • Securing Data Stores
  • Securing Streaming Data

Lessons

  • Explain the monitoring capabilities that are available
  • Troubleshoot common data storage issues
  • Troubleshoot common data processing issues
  • Manage disaster recovery



DP-201: Designing an Azure Data Solution

Programme Overview

In this course, the students will design various data platform technologies into solutions that are in line with business and technical requirements. This can include on-premises, cloud, and hybrid data scenarios which incorporate relational, NoSQL, or Data Warehouse data.


They will also learn how to design process architectures using a range of technologies for both streaming and batch data. The students will also explore how to design data security, including data access, data policies, and standards. They will also design Azure data solutions, which includes the optimization, availability, and disaster recovery of big data, batch processing, and streaming data solutions.


Who Should Attend

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


Course Pre-requisites

  • Azure Fundamentals
  • DP-200: Implementing an Azure Data Solution

Course Details

Certification Exam

Exam DP-201: Designing an Azure Data Solution

Certification Body

Microsoft

Duration:

2 Days

Course Outlines


Lessons

  • Core Principles of Creating Architectures
  • Design with Security in Mind
  • Performance and Scalability
  • Design for availability and recoverability
  • Design for efficiency and operations
  • Case Study

Lessons

  • Lambda architectures from a Batch Mode Perspective
  • Design an Enterprise BI solution in Azure
  • Automate enterprise BI solutions in Azure
  • Architect an Enterprise-grade Conversational Bot in Azure

Lessons

  • Describe Lambda architectures for a Real-Time Perspective
  • Architect a stream processing pipeline with Azure Stream Analytics
  • Design a stream processing pipeline with Azure Databricks
  • Create an Azure IoT reference architecture

Lessons

  • Defense in Depth Security Approach
  • Identity Management
  • Infrastructure Protection
  • Encryption Usage
  • Network Level Protection
  • Application Security

Lessons

  • Adjust Workload Capacity by Scaling
  • Optimize Network Performance
  • Design for Optimized Storage and Database Performance
  • Identify Performance Bottlenecks
  • Design a Highly Available Solution
  • Incorporate Disaster Recovery into Architectures
  • Design Backup and Restore strategies

Lessons

  • Maximizing the Efficiency of your Cloud Environment
  • Use Monitoring and Analytics to Gain Operational Insights
  • Use Automation to Reduce Effort and Error

Trainer's Profile

MR. JESU AROCKIA XAVIER

Mr Xavier is an Engineering graduate in Computer Science in New Delhi, India. He has a track record of over 12 years of experience in IT infrastructure, management, training and consultancy as well as 4 years’ experience as a SAP Certified Trainer for HANA, ABAP & SD modules. His expertise has been employed extensively whilst having a track record of training over more than 800 professionals and fresh graduates as a SAP trainer.

He has successfully trained and empowered professionals from mega companies such as Petronas, BP, Shell, Sime Darby, EY, TNB Sdn Bhd, Malaysian Airlines and others. He is not only an expert in regards to ERP systems like SAP, he is also a Microsoft expert. Holding over 10 certifications from Microsoft on various Cloud solutions as well as certifications from DevOps has valued his input on a high scale.





Contact Us To Find Out More



Share This Programme






Selangor    |   Penang   |   Johor

Tel: +(603) 7960 1922
Fax: +(603) 7960 1921
E-Mail: info@knowledgecom.my