SQL Server 2000 Extended Features Course

SQL Server 2000 includes a rich set of tools that go beyond the basics of querying and manipulating data. Microsoft added many very useful capabilities in SQL Server that most developers never discover. This course assumes that you already know the fundamentals of how to build a database and program it with Transact-SQL. Learn about the advanced features available to you for maintaining, analyzing, searching and distributing your data. Integrate your data safely with Internet and cross-platform applications.

Upon completion of this course, the participant will be able to:
> Work with SQL Server Agent to create maintenance programs that run automatically and send alerts to operators as required
> 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
> Use Full Text Search to index and find textual data efficiently; and build support for non-SQL, natural-language queries, using English Query

Using System Objects
Exploring the System Tables
Information Schema Views
System Stored Procedures
Extended Stored Procedures
Automating Administration with SQL Agent
Jobs
Operators
Alerts
 
Data Transformation Services (DTS)
Introduction
DTS Wizards
DTS Packages
Controlling DTS Workflow

Replication
Replication Overview
Setting up a Central Publisher
Setting up a Central Subscriber
Snapshot Replication
Transactional Replication
Immediate Updating Subscribers
Queued Immediate Updating
Merge Replication
Monitoring Replication
Best Practices

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 1
Setting Up IIS for SQL Server
Accessing SQL Server Using a URL
Introduction to XML, Schemas, XSLT and Xpath
Generating XML from SQL Queries with FOR XML

XML Features, Part 2
Using FOR XML EXPLICIT
Using XML to Update Tables with OPENXML
Using Updategrams

Full Text Search
Overview of Full Text Search
Creating a New Catalog
Populating a Catalog
Administering Full Text Features
 
Analysis Services
Understanding Analysis Services
Building a Simple Cube
Browsing Data from a Cube
Exploring MDX
Adding a Custom Action to a Cube
Introduction to Data Warehousing

Microsoft English Query
Understanding English Query
Creating an English Query Application
Deploying an English Query Application

SQL Server 2000 Programming and Maintaining Databases (RT 126)