SQL Server 2000 for Developers Part 3 - SQD3

Description
ATS'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 bun- dled with SQL Server, including English Query, DTS, Full Text Search, and Analysis Services. You’ll learn powerful techniques for SQL queries with XML, repli- cation 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. .

Course Outline

Module 1

Section A: Exploring System Objects • System Tables • System Stored Procedures • Username Procedures • Object Info Procedures
Section B: Information Schema Views • Overview • Ownership Issues • Using Information Schema
Section C: System Store Procedures • Overview • View Code • SP_HELP… • SP_SPACEUSED • SP_ADDMESSAGE
Section D: Extended Stored Procedures • Overview • SP & XP Examples • Wrapped EX Procedures • SP_OA… • DBCC • Help on DBCC • Example Commands
Section E: SQL Agent • Overview • 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 • Overview • DTS Designer • Understanding Icons • Data Transforming Task • Transformation Options • Lookups & Options • Workflow Properties • Package Properties


Module 2

Section A: Creating a DTS Package • Package from Scratch • Using Connection Tools • Using Task Tools • Transformation Options • ActiveX Tasks • Workflow Constraints • Verify Results
Section B: Introduction to Replication • Overview • 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 • Overview • Place XML in IIS • What is XML? • XML Elements & Attributes • Inside Internet Explorer • Advantages of XML • Elements vs. Attributes • Compared to HTML

Module 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 • Overview • EXPLICIT MODE • Union Query • Correct Column Sequence • Union All • Order By • Results
Section D: Accessing SQL Server Over HTTP • Overview • 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

Module 4

Section A: Using Open XML & Updategrams • Overview • XML Source • Open XML Code • Get Rowsets • In-Memory Table • Create Cleanup Procedure • Insert Values into Database • Test Procedure • Overview • Inserts • Deletes
Section B: Full Text Search • Overview • 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 • Overview • Create Table • Visual Basic Module • Add Document to Table • Full Text Index • Query Documents • Query Free Text • NEAR

Module 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 • Overview • 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

Price £875 (Bundle of 5)

Complementary Courses
SQ2A - SQL Server 2000 Admin
SQ2D - SQL Server Implementing Data Base Design
SQD1 - SQL Server for Developers Part 1
SQD2 - SQL Server for Developers Part 2
SQ2D - SQL Server DTS Data Transformation Services
SXM2 - XML SQL Server 2000

<<Back <<Contact Us