Scroll to top button

Administering a SQL Database Infrastructure

ISBN : 9781644590997

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 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.

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.

Glossary of terms
Pre Assessment Questions
Full Length Tests
Post Assessment Questions
Performance lab
Learn the real world skills using LiveLab.
Video tutorials
Get interactive learning videos with transcripts and voice-over.
Signify the duration of video tutorials in labs.

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
  • About 70-764 Exam
  • Install and Configure the AdventureWorks2016 Database
  • Key Management Architecture and Encryption Hierarchy
  • Cell-Level Encryption
  • Transparent Data Encryption
  • Always Encrypted 
  • 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 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