Description
The NEW Microsoft Azure Data Engineer Training & Certification 6 Day Boot Camp focuses on Azure Data Engineers needs to design and implement the management, monitoring, security, and privacy of data using the full stack of Azure data services to satisfy business needs.
While attending this 6 day instructor led live camp – students will take 2 exams (DP-203 – Replaces DP-200/ DP-201 – AND – DP-900) to achieve the Microsoft Certified Foundations and Associate certifications. This hands on, instructor led live camp focuses on the real world responsibilities of an Azure Data Engineer covering the information needed for the certification exams which are administered while attending.
The Microsoft Certified Azure Data Engineer boot camp is taught using Microsoft Official Courseware –
DP-900T00: Microsoft Azure Data Fundamentals
DP-203T00: Designing an Azure Data Solution
Skills Gained:
Implement data storage solutions
Manage and develop data processing
Monitor and optimize data solutions
Design Azure data storage solutions
Design data processing solutions
Design for data security and compliance
Describe core data concepts in Azure
Explain concepts of relational data in Azure
Explain concepts of non-relational data in Azure
Identify components of a modern data warehouse in Azure
Topics Covered in this Official Boot Camp:
Azure for the Data Engineer
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
Lab : Azure for the Data Engineer
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
Working with Data Storage
Lessons
Choose a data storage approach in Azure
Create an Azure Storage Account
Explain Azure Data Lake storage
Upload data into Azure Data Lake
Lab : Working with Data Storage
Choose a data storage approach in Azure
Create a Storage Account
Explain Data Lake Storage
Upload data into Data Lake Store
Enabling Team Based Data Science with Azure Databricks
Lessons
Explain Azure Databricks
Work with Azure Databricks
Read data with Azure Databricks
Perform transformations with Azure Databricks
Lab : Enabling Team Based Data Science with Azure Databricks
Explain Azure Databricks
Work with Azure Databricks
Read data with Azure Databricks
Perform transformations with Azure Databricks
Building Globally Distributed Databases with Cosmos DB
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 your data globally with Azure Cosmos DB
Lab : Building Globally Distributed Databases with Cosmos DB
Create an Azure Cosmos DB
Insert and query data in Azure Cosmos DB
Distribute data globally with Azure Cosmos DB
Working with Relational Data Stores in the Cloud
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
Lab : Working with Relational Data Stores in the Cloud
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
Performing Real-Time Analytics with Stream Analytics
Lessons
Explain data streams and event processing
Data Ingestion with Event Hubs
Processing Data with Stream Analytics Jobs
Lab : Performing Real-Time Analytics with Stream Analytics
Explain data streams and event processing
Data Ingestion with Event Hubs
Processing Data with Stream Analytics Jobs
Orchestrating Data Movement with Azure Data Factory
Lessons
Explain how Azure Data Factory works
Azure Data Factory Components
Azure Data Factory and Databricks
Lab : Orchestrating Data Movement with Azure Data Factory
Explain how Data Factory Works
Azure Data Factory Components
Azure Data Factory and Databricks
Securing Azure Data Platforms
Lessons
An introduction to security
Key security components
Securing Storage Accounts and Data Lake Storage
Securing Data Stores
Securing Streaming Data
Lab : Securing Azure Data Platforms
An introduction to security
Key security components
Securing Storage Accounts and Data Lake Storage
Securing Data Stores
Securing Streaming Data
Monitoring and Troubleshooting Data Storage and Processing
Lessons
Explain the monitoring capabilities that are available
Troubleshoot common data storage issues
Troubleshoot common data processing issues
Manage disaster recovery
Lab : Monitoring and Troubleshooting Data Storage and Processing
Explain the monitoring capabilities that are available
Troubleshoot common data storage issues
Troubleshoot common data processing issues
Manage disaster recovery
Data Platform Architecture Considerations
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
Lab : Case Study
Design with security in mind
Consider performance and scalability
Design for availability and recoverability
Design for efficiency and operations
Azure Batch Processing Reference Architectures
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
Lab : Architect an Enterprise-grade Conversational Bot in Azure
Designing an Enterprise BI solution in Azure
Automate an Enterprise BI solution in Azure
Automate an Enterprise BI solution in Azure
Azure Real-Time Reference Architectures
Lessons
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
Lab : Azure Real-Time Reference Architectures
Architect a stream processing pipeline with Azure Stream Analytics
Design a stream processing pipeline with Azure Databricks
Create an Azure IoT reference architecture
Data Platform Security Design Considerations
Lessons
Defense in Depth Security Approach
Identity Management
Infrastructure Protection
Encryption Usage
Network Level Protection
Application Security
Lab : Data Platform Security Design Considerations
Defense in Depth Security Approach
Identity Protection
Designing for Resiliency and Scale
Lessons
Adjust Workload Capacity by Scaling
Optimize Network Performance
Design for Optimized Storage and Database Performance
Identifying Performance Bottlenecks
Design a Highly Available Solution
Incorporate Disaster Recovery into Architectures
Design Backup and Restore strategies
Lab : Designing for Resiliency and Scale
Adjust Workload Capacity by Scaling
Design for Optimized Storage and Database Performance
Design a Highly Available Solution
Incorporate Disaster Recovery into Architectures
Design for Efficiency and Operations
Lessons
Maximizing the Efficiency of your Cloud Environment
Use Monitoring and Analytics to Gain Operational Insights
Use Automation to Reduce Effort and Error
Lab : Design for Efficiency and Operations
Maximize the Efficiency of your Cloud Environment
Use Monitoring and Analytics to Gain Operational Insights
Use Automation to Reduce Effort and Error