| 作 者： | 美国IBM公司编；韩建伟，韩牧译 |
| 出版社： | 清华大学出版社 |
| 丛编项： | 微软培训与认证系列教材 |
| 版权说明： | 本书为公共版权或经版权方授权，请支持正版图书 |
| 标 签： | 微软认证 |
| ISBN | 出版时间 | 包装 | 开本 | 页数 | 字数 |
|---|---|---|---|---|---|
| 未知 | 暂无 | 暂无 | 未知 | 0 | 暂无 |
Introduction
Course Materials
Prerequisites
Course Outline
Appendices
Microsoft Official Curriculum
Microsoft Certified Professional Program
Facilities
Module 1: Introduction to Transact-SQL
The Transact-SQL Programming Language
Types of Transact-SQL Statements
Transact-SQL Syntax Elements
Lab A: Using SQL Server Books Online
Review
Module 2: Using Transact-SQL Querying Tools
SQL Query Analyzer
Using the Object Browser Tool in SQL Query Analyzer
Using Templates in SQL Query Analyzer
Using the osql Utility
Executing Transact-SQL Statements
Recommended Practices
Lab A: Creating and Executing Transact-SQL Scripts
Review
Module 3: Retrieving Data
Retrieving Data by Using the SELECT Statement
Filtering Data
Formatting Result Sets
How Queries Are Processed
How Queries Are Cached Automatically
Performance Considerations
Recommended Practices
Lab A: Retrieving Data and Manipulating Result Sets
Review
Module 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
Recommended Practices
Lab A: Grouping and Summarizing Data
Review
Module 5: Joining Multiple Tables
Using Aliases for Table Names
Combining Data from Multiple Tables
Combining Multiple Result Sets
Recommended Practices
Lab A: Querying Multiple Tables
Review
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
Recommended Practices
Lab A: Working with Subqueries
Review
Module 7: Modifying Data
Using Transactions
Inserting Data
Deleting Data
Updating Data
Performance Considerations
Recommended Practices
Lab A: Modifying Data
Review
Module 8: Querying Full-Text Indexes
Introduction to Microsoft Search Service
Microsoft Search Service Components
Getting Information About Full-Text Indexes
Writing Full-Text Querie
Recommended Practices
Lab A: Querying Full-Text Indexes
Review
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
Recommended Practices
Lab A: Working with Views
Review
Appendix A: Library Database Case Study
Appendix B: Database Schemas
Automated Classroom Setup Guide
Classroom Requirements
Classroom Configuration
Setup Instructions
Automated Classroom Setup
Classroom Setup Checklist
Customization Information
