Training / New Courses

New Training: Developing Databases in Microsoft SQL Server 2016

by Team Nuggets
New Training: Developing Databases in Microsoft SQL Server 2016 picture: A
Published on July 2, 2021

In this 28-video, intermediate training, CBT Nuggets trainer Garth Schulte covers the knowledge systems administrators need to implement a database in SQL Server 2016, ensuring the objects you implement are optimized for memory and access.

Watch this new SQL training.

At the heart of implementing a database are object statistics. These descriptions of the data that’s stored in the database depend on much more than being in the right place. When the query optimizer seeks data from a database, the object statistics are responsible for providing information like how many rows are stored and helping find the right join method. This Implementing Database Objects in Microsoft SQL Server 2016 training makes sure a database administrator knows how to implement objects right the first time and ensure a high-speed, reliable database.

The four-part series covers topics such as accessing, changing and reporting on the data stored in your databases, applying the programming concepts of SQL and T-SQL, and mastering the several commands used for navigating and manipulating data.

Watch a video from the series:

The skills that comprise this series include:

Topics this training covers include:

  • Implementing User-Defined Functions

  • Implementing Natively Compiled Stored Procedures

  • Designing User-Defined Functions

  • Implementing Indexes

  • Resource Locks

This training includes:

  • 5 hour of training

  • 28 videos

Start learning SQL today!



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