影印版

lntroduction

Insmictor Notes

Introduction

Course Materials

Prerequisites

Course Outline

Setup

Microsoft Official Cutriculum

Microsoft Certified Professional Program

Facilities

Module 1: SQL Server Overview

Insmictor Notes

Overview

What Is SQL Server?

SQL Server Integration

SQL Server Databases

SQL Server Security

Working with SQL Server

Lab A4 SQL Server Overview

Review

Module 2: Overview of Programming SQL Server

Insmictor Notes

Overview

Designing Enterprise Application Architecture

SQL Server Programming Tools

The TransactSQL Programming Language

Elements of TransactSQL

Additional LangUage Elements

Ways to Execute TransactSQL Statemeflts

Recommended Practices

Lab Af Overview of TransactSQL

Review

Module 3: Creatin9 and Managing Databases

Insmictor Notes

Overview

Creating Databases

Creating FilegrouPs

ManagiY g Databases

Introduction to Data Smictores

Recommended Practices

Lab A: Creating and Managing Databases

Review

Module 4: Creating Data Types and Tables

Insmictor Notes

Overview

Creating Data TyPes

Creating Tables

Generating Column Values

Generating ScriPts

Recommended Practices

Lab A: Creating Data TyPes and Tables

Review

ModuIe 5: lmplementing Data lntegrity

Insmictor Notes

Overview

TyPes of Data Integrity

Enforcing Data Integrity

Defining Constraints

Types of Constraints

Disabling Constraints

Using Defaults and Rules

Deciding Which Enforcement Method to Use

Recommended Practices

Lab A: ImPlementing Data Integrity

Review

Module 6: Planning lndexes

Insmictor NotCs

Overview

Introduction to Indexes

Index Architecture

How SQL Server Retrieves Stored Data

How SQL Server Maintains lndex and HeaP Smictures

Deciding Which Colunms to IndeL

Recomrnended Practices

Lab A: Determining the Indexes of a Table

Review

Module 7: Creating and Maintaining lndexes

Insmictor NotCs

Overview

Creating Indexes

Creating lndex OPtions

Maintaining Indexes

Lab A: Creating and Maintaining Indexes

Introduction to Statistics

Querying the sysindexes Table

Setting Up Indexes Using the lndex Tuning Wizard

Performance Considerations

Reconunended Practices

Lab B: Viewing Index Statistics

Review

ModuIe 8: lmplementing Views

Insmictor NotCs

Overview

Introduction to Vews

Defining Views

Modifying Data Through Views

Optimizing Performance by Using Views

Recommended Practices

Lab Af ImPlementing Views

Review

Module 9: lmplementing Stored Procedures

Instfuctor Notes

Overview

Introduction to Stored Procedures

Creating Executing Modifying and Dropping Stored Procedures

Lab Af Creating Stored Procedures

Using Parameters in Stored Procedures

Executing Extended Stored Procedures

Handling Error Messages

PerfOrmance Considerations

Recommended Practices

Lab BCreating Stored Procedures Using Parameters

Review

Module 10: lmplementing Userdefined Functions

Instructor Notes

Overview

What Is a Userdefined Function?

Defining Userdefined Functions

Examples of Userdefined Functions

Recommended Practices

Lab ACreating Userdefined Functions

Review

ModuIe 11: lmplementing Triggers

Instmctor Notes

Overview

Introduction to Triggers

Defining Triggers

How Triggers Work

Performance Considerations

Recommended Practices

Lab A: Creating Triggers

Review

ModuIe 12: Programmin9 Across MuItiple Servers

Insmictor Notes

Overview

Introduction to Distributed Queries

Executing an Ad Hoc Query on a Remote Data Source

Setting UP a Linked Server Environment

Executing a Query on a Linked Server

Executing a Stored Procedure on a Linked ServeL

Managing Distributed Transactions

Modifying Data on a Linked ServeL

Using Partitioned Views

Recommended Practices

Lab Af Using Distributed Data

Review

Module 13: Optimizing Query PerfOrmance

Insmictor Notes

Overview

Introduction to the Query Optindzer

Obtaining Execution Plan InfOrmation

Using an Index to Cover a Query

Indexing Strategies

Ovetriding the Query Optimizer

Recommended Practices

Lab A: Optimizing Query PerfOrmance

Review

ModuIe 14: AnaIyzing Queries

Instructor Notes

Overview

Queries That Use the AND Operator

Queries That Use the OR Operator

Lab AAnalyzing Queries That Use the AND and OR Operators

Queries That Use Join Operations

Lab Bf Analyzing Queries That Use Different JoinStrategies

Recommended Practices

Review

Module 15: Managing Transactions and Locks

Instmctor Notes

Overview

Introduction to Transactions and Locks

Managing Transactions

SQL Server Locking

Managing Locks

Recommended Practices

Lab Af Managing Transactions and Locks

Review