Master Microsoft MCSA Administración de Microsoft SQL Server 2016
CAS TrainingConsulta precio y condiciones sin compromiso
Programa
LasOposiciones.net ha seleccionado de entre 910 Masters Informática ,este Master para ti. El Master Microsoft MCSA Administración de Microsoft SQL Server 2016 se imparte en modalidad presencial en Madrid.Requisitos
Conocimiento básico del sistema operativo Microsoft Windows y su funcionalidad básica.Conocimiento práctico de Transact-SQL.
Conocimiento práctico de las bases de datos relacionales.
Alguna experiencia con el diseño de la base de datos
Temario
MOC 20764-ADMINISTERING A SQL DATABASE INFRASTRUCTURESQL 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
Objetivos
Objetivos de la Certificación MCSA70-764: Administering a SQL Database Infrastructure
70-765: Provisioning SQL Databases