• Home
uCertify Logo
  • 0
    • Your cart is empty
    • Continue Shopping
    • View Cart
  • Login or Signup
    • Help & Support
    • Accessibility
    • Testimonials
  • Powered by uCertify
  • Request Demo
  • Cart 0
    • Your cart is empty
    • Continue Shopping
    • View Cart
  • Hello GuestLogin or Signup
  • Feedback & Support
    • Support
    • Keyboard Shortcuts
    • Send Feedback
Scroll to top button

Provisioning SQL Databases (70-765)

(70-765) / ISBN: 9781644591222
This course includes
Lessons
TestPrep
LiveLab
70-765 : Provisioning SQL Databases (70-765)
Share
$198
Try This Course Buy Now
Are you an instructor?
Request a free evaluation copy

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.
Here's what you will 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.

Lessons
  • 10+ Lessons
  • 89+ Quizzes
  • 94+ Flashcards
  • 94+ Glossary of terms
TestPrep
  • 40+ Pre Assessment Questions
  • 2+ Full Length Tests
  • 40+ Post Assessment Questions
  • 80+ Practice Test Questions
Lab
  • 20+ Performance lab
Video Lessons
  • 101+ Videos
  • 22:22+ Hours
Here's what you will learn
Download Course Outline
Lesson 1: Introduction
  • About 70-765 Exam
  • Introducing the Azure SQL Database
  • Setting Up Azure
Lesson 2: Deploy a Microsoft Azure SQL Database
  • A Service Tier
  • Create Servers and Databases
  • Create a sysadmin Account
  • Manage Elastic Pools
  • Summary
Lesson 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
Lesson 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
Lesson 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
Lesson 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
Lesson 7: Configure SQL Server Performance
  • SQL Server Performance Settings
  • SQL Server Memory Configuration
  • Database Scoped Configuration
  • Azure Portal Alerts
  • Summary
Lesson 8: Manage SQL Server Instances
  • Create a Database
  • Manage Files and Filegroups
  • System Database
  • TempDB Best Practices
  • Summary
Lesson 9: Manage SQL Storage
  • SMB File Share
  • Stretch Database
  • Azure Storage Account
  • Change Service Tiers
  • Wait Statistics
  • Storage Pool
  • Storage Recovery
  • Summary
Lesson 10: Perform Database Maintenance
  • Monitor SQL Server 
  • Azure SQL Performance Monitoring 
  • Azure Automation
  • Manage Indexes
  • Database Integrity
  • Database Corruption
  • Summary

Hands on Activities (Performance Labs)

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

Plan for SQL Server Installation

  • Creating a Web Application

Deploy SQL Server Instances

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

Deploy SQL Server Databases to Azure Virtual Machines

  • Creating a Data Factory
  • Creating a Load Balancer

Configure Secure Access to Microsoft Azure SQL Databases

  • Creating a Firewall

Configure SQL Server Performance

  • Modifying DB Startup Parameters to Optimize Performance

Manage SQL Server Instances

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

Manage SQL Storage

  • Creating a Storage Account in Azure

Perform Database Maintenance

  • Enabling DTA for a Query Store
  • Using CHECKDB
  • Using sp_who
  • Creating a Backup
Exam FAQs
What are the prerequisites for this exam? There are no technical prerequisites for this certification.
What is the exam registration fee? USD 165
Where do I take the exam? Pearson VUE
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 120 minutes
What is the passing score? The passing score varies from exam to exam and is provided on the score report.
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? For life
Where can I find more information about this exam? To know more about the , click here.
What are the career opportunities after passing this exam?
  • Database Developer
  • SQL Database Administrator
  • SQL Server Database Analyst
×
uc logo for app downloadDownload our uCertify App [lms_setting_placeholder: This filed is used to set the LMS settings.

Share with your friends and colleagues

We use cookies to enhance your experience. By continuing to visit this site you agree to our use of cookies. More information
Accept