Microsoft SQL Server 7.0: Basic Transact-SQL


Overview/Description
To provide students with an introduction to the Transact-SQL programming language

Target Audience
Database administrators, developers, and IT managers who need an introduction to the SQL Server programming tools and an overview of the Transact-SQL language

Prerequisites
An understanding of relational database theory

Expected Duration
4:00 Hours

Objectives:

Microsoft SQL Server 7.0: Basic Transact-SQL

  • To give an overview of Transact-SQL language components, programming tools, and syntax elements
  • To describe how to select data using Transact-SQL
  • To demonstrate how to modify data using the INSERT, UPDATE, and the DELETE statements
  • To explain how Transact-SQL statements are processed

  • Course Number: SQ7041E