Microsoft SQL Server 2000

• Learn to install and configure Microsoft SQL Server 2000.
• Understand basic database design principles and how to implement them in SQL Server.
• Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data.
• Use the programming environment in the Query Analyzer.
• Understand the differences between view, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each.
• Design and implement reliable backup and maintenance plans.
• Understand the SQL Server security model; and create logins, users and permissions to protect your data.
• Configure and tune SQL Server, and monitor database activity.
• Use Data Transformation Services (DTS) to import and export data, or to move it between external data sources, handling data mapping and conversion when necessary.
• Support distributed users by implementing SQL Server Replication, and understand which replication options are appropriate for which requirements.
• Publish data to the Web, and take advantage of SQL Server 2000’s rich support for Extensible Markup Language (XML).
• Use Analysis Services to create online analytical processing (OLAP) solutions and to mine your data for hidden patterns.

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

MODULE 2

Designing and Creating a Database (continued)

• Implementing the Design

Basic Querying

• Introduction to the Query Analyzer
• Retrieving Data

MODULE 3

Basic Querying (continued)

• Joining Tables

Action Queries

• Modifying Data
• Inserting Data
• Updating Data
• Deleting Data

MODULE 4

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

MODULE 5

Programming With Transact-SQL (continued)

• 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?

MODULE 6

Creating Views (continued)

• 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

MODULE 7

Stored Procedures and Triggers (continued)

• Building Stored Procedures (continued)
• 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

MODULE 8

Advanced Queries and Linked Servers

• Dynamic SQL
• Transact-SQL Cursors
• Handling Large Data Sets
• Distributed Queries

Security

• Security Overview
• Authentication
• Understanding Roles
• Assigning Permissions

MODULE 9

Security (continued)

• 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

MODULE 10

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

MODULE 11

Data Transformation Services (DTS) (continued)

• 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

MODULE 12

XML Features, Part I (continued)

• 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

MODULE 13

XML Features, Part II (continued)

• 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

MODULE 14

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 and English Query Application
• Deploying an English Query Application