  
                     
|
| |
 |
EXTENDED FEATURES IN MICROSOFT SQL SERVER 2000 - LEVEL 3
| Course Description |
|
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. 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.
Course Length: 3 Days
Course Tuition: $1190 (US)
|
| Prerequisites |
|
|
Programming Databases with Microsoft SQL Server 2000 - Level 2.
|
• 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
Download a detailed course outline (PDF)
Contact us for course schedules or more
information.
|
|
|
|
|
|
|
