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
鄂公網(wǎng)安備 42010302001612號(hào) 