Course Details
Course Outline
1 - SQL Server Security
Authenticate Connections to SQL ServerAuthorize Logins to Access Databases Across ServersUnderstand Partially Contained DatabasesLab: Authenticating Users
2 - Assigning Servers & Database Roles
Work with Server Roles and Fixed Database RolesCreate User-Defined Database RolesLab: Assigning Server and Database Roles
3 - Authorizing Users to Access Resources
Provide User Access to ObjectsApprove Users to Execute CodeConfigure Permissions at the Schema LevelLab: Authorizing Users to Access Resources
4 - Protecting Data with Encryption and Auditing
Learn the Options for Auditing Data Access in SQL ServerImplement and Manage SQL Server AuditsProtect Data with EncryptionLab: Using Auditing and Encryption
5 - Recovery Models and Backup Strategies
Deploy Secure Backup StrategiesUnderstand SQL Server Transaction LoginPlan a SQL Server Backup StrategyLab: Understanding SQL Server Recovery Models
6 - Backing Up SQL Server Databases
Back up Databases and Transaction LogsManage Database BackupsDeploy Different Backup OptionsLab: Backing up SQL Server Databases
7 - Restoring SQL Server 2016 Databases
Learn About the Restore ProcessWork with Point-in-Time RecoveryRestore System Databases and Individual FilesLab: Restoring SQL Server User Databases
8 - Automating SQL Server Management
Automate SQL Server ManagementExplore the SQL Server AgentManage SQL Server Agent JobsUnderstand Multi-Server ManagementLab: Automating SQL Server Management
9 - Configuring Security for SQL Server Agent
Maintain SQL Server Agent SecurityConfigure Credentials and Proxy AccountsLab: Configuring Security for SQL Server Agent
10 - Monitoring SQL Server with Alerts & Notifications
Create Settings for Database MailMonitor SQL Server ErrorsWork with Operators, Alerts and NotificationsLearn How Alerts Work in Azure SQL DatabaseLab: Monitoring SQL Server with Alerts and Notifications
11 - Introduction to Managing SQL Server by using PowerShell
Configure and Administer SQL Server Using PowerShellMaintain the SQL Server Environment Using PowerShellManage Azure SQL Server Databases Using PowerShellLab: Administering SQL Server Using PowerShell
12 - Tracing Access to SQL Server with Extended events
Capture Activity Using SQL Server ProfilerImprove Performance with the Database Engine Tuning AdvisorWork with Tracing OptionsPerform Distributed ReplaysMonitor LocksLab: Tracing Access to SQL Server
13 - Monitoring SQL Server
Oversee SQL Server ActivityCapture and Manage Performance DataAnalyze Collected Performance DataAssess SQL Server UtilityLab: Monitoring SQL Server
14 - Troubleshooting SQL Server
Learn the SQL Server Troubleshooting MethodologyFix Service Related IssuesResolve Login and Connectivity IssuesTroubleshoot Other Common IssuesLab: Troubleshooting Common Issues
15 - Importing and Exporting Data
Transfer Data to and from SQL ServerImport and Export Table DataApply BCP and BULK INSERT to Import DataDeploy and Upgrade Data-Tier ApplicationsLab: Importing and Exporting Data
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
If you’re a database administrator, developer or engineer responsible for administering or maintaining database technologies, this course is for you. Taking this course will also benefit you if you develop applications that deliver content from SQL Server databases.
Other Prerequisites
Your success is our top priority. To ensure you get the most value out of this course, you should already be familiar with the Microsoft Windows operating system. You will also feel more prepared if you have working knowledge of Transact-SQL and relational databases and experience with database design.