Administering a SQL Database Infrastructure

Coming Soon:

This product will be available from 30-Sep-2019

Gain hands-on experience to pass the Microsoft MCSA SQL Server 70-764 certification exam with the Administering a SQL Database Infrastructure course and lab. The lab is cloud-based, device-enabled, and can be easily integrated with an LMS. Interactive chapters comprehensively cover the Microsoft MCSA 70-764 certification exam objectives and provide 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.

Here's what you will get

The Microsoft MCSA Administering a SQL Database Infrastructure certification is globally recognized credential for validating Querying Microsoft SQL Server knowledge. The Microsoft 70-461 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.

Videos and How To..

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Exam FAQs
What are the prerequisites for this exam? There are no defined pre-requisites for this certification.
What is the exam registration fee? USD 165
Where do I take the exam?

Microsoft

How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 120 minutes
What is the passing score? 700
What is the exam's retake policy?

Here are the retake policies:

  • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait at least 24 hours before retaking the exam.
  • 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 for the fourth and fifth subsequent exam retakes. A candidate may not take a given exam any more than five times per year (12 months). This 12-month period starts the day of the fifth unsuccessful exam retake. The candidate is then eligible to retake the exam 12 months from that date. To take a given exam more than five times per year or to have the time between attempts waived, a candidate must submit a request and obtain prior permission from Microsoft. Requests should be sent to mlsecure@microsoft.com. These requests should include the following information:
  • MCID
  • Name
  • Email
  • Exam Number
  • If a candidate achieves a passing score on an exam, the candidate cannot take the exam again. Microsoft reserves the right to make some exams available for retake. For a complete list of exams that can be retaken annually, click here.
What is the validity of the certification? Microsoft certifications have no expiration. The certification holder is certified for life unless the vendor changes its policy.
Where can I find more information about this exam? To know more about the 70-764, click here.
What are the career opportunities after passing this exam?
  • SQL Analyst
  • SQL Developer
  • SQL Server Database Administrator

Here's what you will learn

  • About 70-764 Exam
  • Install and Configure the AdventureWorks2016 Database
  • Key Management Architecture and Encryption Hierarchy
  • Cell-Level Encryption
  • Transparent Data Encryption
  • Always Encrypted (AE)
  • Backup Encryption
  • Connection Encryption
  • Encryption Troubleshooting
  • Summary
  • 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
  • Manage a SQL Server Audit
  • Query the SQL Server Audit Log
  • Configure and Manage Azure SQL Database Audit
  • Summary
  • SQL Server Backup Tips
  • Backup Types
  • Summary
  • Backup Very Large Databases (VLDB)
  • Benchmark a Server
  • Performance Tuning on Azure IaaS
  • Manage Very Large Databases
  • Summary
  • Configure Alerting for Failed Backups
  • Backup Database to Azure
  • Manage Transaction Log Backups
  • Configure Backup Automation
  • Perform Piecemeal Restores
  • Summary
  • Restore Databases
  • Perform Page Restore
  • Perform Point-in-Time Recovery
  • Restore Filegroups
  • Develop a Plan to Automate and Test Restores
  • Summary
  • Implement Database Consistency Checks
  • Identify Database Corruption
  • Recover from Database Corruption
  • Summary
  • Blocking Activities
  • tempdb Resources
  • Data Collector
  • Summary
  • Manage the Query Store
  • Extended Events
  • Identify Problematic Execution Plans
  • Summary
  • Identify and Repair Index Fragmentation
  • Identify and Create Missing Indexes
  • Manage Columnstore Indexes
  • Manage Partitioned Tables
  • Summary
  • 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
  • Configure and Monitor Log Shipping
  • Windows Server Failover Cluster
  • Manage Shared Disks
  • Cluster Shared Volumes
  • Summary
  • Database Mirroring
  • Create an Availability Group
  • Manage Failover
  • Configure Read-Only Routing
  • Create Distributed Availability Groups
  • Summary

Hands on Activities (Labs)

  • 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 Database
  • Restoring Filegroups
  • Using the ALTER Command with the ROLLBACK IMMEDIATE Command
  • Using CHECKDB
  • Using the CHECKSUM Verification
  • Using sys.dm_os_waiting_tasks
88 88
70-764
Administering a SQL Database Infrastructure
ISBN : 9781644590997