Provisioning SQL Databases (MS20765)
This 5 day instructor led training course teaches students how to provision SQL databases both on premise and in SQL Azure.
Cena
Lokacija
Beograd
Virtuelna učionica
Datum
Prijava
Module 1: SQL Server Components
This module describes the various SQL Server components and versions.
- Introduction to the SQL Server Platform
- Overview of SQL Server Architecture
- SQL Server Services and Configuration Options
Module 2: Installing SQL Server
This modules describes the process to install SQL Server 2016.
- Considerations for SQL Installing Server
- TempDB Files
- Installing SQL Server
- Automating Installation
Module 3: Upgrading SQL Server to SQL Server 2017
This module describes the process for upgrading to SQL Server 2017.
- Upgrade Requirements
- Upgrade SQL Server Services
- Side by Side Upgrade: Migrating SQL Server Data and Applications
Module 4: Working with Databases
This module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.
- Introduction to Data Storage with SQL Server
- Managing Storage for System Databases
- Managing Storage for User Databases
- Moving and Copying Database Files
- Buffer Pool Extension
Module 5: Performing Database Maintenance
This module covers database maintenance plans.
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
Module 6: Database Storage Options
Describe SQL Server storage options.
- SQL Server storage Performance
- SMB Fileshare
- SQL Server Storage in Microsoft Azure
- Stretch Databases
Module 7: Planning to Deploy SQL Server on Microsoft Azure
This module describes how to plan to deploy SQL Server on Azure.
- SQL Server Virtual Machines in Azure
- Azure Storage
- Azure SQL Authentication
- Deploying an Azure SQL Database
Module 8: Migrating Databases to Azure SQL Database
This module describes how to migrate databases to Azure SQL Database.
- Database Migration Testing Tools
- Database Migration Compatibility Issues
- Migrating a SQL Server Database to Azure SQL Database
Module 9: Deploying SQL Server on a Microsoft Azure Virtual Machine
This module describes how to deploy SQL Server on Microsoft Azure VMs.
- Deploying SQL Server on an Azure VM
- The Deploy Database to a Microsoft Azure VM Wizard
Module 10: Managing databases in the Cloud
- This module describes how to manage SQL Server on Azure.
- Managing Azure SQL Database Security
- Configure Azure storage
- Azure Automation
Video snimak predavanja u periodu od 365 dana posle kraja Vaše obuke
Mogućnost pristupa laboratorijama dostupnim putem Interneta, 180 dana od kraja Vaše obuke (Premium Labs doplata)
Materijal u elektronskom obliku koji se automatski ažurira
Zvaničan Microsoft sertifikat o pohađanju kursa
Besplatno pohađanje iste obuke na potvrđenim terminima u sledećih 365 dana
- Moguće je iskoristiti Microsoft trening vaučere za plaćanje ove obuke
Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
- Some experience with database design