Training / New Courses

New Training: Managing Databases and Instances in Microsoft SQL Server 2016

by Team Nuggets
New Training: Managing Databases and Instances in Microsoft SQL Server 2016 picture: A
Published on August 4, 2021

In this 15-video, intermediate training, CBT Nuggets trainer Garth Schulte covers the knowledge systems administrators need to manage and control different databases and instances in SQL Server 2016 to a high degree of granularity.

Watch this new SQL training.

When it comes to database administration, knowing the tasks involved with managing and configuring the different SQL Server 2016 databases and instances you have running are integral to the job, but perfecting them is often overlooked. With a mastery over managing, migrating or consolidating databases and instances, a database administrator can save money, patch security holes before they happen, prevent service disruption, and generally provide a greater data experience for a network. This Managing Databases and Instances in Microsoft SQL Server 2016 training provides you with everything you need to optimize every facet of your databases and instances.

The three-part series covers topics such as configuring the properties of an instance including file locations, formats, etc., managing collation and associated behaviors per instance, and creating logon triggers, managing services and managing server network configs.

Watch a video from the series:

The skills that comprise this series include:

Topics this training covers include:

  • Manage SQL Server Instances: Lab

  • Configure SQL Server Performance Settings: Configure Server Performance Settings

  • Manage SQL Server Instances: Manage System Database Files

  • Manage SQL Server Instances: Create Databases

  • Configure SQL Server Performance Settings: Configure Database Performance Settings

This training includes:

  • 1 hour of training

  • 15 videos

Start learning SQL today!


Download

Download

Ultimate Systems Administration Cert Guide

A 158-page guide to every Microsoft, VMware, Citrix, AWS, Google, and Linux certification, and how they fit into your career.

By submitting this form you agree that you have read, understood, and are able to consent to our privacy policy.


Don't Miss Out

Get great content delivered to your inbox.

I have read and understood the privacy policy, and am able to consent to it.

Recommended Articles

Get CBT Nuggets IT training news and resources

I have read and understood the privacy policy and am able to consent to it.

© 2022 CBT Nuggets. All rights reserved.Terms | Privacy Policy | Accessibility | Sitemap | 2850 Crescent Avenue, Eugene, OR 97408 | 541-284-5522