Your Ad Here
Custom Search

Saturday, October 20, 2007

Microsoft Transact SQL

The 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.

C Programming

Virtual Training Company's C Programming tutorial is taught by an expert C programmer, Mark Virtue, who has been using C for over 15 years, and has been teaching C programming for over 5 years. Perfect for beginners, this tutorial starts at an introductory level, assuming that you have no prior programming experience.

The instructor takes you through the basic concepts and techniques of C, and gives you exercises with which he guides you through to get to the solutions. You will be taken smoothly into more advanced concepts, such as pointers and dynamic memory. If you are already familiar with programming, you can skip past what you already know.