Visão Geral

No Curso Microsoft SQL Server 2016 Administration, você aprenderá as habilidades necessárias para manter um banco de dados Microsoft SQL Server com foco em armazenamento de dados, backup e restauração, importação e exportação de dados, segurança, manutenção de banco de dados e SQL Server Agent.

Objetivo

Ao participar do Curso Microsoft SQL Server 2016 Administration, os participantes aprenderão a:

• Autenticar e autorizar usuários
• Atribuir funções de servidor e banco de dados
• Autorizar usuários a acessar recursos
• Proteja os dados com criptografia e auditoria
• Descrever modelos de recuperação e estratégias de backup
• Backup de bancos de dados SQL Server
• Restaurar bancos de dados SQL Server
• Automatize o gerenciamento de banco de dados
• Configurar a segurança do agente SQL Server
• Gerenciar alertas e notificações
• Gerenciando SQL Server usando PowerShell
• Rastrear acesso ao SQL Server
• Monitore uma infraestrutura do SQL Server
• Solucionar problemas de uma infraestrutura do SQL Server
• Importar e exportar dados

Publico Alvo

• Curso Microsoft SQL Server 2016 Administration é destinada a profissionais de TI e administradores de banco de dados.

Pre-Requisitos

• Conhecimento básico do sistema operacional Microsoft Windows e suas principais funcionalidades.
• Conhecimento prático de Transact-SQL.
• Conhecimento prático de bancos de dados relacionais.
• Alguma experiência com design de banco de dados.

Materiais

Conteúdo Programatico

SQL Server Security

1. Authenticating connections to SQL Server
2. Authorizing logins to connect to databases
3. Authorization across servers
4. Partially contained databases

Assigning Server and Database Roles

1. Working with server roles
2. Working with fixed database roles
3. Assigning User-Defined Database Roles

Authorizing Users to Access Resources

1. Authorizing user access to objects
2. Authorizing users to execute code
3. Configuring permissions at the schema level

Protecting Data with Encryption and Auditing

1. Options for auditing data access in SQL Server
2. Implementing SQL Server audit
3. Managing SQL Server audit
4. Protecting data with encryption

Recovery Models and Backup Strategies

1. Understanding Backup strategies
2. SQL Server transaction login
3. Planning a backup strategy

Backup of SQL Server Databases

1. Backing up databases and transaction logs
2. Managing database backups
3. Working with backup options

Restoring SQL Server 2016 Databases

1. Understanding the Restore Process
2. Restoring databases
3. Point-in-time recovery
4. Advanced Restore Scenarios
5. Performing a Piecemeal Restore

Automating SQL Server Management

1. Automating SQL Server management
2. Working with SQL Server agent
3. Managing SQL Server agent jobs
4. Multiserver management

Configuring Security for SQL Server Agent

1. Understanding SQL Server Agent Security
2. Configuring credentials
3. Configuring proxy accounts

Monitoring SQL Server with Alerts and Notifications

1. Monitoring SQL Server errors
2. Configuring database mail
3. Operators, alerts and notifications
4. Alerts in Azure SQL database

Introduction to Managing SQL Server by using PowerShell

1. Getting Started with Windows PowerShell
2. Configure SQL Server using PowerShell
3. Administer and Maintain SQL Server using PowerShell
4. Managing Azure SQL Server databases using PowerShell

Tracing Access to SQL Server with Extended events

1. Extended Events Core Concepts
2. Working with Extended Events

Monitoring SQL Server

1. Monitoring activity
2. Capturing and managing performance data
3. Analyzing collected performance data
4. SQL Server utility

Troubleshooting SQL Server

1. A Trouble Shooting Methodology for SQL Server
2. Resolving service related issues
3. Resolving login and connectivity issues

Importing and Exporting Data

1. Transferring data to/from SQL Server
2. Importing and exporting table data
3. Using BCP and BULK INSERT to import data
4. Deploying and upgrading data-tier applications