Azure Training Center | Azure Data Specialist | Azure Data Engineer | Azure Data Science | Instructor-Led Training from Opsgility

Azure Data Specialist

Microsoft Data Engineers design and implement the management, monitoring, security, and privacy of data using the full stack of Azure data services to satisfy business needs.

View Courses
What does an Data Specialist do?

A Microsoft Azure Data Specialist is responsible for designing and implementing the management, monitoring, security, and privacy of data using the full stack of Azure data services to satisfy business needs

What certifications are available?

Azure Data Specialist | Instructor-Led Courses

Course Details:
In this course students will gain the necessary knowledge about how to use Azure services to develop, train, and deploy, machine learning solutions. The course starts with an overview of Azure services that support data science. From there, it focuses on using Azure's premier data science service, Azure Machine Learning service, to automate the data science pipeline. This course is focused on Azure and does not teach the student how to do data science. It is assumed students already know that.

Outcome: 
Pass the DP-100 Designing and Implementing a Data Science Solution on Azure exam to be awarded the Microsoft Certified: Azure Data Scientist Associate certification.
Students learn how to develop data models that solve business problems using Azure technologies.

In this workshop, you will learn how to use advanced features of the managed PostgreSQL PaaS service on Azure to make your database more scalable and able to handle the rapid ingest of streaming data while simultaneously generating and serving pre-aggregated data for reports. You will design a resilient stream processing pipeline to ingest, process, and save real-time data to Postgres. Next, you will learn how to explore and gain insights from flat files at scale, perform aggregates, and save the valuable information to your database. Finally, you will create complex reports containing advanced visualizations, using a drag-and-drop interface, and use them to build a customizable dashboard that gets updated in real-time.
In this workshop, you will gain a better understanding of how new features of SQL Server 2019 enables more Big Data and analytics capabilities through the use of Big Data Clusters, data virtualization and orchestration, query processing enhancements, and through better scalability through distributed storage and compute.
IL - Implementing Delta Lake with Azure Databricks
Intermediate | 3 Days | more...

Students will examine Databricks Delta Lake for managing a data lake. Topics will include ingestion of streaming and batch data, managing data, optimizing query performance, and implementing data pipelines.

Additionally, students will cover integration with other Azure services such as storage, Data Factory and Azure Machine Learning.

IL - Performance Tuning with Azure Databricks
Intermediate | 3 Days | more...

This course will teach students how to troubleshoot and optimize Spark applications running on Azure Databricks. Students will learn performance best practices including data partitioning, caching, join optimization and other related techniques.

Students will first cover core internals of Spark and the Azure Databricks platform, they will then work through various hands-on troubleshooting tasks designed to hone their troubleshooting skills within Azure Databricks.

IL - Cosmos DB Deep Dive and Best Practices
Intermediate | 4 Days | more...

This deep dive into Cosmos DB explores all aspects of Cosmos DB. Foundational topics such as optimal use cases, system architecture and concurrency will be covered first.

Next students will dive into other advanced topics such as data modeling for document databases, partitioning, global distribution, request units and billing, programming and troubleshooting.

IL - Deconstructing Monolithic Applications
Intermediate | 1 Day | more...

In this course students will learn how to take a monolithic application and cannibalize it into microservices. Some of the scenarios discussed will involve when to use serverless architecture versus containerization services, such as Azure Functions and Kubernetes (K8s).

By the end of this course students should understand how to break down and migrate monolithic applications into microservices and choose the right Azure services.

IL - Introduction to IoT Edge
Intermediate | 2 Days | more...

In this course we will discuss how you can use IoT Edge can help run custom code and machine learning on devices. We will discuss features available, such as Cognitive Services and Azure Functions to deploy custom solutions.

We will also discuss monitoring using Application Insights and Azure IoT Edge Remote Monitoring Solution Accelerator. By the end of this course students should understand what features are available on IoT Edge and how to deploy those features.

