MOC-2071: Querying Microsoft SQL Server 2000 with Transact-SQL

Module 1: Introduction to Transact-SQL

- The Transact-SQL Programming Language

- Types of Transact-SQL Statements

- Transact-SQL Syntax Elements

- Using SQL Server Books Online

Module 2: Using Transact-SQL Querying Tools

- SQL Query Analyzer

- Using the Object Browser Tool in SQL Query Analyzer

- Using the osql Utility

- Executing Transact-SQL Statements

- Creating and Executing Transact-SQL Scripts

Module 3: Retrieving Data

- Retrieving Data by Using the SELECT Statement

- Filtering Data

- Formatting Result Sets

- How Queries Are Processed

- Performance Considerations

- Retrieving Data and Manipuling Result Sets

Modulo 4: Grouping and Summarizing Data

- Listing the TOP n Values

- Using Aggregate Functions

- GROUP BY Fundamentals

- Generating Aggregate Values Within Result Sets

- Using the COMPUTE and COMPUTE BY Clauses

- Grouping and Summarizing Data

Module 5: Joining Multiple Tables

- Using Aliases for Table Names

- Combining Data from Multiple Tables

- Combining Multiple Result Sets

- Querying Multiple Tables

Module 6: Working with Subqueries

- Introduction to Subqueries

- Using a Subquery as a Derived Table

- Using a Subquery as an Expression

- Using a Subquery to Correlate Data

- Using the EXISTS and NOT EXISTS Clauses

- Working with Subqueries

Module 7: Modifying Data

- Using Transactions

- Inserting Data

- Deleting Data

- Updating Data

- Performance Considerations

- Modifying Data

Module 8: Querying Full-Text Indexes

- Introduction to Microsoft Search Service

- Microsoft Search Service Components

- Getting Information About Full-Text Indexes

- Writing Full-Text Queries

- Querying Full-Text Indexes

Module 9: Introduction to Programming Objects

- Displaying the Text of a Programming Object

- Introduction to Views

- Advantages of Views

- Creating Views

- Introduction to Stored Procedures

- Introduction to Triggers

- Introduction to User-defined Functions

- Working with Views

Requisitos:

Antes de asistir a este curso, el estudiante debe tener: Experiencia usando sistemas operativos Microsoft Windows; Comprensión del concepto de base de datos relacional incluyendo: diseño de bases de datos físicas y lógicas, concepto de integridad de datos, relaciones entre tablas y columnas y como se almacenan los datos en tablas; Familiarizarse con los roles del administrador de bases de datos.