Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

(Start)Datum	Locatie	Inschrijven
05 July 2012	Amsterdam
04 September 2012	Nieuwegein
14 November 2012	Amsterdam

Description:

This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

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

Duration:
3 days

Pre-Requisites:
Before attending this course, students must have:

• 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.

Objectives:

• 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-Test Indexes
• Using Programming Objects for Data Retrieval
• Using Advanced Querying Technique