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

CAS TRAINING, S.L.

Descripción

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.

Temario

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

Destinatarios

Está dirigido a:
  • Personas con conocimientos en Informática.
  • Formación Profesional.
  • Titulados Universitarios.
  • Profesionales del sector IT que deseen actualizar sus conocimientos.

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

Metodología

Presencial

Objetivos

  • Objetivos de la Certificación MCSA
  • 70-764: Administering a SQL Database Infrastructure
  • 70-765: Provisioning SQL Databases

Titulación obtenida

Máster Microsoft MCSA Administración de Microsoft SQL Server 2016
Sí, me interesa
conocer todos los detalles, precios, becas, fechas y plazas disponibles
Máster en Microsoft MCSA Administración de Microsoft SQL Server 2016
También te recomendamos estos cursos
Temas relacionados
X