IL - DP-050T00: Migrate SQL workloads to Azure
Intermediate | 2 Days | more...
In this course, the students will explore the objectives of data platform modernization and how it is suitable for given business requirements. They will also explore each stage of the data platform modernization process and define what tasks are involved at each stage, such as the assessment and planning phase. Students will also learn the available migration tools and how they are suitable for each stage of the data migration process. The student will learn how to migrate to the three target platforms for SQL based workloads; Azure Virtual Machines, Azure SQL Databases and Azure SQL Database Managed Instances. The student will learn the benefits and limitations of each target platform and how they can be used to fulfil both business and technical requirements for modern SQL workloads. The student will explore the changes that may need to be made to existing SQL based applications, so that they can make best use of modern data platforms in Azure.
This course will teach the students what is Cosmos DB and how you can migrate MongoDB and Cassandra workloads to Cosmos DB.
This course will enable the students to understand Azure SQL Database, and educate the students on what is required to migrate MySQL and PostgreSQL workloads to Azure SQL Database.
IL - Cloud Workshop: Migrating SQL databases to Azure
Intermediate | 1 Day | more...
In this workshop, you will work as a group to setup and configure a serverless architecture within Azure using a combination of Azure Functions, Logic Apps, Event Grid, Cosmos DB, and Azure Storage. The focus is on removing server management from the equation, breaking down the solution into smaller components that are individually scalable, and allowing the customer to only pay for what they use
IL - DP-200: Implementing an Azure Data Solution
Intermediate | 3 Days | more...

Course Details:
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 No-SQL data. They will also learn how to process data using a range of technologies and languages for both streaming and batch data. 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.

Outcome: 
Pass the DP-200 and DP-201 exams to be awarded the Microsoft Certified: Azure Data Engineer Associate certification.
Students learn how to develop data solutions using Azure technologies.
IL - DP-201: Designing an Azure Data Solution
Intermediate | 2 Days | more...

Course Details:
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, No-SQL or Data Warehouse data. They will also learn how to design process architectures using a range of technologies for both streaming and batch data. 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.

Outcome: 
Pass the DP-200 and DP-201 exams to be awarded the Microsoft Certified: Azure Data Engineer Associate certification.
Students learn how to design data solutions using Azure technologies.
In this hands-on course, students will learn about running SQL Server in Azure. This course will review basic Azure networking and storage using the Azure Resource Manager architecture to prepare students for building SQL Server solutions in Azure. The primary focus of this course is SQL Server cloud and hybrid-cloud solutions on both Azure Platform as a Service (PaaS) and Azure Infrastructure as a Service (IaaS). This course will cover best practices for deploying SQL Server on Azure Virtual Machines including standalone SQL Servers and hybrid Availability Groups. The course will look at SQL Server features that take advantage of Azure Storage such as SQL Server Managed Backup, Azure Snapshot Backups, and SQL Server data files hosted on Azure Storage. Finally, this course will provide you with an introduction to Azure SQL Database and archiving cold data with SQL Server Stretch Database. This course can help prepare you for the exam: 70-473 Designing and Implementing Cloud Data Platform Solutions.
This three-day instructor-led course is aimed at database professionals who are looking to implement a Cosmos DB solution.
This course covers all aspects of Azure SQL Database performance. This course will cover the performance monitoring and troubleshooting tools available in Azure SQL Database. We will cover designing performant databases in Azure SQL Database, leveraging in-memory and columnstore technologies. Finally, we will wrap up by discussing elastic database pools and the special challenges they bring to monitoring and tuning performance
IL - Power BI for Data Professionals
Intermediate | 2 Days | more...
This course builds on your Power BI skills and walks you through the interfaces of both the Online and Desktop offerings before embarking on a journey that will show you how to ingest data, transform data, create reports and dashboards before publishing and using your data sets, reports and dashboards in the Power BI online tenant.

The course will prepare students to take the Microsoft 70-778, Analyzing and Visualizing Data with Power BI certification exam.


IL - Apache Spark Programming with Azure Databricks
Intermediate | 3 Days | more...
In this course, you will explore the Spark Internals and Architecture of Azure Databricks. The course will start with a brief introduction to Scala. Using the Scala programming language, you will be introduced to the core functionalities and use cases of Azure Databricks including Spark SQL, Spark Streaming, MLlib, and GraphFrames.
IL - Azure Big Data and Analytics Boot Camp
Intermediate | 5 Days | more...

The Azure Big Data and Analytics Boot camp is designed to give students a clear architectural understanding of the application of big data patterns in Azure. Students will participate in team based architectural planning and hands-on implementation sessions.  Students will be taught basic Lambda architecture patterns in Azure, leveraging the scalability and elasticity of Azure in Big Data and IoT solutions.
An introduction to data science techniques in Azure will also be covered.  Individual case studies will focus on specific real-world problems that represent common big data patterns and practices. Students will also experience several hands-on labs to introduce them to some of the key services available. 

IL - Big Data and Machine Learning (ML)
Intermediate | 3 Days | more...

The Azure Big Data and Machine Learning Bootcamp is designed to give students a clear architectural understanding of the application of big data patterns in Azure. Students will participate in team based architectural planning and hands-on implementation sessions.  Students will be taught basic Lambda architecture patterns in Azure, leveraging the scalability and elasticity of Azure in Big Data and IoT solutions.

