Microsoft SQL Server 2017 Administration (Canada)
Hands-On Technology Transfer
Delivery Method
Seminar
Target Audience
SQL Server administrators
Summary
This hands-on course provides students with the knowledge and skills to administer a SQL Server 2017 database infrastructure
Description/Agenda
Students Will Learn
- Installing
and configuring SQL Server 2017
- Authenticating
and authorizing users
- Assigning
server and database roles
- Authorizing
users to access resources
- Protecting
data with encryption and auditing
- Recovery
models and backup strategies
- Backing up
SQL Server databases
- Restoring SQL
Server databases
- Automating
database management
- Configuring
security for the SQL Server agent
- Managing
alerts and notifications
- Tracing
access to SQL Server
- Monitoring a
SQL Server infrastructure
- Troubleshooting
a SQL Server infrastructure
- Importing and
exporting data
- Creating a
high availability solution
Course Description
This
hands-on course provides students with the knowledge and skills
to administer a SQL Server 2017 database infrastructure. You
will learn how to install, configure, manage, secure, automate,
monitor, and optimize SQL Server 2017. You will also learn how
to create, manage, back up, and restore individual databases,
transfer and replicate data, configure for high availability,
and plan disaster recovery.
Comprehensive
hands on exercises are integrated throughout to reinforce
learning and develop real competency.
Course Prerequisites
Familiarity with database
concepts, Windows desktop navigation and Transact-SQL. Attendance
at the Microsoft
Transact-SQL Programming course is highly
recommended although not required.
Course Overview
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
|
Tracing 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
|
q
|
Frequently Asked
Questions
Payment Options
Bill Me/Invoice
Credit Card
Register
Online
Fax Form
Availability
Select a date from the list at the bottom of the page for specific information about that class.
Other Information
Seminar |
|