| Sign in | Sitemap | Feedback
Go To AppexTech

Advance SQL Server 2000

1 Hour Daily

Duration:- ... Months

Appextech Advanced SQL Server 2000 class teaches attendees how to automate administration, import/export data using DTS, perform database replication, work with XML, use Analysis Services, configure and use English Query, perform full text searches, and more.

Advanced Microsoft SQL Server 2000 Training Objectives

All attendees will learn to:

  1. Automate administration with the SQL Agent
  2. Import and export data using DTS
  3. Set up replication
  4. Publish SQL Server data to the web
  5. Write queries for processing XML
  6. Perform full text searches
  7. Master the fundamentals of analysis services
  8. Discover how to use English Query

Advanced Microsoft SQL Server 2000 Training Outline

  1. Using System Objects
    1. Exploring System Objects
    2. DBCC
  2. Automating Administration with SQL Agent
    1. Configuring SQL Server Agent
    2. Operators
    3. Jobs
    4. Alerts
    5. Create an Alert
  3. Data Transformation Services (DTS)
    1. Introduction
    2. The DTS Import/Export Wizard
    3. DTS Packages
    4. Controlling DTS Workflow
  4. Replication
    1. Introduction to Replication
    2. Implementing Replication
  5. Publish SQL Server Data to the Web
    1. Publishing Data to the Web
    2. The Web Assistant Wizard
    3. The SQL Server Web Stored Procedures
    4. Scheduling Web Jobs
  6. XML Features, Part I
    1. XML Fundamentals
    2. Generating XML from SQL Queries with FOR XML
    3. Using FOR XML Explicit
    4. Setting Up IIS for SQL Server
    5. Accessing SQL Server Using a URL
  7. XML Features, Part II
    1. Creating XML Views with Annotated Schemas
    2. Using Xpath to Retrieve SQL Server Data Directly
    3. Using OpenXML to Work with XML Documents in Transact-SQL
    4. Using Updategrams
  8. Full Text Search
    1. What is Full-Text Search?
    2. Configuring Full-Text Search
    3. Writing Full-Text Queries
    4. Using Full-Text Search with Documents Stored in SQL Server
  9. Analysis Services
    1. Understanding Analysis Services
    2. Building a Simple Cube
    3. Browsing Data from a Cube
    4. Exploring MDX
    5. Data Mining
  10. English Query
    1. Overview of English Query
    2. Before You Start - Preparing Your Database
    3. Creating and English Query Application
    4. Deploying an English Query Application

Database Training