SPOTO trainer Garth Schulte demonstrates how to manage and control multiple databases and instances in SQL Server 2016 with high granularity in this intermediate training.
This is a new SQL training.
Although it is essential to be able to manage and configure the various SQL Server 2016 instances and databases you have, it can be difficult to master them all. A database administrator will be able to save money, fix security holes before they happen and provide a better data experience for users. This Microsoft SQL Server 2016 training, Managing Databases and Incidents, will teach you everything you need to optimize all aspects of your instances and databases.
This three-part series covers topics like configuring properties of an instance, including file formats, managing collation, and creating logon triggers. It also discusses managing services and managing server network configurations.
You can watch a video from the series here:
This series includes the following skills:
Secure Access to Microsoft Azure SQL Databases
Configure SQL Server Performance Settings in SQL Server 2016.
SQL Server 2016 Instances Management
This training covers the following topics:
Lab: Manage SQL Server Instances
Configure SQL Server Performance Settings
Manage SQL Server Instances – Manage System Database Files
Create databases: Manage SQL Server Instances
Configure SQL Server Performance Settings. Configure Database Performance Settings
This training includes:
1 hour of training
Learn SQL today!
Are you not a SPOTO subscriber yet? Start your week-long free trial now.
SPOTO offers everything you need to improve your IT skills and advance in your career: unlimited video training and Practice exams, Virtual Labs and validated learning with in–video Quizzes, Accountability coaching, and access to our exclusive IT professionals community.