Cursos
Madrid
Convocatoria Abierta
60 horas
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.
Objetivos de la Certificación MCSA
70-764: Administering a SQL Database Infrastructure
70-765: Provisioning SQL Databases
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
Está dirigido a:
•Personas con conocimientos en Informática.
•Formación Profesional.
•Titulados Universitarios.
•Profesionales del sector IT que deseen actualizar sus conocimientos.
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
Convocatoria Abierta
Madrid
En Avanza en tu Carrera tenemos más de 50.000 cursos para ti. Te orientamos y asesoramos para que elijas tu formación. Elige la opción que más te interese: Formación Profesional, Oposiciones, Grados, Postgrados y mucho más.