Layout Table~~~~3424~3424~~

5 Sessions - 15 Hours of Interactive Training~
LearnKey's SQL Server 2000 for Developers Part 3 training course provides comprehensive instruction for utilizing SQL to its fullest potential. Experts Mary Chipman and Andy Baron cover the rich set of auxiliary tools bundled with SQL Server, including English Query, DTS, Full Text Search, and Analysis Services. You’ll learn powerful techniques for SQL queries with XML, replication and Data Mining and more. At the conclusion of this training course, you will have a thorough understanding of the development and support concepts required to make effective use of SQL Server 2000..

Prerequisites: Experience with any database product or some developer or programming experience

Benefits
• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner. .~~~3424~3425~~

Course Outline Table~~~~3424~3426~~

Session 1~Section A: Exploring System Objects
· System Tables
· System Stored Procedures
· Username Procedures
· Object Info Procedures

Section B: Information Schema Views
· Ownership Issues
· Using Information Schema

Section C: System Store Procedures
· View Code
· SP_HELP…
· SP_SPACEUSED
· SP_ADDMESSAGE

Section D: Extended Stored Procedures
· SP & XP Examples
· Wrapped EX Procedures
· SP_OA…
· DBCC
· Help on DBCC
· Example Commands

Section E: SQL Agent
· User Interface
· Operators
· Configure Agent
· Create Operators
· Create Jobs
· Job Properties
· Test Run Job
· Create Alerts
· Alert Response

Section F: Data Transformation Services
· Intro to DTS
· Data Manipulation
· DTS Wizard
· Data Sources
· Selection of Data
· Save & Schedule
· Save to VB
· Save DTS Package

Section G: DTS Packages
· DTS Designer
· Understanding Icons
· Data Transforming Task
· Transformation Options
· Lookups & Options
· Workflow Properties
· Package Properties~~~3424~3427~~

Session 2~Section A: Creating a DTS Package· Package from Scratch· Using Connection Tools
· Using Task Tools
· ActiveX TasksTransformation Options
· Workflow Constraints
· Verify Results

Section B: Introduction to Replication
· How It Works
· Terminology
· Topologies
· Pre-requisites
· Replication Caveats
· Components & Methods
· Snapshot Replication
· Transactional Replication
· Merge Replication
· Bi-Directional Replication & Transformable Subscriptions
· Best Scenario

Section C: Implementing Replication
· Getting Started
· Wizard Options
· Publisher & Distributor Properties
· Create Publication Wizard
· Published Table Properties
· Push Subscription Wizard
· Replications Monitor
· Verify Replication
· Removing Replication
· Disable Publishing Wizard
· Cleanup

Section D: Publishing to the Web
· Web Assistant Wizard
· Webpage Options
· Verify Webpage
· View Script
· Using Stored Procedures
· Using HTML Template
· Web Job Properties
· SP_DROPWEBTASK

Section E: Introduction to XML
· Place XML in IIS
· What is XML?
· XML Elements & Attributes
· Inside Internet Explorer
· Advantages of XML
· Elements vs. Attributes
· Compared to HTML~~~3424~3428~~

Session 3~Section A: XML Document Structure & Definition
· XML Features
· XML Hierarchy
· XML Schema
· XML Namespace

Section B: SQL Queries with FOR XML
· Generating XML
· Using ASP
· Generated XML Tags
· Select Statement
· ASP Code Listing
· Schema Options
· Raw Mode

Section C: Using FOR XML EXPLICIT
· EXPLICIT MODE
· Union Query
· Correct Column Sequence
· Union All
· Order By
· Results
Section D: Accessing SQL Server Over HTTP
· Setting Up HTTP Access
· New Virtual Directory
· Specifying Security
· Setting Virtual Names

Section E: Creating URL Queries
· Embedding a Query in a URL Address
· Route Element
· Template Queries
· Stylesheet
· XSL Stylesheet
· Using Stylesheet to Retrieve HTML
· Passing Parameter Values
· XML Case Sensitivity

Section F: Using Annotated Queries & Schema
· XML Views & Schemas
· XML View Mapper
· XDR Editor
· XPath Queries
· URL XPATH Queries~~~3424~3429~~

Session 4~Section A: Using Open XML & Updategrams
· XML Source
· Open XML Code
· Get Rowsets
· In-Memory Table
· Create Cleanup Procedure
· Insert Values into Database
· Test Procedure
· Inserts
· Deletes

Section B: Full Text Search
· Advantages
· Configuring Index
· Index Wizard
· Index Catalogs
· Modify Population

Section C: Full Text Queries
· Writing Queries
· Create Variables
· AND & AND NOT
· Term Variations
· FREETEXTTABLE
· Containstable
· Using Weights
· FREETEXTTABLE

Section D: Full Text Search with Documents
· Create Table
· Visual Basic Module
· Add Document to Table
· Full Text Index
· Query Documents
· Query Free Text
· NEAR~~~3424~3430~~

Session 5~Section A: Building an OLAP Cube
· Cubes, Dimensions & Measures
· MOLAP, ROLAP & HOLAP
· Partitions & Virtual Cubes
· Analysis Manager
· Using the Cube Wizard
· Using the Dimension Wizard
· Time Dimensions
· Using the Cube Editor
· Configuring Data Storage Options

Section B: Query an OLAP Cube
· Cube Browser
· Introduction to MDX
· Using MDX

Section C: Data Mining
· Create Data Mining Cube
· Mining Model Wizard
· Browsing Mined Data
· Cube Browser

Section D: Building English Query Models
· Components
· Preparing Your Database
· English Query
· Project Wizard
· Semantic Properties
· Phrasing Types
· Visual Studio Shell
· Relationship Testing

Section E: Deploying an English Query Application
· Deploy to the Web
· Wizard
· Test
· Internet Guest Account
· Question Builder~~~3424~3431~~

Ordering~~~~3424~3432~~

SQL Server 2000 For Developers Part 3 Training Course by LearnKey~Per Seat Licencing Available

Call 01223 894 136 for quotes for MULTIPLE USERS and Training Centre/Bootcamp & Education Solutions!~~PER USER%3A CD Course|410848|PER USER%3A ONLINE Course|!78807|LIBRARY LICENCE%3A CD Course|410845|~3424~3433~sql server 2000~