Show findcourses.com as: Mobile

Microsoft SQL Server 2016 Administration

Hands on Technical Training (HOTT)
Training overview
5 days
English
Classroom / Public
Next start date: 1/27/2020 - Boise
From 2,795 USD
Start dates
Boise
1/27/2020   (English)
2,795 USD
Denver
1/27/2020   (English)
2,795 USD
Portland
1/27/2020   (English)
2,795 USD

Course description

Microsoft SQL Server 2016 Administration

This five-day instructor-led course provides students who administer and maintain SQL Server 2016 databases with the knowledge and skills to administer a SQL Server database infrastructure.

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

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)

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 2016
  • 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

About HOTT

HOTT Logo

Hands on Technical Training (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 2016 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

Training reviews
Course rating
(5.0)
Based on 2 reviews

Need help with your search?

findcourses.com offers a free consultancy service to help compare training for you and your team

Request a free quote

Request a free training quote