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.
Public Schedule: | ||
| Virtual Classroom, EL | 03/05/12 - 03/07/12 | ( register ) |
| Virtual Classroom, EL | 02/13/12 - 02/15/12 | ( register ) |
| Toronto, ON | 02/13/12 - 02/15/12 | ( register ) |
| Virtual Classroom, EL | 03/05/12 - 03/07/12 | ( register ) |
| Pittsburgh, PA | 02/13/12 - 02/15/12 | ( register ) |
| Kansas City, MO | 02/13/12 - 02/15/12 | ( register ) |
| Kansas City, MO | 03/05/12 - 03/07/12 | ( register ) |
| Ottawa, ON | 05/28/12 - 05/30/12 | ( register ) |
| Ottawa, ON | 04/02/12 - 04/04/12 | ( register ) |
| San Diego, CA | 03/05/12 - 03/07/12 | ( register ) |
| Los Angeles, CA | 03/05/12 - 03/07/12 | ( register ) |
| Denver, CO | 03/05/12 - 03/07/12 | ( register ) |
| Richmond, VA | 03/05/12 - 03/07/12 | ( register ) |
| Baltimore, MD | 03/05/12 - 03/07/12 | ( register ) |
