New Training: Managing Databases and Instances in Microsoft SQL Server 2016
| training | new training - Team Nuggets

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

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.

LEARNING ON MOBILE

Learn anytime anywhere with our mobile apps.

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

© 2021 CBT Nuggets. All rights reserved. Terms | Privacy Policy | Accessibility | Sitemap | 1550 Valley River Drive, Eugene, OR 97401 | 541-284-5522
CBT Nuggets