Karlebovej 91, 3400 Hillerød | Krajbjergvej 3, 8541 Skødstrup
70 22 29 29
08:30 - 17:00

Provisioning SQL Databases MOC 20765 (70-765)

  • okt 21
    mandag 21/10/2019 - fredag 25/10/2019
    09:00 - 16:00 Hillerød
    • Kr.20,795.00 ekskl. MOMS
    Ekskl. moms
  • okt 21
    mandag 21/10/2019 - fredag 25/10/2019
    09:00 - 16:00 Aarhus
    • Afholdelsesgaranti
    • Kr.20,795.00 ekskl. MOMS
    Ekskl. moms
  • nov 04
    mandag 04/11/2019 - fredag 08/11/2019
    09:00 - 16:00 Aarhus
    • Afholdelsesgaranti
    • Kr.20,795.00 ekskl. MOMS
    Ekskl. moms
  • dec 02
    mandag 02/12/2019 - fredag 06/12/2019
    09:00 - 16:00 Hillerød
    • Afholdelsesgaranti
    • Kr.20,795.00 ekskl. MOMS
    Ekskl. moms
  • dec 02
    mandag 02/12/2019 - fredag 06/12/2019
    09:00 - 16:00 Aarhus
    • Kr.20,795.00 ekskl. MOMS
    Ekskl. moms
  • mar 09
    mandag 09/03/2020 - fredag 13/03/2020
    09:00 - 16:00 Hillerød
    • Afholdelsesgaranti
    • Kr.20,795.00 ekskl. MOMS
    Ekskl. moms
  • mar 30
    mandag 30/03/2020 - fredag 03/04/2020
    09:00 - 16:00 Aarhus
    • Afholdelsesgaranti
    • Kr.20,795.00 ekskl. MOMS
    Ekskl. moms
Er der ingen af disse datoer som passer dig? Foreslå en anden dato

Kursusinfo

  • Dette kursus varer 5 dage
  • Der medfølger kursusmateriale til dette kursus
  • Dette kursus koster 6 klip på dit klippekort.
  • Fuld forplejning (Morgenmad, frokost, kage, kaffe og sodavand ad libitum)
  • Fuld beståelsesgaranti er inkluderet i prisen - Læs mere her
  • Eksamen er inkluderet i prisen
  • Med i prisen hører Practice Test
  • Du har i alt adgang til din kursus-pc i 3 uger

Varighed

Dette kursus varer 5 dage

Materialer

Der medfølger kursusmateriale til dette kursus

Klip på klippekort

Dette kursus koster 6 klip på dit klippekort.

Forplejning

Fuld forplejning (Morgenmad, frokost, eftermiddagskage samt kaffe og sodavand ad libitum)

Garanti for beståelse

Fuld beståelsesgaranti er inkluderet i prisen - Læs mere her

Eksamen

Alle eksamensforsøg er inkluderet i prisen

Practice Tests

Med i prisen hører Practice Test

Remote adgang

Du har i alt adgang til din kursus-pc i 3 uger

Microsoft Vouchers

5 vouchers + 4.950 kr. for Certificeringspakken.
Læs mere her

Download PDF

Hen PDF om kurset her

"Provisioning SQL Databases" er et af de nye certificeringsrettede SQL Server 2016 kurser fra Microsoft. I alt kommer der 6 nye certificeringer, som leder op til 3 nye Microsoft MCSA SQL Server 2016 titler. For at opnå en MCSA SQL Server 2016 skal man bestå 2 eksamener.

 "Provisioning SQL Databases" indgår som andet kursus i titlen: MCSA SQL Server 2016 Database Administration, som du kan læse mere om her

About this course

This three-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.

Audience profile
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

At course completion
After completing this course, students will be able to:
Provision a Database Server
Upgrade SQL Server
Configure SQL Server
Manage Databases and Files (shared)

Course Outline

Module 1: SQL Server 2016 Components
Describe the SQL Server platform, SQL Server services, and SQL Server configuration options.

Lessons
Introduction to the SQL Server Platform
Overview of SQL Server Architecture
SQL Server Services and Configuration Options

Lab : SQL Server Versions ( Discussion session)
After completing this module, you will be able to:
Describe the SQL Server platform and architecture
Describe the SQL Server services and configuration..

Module 2: Installing SQL Server 2016
This modules describes the process to install SQL Server 2016.

Lessons
Considerations for installing SQL Server
TempDB Files
Installing SQL Server 2016
Automating Installation

Lab : Installing SQL Server
After completing this module, you will be able to:
Describe the considerations when installing SQL Server 2016
Be able to install SQL Server
Be able to automate the installation

Module 3: Upgrading SQL Server to SQL Server 2016
This module describes how you go about upgrading your current SQL Server installation to SQL Server 2016.

Lessons
Upgrade Requirements
Upgrade SQL Server Services
Migrating SQL Server Data and Applications

Lab : Upgrading SQL Server
After completing this module, you will be able to:
Describe the requirements for upgrading to SQL Server 2016
Describe how to upgrade SQL Server services
Be able to migrate SQL Server Data and Applications

Module 4: Deploying SQL Server on Microsoft Azure
This module describes the options available to run SQL Server on Azure.

Lessons
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
After completing this module, you will be able to:
Describe how SQL Server Virtual Machines work in Azure
Describe how to deploy and Azure SQL database
Describe how to migrate and on-premise database to Azure

Module 5: Working with Databases
This module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.

Lessons
Overview of SQL Server Databases
Creating Databases
Database Files and Filegroups
Moving Database Files
Buffer Pool Extension

Lab : Managing Database Storage
After completing this module, you will be able to:
Be able to create SQL Server databases
Describe database files and filegroups
Be able to move database files
Describe the buffer pool extension

Module 6: Database Storage Options
At the end of this module you will be able to describe the database storage options.

Lessons
SQL Server storage Performance
SMB Fileshare
SQL Server Storage in Azure
Stretch Databases

Lab : Implementing Stretch Database
After completing this module, you will be able to:
Explain the elements impacting storage performance
Describe SMB fileshare
Describe SQL Server storage in Azure
Describe Stretch Databases

Module 7: Performing Database Maintenance
This module covers database maintenance.

Lessons
Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance

Lab : Performing Ongoing Database Maintenance
After completing this module, you will be able to:
Describe how to ensure database integrity
Be able to maintain indexes
Be able to automate routine database maintenance

Lignende kurser

Querying Data with Transact-SQL MOC 20761 (70-761) Skriv dig op som interesseret til dette kursus
Analyzing Data with SQL Server Reporting Services (MOC 10990) 21 okt
MCSA SQL Server 2016 Database Administration (70-764 & 70-765) Skriv dig op som interesseret til dette kursus
SQL Programmering Videregående 21 okt
Performance Tuning and Optimizing SQL Databases (10987) Skriv dig op som interesseret til dette kursus