New Training: Developing Databases in Microsoft SQL Server 2016
| training | new training - Team Nuggets

New Training: Developing Databases in Microsoft SQL Server 2016

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

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