|
|||||||||||||||||
|
This text is replaced by the Flash movie.
 |
 |
||||||||||||||||
 |
|||||||||||||||||
Course: Transact SQL Overview This course provides instruction on how to write basic Transact-SQL queries for Microsoft SQL Server 2000. Students will learn how to retrieve, add, update and delete data and get an overview of how to use Transact-SQL with various objects within a database. Topics Included in Training Transact-SQL Overview Uses and Syntax Basic Forms SQL Server Books Online Query Analyzer Object Browser Creating and Executing Scripts Data Retrieval (SELECT) Filtering Grouping Joining and Aliases Unions Sub Queries Functions Adding Data (INSERT) Modifying Data (UPDATE) Removing Data (DELETE) SQL Server Objects Views Stored Procedures Triggers Functions Full-Text Indexes Overview and Application Querying Prerequisite: Database Design or Equivalent Knowledge Format: 16 Hours (2 Days) Instructor Led Training Daytime and Evening/Saturday Classes Available Course Content Subject to Change without Notice Version 015-303A |
|||||||||||||||||
|
|
 |
||||||||||||||||
|
|||||||||||||||||
