Loading...

Terminy kursów:

01.10.2018 - 05.10.2018
10.12.2018 - 14.12.2018

Oficjalny konspekt Microsoft Pozostałe szkolenia

MS-20765 Provisioning SQL Databases

Czas trwania kursu: 5 dni
Cena: 2299zł

Opis kursu

 Kluczowe zagadnienia szkolenia wg trenera CBSG Polska:

  • przygotowanie środowiska, instalacja i konfiguracja SQL Server 2016
  • praca z bazami danych, plikami i grupami plików
  • SQL Server 2016 na Microsoft Azure
  • Database Storage Options – opcje pamięci masowej/dyskowej bazy danych

Dariusz Brejnak, Microsoft Certified Trainer

 Certyfikacje zawodowe

Tematyka szkolenia pokrywa zagadnienia wymagane na ścieżce:

  • MCSA: SQL Server 2016

 

MTA  MCSA  MCSE
MCSD

Dowiedz się więcej o certyfikacjach Microsoft


Poziom szkolenia wg standardów Microsoft

podstawowy średniozaawansowany zaawansowany ekspercki
100 200 300 400 

 

Czas trwania

  • 40 godziny lekcyjne (5 dni)

 

 Tematyka zajęć

  • Module 1: SQL Server 2016 Components
    Introduction to the SQL Server Platform
    Overview of SQL Server Architecture
    SQL Server Services and Configuration Options
    Lab : SQL Server Versions (Discussion session)

 

  • Module 2: Installing SQL Server 2016
    Considerations for installing SQL Server
    TempDB Files
    Installing SQL Server 2016
    Automating Installation
    Lab : Installing SQL Server

 

  • Module 3: Upgrading SQL Server to SQL Server 2016
    Upgrade Requirements
    Upgrade SQL Server Services
    Migrating SQL Server Data and Applications
    Lab : Upgrading SQL Server

 

  • Module 4: Deploying SQL Server on Microsoft Azure
    SQL Server Virtual Machines in Azure
    Deploying an Azure SQL Database
    Migrating an On-Premise Database to an Azure SQL Database
    Lab : Migrating SQL Server with Azure

 

  • Module 5: Working with Databases
    Overview of SQL Server Databases
    Creating Databases
    Database Files and Filegroups
    Moving Database Files
    Buffer Pool Extension
    Lab : Managing Database Storage

 

  • Module 6: Database Storage Options
    SQL Server storage Performance
    SMB Fileshare
    SQL Server Storage in Azure
    Stretch Databases
    Lab : Implementing Stretch Database

 

  • Module 7: Performing Database Maintenance
    Ensuring Database Integrity
    Maintaining Indexes
    Automating Routine Database Maintenance
    Lab : Performing Ongoing Database Maintenance

