Prepare for Microsoft Exam 70-765–and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level.
Focus on the expertise measured by these objectives:
• Implement SQL in Azure
• Manage databases and instances
• Manage storage
This Microsoft Exam Ref:
• Organizes its coverage by exam objectives
• Features strategic, what-if scenarios to challenge you
• Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills
Provisioning SQL Databases About the Exam
Exam 70-765 focuses on skills and knowledge for provisioning, upgrading, and configuring SQL Server; managing databases and files; and provisioning, migrating, and managing databases in the Microsoft Azure cloud.
About Microsoft Certification
Passing this exam as well as Exam 70-764: Administering a SQL Database Infrastructure earns you MCSA: SQL 2016 Database Administration certification, qualifying you for a position as a database administrator or infrastructure specialist.
See full details at: microsoft.com/learning
About the Author
Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry & Associates and lives in Malvern, PA.
Scott Klein loves data. His passion for data brought him to Cloud and Devices where he continues to help developers and companies grok the benefits of cloud computing.
Table of Contents
Chapter 1 Implement SQL in Azure
Skill 1:1: Deploy a Microsoft Azure SQL Database
Skill 1:2: Plan for SQL Server installation
Skill 1:3: Deploy SQL Server instances
Skill 1:4: Deploy SQL Server databases to Azure virtual machines
Chapter 2 Manage databases and instances
Skill 2.1: Configure secure access to Microsoft Azure SQL databases
Skill 2.2: Configure SQL Server performance settings
Skill 2.3: Manage SQL Server instances
Chapter 3 Manage Storage
Skill 3.1: Manage SQL Storage
Skill 3.2: Perform database maintenance