Course Content
Installation and Configuration
- Installing Multiple Instances of SQL Server 2017
- Applying a Service Pack
- Creating Aliases
- Setting up a Central Management Server
Authenticating and Authorizing Users
- Authenticating Connections to SQL Server
- Authorizing Logins to Access Databases
- Authorization Across Servers
- Partially Contained Databases
Assigning Server and Database Roles
- Working with Server Roles
- Working with Fixed Database Roles
- Creating 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
SQL Server Recovery Models
- Backup Strategies
- Understanding SQL Server Transaction Logging
- Planning a SQL Server Backup Strategy
Backup of SQL Server Databases
- Backing up Databases and Transaction Logs
- Managing Database Backups
- Working with Backup Options
Restoring SQL Server Databases
- Understanding the Restore Process
- Restoring Databases
- Working with Point-in-time Recovery
- Restoring System Databases and Individual Files
racing Access to SQL Server
- Capturing Activity Using SQL Server profiler
- Improving Performance with the Database Engine Tuning Advisor
- Working with Tracing Options
Monitoring SQL Server
- Monitoring Activity
- Capturing and Managing Performance Data
- Analyzing Collected Performance Data
Troubleshooting SQL Server
- Resolving Service Related Issues
- Resolving Login and Connectivity Issues
- Troubleshooting Common Issues
Importing and Exporting Data
- Transferring Data to/from SQL Server
- Importing and Exporting Table Data
- Using BCP and BULK INSERT to Import Data
Maintaining High Availability of Data
- Windows Clustering
- AlwaysOn Availability Groups
- Implementing AlwaysOn
- Implementing Log Shipping