There are no items in your cart. Continue shopping on our Course Directory page.
Pay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
PDF Add to WishList
This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.
This is a Microsoft Official Course (MOC) delivered by a Learning Tree expert instructor.
This course is part of a Microsoft Certification Path and can help you prepare for your MCSA Certification, MCSE Certification, or MCSD Certification.
This module describes the various SQL Server 2016 components and versions.
Lessons
Lab: Discussion: SQL Server versions
After completing this module, you will be able to:
This modules describes the process to install SQL Server 2016.
Lessons
Lab: Installing SQL Server
After completing this module, you will be able to:
This module describes the process for upgrading to SQL Server 2016.
Lessons
Lab: Upgrading SQL Server
After completing this module, you will be able to:
This module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.
Lessons
Lab: Managing Database Storage
After completing this module, you will be able to:
This module covers database maintenance plans.
Lessons
Lab: Performing Database Maintenance
After completing this module, you will be able to:
Describe SQL Server storage options.
Lessons
Lab: Implementing Stretch Database
After completing this module, you will be able to:
This module describes how to plan to deploy SQL Server on Azure.
Lessons
Lab: Plan and Deploy an Azure SQL Database
After completing this module, you will be able to:
This module describes how to migrate databases to Azure SQL Database.
Lessons
Lab: Migrating SQL Server Databases to Azure
After completing this module, you will be able to:
This module describes how to deploy SQL Server on Microsoft Azure VMs.
Lessons
Lab: Deploying SQL Server on an Azure Virtual Machine
After completing this module, you will be able to:
This module describes how to manage SQL Server on Azure.
Lessons
Lab: Managing Databases in the Cloud
After completing this module, you will be able to:
Hassle-Free Enrolment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.
Tuition — Standard: $3285 Government: $2890
Apr 16 - 19
(
4 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Jun 25 - 28
(
4 Days)
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Reserve Your Seat
Oct 29 - Nov 1
(
4 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Dec 10 - 13
(
4 Days)
9:00 AM - 4:30 PM EST
New York / Online (AnyWare)
Reserve Your Seat
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.With a blend of video, text, hands-on labs, and knowledge checks, you will receive the same high quality content as the live event, but you can attend on your own time, at your own pace.
PLUS, we include access to a Microsoft Certified Trainer (MCT) to help you prepare for your certification exam and help you apply your new skills immediately… Learning Tree knows how to bring learning to life!
For enrolling multiple subscribers at the same time, contact us »
Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.
For details, call 1-888-843-8733 or Click here »
$3285
$2890
$1195*
Course Tuition Includes:
Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm