2073 Programming a Microsoft SQL Server 2000 Database

Lesson 1: SQL Server Overview

• What Is SQL Server?

• SQL Server Integration

• SQL Server Databases

• SQL Server Security

• Working with SQL Server

Lesson 2: Overview of Programming SQL Server

• Designing Enterprise Application Architecture

• SQL Server Programming Tools

• The Transact-SQL Programming Language

• Elements of Transact-SQL

• Additional Language Elements

• Ways to Execute Transact-SQL Statement

Lesson 3: Creating and Managing Databases

• Creating Databases

• Creating Filegroups

• Managing Databases

• Introduction to Data Structures

Lesson 4: Creating Data Types and Tables

• Creating Data Types

• Creating Tables

• Generating Column Values

• Generating Scripts

Lesson 5: Implementing Data Integrity

• Types of Data Integrity

• Enforcing Data Integrity

• Defining Constraints

• Types of Constraints

• Disabling Constraints

• Using Defaults and Rules

• Deciding Which Enforcement Method to Use

Lesson 6: Planning Indexes

• Introduction to Indexes

• Index Architecture

• How SQL Server Retrieves Stored Data

• How SQL Server Maintains Index and Heap Structures

• Deciding Which Columns to Index

Lesson 7: Creating and Maintaining Indexes

• Creating Indexes

• Creating Index Options

• Maintaining Indexes

• Introduction to Statistics

• Querying the sysindexes Table

• Setting Up Indexes Using the Index Tuning Wizard

• Performance Considerations

Lesson 8: Implementing Views

• Introduction to Views

• Advantages of Views

• Defining Views

• Modifying Data Through Views

• Optimizing Performance by Using Views

• Performance Considerations

Lesson 9: Implementing Stored Procedures

• Introduction to Stored Procedures

• Creating, Executing, Modifying, and Dropping Stored Procedures

• Using Parameters in Stored Procedures

• Executing Extended Stored Procedures

• Handling Error Messages

• Performance Considerations

Lesson 10: Implementing User-defined Functions

• What Is a User-defined Function?

• Defining User-defined Functions

• Examples of User-defined Functions

Lesson 11: Implementing Triggers

• Introduction to Triggers

• Defining Triggers

• How Triggers Work

• Examples of Triggers

• Performance Considerations

Lesson 12: Programming Across Multiple Servers

• 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

• Managing Distributed Transactions

• Modifying Data on a Linked Server

• Using Partitioned Views

Lesson 13: Optimizing Query Performance

• Introduction to the Query Optimizer

• Obtaining Execution Plan Information

• Using an Index to Cover a Query

• Indexing Strategies

• Overriding the Query Optimizer

Lesson 14: Analyzing Queries

• Queries That Use the AND Operator

• Queries That Use the OR Operator

• Queries That Use Join Operations

Lesson 15: Managing Transactions and Locks

• Introduction to Transactions and Locks

• Managing Transactions

• SQL Server Locking

• Managing Locks