20764 Administering MS SQL Server 2016 Databases Infrastructure

Contenidos

1. Module 1: SQL Server Security
   • Authenticating Connections to SQL Server
   • Authorizing Logins to Connect to databases
   • Authorization Across Servers
   • Partially Contained Databases
2. Module 2: Assigning Server and Database Roles
   • Working with server roles
   • Working with Fixed Database Roles
   • Assigning User-Defined Database Roles
3. Module 3: Authorizing Users to Access Resources
   • Authorizing User Access to Objects
   • Authorizing Users to Execute Code
   • Configuring Permissions at the Schema Level
4. Module 4: 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
5. Module 5: Recovery Models and Backup Strategies
   • Understanding Backup Strategies
   • SQL Server Transaction Logs
   • Planning Backup Strategies
6. Module 6: Backing Up SQL Server Databases
   • Backing Up Databases and Transaction Logs
   • Managing Database Backups
   • Advanced Database Options
7. Module 7: Restoring SQL Server 2016 Databases
   • Understanding the Restore Process
   • Restoring Databases
   • Advanced Restore Scenarios
   • Point-in-Time Recovery
8. Module 8: Automating SQL Server Management
   • Automating SQL Server management
   • Working with SQL Server Agent
   • Managing SQL Server Agent Jobs
   • Multi-server Management
9. Module 9: Configuring Security for SQL Server Agent
   • Understanding SQL Server Agent Security
   • Configuring Credentials
   • Configuring Proxy Accounts
10. Module 10: Monitoring SQL Server with Alerts and Notifications
    • Monitoring SQL Server Errors
    • Configuring Database Mail
    • Operators, Alerts, and Notifications
    • Alerts in Azure SQL Database
11. Module 11: 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
12. Module 12: Tracing Access to SQL Server with Extended events
    • Extended Events Core Concepts
    • Working with Extended Events
13. Module 13: Monitoring SQL Server
    • Monitoring activity
    • Capturing and Managing Performance Data
    • Analyzing Collected Performance Data
    • SQL Server Utility
14. Module 14: Troubleshooting SQL Server
    • A Trouble Shooting Methodology for SQL Server
    • Resolving Service Related Issues
    • Resolving Connectivity and Log-in issues
15. Module 15: 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

Metodología: Presencial / Virtual Class

Fechas: Consúltenos las fechas.

Lugar de realización: Aula CB Center, en C/ Jacinto Verdaguer 17, Madrid./ online

Incluye Documentación Oficial.