Microsoft

Administering a SQL Database Infrastructure (70-764)

(70-764) / ISBN : 978-1-64459-099-7
Lessons
Lab
TestPrep
43 Reviews
Get A Free Trial

About This Course

Kick start your prep for the MCSA 70-764 certification exam with the Administering a SQL Database Infrastructure (70-764) course and lab. The lab is cloud-based, device-enabled, and can be easily integrated with an LMS. The SQL training course covers the MCSA 70-764 exam objectives and provides the knowledge and skills required to configure data access and auditing; manage backup and restore of the database; manage and monitor SQL Server instance; and manage high availability and disaster recovery.

Skills You’ll Get

The Microsoft MCSA SQL certification is a globally recognized credential for validating Querying Microsoft SQL Server knowledge. The Microsoft 70-764 exam measures the skill of a candidate to accomplish the technical tasks related to SQL. The MCSA Administering a SQL Database Infrastructure certification is intended for database professionals who perform installation, maintenance, and configuration tasks, and other responsibilities including setting up and securing data from unauthorized access.
Download Course Outline

1

Introduction

  • About 70-764 Exam
  • Install and Configure the AdventureWorks2016 Database
2

Configure Encryption

  • Key Management Architecture and Encryption Hierarchy
  • Cell-Level Encryption
  • Transparent Data Encryption
  • Always Encrypted 
  • Backup Encryption
  • Connection Encryption
  • Encryption Troubleshooting
  • Summary
3

Configure Data Access and Permission

  • Create and Maintain Users
  • Create and Maintain Custom Roles
  • Manage Database Object Permission
  • Configure User Option for Azure SQL Database
  • Configure Row-Level Security (RLS)
  • Configure Dynamic Data Masking (DDM)
  • Summary
4

Configure Auditing

  • Manage a SQL Server Audit
  • Query the SQL Server Audit Log
  • Configure and Manage Azure SQL Database Audit
  • Summary
5

Develop a Backup Strategy

  • SQL Server Backup Tips
  • Backup Types
  • Summary
6

Manage Database

  • Backup Very Large Databases (VLDB)
  • Benchmark a Server
  • Performance Tuning on Azure IaaS
  • Manage Very Large Databases
  • Summary
7

Alert Data for Failed Backups

  • Configure Alerting for Failed Backups
  • Backup Database to Azure
  • Manage Transaction Log Backups
  • Configure Backup Automation
  • Perform Piecemeal Restores
  • Summary
8

Restore Data

  • Restore Databases
  • Perform Page Restore
  • Perform Point-in-Time Recovery
  • Restore Filegroups
  • Develop a Plan to Automate and Test Restores
  • Summary
9

Manage Database Integrity

  • Implement Database Consistency Checks
  • Identify Database Corruption
  • Recover from Database Corruption
  • Summary
10

Database Activity

  • Blocking Activities
  • tempdb Resources
  • Data Collector
  • Summary
11

Query Store

  • Manage the Query Store
  • Extended Events
  • Identify Problematic Execution Plans
  • Summary
12

Manage Indexes

  • Identify and Repair Index Fragmentation
  • Identify and Create Missing Indexes
  • Manage Columnstore Indexes
  • Manage Partitioned Tables
  • Summary
13

SQL Server Instances

  • Create and Manage Operators
  • Create and Manage SQL Agent Alerts
  • Configure Policy-Based Management
  • Identify Available Space on Data Volumes
  • Identify the Cause of Manage Performance Degradation
  • Summary
14

Implement Log Shipping and Configure Cluster

  • Configure and Monitor Log Shipping
  • Windows Server Failover Cluster
  • Manage Shared Disks
  • Cluster Shared Volumes
  • Summary
15

Availability Group

  • Database Mirroring
  • Create an Availability Group
  • Manage Failover
  • Configure Read-Only Routing
  • Create Distributed Availability Groups
  • Summary

1

Configure Data Access and Permission

  • Creating a New User with System Administrator Rights
  • Creating a Database Role
  • Creating an Application Role
  • Granting Permissions to Create Tables
2

Configure Auditing

  • Creating a Server Audit and its Specification
  • Creating and Enabling the SQL Server Audit Log
3

Develop a Backup Strategy

  • Setting the Recovery Model in SQL Server
4

Manage Database

  • Adding a File to a Database
  • Adding a Filegroup with Two Files to a Database
  • Adding Two Log Files to a Database
  • Removing a File from a Database
5

Alert Data for Failed Backups

  • Monitoring a Full Backup of the Database
6

Restore Data

  • Restoring a Database
  • Restoring Filegroups
7

Manage Database Integrity

  • Using the ALTER Command with the ROLLBACK IMMEDIATE Command
  • Using CHECKDB
  • Using the CHECKSUM Verification
  • Creating a Database Snapshot
