70-764
Administering a SQL Database Infrastructure (70-764)
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.
- Practice in 33 Hands-On Labs — nothing to install
- 15 Interactive Lessons and 75 topics mapped to the official exam objectives
- 155 Practice Test Questions and 2 Full Length Tests
Beginner Self-paced · 1 year access 4.4/5 (43 Reviews)
33 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Skills you'll get
What you will be able to do
Target Career Roles
- SQL Analyst
- SQL Developer
- SQL Server Database Administrator
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
15 Interactive Lessons · 75 topics01 Introduction 2 topics +
- About 70-764 Exam
- Install and Configure the AdventureWorks2016 Database
02 Configure Encryption 8 topics +
- Key Management Architecture and Encryption Hierarchy
- Cell-Level Encryption
- Transparent Data Encryption
- Always Encrypted
- Backup Encryption
- Connection Encryption
- Encryption Troubleshooting
- Summary
03 Configure Data Access and Permission 7 topics · 4 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
04 Configure Auditing 4 topics · 2 LiveLab +
- Manage a SQL Server Audit
- Query the SQL Server Audit Log
- Configure and Manage Azure SQL Database Audit
- Summary
2 LiveLab in this lesson — see the labs panel →
05 Develop a Backup Strategy 3 topics · 1 LiveLab +
- SQL Server Backup Tips
- Backup Types
- Summary
1 LiveLab in this lesson — see the labs panel →
06 Manage Database 5 topics · 4 LiveLab +
- Backup Very Large Databases (VLDB)
- Benchmark a Server
- Performance Tuning on Azure IaaS
- Manage Very Large Databases
- Summary
4 LiveLab in this lesson — see the labs panel →
07 Alert Data for Failed Backups 6 topics · 1 LiveLab +
- Configure Alerting for Failed Backups
- Backup Database to Azure
- Manage Transaction Log Backups
- Configure Backup Automation
- Perform Piecemeal Restores
- Summary
1 LiveLab in this lesson — see the labs panel →
08 Restore Data 6 topics · 2 LiveLab +
- Restore Databases
- Perform Page Restore
- Perform Point-in-Time Recovery
- Restore Filegroups
- Develop a Plan to Automate and Test Restores
- Summary
2 LiveLab in this lesson — see the labs panel →
09 Manage Database Integrity 4 topics · 4 LiveLab +
- Implement Database Consistency Checks
- Identify Database Corruption
- Recover from Database Corruption
- Summary
4 LiveLab in this lesson — see the labs panel →
10 Database Activity 4 topics · 4 LiveLab +
- Blocking Activities
- tempdb Resources
- Data Collector
- Summary
4 LiveLab in this lesson — see the labs panel →
11 Query Store 4 topics · 5 LiveLab +
- Manage the Query Store
- Extended Events
- Identify Problematic Execution Plans
- Summary
5 LiveLab in this lesson — see the labs panel →
12 Manage Indexes 5 topics · 2 LiveLab +
- Identify and Repair Index Fragmentation
- Identify and Create Missing Indexes
- Manage Columnstore Indexes
- Manage Partitioned Tables
- Summary
2 LiveLab in this lesson — see the labs panel →
13 SQL Server Instances 6 topics · 4 LiveLab +
- 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
4 LiveLab in this lesson — see the labs panel →
14 Implement Log Shipping and Configure Cluster 5 topics +
- Configure and Monitor Log Shipping
- Windows Server Failover Cluster
- Manage Shared Disks
- Cluster Shared Volumes
- Summary
15 Availability Group 6 topics +
- Database Mirroring
- Create an Availability Group
- Manage Failover
- Configure Read-Only Routing
- Create Distributed Availability Groups
- Summary
Hands-On Labs Our edge
33 LiveLabs- Creating a New User with System Administrator Rights
- Creating a Database Role
- Creating an Application Role
- Granting Permissions to Create Tables
- Creating a Server Audit and its Specification
- Creating and Enabling the SQL Server Audit Log
- Setting the Recovery Model in SQL Server
- 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
- Monitoring a Full Backup of the Database
- Restoring a Database
- Restoring Filegroups
- Using the ALTER Command with the ROLLBACK IMMEDIATE Command
- Using CHECKDB
- Using the CHECKSUM Verification
- Creating a Database Snapshot
- Using sp_who
- Using sys.dm_os_waiting_tasks
- Using sys.dm_db_file_space_usage
- Returning Pages and Usage Information of User Objects
- 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
- Enabling DTA for a Query Store
- Creating a Partitioned Table Using SSMS
- Creating Custom Categories for Policies
- Using sys.dm_os_volume_stats
- Modifying DB Startup Parameters to Optimize Performance
- Creating an Event Session
03 / Exam details
Administering a SQL Database Infrastructure (70-764) Details
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.
Ready to take the exam?
Add your official 70-764 exam voucher to your order.
Official Voucher · Fast delivery · Retake bundle available04 / FAQs
Questions before you start
What are the prerequisites for this exam?+
What is the exam registration fee?+
Where do I take the exam?+
How many questions are asked in the exam?+
What is the duration of the exam?+
What is the passing score?+
What is the exam's retake policy?+
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
What is the validity of the certification?+
Where can I find more information about this exam?+
Prepare for Administering a SQL Database Infrastructure (70-764)
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 33 LiveLab included
- Certificate of completion
No credit card required