Loading...

Terminy kursów:

20.09.2021 - 23.09.2021
22.11.2021 - 25.11.2021

Oficjalny konspekt Microsoft Pozostałe szkolenia

DP-203 Data Engineering on Microsoft Azure

Czas trwania kursu: 4 dni
Cena: 2899 zł netto

CERTYFIKACJE ZAWODOWE

Certyfikacja podstawowa CertyfIkacja specjalistyczna Certyfikacja ekspercka
FUNDAMENTALS ASSOCIATE EXPERT

 


POZIOM SZKOLENIA

podstawowy średniozaawansowany zaawansowany ekspercki
100 200 300 400

 

TEMATYKA ZAJĘĆ

  • Module 1: Explore compute and storage options for data engineering workloads
    Introduction to Azure Synapse Analytics
    Describe Azure Databricks
    Introduction to Azure Data Lake storage
    Describe Delta Lake architecture
    Work with data streams by using Azure Stream Analytics
    Lab : Explore compute and storage options for data engineering workloads

 

  • Module 2: Design and implement the serving layer
    Design a multidimensional schema to optimize analytical workloads
    Code-free transformation at scale with Azure Data Factory
    Populate slowly changing dimensions in Azure Synapse Analytics pipelines
    Lab : Designing and Implementing the Serving Layer

 

  • Module 3: Data engineering considerations for source files
    Design a Modern Data Warehouse using Azure Synapse Analytics
    Secure a data warehouse in Azure Synapse Analytics
    Lab : Data engineering considerations

 

  • Module 4: Run interactive queries using Azure Synapse Analytics serverless SQL pools
    Explore Azure Synapse serverless SQL pools capabilities
    Query data in the lake using Azure Synapse serverless SQL pools
    Create metadata objects in Azure Synapse serverless SQL pools
    Secure data and manage users in Azure Synapse serverless SQL pools
    Lab : Run interactive queries using serverless SQL pools

 

  • Module 5: Explore, transform, and load data into the Data Warehouse using Apache Spark
    Understand big data engineering with Apache Spark in Azure Synapse Analytics
    Ingest data with Apache Spark notebooks in Azure Synapse Analytics
    Transform data with DataFrames in Apache Spark Pools in Azure Synapse Analytics
    Integrate SQL and Apache Spark pools in Azure Synapse Analytics
    Lab : Explore, transform, and load data into the Data Warehouse using Apache Spark

 

  • Module 6: Data exploration and transformation in Azure Databricks
    Describe Azure Databricks
    Read and write data in Azure Databricks
    Work with DataFrames in Azure Databricks
    Work with DataFrames advanced methods in Azure Databricks
    Lab : Data Exploration and Transformation in Azure Databricks

 

  • Module 7: Ingest and load data into the data warehouse
    Use data loading best practices in Azure Synapse Analytics
    Petabyte-scale ingestion with Azure Data Factory
    Lab : Ingest and load Data into the Data Warehouse

 

  • Module 8: Transform data with Azure Data Factory or Azure Synapse Pipelines
    Data integration with Azure Data Factory or Azure Synapse Pipelines
    Code-free transformation at scale with Azure Data Factory or Azure Synapse Pipelines
    Lab : Transform Data with Azure Data Factory or Azure Synapse Pipelines

 

  • Module 9: Orchestrate data movement and transformation in Azure Synapse Pipelines
    Orchestrate data movement and transformation in Azure Data Factory
    Lab : Orchestrate data movement and transformation in Azure Synapse Pipelines

 

  • Module 10: Optimize query performance with dedicated SQL pools in Azure Synapse
    Optimize data warehouse query performance in Azure Synapse Analytics
    Understand data warehouse developer features of Azure Synapse Analytics
    Lab : Optimize Query Performance with Dedicated SQL Pools in Azure Synapse

 

  • Module 11: Analyze and Optimize Data Warehouse Storage
    Analyze and optimize data warehouse storage in Azure Synapse Analytics
    Lab : Analyze and Optimize Data Warehouse Storage

 

  • Module 12: Support Hybrid Transactional Analytical Processing (HTAP) with Azure Synapse Link
    Design hybrid transactional and analytical processing using Azure Synapse Analytics
    Configure Azure Synapse Link with Azure Cosmos DB
    Query Azure Cosmos DB with Apache Spark pools
    Query Azure Cosmos DB with serverless SQL pools
    Lab : Support Hybrid Transactional Analytical Processing (HTAP) with Azure Synapse Link

 

  • Module 13: End-to-end security with Azure Synapse Analytics
    Secure a data warehouse in Azure Synapse Analytics
    Configure and manage secrets in Azure Key Vault
    Implement compliance controls for sensitive data
    Lab : End-to-end security with Azure Synapse Analytics

 

  • Module 14: Real-time Stream Processing with Stream Analytics
    Enable reliable messaging for Big Data applications using Azure Event Hubs
    Work with data streams by using Azure Stream Analytics
    Ingest data streams with Azure Stream Analytics
    Lab : Real-time Stream Processing with Stream Analytics

 

  • Module 15: Create a Stream Processing Solution with Event Hubs and Azure Databricks
    Process streaming data with Azure Databricks structured streaming
    Lab :Create a Stream Processing Solution with Event Hubs and Azure Databricks

 

  • Module 16: Build reports using Power BI integration with Azure Synpase Analytics
    Create reports with Power BI using its integration with Azure Synapse Analytics
    Lab :Build reports using Power BI integration with Azure Synpase Analytics

 

  • Module 17: Perform Integrated Machine Learning Processes in Azure Synapse Analytics
    Use the integrated machine learning process in Azure Synapse Analytics
    Lab : Perform Integrated Machine Learning Processes in Azure Synapse Analytics