8

Database Activity

  • Using sp_who
  • Using sys.dm_os_waiting_tasks
  • Using sys.dm_db_file_space_usage
  • Returning Pages and Usage Information of User Objects
9

Query Store

  • Retrieving Information About Query Store Options
  • Retrieving Information About Query Store Status
  • Retrieving All of the Stored Procedures for a Database
  • Retrieving a List of T-SQL Statements and Query Plans
  • Retrieving the Query Plan, Query Text, and Execution Count
10

Manage Indexes

  • Enabling DTA for a Query Store
  • Creating a Partitioned Table Using SSMS
11

SQL Server Instances

  • Creating Custom Categories for Policies
  • Using sys.dm_os_volume_stats
  • Modifying DB Startup Parameters to Optimize Performance
  • Creating an Event Session

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

There are no technical prerequisites for this certification.

USD 165

Pearson VUE

The exam contains 40-60 questions.

120 minutes

The passing score varies from exam to exam and is provided on the score report.

General Microsoft Certification exam retake policy

  • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam. At that time, candidates can log onto their certification dashboard and reschedule the exam themselves.
  • If a candidate does not achieve a passing score the second time, the candidate must wait at least 14 days before retaking the exam a third time.
  • A 14-day waiting period is also imposed between the third and fourth attempts and fourth and fifth attempts.
  • A candidate may not take a given exam any more than five times per year (12 months). This 12-month period starts from the first attempt. The candidate is eligible to retake the exam 12 months from the date of their first attempt.
  • To take a given exam more than five times per year or to have the time between attempts waived, a candidate must have experienced one of the errors listed below and request an exception from Microsoft. Requests should be sent to mlsecure@microsoft.com. These requests must include the following information:
    • Candidate ID
    • First/Last Name
    • Email associated with your Candidate ID
    • Exam Registration ID
    • Exam Number
    • Description of error
    • Pearson VUE case number

Exam retake exceptions will be granted for the following reasons:

  • Failure due to lab crash
  • Failure due to Internet connectivity issues
  • Failure due to equipment failure

For life

Know more about the 70-764

Administering a SQL Database Infrastructure (70-764)

$ 279.99

Buy Now

Related Courses

All Course
Microsoft Office Word 2016 Expert (77-725 & 77-726)
77-725-77-726 - Microsoft Office Word 2016 Expert (77-725 & 77-726)
Lessons Lab TestPrep AI Tutor
Microsoft Office Word 2016 Expert (77-725 & 77-726)

Microsoft Office Word 2016 Expert (77-725 & 77-726)

ISBN: 9781644591505
77-725-77-726
Buy Now
Microsoft Office Excel 2016 Expert (77-727-77-728)
77-727-77-728 - Microsoft Office Excel 2016 Expert (77-727-77-728)
Lessons Lab TestPrep AI Tutor
Microsoft Office Excel 2016 Expert (77-727-77-728)

Microsoft Office Excel 2016 Expert (77-727-77-728)

ISBN: 9781644591406
77-727-77-728
Buy Now
Microsoft PowerPoint 2016
77-729 - Microsoft PowerPoint 2016
Lessons Lab TestPrep AI Tutor
Microsoft PowerPoint 2016

Microsoft PowerPoint 2016

ISBN: 9781644591062
77-729
Buy Now
Microsoft Access 2016 (77-730)
77-730 - Microsoft Access 2016 (77-730)
Lessons Lab TestPrep AI Tutor
Microsoft Access 2016 (77-730)

Microsoft Access 2016 (77-730)

ISBN: 9781644591543
77-730
Buy Now
Microsoft Azure Administration (AZ-104)
AZ-104.AP2 - Microsoft Azure Administration (AZ-104)
Lessons Lab TestPrep AI Tutor
Microsoft Azure Administration (AZ-104)

Microsoft Azure Administration (AZ-104)

ISBN: 9781644593226
AZ-104.AP2
Buy Now
Developing Solutions for Microsoft Azure
AZ-204.AP1 - Developing Solutions for Microsoft Azure
Lessons Lab TestPrep AI Tutor
Developing Solutions for Microsoft Azure

Developing Solutions for Microsoft Azure

ISBN: 9781644593639
AZ-204.AP1
Buy Now
Designing Microsoft Azure Infrastructure Solutions
AZ-305.AP1 - Designing Microsoft Azure Infrastructure Solutions
Lessons Lab TestPrep AI Tutor
Designing Microsoft Azure Infrastructure Solutions

Designing Microsoft Azure Infrastructure Solutions

ISBN: 9781644594216
AZ-305.AP1
Buy Now
scroll to top