MS-10986 Updating Your Skills to SQL Server 2016
SQL Server 2016
05.11.2018 - 07.11.2018
MS-10985 Introduction to SQL Databases
SQL Server 2012/2014
29.10.2018 - 31.10.2018
MS-10994 Data Analysis Fundamentals using Excel
SQL Server 2016
08.11.2018 - 09.11.2018
MS-20740 Installation, Storage, and Compute with Windows Server 2016 (On-demand)
MS-20537 Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack
Windows
05.11.2018 - 09.11.2018
MS-20535 Architecting Microsoft Azure Solutions
Windows
15.10.2018 - 19.10.2018
MS-55224-2 Operationalize Cloud Analytics Solutions with Microsoft Azure
SQL Server 2016
15.10.2018 - 16.10.2018
MS-55224-1 Microsoft Azure Big Data Analytics Solutions
SQL Server 2016
10.09.2018 - 11.09.2018
MS-20776 Engineering Data with Microsoft Cloud Services
SQL Server 2016
17.09.2018 - 21.09.2018
MS-20773 Analyzing Big Data with Microsoft R
SQL Server 2016
17.09.2018 - 19.09.2018
MS-20775 Performing Data Engineering on Microsoft HD Insight
SQL Server 2016
01.10.2018 - 05.10.2018
MS-20778 Analyzing Data with Power BI
SQL Server 2016
22.10.2018 - 24.10.2018
MS-20779 Analyzing Data with Excel
SQL Server 2016
17.09.2018 - 19.09.2018
MS-20417 Upgrading Your Skills to MCSA Windows Server 2012
Windows Server 2012/2012R2
08.10.2018 - 12.10.2018
MS-20414 Implementing an Advanced Server Infrastructure
Windows Server 2012/2012R2
01.10.2018 - 05.10.2018
MS-20413 Designing and Implementing a Server Infrastructure
Windows Server 2012/2012R2
24.09.2018 - 28.09.2018
MS-10974 Deploying and Migrating Windows Servers
Windows Server 2012/2012R2
19.11.2018 - 21.11.2018
MS-10970 Networking with Windows Server
Windows Server 2012/2012R2
22.10.2018 - 26.10.2018
MS-20697-2 Deploying and Managing Windows 10 Using Enterprise Services
Windows 10
08.10.2018 - 12.10.2018
MS-20697-1 Implementing and Managing Windows 10
Windows 10
01.10.2018 - 05.10.2018
MS-10982 Supporting and Troubleshooting Windows 10
Windows 10
15.10.2018 - 19.10.2018
MS-20412 Configuring Advanced Windows Server 2012 Services
Windows Server 2012/2012R2
17.09.2018 - 21.09.2018
MS-20411 Administering Windows Server 2012
Windows Server 2012/2012R2
22.10.2018 - 26.10.2018
MS-20410 Installing and Configuring Windows Server 2012
Windows Server 2012/2012R2
15.10.2018 - 19.10.2018
MS-20774 Perform Cloud Data Science with Azure Machine Learning
SQL Server 2016
24.09.2018 - 28.09.2018
MS-55200 SharePoint 2016 Power User Training
SharePoint 2016
17.09.2018 - 18.09.2018
MS-55199 SharePoint 2016 End User Training
SharePoint 2016
22.10.2018 - 24.10.2018
MS-20745 Implementing a Software-Defined DataCenter
System Center
24.09.2018 - 28.09.2018
MS-10997 Office 365 Administration and Troubleshooting
Office 365
29.10.2018 - 31.10.2018
MS-20703-2 Integrating MDM and Cloud Services with System Center Configuration Manager
System Center
08.10.2018 - 10.10.2018
MS-20703-1 Administering System Center Configuration Manager
System Center
01.10.2018 - 05.10.2018
MS-10996 Hybrid Cloud and Datacenter Monitoring with Operations Management Suite (OMS)
24.09.2018 - 28.09.2018
MS-20489 Developing Microsoft SharePoint Server 2013 Advanced Solutions
SharePoint 2013
17.09.2018 - 21.09.2018
MS-20532 Developing Microsoft Azure Solutions
MCSA
01.10.2018 - 05.10.2018
MS-55247 Designing and Implementing Cloud Data Platform Solutions
08.10.2018 - 10.10.2018
MS-20487 Developing Windows Azure and Web Services
Programowanie
05.11.2018 - 09.11.2018
MS-20486 Developing ASP.NET MVC 4 Web Applications
Programowanie
22.10.2018 - 26.10.2018
MS-20483 Programming in C#
Programowanie
15.10.2018 - 19.10.2018
MS-20480 Programming in HTML5 with JavaScript and CSS3
Programowanie
08.10.2018 - 12.10.2018
MS-10962 Advanced Automated Administration with Windows PowerShell
Windows PowerShell
29.10.2018 - 31.10.2018
MCSA: Cloud Platform
MCSA
08.04.2019 - 29.05.2019
MS-55154 Office 365 for the End-User
Office 365
01.10.2018 - 01.10.2018
MS-55179 Advanced Microsoft Outlook 2016
25.09.2018 - 25.09.2018
MS-55178 Introduction to Microsoft Outlook 2016
24.09.2018 - 24.09.2018
MS-55177 Advanced Microsoft PowerPoint 2016
PowerPoint 2016
21.09.2018 - 21.09.2018
MS-55176 Introduction to Microsoft PowerPoint 2016
PowerPoint 2016
20.09.2018 - 20.09.2018
MS-55167 Advanced Microsoft Excel 2016
Excel 2016
26.09.2018 - 26.09.2018
MS-55166 Intermediate Microsoft Excel 2016
Excel 2016
25.09.2018 - 25.09.2018
MS-55165 Introduction to Microsoft Excel 2016
Excel 2016
24.09.2018 - 24.09.2018
MS-55175 Advanced Microsoft Word 2016
Word 2016
19.09.2018 - 19.09.2018
MS-55174 Intermediate Microsoft Word 2016
Word 2016
08.05.2018 - 08.05.2018
MS-55173 Introduction to Microsoft Word 2016
Word 2016
17.09.2018 - 17.09.2018
MS-20698 Installing and Configuring Windows 10
Windows 10
01.10.2018 - 05.10.2018
MS-10993 Integrating On-Premises Identity Infrastructure with Microsoft Azure
17.09.2018 - 18.09.2018
MS-10992 Integrating On-Premises Core Infrastructure with Microsoft Azure
10.09.2018 - 12.09.2018
MCSA: Windows Server 2016
MCSA
18.03.2019 - 29.05.2019
MS-20768 Developing SQL Data Models
SQL Server 2016
15.10.2018 - 17.10.2018
MS-20767 Implementing a SQL Data Warehouse
SQL Server 2016
24.09.2018 - 28.09.2018
MS-20334 Core Solutions of Skype for Business 2015
Skype for Business 2015
24.09.2018 - 28.09.2018
MS-20744 Securing Windows Server 2016
Windows Server 2016
10.12.2018 - 14.12.2018
MS-20337 Enterprise Voice and Online Services with Microsoft Lync Server 2013
Lync Server 2013
01.10.2018 - 05.10.2018
MS-20336 Core Solutions of Microsoft Lync Server 2013
Lync Server 2013
24.09.2018 - 28.09.2018
MS-10964 Cloud & Datacenter Monitoring with System Center Operations Manager
System Center
12.11.2018 - 16.11.2018
MS-55004 Installing and Configuring System Center 2012 Operations Manager
System Center
01.10.2018 - 05.10.2018
MS-20765 Provisioning SQL Databases
SQL Server 2016
01.10.2018 - 05.10.2018
MS-20764 Administering a SQL Database Infrastructure
SQL Server 2016
08.10.2018 - 12.10.2018
MS-20762 Developing SQL Databases
SQL Server 2016
01.10.2018 - 05.10.2018
MS-20761 Querying Data with Transact-SQL
SQL Server 2016
15.10.2018 - 19.10.2018
MS-50255 Managing Windows Environments with Group Policy
Windows Server 2012/2012R2
15.10.2018 - 19.10.2018
MS-20339-2 Advanced Technologies of SharePoint 2016
SharePoint 2016
03.09.2018 - 07.09.2018
MS-20339-1 Planning and Administering SharePoint 2016
SharePoint 2016
08.10.2018 - 12.10.2018
MS-20741 Networking with Windows Server 2016
Windows Server 2016
05.11.2018 - 09.11.2018
MS-20740 Installation, Storage, and Compute with Windows Server 2016
Windows Server 2016
24.09.2018 - 28.09.2018
MS-20742 Identity with Windows Server 2016
Windows Server 2016
17.09.2018 - 21.09.2018
MS-20345-2 Designing and Deploying Microsoft Exchange Server 2016
Exchange Server 2016
19.11.2018 - 23.11.2018
MS-20345-1 Administering Microsoft Exchange Server 2016
Exchange Server 2016
24.09.2018 - 28.09.2018
MS-20743 Upgrading Your Skills to MCSA: Windows Server 2016
Windows Server 2016
19.11.2018 - 23.11.2018
MS-10972 Administering the Web Server (IIS) Role of Windows Server
Windows Server 2012/2012R2
12.11.2018 - 16.11.2018
MS-10967 Fundamentals of a Windows Server Infrastructure
Windows Server 2012/2012R2
01.10.2018 - 05.10.2018
MS-10971 Storage and High Availability with Windows Server
Windows Server 2012/2012R2
05.11.2018 - 08.11.2018
MS-10969 Active Directory Services with Windows Server
Windows Server 2012/2012R2
08.10.2018 - 12.10.2018
MS-20488 Developing Microsoft SharePoint Server 2013 Core Solutions
SharePoint 2013
14.05.2018 - 18.05.2018
MS-20332 Advanced Solutions of Microsoft SharePoint Server 2013
SharePoint 2013
15.10.2018 - 19.10.2018
MS-20331 Core Solutions of Microsoft SharePoint Server 2013
SharePoint 2013
08.10.2018 - 12.10.2018
Bezpieczeństwo Microsoft Azure, Office 365 oraz Intune
Microsoft Azure / Office 365 / Windows Intune
01.10.2018 - 03.10.2018
Automatyzacja zabezpieczeń w środowiskach Windows 10 oraz Windows Server 2016
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
24.09.2018 - 26.09.2018
Bezpieczeństwo w środowiskach Windows 10 oraz Windows Server 2016
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
15.10.2018 - 17.10.2018
Podstawy bezpieczeństwa w środowiskach Microsoft
Windows 7/8.1/10 & Windows Server 2008R2/2012R2/2016
08.10.2018 - 10.10.2018
MCSA: Office 365
MCSA
09.04.2019 - 30.05.2019
MCSA: SQL Server 2014
MCSA
11.10.2018 - 20.12.2018
MS-10961 Automating Administration with Windows PowerShell
Windows PowerShell
08.10.2018 - 12.10.2018
MS-20342 Advanced Solutions of Microsoft Exchange Server 2013
Exchange Server 2013
01.10.2018 - 05.10.2018
MS-20341 Core Solutions of Microsoft Exchange Server 2013
Exchange Server 2013
24.09.2018 - 28.09.2018
MS-20533 Implementing Microsoft Azure Infrastructure Solutions
08.10.2018 - 12.10.2018
MS-10979 Microsoft Azure Fundamentals
15.10.2018 - 16.10.2018
MS-10748 Planning and Deploying System Center 2012 Configuration Manager
System Center
05.11.2018 - 07.11.2018
MS-20347 Enabling and Managing Office 365
Office 365
24.09.2018 - 28.09.2018
MS-20463 Implementing a Data Warehouse with Microsoft SQL Server
SQL Server 2012/2014
08.10.2018 - 12.10.2018
MS-20462 Administering Microsoft SQL Server Databases
SQL Server 2012/2014
01.10.2018 - 05.10.2018
MS-20461 Querying Microsoft SQL Server
SQL Server 2012/2014
24.09.2018 - 28.09.2018