Microsoft – MCSA: SQL 2016 DB Administration (70-765)- Provisioning SQL Databases

About this course:

This course is for students interested in SQL architecture, SQL development, SQL infrastructure specialists, and Database development. Candidates completing this course will have working knowledge of various models of cloud service and service model architectures, data storage options, and techniques for data synchronization. Candidates will also know how to deploy models, upgrade and migrate SQL databases, applications and services

Study Mode:

Online Only. Instructor Led E- Learning

Course Fees:

To Enrol for this course or to find out more on pricing or payment methods, please contact our Learning Consultants. Click here –  Contact Us 

If you are looking at completing more than one Certification in the next 12 months, it might be worthwhile looking at our Course Subscription option. To find out more Click here – Subscription option. 


Administration provider and located in Australia. Powered by Skillsoft content

Career Opportunities:
  • Database Administrators
  • Database Engineers
  • SQL Administrators
  • SQL Engineers
  • SQL Coders
  • Web Developers
  • IT Programmers
  • Systems Engineers
  • Systems Administrators
  • App Developers

Global Recognition. Requires sitting for the Microsoft Certification Exam: 70-765: Provisioning SQL Databases

Pre Requisites:

None for the course.

Course location:

Online – 100% Flexible Self Study – You study at your own pace, at your own time. You have 24 hours access via your own private study portal.

Course Length:

25 hours – (depends on the learner, how quickly they pick the skills is up to the student) you have 6 months (180 days) months access to your course material. You have more than enough time to complete this short course.

** Part – time students dedicate on average 5-6 hours study time per week. This course would approximately take 5-6 weeks to complete at that pace of study.

Start date:

Within 3 working days payment confirmation and enrolment form completed or you can pick your own start date!

What will I Learn/ Extra Information:
  • SQL Platform & Installation Best Practices
  • Architecture
  • Installation & Configuration
  • Upgrading to SQL Server 2016
  • Virtual Machines on Azure
  • Service Tiers, Pools, & SQL Databases
  • Instances & Storage Considerations
  • Securing Azure SQL Databases
  • Dynamic Data Masking
  • Transparent Data Encryption
  • Always Encrypted & Cell-level Encryption
  • Database Performance Settings
  • Configuring Operators & Alerts
  • Multiple Tenant Deployments
  • Migrating to Azure SQL Databases
  • Virtual Machines & Benchmark Data
  • Performance Tuning & Availability Sets
  • Connection Strings & Traffic Manager
  • Application Patterns
E Books  Included
Labs: Included
Exam Information:
Implement SQL in Azure (40–45%)
  • Deploy a Microsoft Azure SQL Database
  • Choose a service tier, create servers and databases, create a sysadmin account, configure elastic pools
  • Plan for SQL Server installation
  • Plan for an IaaS or on-premises deployment, select the appropriate size for a virtual machine, plan storage pools based on performance requirements, evaluate best practices for installation, design a storage layout for a SQL Server virtual machine
  • Deploy SQL Server instances
  • Deploy a SQL Server instance in IaaS and on-premises, manually install SQL Server on an Azure Virtual Machine, provision an Azure Virtual Machine to host a SQL Server instance, automate the deployment of SQL Server databases, deploy SQL Server by using templates
  • Deploy SQL Server databases to Azure virtual machines
  • Migrate an on-premises SQL Server database to an Azure virtual machine, generate benchmark data for performance needs, perform performance tuning on Azure IaaS, support availability sets in Azure
Manage databases and instances (30-35%)
  • Configure secure access to Microsoft Azure SQL Databases
  • Configure firewall rules, configure Always Encrypted for Azure SQL Database, configure cell-level encryption, configure dynamic data masking, configure transparent data encryption (TDE)
  • Configure SQL Server performance settings
  • Configure database performance settings, configure max server memory, configure the database scope, configure operators and alerts
  • Manage SQL Server instances
  • Create databases, manage files and file groups, manage system database files, configure tempdb
Manage Storage (30–35%)
  • Manage SQL Storage
  • Manage SMB file shares, manage stretch databases, configure Azure storage, change service tiers, review wait statistics, manage storage pools, recover from failed storage
  • Perform database maintenance
  • Monitor DMVs, maintain indexes, automate maintenance tasks, update statistics, verify database integrity, recover from database corruption
How to Enrol for this Course

For the Subscription option please click below on the Subscribe Here button.

For the Individual course, please contact us via live chat or click below on the Contact CertHub button.