AZ-040 Automating Administration with PowerShell
11.10.2021 - 15.10.2021
AZ-700 Designing and Implementing Microsoft Azure Networking Solutions
04.10.2021 - 06.10.2021
MS-55215 SharePoint Online Power User
13.09.2021 - 16.09.2021
DP-080 Querying Data with Microsoft Transact-SQL
13.09.2021 - 13.09.2021
DP-203 Data Engineering on Microsoft Azure
20.09.2021 - 23.09.2021
AZ-140 Configuring and operating Windows Virtual Desktop on Microsoft Azure
10.05.2021 - 13.05.2021
AI-102 Designing and Implementing a Microsoft Azure AI Solution
27.09.2021 - 30.09.2021
SC-900 Security, Compliance, and Identity Fundamentals
06.09.2021 - 06.09.2021
SC-200 Microsoft Security Operations Analyst
10.05.2021 - 13.05.2021
SC-300 Microsoft Identity and Access Administrator
27.09.2021 - 30.09.2021
SC-400 Microsoft Information Protection Administrator
13.09.2021 - 14.09.2021
MS-55281 SharePoint Online Branding
22.03.2021 - 22.03.2021
MS-55300 Microsoft Teams for End Users
05.03.2021 - 05.03.2021
MS-55133 PowerShell for System Center Configuration Manager Administrators
08.03.2021 - 10.03.2021
MS-10984 Deploying and Managing Office 365 Hybrid Deployments
26.10.2020 - 28.10.2020
DP-300 Administering Relational Databases on Microsoft Azure
12.10.2020 - 15.10.2020
MS-203 Microsoft 365 Messaging
19.10.2020 - 23.10.2020
DP-900 Microsoft Azure Data Fundamentals
12.10.2020 - 12.10.2020
WS-012 Windows Server 2019 Hybrid and Azure IaaS
11.01.2021 - 13.01.2021
WS-011 Windows Server 2019 Administration
07.09.2020 - 11.09.2020
AZ-304 Microsoft Azure Architect Design
08.02.2021 - 11.02.2021
AZ-303 Microsoft Azure Architect Technologies
08.02.2021 - 12.02.2021
DA-100 Analyzing Data with Power BI
05.10.2020 - 08.10.2020
MS-050 SharePoint Hybrid Deployment and Migration
26.10.2020 - 30.10.2020
MS-040 Manage SharePoint and OneDrive in Microsoft 365
05.10.2020 - 07.10.2020
AI-900 Microsoft Azure AI Fundamentals
04.09.2020 - 04.09.2020
AZ-400 Designing and Implementing Microsoft DevOps solutions
24.08.2020 - 28.08.2020
MS-500 Microsoft 365 Security Administration
15.06.2020 - 18.06.2020
AZ-104 Microsoft Azure Administrator
06.04.2021 - 09.04.2021
DP-070 Migrate Open Source Data Workloads to Azure
30.06.2020 - 30.06.2020
AZ-204 Developing Solutions for Microsoft Azure
15.06.2020 - 19.06.2020
PL-900 Microsoft Power Platform Fundamentals
24.08.2020 - 25.08.2020
MS-10990 Analyzing Data with SQL Server Reporting Services
22.06.2020 - 26.06.2020
MS-10988 Managing SQL Business Intelligence Operations
01.07.2020 - 03.07.2020
DP-060 Migrate NoSQL workloads to Azure Cosmos DB
31.08.2020 - 31.08.2020
DP-050 Migrate SQL workloads to Azure
27.09.2021 - 28.09.2021
MS-700 Managing Microsoft Teams
15.06.2020 - 19.06.2020
MS-600 Building applications and solutions with Microsoft 365 core services
21.09.2020 - 25.09.2020
AZ-010 Azure Administration for AWS SysOps
07.09.2020 - 08.09.2020
MS-030 Office 365 Administrator
29.06.2020 - 03.07.2020
AZ-500 Microsoft Azure Security Technologies
15.03.2021 - 18.03.2021
DP-100 Designing and Implementing a Data Science Solution on Azure
29.06.2020 - 01.07.2020
MS-55039 Windows PowerShell Scripting and Toolmaking
01.02.2021 - 05.02.2021
DP-201 Designing an Azure Data Solution
09.07.2020 - 10.07.2020
MD-101 Managing Modern Desktops
21.09.2020 - 25.09.2020
DP-200 Implementing an Azure Data Solution
31.08.2020 - 02.09.2020
AI-100 Designing and Implementing an Azure AI Solution
26.08.2020 - 28.08.2020
MD-100 Windows 10
20.07.2020 - 24.07.2020
MS-900 Microsoft 365 Fundamentals
27.09.2021 - 27.09.2021
AZ-900 Microsoft Azure Fundamentals
03.09.2020 - 04.09.2020
MS-10987 Performance Tuning and Optimizing SQL Databases
15.03.2021 - 18.03.2021
MS-101 Microsoft 365 Mobility and Security
04.10.2021 - 07.10.2022
MS-100 Microsoft 365 Identity and Services
27.09.2021 - 01.10.2021
MS-40551 Microsoft Security Workshop: Enterprise Security Fundamentals
MS-40555 Microsoft Security Workshop: Implementing PowerShell Security Best Practices
Microsoft Security Workshop
18.05.2020 - 22.05.2020
MS-20467 Designing Business Intelligence Solutions with Microsoft SQL Server 2014
SQL Server 2012/2014
07.09.2020 - 11.09.2020
MS-20466 Implementing Data Models and Reports with SQL Server 2014
SQL Server 2012/2014
24.08.2020 - 28.08.2020
MS-20465 Designing Solutions for Microsoft SQL Server 2014
SQL Server 2012/2014
28.09.2020 - 02.10.2020
MS-20464 Developing Microsoft SQL Server 2014 Databases
SQL Server 2012/2014
30.11.2020 - 04.12.2020
MS-10986 Updating Your Skills to SQL Server 2016
SQL Server 2016
14.09.2020 - 16.09.2020
MS-10985 Introduction to SQL Databases
SQL Server 2012/2014
26.10.2020 - 28.10.2020
MS-10994 Data Analysis Fundamentals using Excel
SQL Server 2016
27.08.2020 - 28.08.2020
MS-20537 Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack
MCSA
21.09.2020 - 25.09.2020
MS-55224-2 Operationalize Cloud Analytics Solutions with Microsoft Azure
MCSE
07.09.2020 - 08.09.2020
MS-55224-1 Microsoft Azure Big Data Analytics Solutions
SQL Server 2016
29.10.2020 - 30.10.2020
MS-20779 Analyzing Data with Excel
SQL Server 2016
26.08.2020 - 28.08.2020
MS-20417 Upgrading Your Skills to MCSA Windows Server 2012
Windows Server 2012/2012R2
24.08.2020 - 28.08.2020
MS-20414 Implementing an Advanced Server Infrastructure
Windows Server 2012/2012R2
07.09.2020 - 11.09.2020
MS-20413 Designing and Implementing a Server Infrastructure
Windows Server 2012/2012R2
31.08.2020 - 04.09.2020
MS-10982 Supporting and Troubleshooting Windows 10
Windows 10
22.03.2021 - 26.03.2021
MS-20412 Configuring Advanced Windows Server 2012 Services
Windows Server 2012/2012R2
05.10.2020 - 09.10.2020
MS-20411 Administering Windows Server 2012
Windows Server 2012/2012R2
12.10.2020 - 16.10.2020
MS-20410 Installing and Configuring Windows Server 2012
Windows Server 2012/2012R2
07.09.2020 - 11.09.2020
MS-55200 SharePoint 2016 Power User Training
SharePoint 2016
05.10.2020 - 09.10.2020
MS-55199 SharePoint 2016 End User Training
SharePoint 2016
07.09.2020 - 11.09.2020
MS-20745 Implementing a Software-Defined DataCenter
System Center
17.08.2020 - 21.08.2020
MS-10997 Office 365 Administration and Troubleshooting
Office 365
22.02.2021 - 24.02.2021
MS-20703-1 Administering System Center Configuration Manager
System Center
04.10.2021 - 08.10.2021
MS-55247 Designing and Implementing Cloud Data Platform Solutions
14.12.2020 - 18.12.2020
MS-20487 Developing Windows Azure and Web Services
Programowanie
07.12.2020 - 11.12.2020
MS-20486 Developing ASP.NET MVC 4 Web Applications
Programowanie
17.08.2020 - 21.08.2020
MS-20483 Programming in C#
Programowanie
31.08.2020 - 04.09.2020
MS-20480 Programming in HTML5 with JavaScript and CSS3
Programowanie
24.08.2020 - 28.08.2020
MS-10962 Advanced Automated Administration with Windows PowerShell
MCSA
24.08.2020 - 26.08.2020
MS-55154 Office 365 for the End-User
Office 365
09.07.2020 - 09.07.2020
MS-55179 Advanced Microsoft Outlook 2016
01.09.2020 - 01.09.2020
MS-55178 Introduction to Microsoft Outlook 2016
02.09.2020 - 02.09.2020
MS-55177 Advanced Microsoft PowerPoint 2016
PowerPoint 2016
03.09.2020 - 03.09.2020
MS-55176 Introduction to Microsoft PowerPoint 2016
PowerPoint 2016
04.09.2020 - 04.09.2020
MS-55167 Advanced Microsoft Excel 2016
Excel 2016
07.09.2020 - 07.09.2020
MS-55166 Intermediate Microsoft Excel 2016
Excel 2016
08.09.2020 - 08.09.2020
MS-55165 Introduction to Microsoft Excel 2016
Excel 2016
09.09.2020 - 09.09.2020
MS-55175 Advanced Microsoft Word 2016
Word 2016
10.09.2020 - 10.09.2020
MS-55174 Intermediate Microsoft Word 2016
Word 2016
14.09.2020 - 14.09.2020
MS-55173 Introduction to Microsoft Word 2016
Word 2016
15.09.2020 - 15.09.2020
MCSA: Windows Server 2016 (wzbogacony o elementy Windows Server 2019) – online
MCSA
14.10.2020 - 20.01.2021
MS-20768 Developing SQL Data Models
SQL Server 2016
02.09.2020 - 04.09.2020
MS-20767 Implementing a SQL Data Warehouse
SQL Server 2016
15.02.2021 - 19.02.2021
MS-20334 Core Solutions of Skype for Business 2015/2019
Skype for Business 2015
28.09.2020 - 02.10.2020
MS-20744 Securing Windows Server 2016
Windows Server 2016
28.09.2020 - 02.10.2020
MS-10964 Cloud & Datacenter Monitoring with System Center Operations Manager
System Center
24.08.2020 - 28.08.2020
MS-55004 Installing and Configuring System Center 2012 Operations Manager
System Center
28.09.2020 - 02.10.2020
MS-20765 Provisioning SQL Databases
SQL Server 2016
21.09.2020 - 25.09.2020
MS-20764 Administering a SQL Database Infrastructure
SQL Server 2016
01.03.2021 - 05.03.2021
MS-20762 Developing SQL Databases
SQL Server 2016
05.10.2020 - 09.10.2020
MS-20761 Querying Data with Transact-SQL
SQL Server 2016
12.10.2020 - 16.10.2020
MS-20339-2 Advanced Technologies of SharePoint 2016
SharePoint 2016
28.09.2020 - 02.10.2020
MS-20339-1 Planning and Administering SharePoint 2016
SharePoint 2016
05.10.2020 - 09.10.2020
MS-20741 Networking with Windows Server 2016
Windows Server 2016
04.10.2021 - 08.10.2021
MS-20740 Installation, Storage, and Compute with Windows Server 2016
Windows Server 2016
25.01.2021 - 29.01.2021
MS-20742 Identity with Windows Server 2016
Windows Server 2016
12.10.2020 - 16.10.2020
MS-20345-2 Designing and Deploying Microsoft Exchange Server 2016/2019
Exchange Server 2016/2019
21.09.2020 - 25.09.2020
MS-20345-1 Administering Microsoft Exchange Server 2016/2019
Exchange Server 2016/2019
05.10.2020 - 09.10.2020
MS-20743 Upgrading Your Skills to MCSA: Windows Server 2016
Windows Server 2016
05.10.2020 - 09.10.2020
MS-10972 Administering the Web Server (IIS) Role of Windows Server
Windows Server 2012/2012R2
04.10.2021 - 08.10.2021
MS-10967 Fundamentals of a Windows Server Infrastructure
Windows Server 2012/2012R2
07.09.2020 - 11.09.2020
MS-10969 Active Directory Services with Windows Server
Windows Server 2012/2012R2
27.07.2020 - 31.07.2020
MS-20488 Developing Microsoft SharePoint Server 2013 Core Solutions
SharePoint 2013
26.10.2020 - 30.10.2020
MS-20332 Advanced Solutions of Microsoft SharePoint Server 2013
SharePoint 2013
31.08.2020 - 04.09.2020
MS-20331 Core Solutions of Microsoft SharePoint Server 2013
SharePoint 2013
28.09.2020 - 02.10.2020
Bezpieczeństwo Microsoft Azure, Office 365 oraz Intune
Microsoft Azure / Office 365 / Windows Intune
28.09.2020 - 30.09.2020
Automatyzacja zabezpieczeń w środowiskach Windows 10 oraz Windows Server 2016
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
19.10.2020 - 23.10.2020
Bezpieczeństwo w środowiskach Windows 10 oraz Windows Server 2016
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
07.04.2021 - 09.04.2021
Podstawy bezpieczeństwa w środowiskach Microsoft
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
17.08.2020 - 19.08.2020
MS-10961 Automating Administration with Windows PowerShell
MCSA
12.04.2021 - 16.04.2021
MS-20341 Core Solutions of Microsoft Exchange Server 2013
Exchange Server 2013
07.09.2020 - 11.09.2020
MS-10748 Planning and Deploying System Center 2012 Configuration Manager
System Center
26.10.2020 - 28.10.2020
MS-20463 Implementing a Data Warehouse with Microsoft SQL Server
SQL Server 2012/2014
31.08.2020 - 04.09.2020
MS-20462 Administering Microsoft SQL Server Databases
SQL Server 2012/2014
28.09.2020 - 02.10.2020
MS-20461 Querying Microsoft SQL Server
SQL Server 2012/2014
07.09.2020 - 11.09.2020