SQL Server 2000 For Developers
Part 3

SQL Server 2000 For Developers Part 3

5 Sessions –
15 Hours of Interactive Training

LearnKey's SQL Server 2000 for Developers Part 3 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 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.

Also Available:
· Study Guide

About The Author

Mary Chipman and Andy Baron are Senior Consultants with MCW Technologies, and both are Microsoft MVPs for 5 years running. Specializing in database application development and writing about SQL Server, Visual Basic, the .NET framework, and related technologies, they are co-authors of the Microsoft Access Developer's Guide to SQL Server, published by Sams, and Mary co-authored SQL Server 7.0 in Record Time, published by Sybex. Their combination of experience brings a unique programming and management view to the concepts of SQL development.

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

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

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

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

Session 5

Section A: Building an OLAP Cube
· Cubes, Dimensions & Measures
· MOLAP, ROLAP & HOLAP

SQL Server 2000 For Developers Part 3 continued

· 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