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

OBJECTIVOS

This three-day instructor-led course provides students with product knowledge and skills needed to program and understand relational databases and the concept of data normalization.

DESTINATÁRIOS

This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database.

METODOLOGIA

Sessões mistas de teoria e prática, com experimentação no computador pessoal. Exercícios e simulação de situações práticas com resolução individualizada.

PRÉ-REQUISITOS

Students should be familiar with a programming or scripting language and Understand relational databases and the concept of data normalization.

PROGRAMA

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