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.

Pohađajte naše zvanične Microsoft obuke u Beogradu, putem virtuelne učionice (online, uživo) ili u vašim prostorijama (on-site).

Specijalni popusti se odobravaju prilikom prijave više učesnika koji istovremeno pohađaju obuku iz vaše kompanije, državni i neprofitni sektor, itd. Kontaktirajte nas da biste saznali više.

Termini obuke

Beograd
Planirani datumPlanirani datum
26.10.2020
650€
 
Srpski
Novi Sad
Planirani datumPlanirani datum
26.10.2020
650€
 
Srpski
Virtuelna učionica
Planirani datumPlanirani datum
26.10.2020
550€
 
Srpski
Beograd
Planirani datumPlanirani datum
08.02.2021
650€
 
Srpski
Novi Sad
Planirani datumPlanirani datum
08.02.2021
650€
 
Srpski
Virtuelna učionica
Planirani datumPlanirani datum
08.02.2021
550€
 
Srpski
550€
Trajanje obuke: 
5 dana / 35 sati

Privatni trening

On-site / Online
Minimalan broj polaznika: 3
5 dana / 35 sati
Cena na zahtev
srpski ili engleski
Plan obuke: 

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
Benefiti: 
  • Video snimak predavanja u periodu od 365 dana posle kraja obuke

  • Pristup laboratorijama putem Interneta 180 dana od kraja obuke
  • Materijal u elektronskom obliku

  • Zvaničan Microsoft sertifikat o pohađanju kursa

  • Mogućnost korišćenja Microsoft SA vaučera za plaćanje ove obuke
Poželjno predznanje: 

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