2071 - QUERYING MICROSOFT SQL SERVER 2000 WITH TRANSACT-SQL
|
|
Course MOC |
Language Course |
ILT Classroom |
Mentored Learning |
OnLine AnyTime |
OnLive Live |
|
2 DAYS |
English |
Yes |
Yes |
Yes |
Yes |
Module 1: Introduction to Transact-SQL
The following topics are covered in this module:
• 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
The following topics are covered in this module:
• 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
The following topics are covered in this module:
• Retrieving Data by Using the SELECT Statement
• Filtering Data
• Formatting Result Sets
• How Queries Are Processed
• Performance Considerations
• Retrieving Data and Manipulating Result Sets
Module 4: Grouping and Summarizing Data
The following topics are covered in this module:
• 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
The following topics are covered in this module:
• Using Aliases for Table Names
• Combining Data from Multiple Tables
• Combining Multiple Result Sets
• Querying Multiple Tables
Module 6: Working with Subqueries
The following topics are covered in this
module:
• 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
The following topics are covered in this module:
• Using Transactions
• Inserting Data
• Deleting Data
• Updating Data
• Performance Considerations
• Modifying Data
Module 8: Querying Full-Text Indexes
The following topics are covered in this module:
• 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
The following topics are covered in this module:
• 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