Microsoft SQL Server 2000: Querying with Transact-SQL


Description:

In this course, you will explore the features of Transact-SQL and the Transact SQL statement types and elements that enable you to design flexible programs. You will explore the techniques for modifying data in tables and the different types of functions in SQL that you can use to summarize data. After completing this course, you will be able to use the Transact-SQL utilities to query a SQL server, retrieve data by using the SELECT statement, modify data by using the INSERT, UPDATE, and DELETE statements, and summarize data by using the TOP, GROUP BY, COMPUTE, and COMPUTE BY clauses. You will also be able to query multiple tables through the use of joins, use subqueries, work with full-text indexes, and other types of programming objects in Transact-SQL.

 

Objectives:

  • After completing this tutorial, you will be able to define the different types of Transact-SQL statements and use SQL Query Analyzer to execute them.

Hardware and Software Required:

  • Please note that the content in the course you have selected is supported and should function without major error in current, popular browsers. However, it has not been optimized for them. Therefore, you may encounter slight formatting or functionality issues during your learning experience.

 




User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-MS200-QT
  • Duration: 7 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend