Exam Ref 70-764 Administering a SQL Database Infrastructure

Exam Ref 70-764 Administering a SQL Database Infrastructure

by Victor Isakov

Paperback

$38.63 $39.99 Save 3% Current price is $38.63, Original price is $39.99. You Save 3%.
View All Available Formats & Editions
Eligible for FREE SHIPPING
  • Want it by Friday, October 19  Order now and choose Expedited Shipping during checkout.
    Same Day shipping in Manhattan. 
    See Details

Overview

Exam Ref 70-764 Administering a SQL Database Infrastructure by Victor Isakov

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

Product Details

ISBN-13: 9781509303830
Publisher: Microsoft Press
Publication date: 10/02/2017
Series: Exam Ref Series
Pages: 416
Sales rank: 497,131
Product dimensions: 7.40(w) x 8.90(h) x 1.00(d)

About the Author

Victor Isakov is a Microsoft Certified Master, Microsoft Certified Architect, and Microsoft Certified Trainer. He’s worked with SQL Server since 1994 and is a Microsoft SQL Server MVP. Victor is the author of MCITP Developer: Microsoft SQL Server 2005 Database Solutions Design (Exam 70-441) Study Guide (Sybex, 2006) and co-author of MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide (Sybex, 2007). He also co-authored the Microsoft SQL Server 2005 Administrator’s Companion (Microsoft Press, 2006) and helped to create the High Availability course for Microsoft’s official curriculum. Currently Victor is based in Sydney, Australia, and provides consulting and training services to organizations worldwide.

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

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews