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.

Watch this new SQL training.

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:

• Manage Data with T-SQL

• Query Data with T-SQL

• Program Databases by using T-SQL

Topics this training covers include:

• Table Joins

• Transactions and Error Handling

• Temporal and Non-Relational Data

• Pivoting and Ranking Data

• Modifying Data with DML

This training includes:

• 5 hour of training

• 28 videos

Start learning SQL today!