Using T-SQL to Manage Data, Query Data, and Program Databases Online Training

Taught by

UPDATED: February 26, 2021

Intermediate

Virtual Labs

This intermediate T-SQL training prepares administrators to leverage SQL Server's extended functionality, enhancing control over instances. You'll learn to perform complex operations with T-SQL, including transaction control, exception handling, and querying data across multiple tables. This T-SQL course course also covers temporal and non-relational data and error handling for robust database management.

Start a free week

Subscription options

$59.00

Access all premium content with a free week!

Quizzes
CyberVista® IT practice exams
Coaching
IT learner community

Start a free week

See training reviews

What you'll learn

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
Performing transaction control and exception handling with T-SQL
Querying multiple tables by using joins
Querying temporal data and non-relational data
Implementing error handling and transactions

FAQs

What will you learn in this T-SQL training?

You'll learn how to use Transact-SQL to reach into databases and pull out the data you need from them, and then use it. This T-SQL course focuses on transaction control and exception handling with T-SQL along with the basics of storing, accessing and manipulating relational data with T-SQL.

Why should you take this T-SQL data management course?

You should take this T-SQL course if you work with Microsoft databases in any way. Because SQL runs most databases it's one of the most common languages in the world. T-SQL is Microsoft's extension to it, and learning it makes Microsoft databases even more powerful and versatile.

Is this T-SQL course associated with any certifications?

No, this T-SQL training isn't designed to prepare you for any specific certification. Microsoft retired basically all their certifications that related specifically to Transact-SQL and SQL Server in January 2021. Nevertheless, administrator certifications that call for T-SQL knowledge will be much easier after this course.

What certification should you consider after taking this T-SQL course?

Depending on what you do for work, you might consider exploring the Microsoft Certified: Azure Data Engineer Associate after taking this T-SQL course. Its certification exam, DP-203, has a lot more information on it than just T-SQL, but T-SQL plays an important part.

Who would benefit from taking this course in managing and querying data in T-SQL?

Basically anyone who has to interact with databases at all would benefit from this T-SQL course. It doesn't matter whether you're really comfortable around databases or you're brand new to data manipulation, this T-SQL course can help you understand them better and make your job much easier.

Who is this for?

This Using T-SQL to Manage Data, Query Data, and Program Databases training is considered associate-level Microsoft training, which means it was designed for systems administrators with at least a year of experience with T-SQL and experienced database administrators looking to validate their Microsoft skills.

What our learners say

You constantly have to invest in training for your people.
Rick N. | CEO
Practice exams help you have an overview of your readiness. If you have failed a couple questions in one area, you can go back and work on them.
Harold M. | Network Administrator
CBT Nuggets is exactly what I needed.
Thomas S. | Systems Engineer & Consultant

Study plan

Download the free Using T-SQL to Manage Data, Query Data, and Program Databases Online Training study plan to complete this course in about 7 hours.

Download study plan