Microsoft SQL Server 2016 Certification (70-765)
4.1 (282 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,516 students enrolled

Microsoft SQL Server 2016 Certification (70-765)

A comprehensive and practical course designed to help you pass the Microsoft SQL 2016 (70-765) exam.
4.1 (282 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,516 students enrolled
Last updated 2/2020
English
English [Auto]
Current price: $104.99 Original price: $149.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8 hours on-demand video
  • 2 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Implement SQL in Azure
  • Deploy a Microsoft Azure SQL Database
  • Plan for SQL Server installation
  • Deploy SQL Server instances
  • Deploy SQL Server databases to Azure virtual machines
  • Manage databases and instances
  • Configure secure access to Microsoft Azure SQL Databases
  • Configure SQL Server performance settings
  • Manage SQL Server instances
  • Perform database maintenance
Requirements
  • A PC
  • Internet Access
Description

Welcome to this course: Microsoft SQL Server 2016 Certification (70-765) - Provisioning SQL Databases. This exam is intended for architects, senior developers, infrastructure specialists, and development leads. Candidates have a working knowledge of the various cloud service models and service model architectures, data storage options, and data synchronization techniques. Candidates also have a working knowledge of deployment models, upgrading and migrating databases, and applications and services, in addition to integrating Azure applications with external resources.

In this course, you'll learn:
  • Implement SQL in Azure 
  • Deploy a Microsoft Azure SQL Database
  • Plan for SQL Server installation
  • Deploy SQL Server instances
  • Deploy SQL Server databases to Azure virtual machines
  • Manage databases and instances 
  • Configure secure access to Microsoft Azure SQL Databases
  • Configure SQL Server performance settings
  • Manage SQL Server instances
  • Manage SQL Storage
  • Perform database maintenance

At the end of this course, you will have developed the knowledge and skills necessary to pass the Provisioning SQL Databases Exam. So let's get started.

Who this course is for:
  • Web Developers
  • Software Developers
  • Programmers
  • Anyone who wants to pass Exam 70-765
Course content
Expand all 74 lectures 08:09:27
+ Getting Started With This Course
4 lectures 26:34
Introduction
08:27
Getting Started - Overview: MS SQL Server
05:59
Getting Started - The Certifications
09:25
Getting Started - Microsoft SQL Server Examples
02:43
+ Learn About SQL Server
5 lectures 41:08
Introduction
09:36
Learn About SQL Server: SQL Server Databases
09:44
Learn About SQL Server: Learn and Understand Database Structures
08:46
Learn About SQL Server: SQL Server: Transact-SQL
07:04
+ Learn About MS SQL Server 2016
6 lectures 39:04
Introduction
05:58
MS SQL Server 2016: Learn How To Install SQL Server 2016 - 1
08:23
MS SQL Server 2016: Learn How To Install SQL Server 2016 - 2
04:43
MS SQL Server 2016: Learn How To Install SQL Server Management Studio
05:36
MS SQL Server 2016: Verifying The Installation
05:16
MS SQL Server 2016: SQL Server Deployment Options
09:08
+ Learn and Understand Cloud Computing
12 lectures 01:26:39
Introduction
09:23
Cloud Computing - Virtualization
09:49
Cloud Computing - Cloud-Based Applications
08:16
Cloud Computing - RMA
07:56
Cloud Computing - Learn How To Utilize The Cloud
07:22
Cloud Computing - Cloud Modes
07:46
Cloud Computing - Service Models
03:39
Cloud Computing - IaaS
06:44
Cloud Computing - PaaS
03:39
Cloud Computing - SaaS
05:14
Cloud Computing - Technologies In The Cloud
06:30
Cloud Computing - Impact Of The Cloud
10:21
+ Learn About Microsoft Azure
5 lectures 31:37
Introduction
05:55
Learn About Microsoft Azure: Microsoft Azure Terminology
06:51
Learn About Microsoft Azure: Microsoft Azure Subscriptions
05:30
Learn About Microsoft Azure: Microsoft Azure Sign-Up
07:07
Learn About Microsoft Azure: Microsoft Azure Portal Tour
06:14
+ Learn About Microsoft Azure SQL Database
7 lectures 40:48
Introduction
04:24
Microsoft Azure SQL Database - Learning and Understanding DTUs
04:58
Azure SQL Database - Logical Servers
05:27
Azure SQL Database - Creating A SQL Database
08:26
Azure SQL Database - SSMS and SQL Database
05:55
Azure SQL Database - Understanding Elastic Pools
06:31
Azure SQL Database - Creating An Elastic Pool
05:07
+ Learn About Microsoft SQL Server Virtualization
16 lectures 01:44:12
Introduction
08:19
SQL Server Virtualization: Azure Resource Groups
06:35
SQL Server Virtualization: Creating A VM - 1
09:13
SQL Server Virtualization: Creating A VM - 2
04:26
SQL Server Virtualization: Accessing The VM
05:10
SQL Server Virtualization: VM Storage Planning
05:04
SQL Server Virtualization: Virtual Networking
07:01
SQL Server Virtualization: On-Premises Vs. SQL Server VM
06:28
SQL Server Virtualization: Provisioning A SQL Server VM
07:15
SQL Server Virtualization: Manual SQL Server Install
05:15
SQL Server Virtualization: Max Server Memory
10:24
SQL Server Virtualization: Manually Configuring Memory
03:59
SQL Server Virtualization: SQL Server Agent
06:44
SQL Server Virtualization: Configuring Operators
04:38
SQL Server Virtualization: Configuring Alerts
05:22
SQL Server Virtualization: Azure Alerts
08:19
+ Microsoft Azure Security
7 lectures 44:19
Introduction
07:02
Microsoft Azure Security - Access Control and Authorization
08:08
Microsoft Azure Security - Transparent Data Encryption
05:36
Microsoft Azure Security - Enabling TDE
03:33
Microsoft Azure Security - Understanding DDM
07:17
Microsoft Azure Security - Implementing DDM
08:02
Microsoft Azure Security - Azure Always Encrypted
04:41
+ Learning Migration & Performance
8 lectures 01:03:47
Introduction
10:45
Migration: Data Migration Assistant
09:49
Migration: Migrating To SQL Database
08:09
Migration: Migrating To SQL Server VM
05:47
Performance: Azure Performance Tuning
07:50
Performance: Using Azure Monitor - 1
10:18
Performance: Using Azure Monitor - 2
02:49
Performance: Azure Availability Sets
08:20