MS-2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008
To schedule a class, please contact us at 888-825-6273
This course requires that you meet the following prerequisites:
Knowledge of data integrity concepts.
Core Windows Server skills.
Relational database design skills.
Describe the uses of and ways to execute the Transact-SQL language.
Use querying tool.
Write SELECT queries to retrieve data.
Group and summarize data by using Transact-SQL.
Join data from multiple tables.
Write queries that retrieve and modify data by using subqueries.
Modify data in tables.
Query text fields with full-text search.
Describe how to create programming objects.
Use various techniques when working with complex queries.