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

Awesome, Top notch, I am super excited and thankful for CBT Nuggets. I am starting to get addicted to CBT Nuggets. I hope that there's no cure!!!
Mike M. | CBTN Learner
This is the gold standard of video training. You always hear in grade school or college that the best teachers are the ones who are passionate in their field. The CBT Nuggets team are extremely passionate and get you motivated for the material.
Michael J. | IS&T Major Incident Manager
CBT Nuggets fits into my day-to-day amazingly.
John M. | IT Manager

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