Microsoft SQL Server 2000 Professional Training via CD-ROM

Level 3 

Microsoft SQL Server 2000 CD-ROMs

Cost Level 3: $595 + GST

Set of 5 CD's

Cost All 3 Levels: $1,350.00 + GST

Set of 14 CD's

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.

Level 3 

Digging Into the Server
  • System Objects and Stored Procedures
  • Extended Stored Procedures
    Information Schema Views
  • Exploring System Tables
  • DBCC Commands

Using SQL Agent to Automate Administration

  • Configuring SQL Server Agent
  • Jobs
  • Operators
  • Alerts

DTS (Data Transformation Services)

  • DTS Package Designer
    Tasks
  • Import / Export
  • DTS Packages
  • Controlling DTS Workflow
  • Precedent Constraints, DTS Transactions, Error Handling
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
  • XML Document Structure
  • Introduction to XML, XMLSchema and XPath
  • Generating XML from SQL Queries with FOR XML
  • Using XSLT to Transform XML Data
  • URL Queries
XML 2
  • Creating XML Views and Annotated Schemas
  • Using Template XPath Queries
  • Using URL XPath Queries
  • Using Xpath to Retrieve SQL Server Data Directly
  • Inserting Data from XML into SQL Server
  • Using Updategrams

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

Using Analysis Services

  • Cubes, Dimensions and Measures
  • MOLAP, ROLAP and HOLAP
  • Partitions and Virtual Cubes
  • Data Mining
  • Browsing Data from a CUBE
  • Exploring MDX

English Query

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