Loading...

Terminy kursów:

09.10.2023 - 12.10.2023
06.11.2023 - 09.11.2023
04.12.2023 - 07.12.2023

Oficjalny konspekt Microsoft Pozostałe szkolenia

DP-300 Administering Microsoft Azure SQL Solutions

Czas trwania kursu: 4 dni
Cena: 2999 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: The Role of the Azure Database Administrator
    Azure Data Platform Roles
    Azure Database Platforms and Options
    SQL Server Compatibility Levels
    Azure Preview Features
    Lab: Using the Azure Portal and SQL Server Management Studio

 

  • Module 2: Plan and Implement Data Platform Resources
    Deploying SQL Server using IaaS
    Deploying SQL Server using PaaS
    Deploying Open Source Database Solutions on Azure
    Lab: Deploying Azure SQL Database

 

  • Module 3: Implement a Secure Environment
    Configure Database Authentication
    Configure Database Authorization
    Implement Security for Data at Rest
    Implement Security for Data in Transit
    Implement Compliance Controls for Sensitive Data
    Lab: Implement a Secure Environment

 

  • Module 4: Monitor and Optimize Operational Resources
    Baselines and Performance Monitoring
    Major Causes of Performance Issues
    Configuring Resources for Optimal Performance
    User Database Configuration
    Performance-related Maintenance Tasks
    Lab: Monitor and Optimize Resources

 

  • Module 5: Optimize Query Performance
    Understanding SQL Server Query Plans
    Explore Performance-based Database Design
    Evaluate Performance Improvements
    Lab: Query Performance Troubleshooting

 

  • Module 6: Automation of Tasks
    Setting up Automatic Deployment
    Defining Scheduled Tasks
    Managing Azure PaaS resources Using Automated Methods
    Lab: Automating Tasks

 

  • Module 7: Plan and Implement a High Availability and Disaster Recovery Environment
    High Availability and Disaster Recovery Strategies
    IaaS Platform and Database Tools for HADR
    PaaS Platform and Database Tools for HADR
    Database Backup and Recovery
    Lab: Plan and Implement a High Availability and Disaster Recovery Environment

