Managing Databases and Instances in SQL Server 2016 Online Training

Taught by

UPDATED: March 4, 2021

Intermediate

Virtual Labs

This intermediate SQL Server 2016 training focuses on managing and optimizing databases and instances Microsoft SQL Server 2016. You'll learn how to configure instance properties, manage collation, create logon triggers, and perform key maintenance tasks. Mastering these SQL skills helps prevent service disruptions, patch security issues, and optimize overall network data management.

Start a free week

Subscription options

$59.00

Access all premium content with a free week!

Quizzes
CyberVista® IT practice exams
Coaching
IT learner community

Start a free week

See training reviews

What you'll learn

Configuring the properties of an instance including file locations, formats, etc.
Managing collation and associated behaviors per instance
Creating logon triggers, managing services and managing server network configs
Providing maintenance through common administration tasks

FAQs

What will you learn in this Microsoft SQL Server 2016 database and instance management training?

You'll learn how to control your data within SQL Server 2016. You might already know how to make data do what you need it to do – but can you do that in SQL Server 2016? This course covers intermediate and advanced knowledge for managing network data usage with Server 2016.

Who should take this Microsoft SQL Server 2016 database and instance management course?

This course is best for database administrators who've suddenly found themselves forced to use SQL Server 2016. But since it's also full of practice environments, it's a great way for brand new administrators to get experience with the routine tasks you'll need to know in all your future jobs.

Is this training in managing databases and instances in SQL Server 2016 associated with any certifications?

No – some courses are designed to help learners prepare for a certain certifying exam, but this one was created to help database administrators do their jobs better. Rather than cram random facts into your head, in this training you'll use SQL Server 2016 and practice database administration tasks.

What certification should you consider after taking this course on managing databases and instances in SQL Server 2016?

Microsoft Certified: Azure Database Administrator Associate is a good certificate to consider if you find the information on this SQL Server 2016 course useful in your job. You'll have more prep work to do before taking that exam, but the data administration familiarity will help you along the way.

Why should you take this Microsoft SQL Server 2016 database and instance management training?

You should take this course because although SQL Server 2016 is a fairly recent instance of the database administration software, it's different enough that if you suddenly find yourself using it without any preparation, you'll likely be lost in all its differences from more contemporary versions of the RDBMS.

Who is this for?

This Managing Databases and Instances in SQL Server 2016 training is considered associate-level Microsoft training, which means it was designed for systems administrators with at least a year of experience with Server 2016 database technologies and experienced systems administrators looking to validate their Microsoft skills.

What our learners say

CBT Nuggets fits into my day-to-day amazingly.
John M. | IT Manager
I didn't ever think I'd have the position I have now.
Jenna B. | Service Operations Manager
You constantly have to invest in training for your people.
Rick N. | CEO

Study plan

Download the free Managing Databases and Instances in SQL Server 2016 Online Training study plan to complete this course in about 2 hours.

Download study plan