Loading...

Terminy kursów:

19.09.2022 - 22.09.2022
17.10.2022 - 20.10.2022
14.11.2022 - 17.11.2022
12.12.2022 - 15.12.2022

Pozostałe szkolenia

MS-10987 Performance Tuning and Optimizing SQL Databases

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

KLUCZOWE ZAGADNIENIA

  • architektura środowiska i bazy danych
  • zarządzanie pamięcią
  • indeksy i statystyki
  • monitorowanie SQL Server
  • plany wykonania, rekompilacja zapytań
  • diagnozowanie problemów z wydajnością

Przemysław Rosłon Microsoft Certified Trainer

POZIOM SZKOLENIA

podstawowy średniozaawansowany zaawansowany ekspercki
100 200 300 400

 

TEMATYKA ZAJĘĆ

  • Module 1: SQL Server Architecture, Scheduling, and Waits
    SQL Server Components and SQL OS
    Windows Scheduling vs SQL Scheduling
    Waits and Queues
    Lab: SQL Server Architecture, Scheduling, and Waits

 

  • Module 2: SQL Server I/O
    Core Concepts
    Storage Solutions
    I/O Setup and Testing
    Lab: Testing Storage Performance

 

  • Module 3: Database Structures
    Database Structure Internals
    Data File Internals
    TempDB Internals
    Lab: Database Structures

 

  • Module 4: SQL Server Memory
    Windows Memory
    SQL Server Memory
    In-Memory OLTP
    Lab: SQL Server Memory

 

  • Module 5: SQL Server Concurrency
    Concurrency and Transactions
    Locking Internals
    Lab: SQL Server Concurrency

 

  • Module 6: Statistics and Index Internals
    Statistics Internals and Cardinality Estimation
    Index Internals
    Columnstore Indexes
    Lab: Statistics and index Internals

 

  • Module 7: Query Execution and Query Plan Analysis
    Query execution and optimizer internals
    Query execution plans
    Analyzing query execution plans
    Adaptive query processing
    Lab: Query execution and query plan analysis

 

  • Module 8: Plan Caching and Recompilation
    Plan cache internals
    Troubleshooting plan cache issues
    Automatic tuning
    Query store
    Lab: Plan caching and recompilation

 

  • Module 9: Extended Events
    Extended events core concepts
    Working with extended events
    Lab: Extended events

 

  • Module 10: Monitoring, Tracing, and Baselining
    Monitoring and tracing
    Baselining and benchmarking
    Lab: Monitoring, Tracing and Baselining

