Objectives of the training
This training course will introduce you to data engineering models and practices as part of real-time and batch analytic solutions using Azure data platform technologies.Targeted audience
This training is aimed at data professionals, data architects and business intelligence professionals who want to learn about data engineering and the creation of analytical solutions using the data platform technologies available on Microsoft Azure. The secondary audience for this training is Data Analysts and Data Scientists working with analytical solutions built on Microsoft Azure.Prerequisite
Upon completion of the course, participants will be able to:• Explore compute and storage options for data engineering workloads in Azure
• Execute interactive queries using serverless SQL pools
• Perform data exploration and transformation in Azure Databricks
• Explore, transform and load data into the data warehouse using Apache Spark
• Ingest and load data into the data warehouse
• Transform data with Azure Data Factory or Azure Synapse Pipelines
Trainers
Benefits for Participants
On completion of the course, participants will be able to :
Plan, deploy and configure Azure SQL offerings
Explain how to monitor database performance and set up a database and queries for optimal performance.
Course architecture
Getting started with data engineering in Azure
Overview of data engineering in Azure
Overview of Azure Data Lake Storage Gen2
Overview of Azure Synapse Analytics
Creating data analytics solutions with Azure Synapse serverless SQL pools
Using an Azure Synapse serverless SQL pool to query files in a data lake
Using Azure Synapse serverless SQL pools to transform data in a data lake
Creating a database lake in Azure Synapse Analytics
Secure data and manage users in Azure Synapse SQL serverless pools
Applying data engineering with Azure Synapse Apache Spark pools
Analyze data with Apache Spark in Azure Synapse Analytics
Transforming data with Spark in Azure Synapse Analytics
Using Delta Lake in Azure Synapse Analytics
Using data warehouses with Azure Synapse Analytics
Analyzing data in a relational data warehouse
Loading data into a relational data warehouse
Manage and supervise data warehouse activities in Azure Synapse Analytics
Analyze and optimize data warehouse storage in Azure Synapse Analytics
Secure a data warehouse in Azure Synapse Analytics
Transfer and transform data with Azure Synapse Analytics pipelines
Creating a data pipeline in Azure Synapse Analytics
Using Spark notebooks in an Azure Synapse pipeline.
Pedagogical details
Type of training
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quotePrivate or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote