70-765 Provisioning SQL Databases
Exam Preparation Microsoft Certification for SQL server 2016, Exam 70-765
70-765 Provisioning SQL Databases udemy course
Exam Preparation Microsoft Certification for SQL server 2016, Exam 70-765
Update Alert
1 Dec 2020
Re-Written Practice test- 2,3 and 4 with improved English.
Added new Practice Test -5 with 20 new questions.
30 Nov 2020
Re-Written Practice test- 1 with improved English.
Microsoft MCSA 70-765 for SQL server Practice Test
MCSA 70-765 practice test
This course contain 3 Practice test for Microsoft Certification exam 70-765 for SQL server 2016.
It cover 100% of Microsoft certification syllabus.
You can find questions more on practical side,they will help you to solve your real time problems.
Course Detail
Deploy a Microsoft Azure SQL Database
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 Database and instances
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
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
