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

Course Aim

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

Learning Objectives

Describe the SQL Server programming tools. Create basic Transact-SQL programs. Outline the different methods of executing T-SQL commands.

Topics Covered

Overview of Transact-SQL - Introduction to T-SQL - Programming tools - T-SQL syntax elements - T-SQL functions and expressions Selecting data - The SELECT statement - Filtering data - Formatting data - Hands-on: Querying data Data modification - Inserting data - Updating data - Deleting data - Hands-on: Modifying data Executing statements - Control-of-flow - Executing T-SQL commands - Hands-on: Creating a script - Processing commands

| About Eno.com | Security&Privacy | Contact Us |
Copyright © 1998-2001 E&A Inc.. All rights reserved.