Microsoft Transact SQL Training Course
Improve job skills - Become more efficient - Produce better results !
Learn Microsoft Transact SQL (in only 7 hours)
Watch these professional training videos at your convenience. All you need is a computer or mobile device with an Internet connection. Login to learn anytime and view the videos as many times as you want.
Course Description: Virtual Training CompanyÕs Transact SQL tutorial is instructed by Microsoft certified Systems Engineer and Database administrator Mark Long. In this tutorial, you will not only learn about this data definition, manipulation, and control language, but you will also become better prepared for the MCDBA certification, particularly Exam #70-229. It will also help you become a better Database Administrator. Mark Long begins by introducing you to the origins and capabilities of Transact SQL. He will give a brief history of databases and will cover some language basics, including scripts, batches, functions, and views. From there, he moves onto more advanced ideas by teaching you about TSQL tools, such as the Query Analyzer and the Enterprise Manager. He then goes into great depth explaining the 4 main commands: SELECT, INSERT, UPDATE, and DELETE. You will also learn about indexes, variables, and stored procedures. He even touches on XML. To get started, simply click on one of the movie links below.
Click a play button below to view a free training video. Place your order online for full access.
Video Tutorials Included: 99
General Database Information
Transact SQL Tools
More Than A Query Language
Optimizing Your TSQL