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:
- Designing and Implementing Database Objects in SQL Server 2016
- Implementing Programmability Objects in SQL Server 2016
- Managing Database Concurrency in SQL Server 2016
- Optimizing Database Objects and SQL Infrastructure
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