2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL

Introduction

Elements of this syllabus are subject to change.

At the end of this three-day course, students who are new to SQL Server will learn how to write basic Transact-SQL queries for Microsoft SQL Server 2005.

Audience

IT Professionals, IT generalists, and Information Workers who want to learn about writing queries for Microsoft SQL Server 2005. Candidates should have at least 3 years experience working in the IT field—typically in the area of databases. No experience with SQL Server is necessary.

At Course Completion

After completing this course, students will be able to:

• Get started with databases and Transact-SQL.
• Perform basic queries.
• Group and summarize data.
• Join data from multiple tables.
• Work with subqueries.
• Modify data.
• Query metadata, XML, and full-text indexes.
• Use programming objects for data retrieval.
• Use advanced querying techniques.

Prerequisites

• An understanding of basic relational database concepts, including:
• Logical database design.
• Physical database design.
• How data is stored in tables (rows and columns).
• Data integrity concepts.
• Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
• Basic knowledge of the Microsoft Windows operating system and its core functionality. For example, how to use Windows Explorer, open and save files, and what a client/server application interaction means.