SQL Server Tour
SQL Server Editions
Graphical Tools
Exploring the Enterprise Manager
Working with SQL Server Books Online

Installing SQL Server
Multiple Instances
Installing an Instance of SQL Server
Configuring the Server

Designing and Creating a Database
Relational Database Design Principles
Implementing the Design

Basic Querying
Introduction to the Query Analyzer
Retrieving Data
Joining Tables

Action Queries
Modifying Data
Inserting Data
Updating Data
Deleting Data

Using the Query Analyzer
Query Analyzer Features
The File Menu Items
The Edit Menu
Query Menu Items
Tools Menu Items
Window Menu Items
Help Menu Items

Programming With Transact-SQL
Overview of Transact-SQL
Using Built-In Functions
Control of Flow
Error Handling

Transaction Processing
Transactions
Working with Locks
Monitoring Processes and Locks
Transaction Isolation
Blocking and Deadlocks

Creating Views
What is a View?
Creating Views
Updating Views

Backups and Maintenance
Creating a Backup Strategy
Implementing Backups
Restoring from a Backup
The Database Maintenance Plan Wizard

Stored Procedures and Triggers
Building Stored Procedures
Building Triggers
Using INSTEAD OF Triggers

User-Defined Functions
User-Defined Functions in SQL Server 2000
Scalar Functions
Inline Table-Valued Functions
Multi-Statement Table-Valued Functions
Functions, Views, and Stored Procedures

Advanced Queries and Linked Servers
Dynamic SQL
Transact-SQL Cursors
Handling Large Data Sets
Distributed Queries

Security
Security Overview
Authentication
Understanding Roles
Assigning Permissions
Application Roles

Monitoring, Tuning, and Configuration
Evaluating Performance
Monitoring with SQL Server Profiler
Tuning Queries
Working with Indexes
Indexed Views
Using the Index Tuning Wizard
Data Caching
The System Monitor

Using System Objects
Exploring System Objects
DBCC

Automating Administration with SQL Agent
Configuring SQL Server Agent
Operators
Jobs
Alerts
Create an Alert

Data Transformation Services (DTS)
Introduction
The DTS Import/Export Wizard
DTS Packages
Controlling DTS Workflow

Replication
Introduction to Replication
Implementing Replication

Publish SQL Server Data to the Web
Publishing Data to the Web
The Web Assistant Wizard
The SQL Server Web Stored Procedures
Scheduling Web Jobs

XML Features, Part I
XML Fundamentals
Generating XML from SQL Queries with FOR XML
Using FOR XML Explicit
Setting Up IIS for SQL Server
Accessing SQL Server Using a URL

XML Features, Part II
Creating XML Views with Annotated Schemas
Using Xpath to Retrieve SQL Server Data Directly
Using OpenXML to Work with XML Documents in Transact-SQL
Using Updategrams

Full Text Search
What is Full-Text Search?
Configuring Full-Text Search
Writing Full-Text Queries
Using Full-Text Search with Documents Stored in SQL Server

Analysis Services
Understanding Analysis Services
Building a Simple Cube
Browsing Data from a Cube
Exploring MDX
Data Mining

English Query
Overview of English Query
Before You Start – Preparing Your Database
Creating an English Query Application
Deploying an English Query Application