70-765
Provisioning SQL Databases (70-765)
Get certified for the MCSA 70-765 certification exam with the Provisioning SQL Databases (70-765) course and lab. The lab can be mapped to any course, textbook, or training adding value and a hands-on component to training. The MCSA certification course completely covers the MCSA 70-765 exam objectives and will help you master the skills required to implement SQL in Azure, and manage databases, instances, and storage. The course also teaches you how to configure both firewall rules and Always Encrypted for Azure SQL Database.
- Practice in 20 Hands-On Labs — nothing to install
- 10 Interactive Lessons and 56 topics mapped to the official exam objectives
- 163 Practice Test Questions and 2 Full Length Tests
Self-paced · 1 year access
20 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Skills you'll get
What you will be able to do
Target Career Roles
- Database Developer
- SQL Database Administrator
- SQL Server Database Analyst
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
10 Interactive Lessons · 56 topics01 Introduction 3 topics +
- About 70-765 Exam
- Introducing the Azure SQL Database
- Setting Up Azure
02 Deploy a Microsoft Azure SQL Database 5 topics · 6 LiveLab +
- A Service Tier
- Create Servers and Databases
- Create a sysadmin Account
- Manage Elastic Pools
- Summary
6 LiveLab in this lesson — see the labs panel →
03 Plan for SQL Server Installation 7 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
04 Deploy SQL Server Instances 5 topics · 2 LiveLab +
- Install SQL On-Premises
- Manually Install SQL Server on an Azure Virtual Machine
- Automate the Deployment of SQL Server Databases
- JSON Templates
- Summary
2 LiveLab in this lesson — see the labs panel →
05 Deploy SQL Server Databases to Azure Virtual Machines 5 topics · 2 LiveLab +
- Migrate an On-premises SQL to Azure
- Generate Benchmark Data for Performance Needs
- Perform Performance Tuning on Azure IaaS
- Availability Group
- Summary
2 LiveLab in this lesson — see the labs panel →
06 Configure Secure Access to Microsoft Azure SQL Databases 6 topics · 1 LiveLab +
- Configure Firewall Rules
- Always Encrypted for Azure SQL Database
- Cell-Level Encryption in Azure
- Dynamic Data Masking
- Transparent Data Encryption
- Summary
1 LiveLab in this lesson — see the labs panel →
07 Configure SQL Server Performance 5 topics · 1 LiveLab +
- SQL Server Performance Settings
- SQL Server Memory Configuration
- Database Scoped Configuration
- Azure Portal Alerts
- Summary
1 LiveLab in this lesson — see the labs panel →
08 Manage SQL Server Instances 5 topics · 2 LiveLab +
- Create a Database
- Manage Files and Filegroups
- System Database
- TempDB Best Practices
- Summary
2 LiveLab in this lesson — see the labs panel →
09 Manage SQL Storage 8 topics · 1 LiveLab +
- SMB File Share
- Stretch Database
- Azure Storage Account
- Change Service Tiers
- Wait Statistics
- Storage Pool
- Storage Recovery
- Summary
1 LiveLab in this lesson — see the labs panel →
10 Perform Database Maintenance 7 topics · 4 LiveLab +
- Monitor SQL Server
- Azure SQL Performance Monitoring
- Azure Automation
- Manage Indexes
- Database Integrity
- Database Corruption
- Summary
4 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
20 LiveLabs- 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
- Creating a Web Application
- Restoring a Database in SSMS
- Creating an Azure VM to Host an SQL Server Instance
- Creating a Data Factory
- Creating a Load Balancer
- Creating a Firewall
- Modifying DB Startup Parameters to Optimize Performance
- Adding a File to a Database
- Adding a Filegroup with Two Files to a Database
- Creating a Storage Account in Azure
- Enabling DTA for a Query Store
- Using CHECKDB
- Using sp_who
- Creating a Backup
03 / Exam details
Provisioning SQL Databases (70-765) Details
Get certified for the MCSA 70-765 certification exam with the Provisioning SQL Databases (70-765) course and lab. The lab can be mapped to any course, textbook, or training adding value and a hands-on component to training. The MCSA certification course completely covers the MCSA 70-765 exam objectives and will help you master the skills required to implement SQL in Azure, and manage databases, instances, and storage. The course also teaches you how to configure both firewall rules and Always Encrypted for Azure SQL Database.
Ready to take the exam?
Add your official 70-765 exam voucher to your order.
Official Voucher · Fast delivery · Retake bundle available04 / FAQs
Questions before you start
What are the prerequisites for this exam?+
What is the exam registration fee?+
Where do I take the exam?+
How many questions are asked in the exam?+
What is the duration of the exam?+
What is the passing score?+
What is the exam's retake policy?+
General Microsoft Certification exam retake policy
- If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam. At that time, candidates can log onto their certification dashboard and reschedule the exam themselves.
- If a candidate does not achieve a passing score the second time, the candidate must wait at least 14 days before retaking the exam a third time.
- A 14-day waiting period is also imposed between the third and fourth attempts and fourth and fifth attempts.
- A candidate may not take a given exam any more than five times per year (12 months). This 12-month period starts from the first attempt. The candidate is eligible to retake the exam 12 months from the date of their first attempt.
- To take a given exam more than five times per year or to have the time between attempts waived, a candidate must have experienced one of the errors listed below and request an exception from Microsoft. Requests should be sent to mlsecure@microsoft.com. These requests must include the following information:
- Candidate ID
- First/Last Name
- Email associated with your Candidate ID
- Exam Registration ID
- Exam Number
- Description of error
- Pearson VUE case number
Exam retake exceptions will be granted for the following reasons:
- Failure due to lab crash
- Failure due to Internet connectivity issues
- Failure due to equipment failure
What is the validity of the certification?+
Where can I find more information about this exam?+
Prepare for Provisioning SQL Databases (70-765)
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 20 LiveLab included
- Certificate of completion
No credit card required