0%

Book Description

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

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright Page
  4. Contents at a Glance
  5. Table of Contents
  6. Introduction
    1. Organization of this book
    2. Microsoft certifications
    3. Acknowledgments
    4. Microsoft Virtual Academy
    5. Quick access to online references
    6. Errata, updates, & book support
    7. We want to hear from you
    8. Stay in touch
    9. Important: How to use this book to study for the exam
  7. Chapter 1 Implement SQL in Azure
    1. Skill 1:1: Deploy a Microsoft Azure SQL Database
    2. Skill 1:2: Plan for SQL Server installation
    3. Skill 1:3: Deploy SQL Server instances
    4. Skill 1:4: Deploy SQL Server databases to Azure virtual machines
    5. Thought experiment
    6. Thought experiment answers
    7. Chapter summary
  8. Chapter 2 Manage databases and instances
    1. Skill 2.1: Configure secure access to Microsoft Azure SQL databases
    2. Skill 2.2: Configure SQL Server performance settings
    3. Skill 2.3: Manage SQL Server instances
    4. Thought Experiment
    5. Thought experiment answers
    6. Chapter summary
  9. Chapter 3 Manage Storage
    1. Skill 3.1: Manage SQL Storage
    2. Skill 3.2: Perform database maintenance
    3. Thought experiment
    4. Thought experiment answers
    5. Chapter summary
  10. Index
  11. Code Snippets