> > 20765-ADVANCED

Provisioning SQL Databases MOC On-Demand Advanced

 

You want to take a MOC On Demand course but you don't want to be left alone?

"MOD Advanced" version offers you additional virtual "MCT Technology Days" with a Microsoft Certified Trainer (MCT). Frequently scheduled, the virtual conferences provide for the participants an interactive and direct exchange with an MCT, who will answer all the individual questions and provide the small group with in-depth support in the preparation for the exam. Additionally, an exam voucher and a measure-up practice test are included.

Our offer comprises:

  • MOC On-Demand Core (English language)
  • Digital MOC courseware
  • Exam vouchers
  • Measure-up practice test
  • Two days of virtual group learning with an experienced Microsoft Certified Trainer (MCT)

MOC On Demand Offer Overview

Who should attend

  • SQL Server Administrators
  • Anyone pursuing the MCSA: SQL Server 2016 Database Administration certification
  • Application Developers who use SQL Server to deliver content

Prerequisites

  • 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
  • Querying Data with Transact-SQL (20761) is recommended if you do not meet all the above prerequisites.

Product Description

This course teaches you how to provision SQL Server 2016 both on-premise and in Azure, and it also covers installing from new and migrating from an existing install.

Module 1: SQL Server 2016 Components

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

Module 2: Installing SQL Server 2016

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

Module 3: Upgrading SQL Server to SQL Server 2016

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

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

Module 5: Working with Databases

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

Module 6: Database Storage Options

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

Module 7: Performing Database Maintenance

  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance

Labs

  • SQL Server Versions ( Discussion session)
  • Installing SQL Server
  • Upgrading SQL Server
  • Migrating SQL Server with Azure
  • Managing Database Storage
  • Implementing Stretch Database
  • Performing Ongoing Database Maintenance
E-Learning MOC on Demand

Price on request

BUY NOW
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!