Microsoft SQL Server 2017 for Administration

Module 1: Configure Encryption

• Encryption overview
• Implement cell-level encryption
• Configure transparent data encryption
• Implement Always Encrypted
• Implement backup encryption
• Configure encryption for connections

Module 2: Configure Data Access and Permissions

• Create and maintain users
• Manage database object permissions
• Create and maintain custom roles
• User options for Azure SQL Database
• Configure row-level security
• Configure dynamic data masking

Module 3: Configure Auditing

• SQL Server audits
• Create an audit on SQL Server
• Query the SQL Server audit log
• Configure an Azure SQL Database audit
• Analyze logs from Azure SQL Database

Module 4: Develop a Backup Strategy

• Back up very large databases
• Configure database recovery models
• Manage transaction log backups
• Configure backup automation
• Back up databases to Azure

Module 5: Restore Databases

• Automate and test restores
• Perform page recovery
• Restore file groups
• Perform piecemeal restores

Module 6: Manage Database Integrity

• Identify database corruption
• Implement database consistency checks
• Recover from database corruption

Module 7: Monitor Database Activity

• Monitor current sessions
• Identify causes of blocking activity
• Find sessions that use tempdb resources
• Configure the data collector

Module 8: Monitor Queries

• Manage the Query Store
• Configure trace events
• Identify problematic execution plans
• Server health and extended events

Module 9: Manage Indexes

• Identify and repair index fragmentation
• Identify and create missing indexes
• Identify and drop underutilized indexes
• Manage existing columnstore indexes

Module 10: Manage Statistics

• Statistics objects
• Identify and correct outdated statistics
• Implement auto update statistics
• Implement statistics for large tables

Module 11: Monitor SQL Server Instances

• Configure database mail
• Create and manage operators
• Create and manage SQL Server Agent alerts
• Define failure actions
• Identify available space on data volumes
• Introduction to Policy-Based Management

Module 12: Implement Log Shipping

• Log shipping overview
• Configure log shipping

Module 13: Implement Always On Availability Groups

• Configure Windows clustering
• Create an availability group
• Configure read-only routing
• Manage failover
• Create distributed availability groups

Module 14: Importing and Exporting Data

• Introduction to Transferring Data
• Importing and Exporting Table Data
• Implementing bcp and BULK Insert for Importing data
• Implementing Data-Tier Applications and upgrading

Module 15: Workshop and Exercise

• Live workshop and exercise