Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Gain the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008 in this course that incorporates material from the Official Microsoft Learning Product (OMLP) 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.

• Uses of and ways to execute the Transact-SQL language
• Use querying tools
• 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
• Create programming objects
• Use various techniques when working with complex queries

SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries