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.
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
This training includes:
5 hour of training