Microsoft 70-765: Provisioning SQL Databases
$99.00
This Microsoft 70-765 course teaches you how to provision and manage SQL Server databases on premises and in Azure. It has 102 videos and runs for 22 hours 19 minutes.
- Login details sent straight after payment
- Self-paced. Study on any device
- StemBoss Certificate of Completion
- 14-day refund promise
Secure checkout. Pay by card, Apple Pay or Google Pay.
Microsoft 70-765: Provisioning SQL Databases is a course for database administrators who set up and manage SQL Server databases, both on premises and in Microsoft Azure. It follows the topics of Microsoft exam 70-765 and suits people who already know the basics of SQL Server. The course runs for 22 hours 19 minutes across 102 video lessons.
What you will learn
- Plan SQL Server solutions for on-premises and cloud use
- Deploy SQL Server on Azure virtual machines
- Set up and manage Azure SQL Database
- Configure and manage database instances
- Configure database storage to meet business needs
- Set up high availability with Always On availability groups, log shipping and database mirroring
- Plan for disaster recovery
- Manage database security, access, permissions and auditing
- Carry out routine database maintenance tasks
Topics covered
- Implement SQL in Azure: running SQL Server on Azure virtual machines and using Azure SQL Database.
- Manage databases and instances: installing, configuring and looking after SQL Server instances and databases.
- Manage storage: setting up database storage so data stays safe and performs well.
- Availability and recovery: keeping databases online with Always On availability groups, log shipping and mirroring, and ready to recover after a failure.
- Security and auditing: controlling who can reach data, setting permissions and tracking what users do.
- Maintenance: the routine tasks that keep databases healthy over time.
Who this course is for
- SQL Server administrators planning a move from on-premises servers to Azure
- Database administrators who look after SQL Server
- IT professionals who plan SQL Server solutions in Azure or on premises
- SQL Server specialists moving workloads to the cloud
- Learners who studied the 70-765 topics and want a structured refresher
- Administrators who need to keep business databases secure, available and easy to recover
Before you start
This course is not for complete beginners. You should have a working knowledge of SQL Server administration and maintenance, and some experience with Azure. If you are new to SQL Server, start with a querying or administration course first. Access to a test SQL Server instance, and an Azure account you can practise in, will help you try each task as you learn it. Always practise on test systems, never on live databases.
About the 70-765 exam
Exam 70-765, Provisioning SQL Databases, was set by Microsoft. It checked that you could plan and build Azure SQL Database solutions, run SQL Server in Azure virtual machines and manage SQL Server on premises. It counted towards the MCSA: SQL 2016 Database Administration certification. Microsoft has since retired this exam and now offers role-based database certifications, such as DP-300: Administering Microsoft Azure SQL Solutions. The provisioning, storage and availability skills in this course still apply to SQL Server work today.
Jobs this course supports
- Database administrator
- SQL Server specialist
- Cloud database professional
| Skill level | Intermediate |
|---|---|
| Duration | 22 Hours 19 Minutes |
| Videos | 102 Course Videos |
| Questions | 247 Test Questions |
| Certification | Microsoft MCSA: SQL 2016 Database Administration (retired) |
| Exam code | 70-765 |
| Certification body | Microsoft |
| Prerequisites | Working knowledge of SQL Server administration and some Azure skills. |
| Best for | Database administrators, SQL Server specialists, cloud database professionals |
| Topics covered | SQL Server on Azure VMs, Azure SQL Database, Database instances, Database storage, High availability, Disaster recovery, Security and auditing |
| Format | Online video lessons, self-paced |
| Language | English |
| Certificate | StemBoss Certificate of Completion |
What is inside this course
9 modules and 102 lessons. Here is the full outline.
Module 1: Deploy a Microsoft Azure SQL Database16 lessons
- Introduction
- Introducing the Azure SQL Database Part 1
- Introducing the Azure SQL Database Part 2
- Setting Up Azure Lab
- Chose a Service Tier Part 1
- Chose a Service Tier Part 2
- Create Servers and Databases Part 1
- Creating a Azure SQL Server and Database Lab
- Create Servers and Databases Part 2
- Create Servers and Databases Part 3
- Connecting SSMS to Azure SQL Lab Part 1
- Connecting SSMS to Azure SQL Lab Part 2
- Create a Sysadmin Account
- Creating Azure SQL Logins and Users Lab
- Congure Elastic Pools
- Creating and Conguring an Elastic Pool Lab
Module 2: Plan for SQL Server Installation7 lessons
- Plan for an IaaS or On-Premises Deployment Part 1
- Plan for an IaaS or On-Premises Deployment Part 2
- Select the Appropriate Size for a Virtual Machine
- Plan Storage Pools Based on Performance Requirements Part 1
- Plan Storage Pools Based on Performance Requirements Part 2
- Evaluate Best Practices for Installation
- Design a Storage Layout for a SQL Server Virtual Machine
Module 3: Deploy SQL Server Instances11 lessons
- Deploy a SQL Server Instance in IaaS and On-Premises
- Restoring AdventureWorks 2016 Database Lab
- Provision an Azure Virtual Machine to Host a SQL Server Instance
- Provisioning an Azure Virtual Machine to Host a SQL Server Lab
- Manually Install SQL Server on an Azure Virtual Machine
- Installing SQL 2016 Lab Part 1
- Installing SQL 2016 Lab Part 2
- Automate the Deployment of SQL Server Databases
- Exploring Azure SQL Database Automation Lab
- Deploy SQL Server by Using Templates
- Managing JSON Templates Lab
Module 4: Deploy SQL Server Databases to Azure Virtual Machines18 lessons
- Migrate an On-Premises SQL Server Database to an Azure Virtual Machine
- Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 1
- Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 2
- Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 3
- Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 4
- Generate Benchmark Data for Performance Needs
- Generating Benchmark Data Lab Part 1
- Generating Benchmark Data Lab Part 2
- Perform Performance Tuning on Azure IaaS
- Perform Performance Tuning on Azure IaaS Lab Part 1
- Perform Performance Tuning on Azure IaaS Lab Part 2
- Support Availability Sets in Azure Part 1
- Support Availability Sets in Azure Part 2
- Manage High Availability Lab Part 1
- Manage High Availability Lab Part 2
- Manage High Availability Lab Part 3
- Manage High Availability Lab Part 4
- Manage High Availability Lab Part 5
Module 5: Configure Secure Access to Microsoft Azure SQL Databases10 lessons
- Configure Firewall Rules
- Creating Firewall Rules Lab
- Configure Always Encrypted for Azure SQL Database
- Implementing Always Encrypted Lab
- Configure Cell-Level Encryption
- Cell-Level Encryption Lab
- Configure Dynamic Data Masking
- Dynamic Data Masking Lab
- Configure Transparent Data Encryption (TDE)
- Transparent Data Encryption (TDE) Lab
Module 6: Configure SQL Server performance settings8 lessons
- Configure SQL Performance Settings
- Configuring SQL Performance Settings Lab
- Configure Max Server Memory
- Configuring SQL Memory Lab
- Configure Database Performance Settings
- Configure Database Performance Settings Lab
- Configure Operators and Alerts
- Configure alerts in Azure and On-Premise SQL Server Lab
Module 7: Manage SQL Server instances8 lessons
- Create Databases
- Creating Databases Lab
- Manage Files and File Groups
- Managing Files and File Groups Lab
- Manage System Database Files
- Manage System Database Files Lab
- Configure tempdb
- Configure tempdb Lab
Module 8: Manage SQL Storage11 lessons
- Manage SMB File Shares
- Manage SMB File Shares Lab
- Manage Stretch Databases
- Configure Azure Storage
- Change Service Tiers
- Change Service Tiers Lab Part 1
- Review Wait Statistics
- Manage Storage Pools
- Recover from Failed Storage
- Managing Storage Lab Part 1
- Managing Storage Lab Part 2
Module 9: Perform Database Maintenance13 lessons
- Monitoring Tools
- Using Monitoring Tools Lab Part 1
- Using Monitoring Tools Lab Part 2
- Azure Performance Tuning
- Automate Maintenance Tasks
- Update Statistics and Indexes
- Update Statistics and Indexes Lab Part 1
- Update Statistics and Indexes Lab Part 2
- Verify Database Integrity
- Verify Database Integrity Lab
- Recover from Database Corruption
- Recover from Database Corruption Lab
- Conclusion
Your learning path
Where Microsoft 70-765: Provisioning SQL Databases fits. Build your skills one step at a time.
Frequently asked questions
Is the 70-765 exam still available?
No. Microsoft has retired exam 70-765 and the MCSA certifications. Its role-based database exam today is DP-300: Administering Microsoft Azure SQL Solutions.
Does this course cover Azure as well as on-premises SQL Server?
Yes. It covers SQL Server on Azure virtual machines and Azure SQL Database, as well as installing and managing SQL Server on premises.
Which high availability options are covered?
The course looks at Always On availability groups, log shipping and database mirroring, and how each one keeps databases available.
What should I know before I start?
You should already know how to administer and maintain SQL Server, and have some Azure skills. It is an intermediate course.
How long is the course?
It has 102 video lessons with a total running time of 22 hours 19 minutes, plus 247 test questions.
Do I get a certificate?
Yes. You get a StemBoss Certificate of Completion when you finish the course.
Can I get a refund?
Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.
