Provisioning SQL Databases- Exam 70-765 Certification Training

Provisioning SQL Databases- Exam 70-765 Certification Training image

Prepare for the Microsoft 70-765 Exam and Work Towards Your MCSA: SQL 2016 Database Administration Certification

Publisher: Infinite Skills

Release Date: August 2017

Duration: 8 hours 11 minutes

Watch on Safari with a 10-day trial

Start your free trial now

Microsoft exam 70-765 (aka "Provisioning SQL Databases") is one of two tests you must pass to earn a Microsoft Certified Solutions Associate (MCSA): 2016 Database Administration certification. This course supplies you with the knowledge you need to pass the 70-765. It's also a practical introduction to Microsoft's Azure cloud platform service. It covers the processes, implications, technologies, and actions involved in utilizing SQL Server in the cloud in both PaaS and IaaS environments. After you learn how to create and use a free Microsoft Azure subscription, you will get hands-on experience with SQL Server in various cloud-based configurations, giving you an understanding of the implications and purposes for various options.

  • Survey Microsoft's published objectives required to pass the Microsoft 70-765 exam
  • Gain an operational understanding of Microsoft's Azure platform and administrative interface
  • Learn the impacts and considerations to consider when migrating technologies to the cloud
  • Discover the difference between SQL Database and SQL Server on an Azure VM
  • Explore the dashboard and monitoring tools available on the Azure portal
  • Understand the security options and implementations available with SQL Server in Azure
  • Learn the efficiencies of utilizing SQL Server in the cloud

Mark Long is a long time contributor to O'Reilly Media having authored more than a dozen book and video titles including "Windows Presentation Foundation Basics", "Learning Windows PowerShell", and "Securing Windows Networks". He solves IT issues for numerous Fortune 500 companies as the head of his own consulting company. Mark holds the A+ certification and many others, including Microsoft's MCSE, MCDBA, and MCT.

Table of Contents

Chapter: Introduction

Welcome To The Course

04m 41s

About The Author

04m 7s

Course Overview

08m 25s

Microsoft SQL Server

05m 57s

SQL Server 2016 Certifications

09m 22s

Examples And Code

02m 44s

Chapter: SQL Server Basics

SQL Server Platform

09m 32s

SQL Server Editions

05m 56s

Understanding Databases

09m 41s

Database Structures

08m 43s


07m 2s

Chapter: Getting And Installing SQL Server 2016

Getting SQL Server 2016

05m 56s

Installing SQL Server 2016 Part - 1

08m 20s

Installing SQL Server 2016 Part - 2

04m 42s

Installing SQL Server Management Studio

05m 35s

Verifying The Installation

05m 15s

SQL Server Deployment Options

09m 5s

Chapter: Cloud Computing Overview

What Is Cloud Computing?

09m 20s


09m 46s

Cloud-Based Applications

08m 14s


07m 53s

Why Utilize The Cloud?

07m 21s

Cloud Modes

07m 44s

Service Models

03m 39s


06m 43s


03m 39s


05m 12s

Technologies In The Cloud

06m 29s

Impact Of The Cloud

10m 18s

Chapter: Microsoft Azure

Understanding Azure

05m 54s

Azure Terminology

06m 49s

Azure Subscriptions

05m 29s

Azure Sign-Up

07m 5s

Azure Portal Tour

06m 13s

Chapter: Azure SQL Database

Intro To SQL Database

04m 23s

Understanding DTUs

04m 57s

Logical Servers

05m 25s

Creating A SQL Database

08m 23s

SSMS And SQL Database

05m 53s

Understanding Elastic Pools

06m 29s

Creating An Elastic Pool

05m 6s

Chapter: SQL Server Virtualization

Azure Virtual Machines

08m 16s

Azure Resource Groups

06m 34s

Creating A VM Part - 1

09m 9s

Creating A VM Part - 2

04m 24s

Accessing The VM

05m 8s

VM Storage Planning

05m 3s

Virtual Networking

06m 58s

On-Premises Vs. SQL Server VM

06m 26s

Provisioning A SQL Server VM

07m 12s

Manual SQL Server Install

05m 13s

Max Server Memory

10m 20s

Manually Configuring Memory

03m 57s

SQL Server Agent

06m 42s

Configuring Operators

04m 37s

Configuring Alerts

05m 21s

Azure Alerts

08m 16s

Chapter: Azure Security

SQL Database Security

07m 0s

Access Control And Authorization

08m 6s

Transparent Data Encryption

05m 35s

Enabling TDE

03m 32s

Understanding DDM

07m 15s

Implementing DDM

08m 0s

Azure Always Encrypted

04m 40s

Chapter: Migration And Performance

Migrating To The Cloud

10m 42s

Data Migration Assistant

09m 45s

Migrating To SQL Database

08m 7s

Migrating To SQL Server VM

05m 45s

Azure Performance Tuning

07m 47s

Using Azure Monitor Part - 1

10m 14s

Using Azure Monitor Part - 2

02m 47s

Azure Availability Sets

08m 16s

Chapter: Conclusion

Wrap Up

06m 42s

  • Publication date: 31.08.2017
  • Source