Writing Queries Using Microsoft SQL Server 2008 SQL MOC 2778 TransAC

Overview

This course provides the necessary expertise to write database queries Transact-SQL for Microsoft SQL Server 2008.

Who should attend?

This course is designed for administrators database SQL Server, implementers, system engineers and developers who are responsible for drafting the questions.

At the end of this year:

After completing this course, students will be able to: Describe the uses and forms deejecutar the Transact-SQL language. - Use laherramienta consultation. - Write SELECT queries to retrieve data. - Group and summarize data by using Transact-SQL. -Ingrés Devarias data tables. - Write querecuperar query and modify data by using subqueries. - Modify data in tables. -Consulta Detexto fields with full-text search. - Describe how to create programming objects. - Use various techniques to trabajarcon consultascomplejas.

Prerequisite Comments:

• Skills relational database design
• Programming skills
• Knowledge of data integrity concepts.
• Windows Server Basic skills

Lesson 1: Introduction to Databases and Transact-SQL in SQL Server 2008

• Information SQL Server 2008
• Information Database SQL Server
• Overview and syntax elements of T-SQL
• Working with T-SQL Scripts
• Use T-SQL query tools

Lesson 2: Find and filter data

• Use the SELECT
• Filtering Data
• Working with NULL
• Formatting Result Sets
• Performance Considerations for Writing Queries

Lesson 3: How to group and summarize data

• Summarize data with aggregate functions
• Summarize grouped data
• Traffic pooled
• Create cross-reference queries

Lesson 4: Join data from multiple tables

• View multiple tables using combinations
• The application joins for typical reporting needs
• The combination of limited and result set

Lesson 5: Working with Subqueries

• Writing Basic Subqueries
• Write correlated subquery
• Comparing Subqueries with unions and temporary tables
• Use common table expressions

Lesson 6: Modifying Data in tables

• insert data into tables
• Deleting Data Tables
• Update data in tables
• Information transactions

Lesson 7: Question metadata, XML, and full-text indexes

• Metadata Query
• Information XML
• query XML data
• List of full-text indexes
• query full-text indexes

Lesson 8: Using Programming Objects for Data Recovery

• Summary Visitors
• Understanding user-defined functions
• Summary stored procedures
• List Triggers
• Writing Distributed Queries

Lesson 9: Using Advanced Query Techniques

• Considerations for data available
• Working with data type
• cursors and queries based on sets
• Dynamic SQL
• Maintaining query files