Máster Microsoft MCSA Administración de Microsoft SQL Server 2016

MOC 20764-ADMINISTERING A SQL DATABASE INFRASTRUCTURE
SQL SERVER SECURITY
-Authenticating Connections to SQL Server
-Authorizing Logins to Connect to databases
-Authorization Across Servers
-Partially Contained Databases

ASSIGNING SERVER AND DATABASE ROLES
-Working with server roles
-Working with Fixed Database Roles
-Assigning User-Defined Database Roles

AUTHORIZING USERS TO ACCESS RESOURCES
-Authorizing User Access to Objects
-Authorizing Users to Execute Code
-Configuring Permissions at the Schema Level

PROTECTING DATA WITH ENCRYPTION AND AUDITING
-Options for auditing data access in SQL Server
-Implementing SQL Server Audit
-Managing SQL Server Audit
-Protecting Data with Encryption

RECOVERY MODELS AND BACKUP STRATEGIES
-Understanding Backup Strategies
-SQL Server Transaction Logs
-Planning Backup Strategies

BACKING UP SQL SERVER DATABASES
-Backing Up Databases and Transaction Logs
-Managing Database Backups
-Advanced Database Options

RESTORING SQL SERVER 2016 DATABASES
-Understanding the Restore Process
-Restoring Databases
-Advanced Restore Scenarios
-Point-in-Time Recovery

AUTOMATING SQL SERVER MANAGEMENT
-Automating SQL Server management
-Working with SQL Server Agent
-Managing SQL Server Agent Jobs
-Multi-server Management

CONFIGURING SECURITY FOR SQL SERVER AGENT
-Understanding SQL Server Agent Security
-Configuring Credentials
-Configuring Proxy Accounts

MONITORING SQL SERVER WITH ALERTS AND NOTIFICATIONS
-Monitoring SQL Server Errors
-Configuring Database Mail
-Operators, Alerts, and Notifications
-Alerts in Azure SQL Database

INTRODUCTION TO MANAGING SQL SERVER BY USING POWERSHELL
-Getting Started with Windows PowerShell
-Configure SQL Server using PowerShell
-Administer and Maintain SQL Server with PowerShell
-Managing Azure SQL Databases using PowerShell

TRACING ACCESS TO SQL SERVER WITH EXTENDED EVENTS
-Extended Events Core Concepts
-Working with Extended Events

MONITORING SQL SERVER
-Monitoring activity
-Capturing and Managing Performance Data
-Analyzing Collected Performance Data
-SQL Server Utility

TROUBLESHOOTING SQL SERVER
-A Trouble Shooting Methodology for SQL Server
-Resolving Service Related Issues
-Resolving Connectivity and Log-in issues

IMPORTING AND EXPORTING DATA
-Transferring Data to and from SQL Server
-Importing and Exporting Table Data
-Using bcp and BULK INSERT to Import Data
-Deploying and Upgrading Data-Tier Application
 
MOC 20765: PROVISIONING SQL DATABASES
SQL SERVER 2016 COMPONENTS
-Introduction to the SQL Server Platform
-Overview of SQL Server Architecture
-SQL Server Services and Configuration Options

INSTALLING SQL SERVER 2016
-Considerations for installing SQL Server
-TempDB Files
-Installing SQL Server 2016
-Automating Installation

UPGRADING SQL SERVER TO SQL SERVER 2016
-Upgrade Requirements
-Upgrade SQL Server Services
-Migrating SQL Server Data and Applications

DEPLOYING SQL SERVER ON MICROSOFT AZURE
-SQL Server Virtual Machines in Azure
-Deploying an Azure SQL Database
-Migrating an On-Premise Database to an Azure SQL Database

WORKING WITH DATABASES
-Overview of SQL Server Databases
-Creating Databases
-Database Files and Filegroups
-Moving Database Files
-Buffer Pool Extension

DATABASE STORAGE OPTIONS
-SQL Server storage Performance
-SMB Fileshare
-SQL Server Storage in Azure
-Stretch Databases

PLANNING TO DEPLOY SQL SERVER ON MICROSOFT AZURE
-SQL Server Virtual Machines in Azure
-Azure Storage
-Azure SQL Authentication
-Deploying an Azure SQL Database

MIGRATING DATABASES TO AZURE SQL DATABASE
-Database Migration Testing Tools
-Database Migration Compatibility Issues
-Migrating a SQL Server Database to Azure SQL Database

DEPLOYING SQL SERVER ON A MICROSOFT AZURE VIRTUAL MACHINE
-Automating Routine Database Maintenance
-Deploying SQL Server on an Azure VM
-The Deploy Database to a Microsoft Azure VM Wizard

MANAGING DATABASES IN THE CLOUD
-Managing Azure SQL Database Security
-Configure Azure storage
-Azure Automation