SQL with Transact-SQL on SQL Server 2000 and SQL Server 2005

Who should attend:

 

This course is for database developers and administrators at beginner or intermediate level.

 

Some familiarity with relational databases and basic SQL might be helpful. Some programming experience might be helpful. Although we use Transact-SQL, the topics are applicable to all SQL implementations.

 

 

Introducing Transact-SQL and Data Management Systems SQL Server Fundamentals Tools for Accessing SQL Server Introducing Transact-SQL Language Data Retrieval SQL Functions Aggregation and Grouping

Multi-Table Queries Data Transactions Advanced Queries and Scripting Full-Text Index Queries Creating and Managing Database Objects Transact-SQL Programming Objects Transact-SQL in Applications and Reporting