MOC 2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

    

Summary:
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

Duration:
3 Days/Lecture & Lab

Audience:
This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

Topics:

• Getting Started with Databases and Transact-SQL in SQL Server 2008
• Querying and Filtering Data
• Grouping and Summarizing Data
• Joining Data from Multiple Tables
• Working with Subqueries
• Modifying Data in Tables
• Querying Metadata, XML, and Full-Text Indexes
• Using Programming Objects for Data Retrieval
• Using Advanced Querying Techniques

Prerequisites:
Before attending this course, students must have:-Knowledge of data integrity concepts. -Core Windows Server skills. -Relational database design skills. -Programming skills.

Last Update: February 6, 2012