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
Follow us
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

By submitting this form you agree to receive marketing emails from CBT Nuggets and 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.

By submitting this form you agree to receive marketing emails from CBT Nuggets and that you have read, understood and are able to consent to our privacy policy.

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.

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