New Training: Using T-SQL to Manage Data, Query Data, and Program Databases
In this 28-video, intermediate training, CBT Nuggets trainer Garth Schulte covers the knowledge systems administrators need to use all of the differences in Transaction-SQL to extend the functionality of SQL for advanced control over SQL Server instances.
Microsoft SQL Server is one of the most commonly used database management systems in the world. When it comes to storing, accessing and manipulating relational data, Microsoft SQL Server’s global market share tops all its competitors. And any time a database administrator is called on to use a Microsoft SQL server, T-SQL is being used. This Managing Data with T-SQL in Microsoft SQL Server 2016 will demonstrate how to use the extended form of SQL. Database administrators with this training will be better equipped to perform complex operations with and exert control over their data.
The three-part series covers topics such as communicating with an instance of SQL Server via Transact-SQL statements, recognizing and using what sets some of T-SQL’s most unique commands apart from SQL’s, and performing transaction control and exception handling with T-SQL.
Watch a video from the series:
The skills that comprise this series include:
Topics this training covers include:
Transactions and Error Handling
Temporal and Non-Relational Data
Pivoting and Ranking Data
Modifying Data with DML
This training includes:
5 hour of training