In this instructor-led, online training course, students will learn the knowledge and skills to administer a SQL server database infrastructure. Students will be taught how to authenticate and authorize users, protect data with encryption and auditing, backup and restore SQL Server, configure security for the SQL Server agent, and more.
Exam Number: 70-764
| Formato | Ritmo propio |
|---|---|
| Tema | |
| Proveedor | microsoft |
Configuring auditing
Configure an audit on SQL Server
Query the SQL Server audit log
Manage a SQL Server audit
Configure an Azure SQL database audit
Analyze audit logs and reports from Azure SQL database
Developing a backup strategy
Configure database recovery models
Managing transaction log backups
Back up very large databases
Configure alerting for failed backups
Back up databases to Azure
Configure backup automation
Monitoring database activity
Monitor current sessions
Identify sessions that cause blocking activity
Identify sessions that consume tempdb resources
Configure the data collector
Monitoring Queries
Manage the Query Store
Configure extended events and trace events
Identify problematic execution plans
Troubleshoot server health using extended events
Managing indexes
Identify and repair index fragmentation
Identify and create missing indexes
Identify and drop underutilized indexes
Manage existing columnstore indexes
Managing statistics
Identify and correct outdated statistics
Implement auto update statistics
Implement statistics for large tables
Monitoring queries
Create and manage operators
Create and manage SQL Agent alerts
Define custom alert actions and failure actions
Configure database mail
Configure Policy-Based Management
Identify available space on data volumes
Identify the cause of performance degradation
Implement log shipping
Configure log shipping
Monitor log shipping
Implement AlwaysOn availability groups
Configure Windows clustering
Create an availability group
Configure read-only routing
Manage failover
Create distributed availability groups
Implement failover cluster instances
Manage shared disks
Configure cluster shared volumes (CSV)
Monitoring database activity
SQL edition capability map
Replication definitions
Publishing industry metaphor concepts
What can be replicated?
How replication works
Replication use cases
Typical transactional replication use case
Replication setup walkthrough
Monitoring replication
Performance tuning
Autenticar y autorizar usuarios
Asignar roles de servidor y base de datos
Autorizar a los usuarios a acceder a los recursos
Protect data with encryption and auditing
Describir modelos de recuperación y estrategias de respaldo.
Backup SQL Server databases
Restore SQL Server databases
Automatizar la gestión de bases de datos
Configurar la seguridad para el agente SQL Server
Administrar alertas y notificaciones
Administrar SQL Server usando PowerShell
Seguimiento del acceso a SQL Server
Monitorear una infraestructura de SQL Server
Solucionar problemas de una infraestructura de SQL Server
Importar y exportar datos
This instructor led, online training course is for those who administer and maintain SQL Server databases.
We recommend that students have:
Basic knowledge of the Microsoft Windows operating system and its core functionality
*Para más detalles llame al: 858-208-4141 o correo electrónico: formación@ccslearningacademy.com; ventas@ccslearningacademy.com
NOTA: Estos son nuestros cursos de aprendizaje electrónico impartidos por socios.
Spanish 
English