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


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