Writing Queries using Microsoft SQL Server 2008 Transact SQL

Learn the Transact SQL language to query SQL Server

Info Support course code	MS2778	Price	€ 1.320,00
Supplier (code)	Microsoft (2778)	Length	3 days

Course date by location

Maand	Veenendaal (NL)	Utrecht (NL)	Mechelen (B)	Partner (NL)	Partner (B)
September
Oktober	19-20-21
November			3-4-5
December
Januari	5-6-7		26-27-28
Februari		21-22-23
Maart			14-15-16

Click on a date to enlist yourself for this course or click here if no suitable date can be found.

Prerequisites

Before attending this course, students should have an understanding of basic relational database concepts.

Course outline

This course provides you with the technical skills required to write Transact-SQL queries for Microsoft SQL Server 2008. At the end of the course, you will be able to:
Describe the uses of the Transact-SQL language;
Write queries to retrieve, modify and summarize data;
Join data from multiple tables;

Course content

• 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

Course material

Coursematerial from Microsoft with Labs and CD-ROM.

Follow up courses

• Writing Queries using Advanced Features of Microsoft SQL Server 2008 Transact SQL (ADVSQL)
• Maintaining a SQL Server 2008 Database (MS6231)
• Implementing a SQL Server 2008 Database (MS6232)