Öppna kurser

Provisioning SQL Server 2016 Databases (20765)

This official Microsoft 4-day instructor-led Provisioning SQL Databases training course (20765) is designed to teach students how to provision SQL Server databases both on-premise and in SQL Azure.Plus, get prepped for Microsoft exam 70-765, a requirement for MCSA: SQL 2016 Database Administration.

Kursmål

  • Provision a Database Server
  • Upgrade SQL Server
  • Configure SQL Server
  • Manage Databases and Files (shared)

Förkunskaper

  • 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

Redeem Your Microsoft SATVs. This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.

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

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

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.

Module 4: Deploying SQL Server on Microsoft Azure
This module describes the options available to run SQL Server on 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.

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

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

Kursen levereras genom utbildningspartner: Learning Tree
images.png