Wdrażanie i konfiguracja Windows 10 w środowisku domenowym
21.08.2023 - 25.08.2023
MS-55341 Installation, Storage, and Compute with Windows Server (dawniej MS-20740)
21.08.2023 - 25.08.2023
MS-55337 Introduction to Programming
26.06.2023 - 30.06.2023
MS-55238 SharePoint Online for Administrators
20.04.2023 - 21.04.2023
MS-55244 Javascript for Developers (dawniej MS-20480)
26.06.2023 - 30.06.2023
MS-55320 Programming with HTML, CSS, and JavaScript (dawniej MS-20480)
04.09.2023 - 08.09.2023
MS-55348AC Administering Microsoft Endpoint Configuration Manager (dawniej MS-20703-1)
21.11.2022 - 25.11.2022
MS-55349 Networking with Windows Server 2016 (dawniej MS-20741)
26.06.2023 - 30.06.2023
PL-300 Microsoft Power BI Data Analyst
19.06.2023 - 21.06.2023
AZ-801 Configuring Windows Server Hybrid Advanced Services
21.08.2023 - 24.08.2023
AZ-800 Administering Windows Server Hybrid Core Infrastructure
19.06.2023 - 22.06.2023
DP-420 Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB
19.06.2023 - 22.06.2023
ASP.NET MVC Core
04.09.2023 - 08.09.2023
SQL SERVER – WYSOKA DOSTĘPNOŚĆ
19.06.2023 - 23.06.2023
AZ-305 Designing Microsoft Azure Infrastructure Solutions
19.06.2023 - 22.06.2023
AZ-030 Microsoft Azure technologies for AWS architects
28.08.2023 - 31.08.2023
AZ-020 Microsoft Azure solutions for AWS developers
26.06.2023 - 28.06.2023
DP-090 Implementing a Machine Learning Solution with Microsoft Azure Databricks
23.06.2023 - 23.06.2023
PL-400 Microsoft Power Platform Developer
19.06.2023 - 23.06.2023
PL-600 Microsoft Power Platform Solution Architect
04.09.2023 - 06.09.2023
PL-200 Microsoft Power Platform Functional Consultant
28.08.2023 - 31.08.2023
PL-100 Microsoft Power Platform App Maker
04.09.2023 - 06.09.2023
AZ-220 Microsoft Azure IoT Developer
19.06.2023 - 22.06.2023
WS-050 Migrating Application Workloads to Azure
28.08.2023 - 29.08.2023
AZ-600 Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack Hub
28.08.2023 - 31.08.2023
AZ-040 Automating Administration with PowerShell
21.08.2023 - 25.08.2023
AZ-700 Designing and Implementing Microsoft Azure Networking Solutions
19.06.2023 - 21.06.2023
MS-55215 SharePoint Online Power User
19.06.2023 - 22.06.2023
DP-080 Querying Data with Microsoft Transact-SQL
26.06.2023 - 27.06.2023
DP-203 Data Engineering on Microsoft Azure
19.06.2023 - 22.06.2023
AZ-140 Configuring and Operating Microsoft Azure Virtual Desktop
21.08.2023 - 24.08.2023
AI-102 Designing and Implementing a Microsoft Azure AI Solution
21.08.2023 - 24.08.2023
SC-900 Security, Compliance, and Identity Fundamentals
26.06.2023 - 26.06.2023
SC-200 Microsoft Security Operations Analyst
28.08.2023 - 31.08.2023
SC-300 Microsoft Identity and Access Administrator
04.09.2023 - 07.09.2023
SC-400 Microsoft Information Protection Administrator
19.06.2023 - 20.06.2023
MS-55300 Microsoft Teams for End Users
26.06.2023 - 26.06.2023
MS-55133 PowerShell for System Center Configuration Manager Administrators
19.06.2023 - 21.06.2023
MS-10984 Deploying and Managing Office 365 Hybrid Deployments
21.08.2023 - 23.08.2023
DP-300 Administering Microsoft Azure SQL Solutions
26.06.2023 - 29.06.2023
MS-203 Microsoft 365 Messaging
28.08.2023 - 01.09.2023
DP-900 Microsoft Azure Data Fundamentals
23.06.2023 - 23.06.2023
WS-012 Windows Server 2019 Hybrid and Azure IaaS
28.08.2023 - 30.08.2023
MS-55371 Windows Server Administration (dawniej WS-011)
28.08.2023 - 01.09.2023
AZ-304 Microsoft Azure Architect Design
28.08.2023 - 31.08.2023
AZ-303 Microsoft Azure Architect Technologies
21.08.2023 - 25.08.2023
MS-050 SharePoint Hybrid Deployment and Migration
26.06.2023 - 30.06.2023
AI-900 Microsoft Azure AI Fundamentals
23.06.2023 - 23.06.2023
AZ-400 Designing and Implementing Microsoft DevOps solutions
26.06.2023 - 29.06.2023
MS-500 Microsoft 365 Security Administration
28.08.2023 - 31.08.2023
AZ-104 Microsoft Azure Administrator
26.06.2023 - 29.06.2023
DP-070 Migrate Open Source Data Workloads to Azure
01.09.2023 - 01.09.2023
AZ-204 Developing Solutions for Microsoft Azure
26.06.2023 - 30.06.2023
PL-900 Microsoft Power Platform Fundamentals
01.09.2023 - 01.09.2023
MS-10990 Analyzing Data with SQL Server Reporting Services
21.08.2023 - 25.08.2023
MS-10988 Managing SQL Business Intelligence Operations
28.06.2023 - 30.06.2023
DP-060 Migrate NoSQL workloads to Azure Cosmos DB
30.06.2023 - 30.06.2023
DP-050 Migrate SQL workloads to Azure
19.06.2023 - 20.06.2023
MS-700 Managing Microsoft Teams
26.06.2023 - 29.06.2023
MS-600 Building applications and solutions with Microsoft 365 core services
26.06.2023 - 30.06.2023
AZ-010 Azure Administration for AWS SysOps
28.08.2023 - 29.08.2023
MS-55354 Administering Office 365 (dawniej MS-030)
26.06.2023 - 30.06.2023
AZ-500 Microsoft Azure Security Technologies
28.08.2023 - 31.08.2023
DP-100 Designing and Implementing a Data Science Solution on Azure
21.08.2023 - 23.08.2023
MS-55039 Windows PowerShell Scripting and Toolmaking
21.08.2023 - 25.08.2023
MD-101 Managing Modern Desktops
26.06.2023 - 30.06.2023
MD-100 Windows Client
19.06.2023 - 23.06.2023
MS-900 Microsoft 365 Fundamentals
19.06.2023 - 19.06.2023
AZ-900 Microsoft Azure Fundamentals
31.08.2023 - 01.09.2023
MS-10987 Performance Tuning and Optimizing SQL Databases
26.06.2023 - 29.06.2023
MS-101 Microsoft 365 Mobility and Security
19.06.2023 - 23.06.2023
MS-100 Microsoft 365 Identity and Services
26.06.2023 - 30.06.2023
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
26.06.2023 - 30.06.2023
MS-20465 Designing Solutions for Microsoft SQL Server 2014
SQL Server 2012/2014
28.06.2023 - 30.06.2023
MS-20464 Developing Microsoft SQL Server 2014 Databases
SQL Server 2012/2014
21.08.2023 - 25.08.2023
MS-10986 Updating Your Skills to SQL Server 2016
SQL Server 2016
28.08.2023 - 30.08.2023
MS-55315 Introduction to SQL Databases (dawniej MS-10985)
SQL Server 2012/2014
04.09.2023 - 06.09.2023
MS-10994 Data Analysis Fundamentals using Excel
SQL Server 2016
31.08.2023 - 01.09.2023
MS-20779 Analyzing Data with Excel
SQL Server 2016
21.06.2023 - 23.06.2023
MS-55345 Implementing and Managing Windows 11 (dawniej MS-20697-1)
Windows 10
26.06.2023 - 30.06.2023
MS-55342 Supporting and Troubleshooting Windows 11 (dawniej MS-10982)
Windows 10
26.06.2023 - 30.06.2023
MS-55200 SharePoint 2016 Power User Training
SharePoint 2016
31.08.2023 - 01.09.2023
MS-55199 SharePoint 2016 End User Training
SharePoint 2016
26.06.2023 - 28.06.2023
MS-20745 Implementing a Software-Defined DataCenter
System Center
04.09.2023 - 08.09.2023
MS-10997 Office 365 Administration and Troubleshooting
Office 365
04.09.2023 - 06.09.2023
MS-55313 Administering Configuration Manager, Part I: Fundamentals and Asset Management (część MS-20703-1 oraz MS-55348- podstawy)
System Center
28.08.2023 - 30.08.2023
MS-55247 Designing and Implementing Cloud Data Platform Solutions
19.06.2023 - 21.06.2023
MS-20487 Developing Windows Azure and Web Services
Programowanie
21.08.2023 - 25.08.2023
MS-20486 Developing ASP.NET MVC 4 Web Applications
Programowanie
28.08.2023 - 01.09.2023
MS-55339 Programming in C# (dawniej MS-20483)
Programowanie
26.06.2023 - 30.06.2023
MS-55319 HTML5 and CSS (dawniej MS-20480)
Programowanie
19.06.2023 - 23.06.2023
MS-55318 Advanced Automated Administration with Windows PowerShell (dawniej MS-10962)
MCSA
28.06.2023 - 30.06.2023
MS-55154 Office 365 for the End-User
Office 365
01.09.2023 - 01.09.2023
MS-55179 Advanced Microsoft Outlook 2016
26.06.2023 - 26.06.2023
MS-55178 Introduction to Microsoft Outlook 2016
23.06.2023 - 23.06.2023
MS-55177 Advanced Microsoft PowerPoint 2016
PowerPoint 2016
01.09.2023 - 01.09.2023
MS-55176 Introduction to Microsoft PowerPoint 2016
PowerPoint 2016
21.08.2023 - 21.08.2023
MS-55167 Advanced Microsoft Excel 2016
Excel 2016
26.06.2023 - 26.06.2023
MS-55166 Intermediate Microsoft Excel 2016
Excel 2016
19.06.2023 - 19.06.2023
MS-55165 Introduction to Microsoft Excel 2016
Excel 2016
23.06.2023 - 23.06.2023
MS-55175 Advanced Microsoft Word 2016
Word 2016
28.08.2023 - 28.08.2023
MS-55174 Intermediate Microsoft Word 2016
Word 2016
01.09.2023 - 01.09.2023
MS-55173 Introduction to Microsoft Word 2016
Word 2016
28.08.2023 - 28.08.2023
MCSA: Windows Server 2016 (wzbogacony o elementy Windows Server 2019) – online
MCSA
-
MS-20768 Developing SQL Data Models
SQL Server 2016
26.06.2023 - 28.06.2023
MS-55321 SQL Server Integration Services (dawniej MS-20767)
SQL Server 2016
19.06.2023 - 23.06.2023
MS-20334 Core Solutions of Skype for Business 2015/2019
Skype for Business 2015
26.06.2023 - 30.06.2023
MS-20744 Securing Windows Server 2016
Windows Server 2016
26.06.2023 - 30.06.2023
MS-10964 Cloud & Datacenter Monitoring with System Center Operations Manager
System Center
19.06.2023 - 23.06.2023
MS-55004 Installing and Configuring System Center 2012 Operations Manager
System Center
26.06.2023 - 30.06.2023
MS-20765 Provisioning SQL Databases
SQL Server 2016
28.08.2023 - 01.09.2023
MS-55316 Administering a SQL Database (dawniej MS-20764)
SQL Server 2016
19.06.2023 - 23.06.2023
MS-20762 Developing SQL Databases
SQL Server 2016
26.06.2023 - 30.06.2023
MS-20761 Querying Data with Transact-SQL
SQL Server 2016
26.06.2023 - 30.06.2023
MS-55343 Networking with Windows Server (dawniej MS-20741)
Windows Server 2016
28.08.2023 - 01.09.2023
MS-55324 Installation, Storage, and Compute with Windows Server 2016 (dawniej MS-20740)
Windows Server 2016
26.06.2023 - 30.06.2023
MS-55344 Identity with Windows Server (dawniej MS-20742)
Windows Server 2016
19.06.2023 - 23.06.2023
MS-20345-2 Designing and Deploying Microsoft Exchange Server 2016/2019
Exchange Server 2016/2019
19.06.2023 - 23.06.2023
MS-20345-1 Administering Microsoft Exchange Server 2016/2019
Exchange Server 2016/2019
26.06.2023 - 30.06.2023
MS-20743 Upgrading Your Skills to MCSA: Windows Server 2016
Windows Server 2016
26.06.2023 - 30.06.2023
MS-10972 Administering the Web Server (IIS) Role of Windows Server
Windows Server 2012/2012R2
17.07.2023 - 21.07.2023
MS-10967 Fundamentals of a Windows Server Infrastructure
Windows Server 2012/2012R2
26.06.2023 - 30.06.2023
MS-10969 Active Directory Services with Windows Server
Windows Server 2012/2012R2
19.06.2023 - 23.06.2023
Bezpieczeństwo Microsoft Azure, Office 365 oraz Intune
Microsoft Azure / Office 365 / Windows Intune
19.06.2023 - 21.06.2023
Automatyzacja zabezpieczeń w środowiskach Windows 10 oraz Windows Server 2016
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
26.06.2023 - 30.06.2023
Bezpieczeństwo w środowiskach Windows Client oraz Windows Server
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
23.08.2023 - 25.08.2023
Podstawy bezpieczeństwa w środowiskach Microsoft
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
19.06.2023 - 21.06.2023
MS-10961 Automating Administration with Windows PowerShell
MCSA
26.06.2023 - 30.06.2023
MS-20463 Implementing a Data Warehouse with Microsoft SQL Server
SQL Server 2012/2014
28.08.2023 - 01.09.2023
MS-20462 Administering Microsoft SQL Server Databases
SQL Server 2012/2014
19.06.2023 - 23.06.2023
MS-20461 Querying Microsoft SQL Server
SQL Server 2012/2014
19.06.2023 - 23.06.2023