Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (MOC 2778A)

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

Before attending this course, students must have:

• Knowledge of data integrity concepts.
• Core Windows Server skills.
• Relational database design skills.
• Programming skills.

After completing this course, students will be able to:

• Describe the uses of and ways to execute the Transact-SQL language.
• Use querying tool.
• Write SELECT queries to retrieve data.
• Group and summarize data by using Transact-SQL.
• Join data from multiple tables.
• Write queries that retrieve and modify data by using subqueries.
• Modify data in tables.
• Query text fields with full-text search.
• Describe how to create programming objects.
• Use various techniques when working with complex queries.

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

Oggi gli architetti IT, i decision maker e i network managers si trovano ad affrontare una sempre più crescente varietà di nuove tecnologie, soluzioni e prodotti per l'informazione e le infrastrutture di comunicazione. Sviluppiamo soluzioni enterprise personalizzate ed economicamente efficaci che sfruttano al massimo il potenziale delle nuove tecnologie. Tutte le nostre soluzioni sono focalizzate su standard internazionali.