PL-300 Microsoft Power BI Data Analyst
12.09.2022 - 14.09.2022
AZ-801 Configuring Windows Server Hybrid Advanced Services
05.09.2022 - 08.09.2022
AZ-800 Administering Windows Server Hybrid Core Infrastructure
27.06.2022 - 30.06.2022
DP-420 Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB
04.07.2022 - 07.07.2022
ASP.NET MVC Core
26.09.2022 - 30.09.2022
SQL SERVER – WYSOKA DOSTĘPNOŚĆ
20.06.2022 - 24.06.2022
AZ-305 Designing Microsoft Azure Infrastructure Solutions
05.09.2022 - 08.09.2022
AZ-030 Microsoft Azure technologies for AWS architects
29.08.2022 - 01.09.2022
AZ-020 Microsoft Azure solutions for AWS developers
29.08.2022 - 31.08.2022
DP-090 Implementing a Machine Learning Solution with Microsoft Azure Databricks
19.09.2022 - 19.09.2022
PL-400 Microsoft Power Platform Developer
04.07.2022 - 08.07.2022
PL-600 Microsoft Power Platform Solution Architect
26.09.2022 - 28.09.2022
PL-200 Microsoft Power Platform Functional Consultant
11.07.2022 - 14.07.2022
PL-100 Microsoft Power Platform App Maker
29.08.2022 - 31.08.2022
AZ-220 Microsoft Azure IoT Developer
05.09.2022 - 08.09.2022
WS-050 Migrating Application Workloads to Azure
20.06.2022 - 21.06.2022
AZ-600 Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack Hub
20.06.2022 - 23.06.2022
AZ-040 Automating Administration with PowerShell
20.06.2022 - 24.06.2022
AZ-700 Designing and Implementing Microsoft Azure Networking Solutions
27.06.2022 - 29.06.2022
MS-55215 SharePoint Online Power User
12.09.2022 - 15.09.2022
DP-080 Querying Data with Microsoft Transact-SQL
12.09.2022 - 13.09.2022
DP-203 Data Engineering on Microsoft Azure
27.06.2022 - 30.06.2022
AZ-140 Configuring and Operating Microsoft Azure Virtual Desktop
11.07.2022 - 14.07.2022
AI-102 Designing and Implementing a Microsoft Azure AI Solution
29.08.2022 - 01.09.2022
SC-900 Security, Compliance, and Identity Fundamentals
11.07.2022 - 11.07.2022
SC-200 Microsoft Security Operations Analyst
20.06.2022 - 23.06.2022
SC-300 Microsoft Identity and Access Administrator
12.09.2022 - 15.09.2022
SC-400 Microsoft Information Protection Administrator
19.09.2022 - 20.09.2022
MS-55300 Microsoft Teams for End Users
01.07.2022 - 01.07.2022
MS-55133 PowerShell for System Center Configuration Manager Administrators
27.06.2022 - 29.06.2022
MS-10984 Deploying and Managing Office 365 Hybrid Deployments
12.09.2022 - 14.09.2022
DP-300 Administering Relational Databases on Microsoft Azure
20.06.2022 - 23.06.2022
MS-203 Microsoft 365 Messaging
12.09.2022 - 16.09.2022
DP-900 Microsoft Azure Data Fundamentals
27.06.2022 - 27.06.2022
WS-012 Windows Server 2019 Hybrid and Azure IaaS
25.07.2022 - 27.07.2022
WS-011 Windows Server 2019 Administration
12.09.2022 - 16.09.2022
AZ-304 Microsoft Azure Architect Design
05.09.2022 - 08.09.2022
AZ-303 Microsoft Azure Architect Technologies
18.07.2022 - 22.07.2022
MS-050 SharePoint Hybrid Deployment and Migration
05.09.2022 - 09.09.2022
AI-900 Microsoft Azure AI Fundamentals
05.09.2022 - 05.09.2022
AZ-400 Designing and Implementing Microsoft DevOps solutions
04.07.2022 - 07.07.2022
MS-500 Microsoft 365 Security Administration
04.07.2022 - 07.07.2022
AZ-104 Microsoft Azure Administrator
04.07.2022 - 07.07.2022
DP-070 Migrate Open Source Data Workloads to Azure
04.07.2022 - 04.07.2022
AZ-204 Developing Solutions for Microsoft Azure
20.06.2022 - 24.06.2022
PL-900 Microsoft Power Platform Fundamentals
29.08.2022 - 29.08.2022
MS-10990 Analyzing Data with SQL Server Reporting Services
05.09.2022 - 09.09.2022
MS-10988 Managing SQL Business Intelligence Operations
19.09.2022 - 21.09.2022
DP-060 Migrate NoSQL workloads to Azure Cosmos DB
20.06.2022 - 20.06.2022
DP-050 Migrate SQL workloads to Azure
12.09.2022 - 13.09.2022
MS-700 Managing Microsoft Teams
20.06.2022 - 23.06.2022
MS-600 Building applications and solutions with Microsoft 365 core services
27.06.2022 - 01.07.2022
AZ-010 Azure Administration for AWS SysOps
11.07.2022 - 12.07.2022
MS-55354 Administering Office 365 (dawniej MS-030)
05.09.2022 - 09.09.2022
AZ-500 Microsoft Azure Security Technologies
04.07.2022 - 07.07.2022
DP-100 Designing and Implementing a Data Science Solution on Azure
27.06.2022 - 29.06.2022
MS-55039 Windows PowerShell Scripting and Toolmaking
26.09.2022 - 30.09.2022
MD-101 Managing Modern Desktops
19.09.2022 - 23.09.2022
MD-100 Windows Client
12.09.2022 - 16.09.2022
MS-900 Microsoft 365 Fundamentals
27.06.2022 - 27.06.2022
AZ-900 Microsoft Azure Fundamentals
20.06.2022 - 21.06.2022
MS-10987 Performance Tuning and Optimizing SQL Databases
19.09.2022 - 22.09.2022
MS-101 Microsoft 365 Mobility and Security
29.08.2022 - 02.09.2022
MS-100 Microsoft 365 Identity and Services
05.09.2022 - 09.09.2022
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
03.10.2022 - 07.10.2022
MS-20465 Designing Solutions for Microsoft SQL Server 2014
SQL Server 2012/2014
26.09.2022 - 28.09.2022
MS-20464 Developing Microsoft SQL Server 2014 Databases
SQL Server 2012/2014
19.09.2022 - 23.09.2022
MS-10986 Updating Your Skills to SQL Server 2016
SQL Server 2016
29.08.2022 - 31.08.2022
MS-55315 Introduction to SQL Databases (dawniej MS-10985)
SQL Server 2012/2014
29.08.2022 - 31.08.2022
MS-10994 Data Analysis Fundamentals using Excel
SQL Server 2016
29.08.2022 - 30.08.2022
MS-20779 Analyzing Data with Excel
SQL Server 2016
12.09.2022 - 14.09.2022
MS-55342 Supporting and Troubleshooting Windows 11 (dawniej MS-10982)
Windows 10
12.09.2022 - 16.09.2022
MS-55200 SharePoint 2016 Power User Training
SharePoint 2016
05.09.2022 - 06.09.2022
MS-55199 SharePoint 2016 End User Training
SharePoint 2016
29.08.2022 - 31.08.2022
MS-20745 Implementing a Software-Defined DataCenter
System Center
12.09.2022 - 16.09.2022
MS-10997 Office 365 Administration and Troubleshooting
Office 365
29.08.2022 - 31.08.2022
MS-20703-1 Administering System Center Configuration Manager
System Center
05.09.2022 - 09.09.2022
MS-55247 Designing and Implementing Cloud Data Platform Solutions
13.06.2022 - 15.06.2022
MS-20487 Developing Windows Azure and Web Services
Programowanie
19.09.2022 - 23.09.2022
MS-20486 Developing ASP.NET MVC 4 Web Applications
Programowanie
12.09.2022 - 16.09.2022
MS-20483 Programming in C#
Programowanie
05.09.2022 - 09.09.2022
MS-20480 Programming in HTML5 with JavaScript and CSS3
Programowanie
29.08.2022 - 02.09.2022
MS-10962 Advanced Automated Administration with Windows PowerShell
MCSA
05.09.2022 - 07.09.2022
MS-55154 Office 365 for the End-User
Office 365
19.09.2022 - 19.09.2022
MS-55179 Advanced Microsoft Outlook 2016
27.06.2022 - 27.06.2022
MS-55178 Introduction to Microsoft Outlook 2016
28.06.2022 - 28.06.2022
MS-55177 Advanced Microsoft PowerPoint 2016
PowerPoint 2016
29.06.2022 - 29.06.2022
MS-55176 Introduction to Microsoft PowerPoint 2016
PowerPoint 2016
30.06.2022 - 30.06.2022
MS-55167 Advanced Microsoft Excel 2016
Excel 2016
01.07.2022 - 01.07.2022
MS-55166 Intermediate Microsoft Excel 2016
Excel 2016
04.07.2022 - 04.07.2022
MS-55165 Introduction to Microsoft Excel 2016
Excel 2016
29.08.2022 - 29.08.2022
MS-55175 Advanced Microsoft Word 2016
Word 2016
14.07.2022 - 14.07.2022
MS-55174 Intermediate Microsoft Word 2016
Word 2016
12.07.2022 - 12.07.2022
MS-55173 Introduction to Microsoft Word 2016
Word 2016
18.07.2022 - 18.07.2022
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
12.09.2022 - 14.09.2022
MS-55321 SQL Server Integration Services (dawniej MS-20767)
SQL Server 2016
12.09.2022 - 16.09.2022
MS-20334 Core Solutions of Skype for Business 2015/2019
Skype for Business 2015
05.09.2022 - 09.09.2022
MS-20744 Securing Windows Server 2016
Windows Server 2016
26.09.2022 - 30.09.2022
MS-10964 Cloud & Datacenter Monitoring with System Center Operations Manager
System Center
29.08.2022 - 02.09.2022
MS-55004 Installing and Configuring System Center 2012 Operations Manager
System Center
19.09.2022 - 23.09.2022
MS-20765 Provisioning SQL Databases
SQL Server 2016
05.09.2022 - 09.09.2022
MS-20764 Administering a SQL Database Infrastructure
SQL Server 2016
05.09.2022 - 09.09.2022
MS-20762 Developing SQL Databases
SQL Server 2016
05.09.2022 - 09.09.2022
MS-20761 Querying Data with Transact-SQL
SQL Server 2016
29.08.2022 - 02.09.2022
MS-55343 Networking with Windows Server (dawniej MS-20741)
Windows Server 2016
05.09.2022 - 09.09.2022
MS-55324 Installation, Storage, and Compute with Windows Server 2016 (dawniej MS-20740)
Windows Server 2016
29.08.2022 - 02.09.2022
MS-20742 Identity with Windows Server 2016
Windows Server 2016
12.09.2022 - 16.09.2022
MS-20345-2 Designing and Deploying Microsoft Exchange Server 2016/2019
Exchange Server 2016/2019
12.09.2022 - 16.09.2022
MS-20345-1 Administering Microsoft Exchange Server 2016/2019
Exchange Server 2016/2019
05.09.2022 - 09.09.2022
MS-20743 Upgrading Your Skills to MCSA: Windows Server 2016
Windows Server 2016
19.09.2022 - 23.09.2022
MS-10972 Administering the Web Server (IIS) Role of Windows Server
Windows Server 2012/2012R2
12.09.2022 - 16.09.2022
MS-10967 Fundamentals of a Windows Server Infrastructure
Windows Server 2012/2012R2
29.08.2022 - 02.09.2022
MS-10969 Active Directory Services with Windows Server
Windows Server 2012/2012R2
05.09.2022 - 09.09.2022
Bezpieczeństwo Microsoft Azure, Office 365 oraz Intune
Microsoft Azure / Office 365 / Windows Intune
04.07.2022 - 06.07.2022
Automatyzacja zabezpieczeń w środowiskach Windows 10 oraz Windows Server 2016
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
29.08.2022 - 02.09.2022
Bezpieczeństwo w środowiskach Windows 10 oraz Windows Server 2016/2019
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
04.07.2022 - 06.07.2022
Podstawy bezpieczeństwa w środowiskach Microsoft
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
19.09.2022 - 21.09.2022
MS-10961 Automating Administration with Windows PowerShell
MCSA
29.08.2022 - 02.09.2022
MS-20463 Implementing a Data Warehouse with Microsoft SQL Server
SQL Server 2012/2014
12.09.2022 - 16.09.2022
MS-20462 Administering Microsoft SQL Server Databases
SQL Server 2012/2014
05.09.2022 - 09.09.2022
MS-20461 Querying Microsoft SQL Server
SQL Server 2012/2014
29.08.2022 - 02.09.2022