Home > Store > Microsoft

Exam Ref 70-764 Administering a SQL Database Infrastructure

Register your product to gain access to bonus material or receive a coupon.

Exam Ref 70-764 Administering a SQL Database Infrastructure

Best Value Purchase

Book + eBook Bundle

  • Your Price: $43.19
  • List Price: $71.98
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

More Purchase Options

Book

  • Your Price: $31.99
  • List Price: $39.99
  • Usually ships in 24 hours.

eBook (Watermarked)

  • Your Price: $25.59
  • List Price: $31.99
  • Estimated Release: Sep 29, 2017
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

About

Features

  • Authoritative and complete MCSA Exam 70-764 preparation content, straight from Microsoft
  • Covers configuring data access and auditing, managing database backup/restore; managing/monitoring SQL Server instances, and managing high availability and disaster recovery
  • Organized by exam objectives for efficient study
  • Strategic, what-if scenarios challenge you as an exam candidate, helping you master the big-picture thinking the exam demands
  • Contains up-to-date exam preparation tips from a long-time Microsoft SQL MVP and Microsoft Certified Trainer (MCT)

Description

  • Copyright 2018
  • Dimensions: 7-3/8 X 9
  • Pages: 416
  • Edition: 1st
  • Book
  • ISBN-10: 1-5093-0383-9
  • ISBN-13: 978-1-5093-0383-0

Prepare for Microsoft Exam 70-764—and help demonstrate your real-world mastery of skills for database administration. This exam is intended for database administrators charged with installation, maintenance, and configuration tasks. Their responsibilities also include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

Focus on the expertise measured by these objectives:

• Configure data access and auditing

• Manage backup and restore of databases

• Manage and monitor SQL Server instances

• Manage high availability and disaster recovery


This Microsoft Exam Ref:

• Organizes its coverage by exam objectives

• Features strategic, what-if scenarios to challenge you

• Assumes you have working knowledge of database installation, configuration, and maintenance tasks. You should also have experience with setting up database systems, ensuring those systems operate efficiently, regularly storing and backing up data, and securing data from unauthorized access.

About the Exam

Exam 70-764 focuses on skills and knowledge required for database administration.


About Microsoft Certification

Passing both Exam 70-764 and Exam 70-765 (Provisioning SQL Databases) earns you credit toward an MCSA: SQL 2016 Database Administration certification. See full details at: microsoft.com/learning

Sample Content

Table of Contents

Contents

Chapter 1 Configure data access and auditing 

Skill 1.1: Configure encryption

Skill 1.2 Configure data access and permissions

Skill 1.3: Configure auditing


Chapter 2 Manage backup and restore of databases

Skill 2.1: Develop a backup strategy

Skill 2.2 Restore databases

Skill 2.3 Manage database integrity


Chapter 3 Manage and monitor SQL Server instances

Skill 3.1: Monitor database activity

Skill 3.2 Monitor queries

Skill 3.3 Manage indexes

Skill 3.4 Manage statistics

Skill 3.5 Monitor SQL Server instances

Chapter 4 Manage high availability and disaster recovery

Skill 4.1: Design a high availability solution

Skill 4.2: Design a disaster recovery solution

Skill 4.3: Implement log shipping

Skill 4.4: Implement Availability Groups

Skill 4.5: Implement failover clustering

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership