Microsoft SQL Server 2017 Administration

Hands on Technical Training (HOTT)
Training overview
Professional Course
5 days
From 2,795 USD
Start dates
Online
Inquire for more information

Bakersfield
2,795 USD
8/10/2020

Fresno
2,795 USD
8/10/2020

Modesto
2,795 USD
8/10/2020

Course description

Microsoft SQL Server 2017 Administration

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.

Delivery method

  • Attend face-to-face in the classroom
  • Remote-live (live, instructor-led training from the convenience of your home or office)
  • On-demand streaming (train on your own time and at your own pace)
Want to find out more?

COVID-19 Update

In light of COVID-19, this provider is now delivering some or all of their courses online. Contact them for more information!

Who should attend?

Prerequisites

Familiarity with database concepts, Windows desktop navigation and Transact-SQL. Attendance at our Microsoft Transact-SQL Programming course is highly recommended although not required.

Training 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

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

Why choose HOTT?

50% of class time is hands-on lab exercises

Public classes average less than 12 students

Courses cover over 60 different subject areas

About HOTT

HOTT Logo

Hands On Technology Transfer, Inc. (HOTT)  

We offer competency-based IT training programs in more than 100 cities across the United States, Canada and the United Kingdom, covering over 60 IT subject areas. These programs are designed with one main goal – making sure you and your staff...


Read more and show all training delivered by this supplier

Request info

Fill out your details to find out more about Microsoft SQL Server 2017 Administration.

  Contact the provider

  Get more information

  Register your interest

Contact info

Hands on Technical Training (HOTT)


 Show phone number
www.traininghott.com


Reviews

Average rating 5

Based on 2 reviews

S.H., Tyco/ADT
(5)
Instructor was excellent. He made the class enjoyable and was able to convey difficult concepts into meaningful, understandable and easy to grasp concepts. His knowledge and experience is obviously at expert level.
P.F., NBC Universal
(5)
The instructor was great at answering all of my questions. He knew where any mistakes were made in an instance and was able to get me back on the right track. The lessons were thorough and gave me the foundation I was looking for. I would recommend this class to anyone looking to get into programming.
Request Information

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available