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

Con el Máster en Administración de Microsoft SQL Server dominarás con facilidad y soltura el servidor SQL, podrás controlar y gestionar las bases de datos localizadas en servidores Windows SQL sin ningún tipo de problema, así como tendrás las herramientas necesarias para asegurar su correcto mantenimiento y funcionamiento.

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