Provisioning SQL Databases (70-765)
(70-765)
/ ISBN: 9781644591222
This course includes
Lessons
TestPrep
LiveLab
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.
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
- About 70-765 Exam
- Introducing the Azure SQL Database
- Setting Up Azure
- A Service Tier
- Create Servers and Databases
- Create a sysadmin Account
- Manage Elastic Pools
- Summary
- 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
- Install SQL On-Premises
- Manually Install SQL Server on an Azure Virtual Machine
- Automate the Deployment of SQL Server Databases
- JSON Templates
- Summary
- Migrate an On-premises SQL to Azure
- Generate Benchmark Data for Performance Needs
- Perform Performance Tuning on Azure IaaS
- Availability Group
- Summary
- Configure Firewall Rules
- Always Encrypted for Azure SQL Database
- Cell-Level Encryption in Azure
- Dynamic Data Masking
- Transparent Data Encryption
- Summary
- SQL Server Performance Settings
- SQL Server Memory Configuration
- Database Scoped Configuration
- Azure Portal Alerts
- Summary
- Create a Database
- Manage Files and Filegroups
- System Database
- TempDB Best Practices
- Summary
- SMB File Share
- Stretch Database
- Azure Storage Account
- Change Service Tiers
- Wait Statistics
- Storage Pool
- Storage Recovery
- Summary
- Monitor SQL Server
- Azure SQL Performance Monitoring
- Azure Automation
- Manage Indexes
- Database Integrity
- Database Corruption
- Summary
Hands on Activities (Performance Labs)
- 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
×
