Lo sentimos, en estos momentos este programa no está activo en CanalCursos.com
Máster en Microsoft MCSA Administración de Microsoft SQL Server 2016
- Máster |
- Presencial en Madrid
Precio
Contacta con el centro para más información
Pide Información y sin compromiso
Descripción del curso
Detalles
Dirigido a:
• Personas con conocimientos en Informática.
• Formación Profesional.
• Titulados Universitarios.
• Profesionales del sector IT que deseen actualizar sus conocimientos.
Comentarios:
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
Objetivos:
Objetivos de la Certificación MCSA.
70-764: Administering a SQL Database Infrastructure.
70-765: Provisioning SQL Databases.
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
• Personas con conocimientos en Informática.
• Formación Profesional.
• Titulados Universitarios.
• Profesionales del sector IT que deseen actualizar sus conocimientos.
Comentarios:
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
Objetivos:
Objetivos de la Certificación MCSA.
70-764: Administering a SQL Database Infrastructure.
70-765: Provisioning SQL Databases.
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
Duración:
60 horas
...- 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
Duración:
60 horas
Sede principal del centro
Madrid: Calle de la Basílica 19 - 28020 - Madrid- Madrid: Calle de la Basílica 19 - 28020 - Madrid
Ofertas relacionadas
-
Online y Semipresencial en Madrid, Barcelona, A Coruña, Alicante y 19 provincias +Centro: Tokio
Estás viendo