An introduction to data science techniques in Azure will also be covered.  Individual case studies will focus on specific real-world problems that represent common big data patterns and practices. Students will also experience several hands-on labs to introduce them to some of the key services available. 

Format: Instructor-led with hands-on labs and whiteboard design sessions

In this hands-on course, students will learn about running SQL Server in Azure. This course will review basic Azure networking and storage using the Azure Resource Manager architecture to prepare students for building SQL Server solutions in Azure. The primary focus of this course is SQL Server cloud and hybrid-cloud solutions on both Azure Platform as a Service (PaaS) and Azure Infrastructure as a Service (IaaS). This course will cover best practices for deploying SQL Server on Azure Virtual Machines including standalone SQL Servers and hybrid Availability Groups. The course will look at SQL Server features that take advantage of Azure Storage such as SQL Server Managed Backup, Azure Snapshot Backups, and SQL Server data files hosted on Azure Storage. Finally this course will provide you with an introduction to Azure SQL Database and archiving cold data with SQL Server Stretch Database.



IL - MOC 20778: Analyzing Data with Power BI
Intermediate | 2 days | more...
The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.Audience profileThe course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data. At course completion

A cloud workshop is a 1-day event that consists of an overview of the technology, a deep dive whiteboard design session and Hands-on lab where participants will a subset of the solution.



In this Workshop you will learn how to upgrade from Oracle Databases and earlier SQL Server Databases to SQL Server 2016 and Azure SQL DB.  SQL Server 2016 on Windows Server 2016 (and now also available on Linux) will offer higher availability, greater performance and faster analytics.  SQL Server 2016 and Azure DB supports virtually any data, of any size, with any application on any platform. SQL Server 2016 also boasts the fastest In-Memory technology on the planet across workloads helping customers to take performance and throughput to another level. It is also possible to build a hybrid data platform with frequently accessed data in SQL Server 2016 and less frequently accessed data in Azure’s SQL Database. Attend this workshop to upgrade to these latest versions to take advantage of these benefits to increase protection from security vulnerabilities. This workshop includes: Whiteboard design session and Hands-on lab

A cloud workshop is a 1-day event that consists of an overview of the technology, a deep dive whiteboard design session and Hands-on lab where participants will a subset of the solution.



In this workshop, attendees will migrate a retail chain to from an existing data warehouse from an on-premises SQL Server into Azure SQL Data Warehouse. Prepare a detailed migration plan including data preparation, importing data into Azure SQL Data Warehouse, and architecting a data orchestration strategy to move data from the existing on-premises source systems to Azure SQL Data Warehouse. This workshop includes: Whiteboard design session and Hands-on lab

IL - Cloud Workshop: SQL Server hybrid cloud
Advanced | 1 Day | more...

A cloud workshop is a 1-day event that consists of an overview of the technology, a deep dive whiteboard design session and Hands-on lab where participants will a subset of the solution.



In this workshop, students will work with a media publishing company to design a hybrid cloud disaster recovery solution. Students will design the solution to handle large spikes in load and harden the security to include encryption of PCI data. Additionally students will implement an archival strategy to keep databases sizes in check. This workshop will include: Whiteboard design session.

IL - Cloud Workshop: Intelligent analytics
Advanced | 1 Day | more...

A cloud workshop is a 1-day event that consists of an overview of the technology, a deep dive whiteboard design session and Hands-on lab where participants will a subset of the solution.



In this workshop, attendees will learn real-time analytics without IoT. Enable intelligent conversation in a machine learning-enabled, real-time chat pipeline and apply analytics to visualize customer sentiment in real-time for hospitals to allow guests to chat with one another, and to communicate directly with the concierge. This workshop includes: Whiteboard design session and Hands-on lab

IL - Cloud Workshop: Intelligent vending machines
Advanced | 1 Day | more...

A cloud workshop is a 1-day event that consists of an overview of the technology, a deep dive whiteboard design session and Hands-on lab where participants will a subset of the solution.



In this workshop, attendees will implement an IoT solution for intelligent vending machines leveraging Facial feature recognition and Machine learning to drive on-demand pricing, enable real-time analytics, and cloud to device messaging flows. Learn how to create Machine Learning models in R, train the models at scale using R and Spark on HDInsight, then expose the model as a web service through R Server Operationalization. You will use IoT Hub to facilitate vending machine device registration and communication for product promotions, and enable real-time analytics with SQL Database in-memory and columnar indexing. This workshop includes: Whiteboard design session and Hands-on lab

This course will look at the process of migrating workloads to Azure. You will leave with the information needed to develop a solid migration plan to keep mission-critical apps and data protected as your customers transition and modernize their application, data, and infrastructure environment.