Provisioning SQL Databases (70-765)

(70-765) / ISBN : 978-1-64459-122-2
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

The Microsoft MCSA Provisioning SQL Databases certification is intended for architects, senior developers, infrastructure specialists, and development leads. The certified candidates will gain a working knowledge of the various cloud service models and service model architectures, data storage options, and data synchronization techniques. The MCSA 70-765 exam validates a candidate's knowledge of deployment models, upgrading and migrating databases, and applications and services.

1

Introduction

  • About 70-765 Exam
  • Introducing the Azure SQL Database
  • Setting Up Azure
2

Deploy a Microsoft Azure SQL Database

  • A Service Tier
  • Create Servers and Databases
  • Create a sysadmin Account
  • Manage Elastic Pools
  • Summary
3

Plan for SQL Server Installation

  • What is IaaS?
  • Cloud vs On-Premises: Security, Reliability, and Uptime
  • Azure Virtual Machine Size
  • Storage Used by Azure VMs
  • Azure VM Performance Best Practices
  • Designing a Storage Layout
  • Summary
4

Deploy SQL Server Instances

  • Install SQL On-Premises
  • Manually Install SQL Server on an Azure Virtual Machine
  • Automate the Deployment of SQL Server Databases
  • JSON Templates
  • Summary
5

Deploy SQL Server Databases to Azure Virtual Machines

  • Migrate an On-premises SQL to Azure
  • Generate Benchmark Data for Performance Needs
  • Perform Performance Tuning on Azure IaaS
  • Availability Group
  • Summary
6

Configure Secure Access to Microsoft Azure SQL Databases

  • Configure Firewall Rules
  • Always Encrypted for Azure SQL Database
  • Cell-Level Encryption in Azure
  • Dynamic Data Masking
  • Transparent Data Encryption
  • Summary
7

Configure SQL Server Performance

  • SQL Server Performance Settings
  • SQL Server Memory Configuration
  • Database Scoped Configuration
  • Azure Portal Alerts
  • Summary
8

Manage SQL Server Instances

  • Create a Database
  • Manage Files and Filegroups
  • System Database
  • TempDB Best Practices
  • Summary
9

Manage SQL Storage

  • SMB File Share
  • Stretch Database
  • Azure Storage Account
  • Change Service Tiers
  • Wait Statistics
  • Storage Pool
  • Storage Recovery
  • Summary
10

Perform Database Maintenance

  • Monitor SQL Server 
  • Azure SQL Performance Monitoring 
  • Azure Automation
  • Manage Indexes
  • Database Integrity
  • Database Corruption
  • Summary

1

Deploy a Microsoft Azure SQL Database

  • Creating an SQL Server in Azure
  • Creating an SQL Database Using Sample db
  • Setting Firewall Rules to Connect to DB Using Public IP
  • Granting Permissions to Create Tables
  • Creating an Elastic Pool
  • Using the ALTER Command with the ROLLBACK IMMEDIATE Command
2

Plan for SQL Server Installation

  • Creating a Web Application
3

Deploy SQL Server Instances

  • Restoring a Database in SSMS
  • Creating an Azure VM to Host an SQL Server Instance
4

Deploy SQL Server Databases to Azure Virtual Machines

  • Creating a Data Factory
  • Creating a Load Balancer
5

Configure Secure Access to Microsoft Azure SQL Databases

  • Creating a Firewall
6

Configure SQL Server Performance

  • Modifying DB Startup Parameters to Optimize Performance
7

Manage SQL Server Instances

  • Adding a File to a Database
  • Adding a Filegroup with Two Files to a Database
8

Manage SQL Storage

  • Creating a Storage Account in Azure
9

Perform Database Maintenance

  • Enabling DTA for a Query Store
  • Using CHECKDB
  • Using sp_who
  • Creating a Backup

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Provisioning SQL Databases (70-765)

$279.99

Buy Now

Related Courses

All Course
scroll to top