Microsoft SQL Server 2000 Development


Advanced Features Of Microsoft SQL Server 2000, Level 3

SQL Server 2000 includes a rich set of tools that go beyond the basics of querying and manipulating data. This level covers advanced features for
All 3 levels
Cost: $1,399 + GST
 

maintaining, analyzing, searching and distributing your data.
Integrate your data safely with Internet and cross-platform applications.
This Includes SQL Server Agent, Data Transformation Services (DTS)

Replication, the use of XML, Online Analytical Processing (OLAP) and

the English Query features.
Digging Into the Server
  • System Stored Procedures
  • Extended Stored Procedures
    xp_cmdshell
    xp_sendmail
  • Information Schema Views
  • Exploring System Tables

Using SQL Agent to Automate Administration

  • Jobs
  • Operators
  • Alerts

DTS (Data Transformation Services)

  • DTS Package Designer
    Tasks
  • Controlling DTS Workflow
 Replication
  • Overview of Replication
  • Configuring Replication
  • Publishing and Subscribing
  • Transactional Replication
  • Monitoring Replication
  • Best Practices

Publishing SQL Server Data to the Web

  • Publish to Web Wizard
  • Web Stored Procedures
  • Scheduling Web Jobs

XML

  • Setting Up IIS for SQL Server
  • Introduction to XML, XMLSchema and XPath
  • Generating XML from SQL Queries with FOR XML
 XML 2
  • Using XML to Update Tables with OPENXML
  • Accessing SQL Server Using a URL
  • Using Updategrams

Using Full Text Search
  • Creating a Catalogue
  • Population Catalogues
  • Administering Full Text Features

Using Analysis Services

  • Cube Wizard
  • OLAP Services
  • Building Cubes
  • Data Warehousing
  • Foodmart2000 (MDX)

English Query

  • Understanding English Query
  • Creating and Deploying an English Query Application