XML with SQL Server 2000 For Developers

XML with SQL Server 2000
For Developers

3 Sessions –
9 Hours of Interactive Training

XML and HTTP have become the standard technologies for marshalling data between the tiers of distributed applications. In the XML with SQL Server 2000 for Developers course from LearnKey, expert instructor Andy Baron uses example-based instruction and clear explanations of underlying concepts to show application developers the powerful support in SQL Server 2000 for working with data as XML and for communicating with the server over HTTP. At the conclusion of this course, you will understand how to take advantage of XML and HTTP support offered by SQL Server 2000 to save programming time and increase program efficiency.

Prerequisites: Some basic experience using SQL Server and Structured Query Language (SQL).

Benefits

Maximize your efforts to rapidly deploy effective business solutions.

Increase your earning potential with technical mastery and proficiency.

Enhance employment opportunities with in-demand technical knowledge.

About The Author

Andy Baron, based in Singer Island, Florida, is a Senior Consultant with MCW Technologies, specializing in Visual Basic and T-SQL programming, database design, the .NET Framework, and creation of effective user interfaces. He is a Contributing Editor for Advisor Media and for Pinnacle Publication, a writer for SQL Server Magazine, and co-author of the Microsoft Access Developer's Guide to SQL Server. Since 1995, Andy has been selected each year as a Microsoft MVP for his contributions to Microsoft's online support. He also speaks regularly at industry conferences.

Session 1

Section A: Traditional Text Files
· Data Interchange
· Text File Types
· Shortcomings of Text Data

Section B: From HTML to XML
· HTML Overview
· Attributes & Elements
· XML Rules
· XML Features in Internet Explorer
· Advantages of Using XML

Section C: XML Technologies
· Namespaces
· Advantages to Namespace
· Planning Schemas
· Defining Schemas
· Using Schemas

Section D: Transforming XML with Style Sheets
· Using XSLT Style Sheets
· XSL Style Sheets
· Generate HTML with XML & XSL

Section E: XML & HTTP in SQL 2000
· Accessing SQL Server Over HTTP
· Retrieve Data as XML
· Create XML Views
· Send Data to SQL Server

Section F: Virtual Directories & SQL Security
· Setup Virtual Directory for SQL 2000
· Virtual Directory Properties
· Setup Security
· Establish Data Source
· SQL Settings & Options
· Allow XPath & Post

Section G: Setting Up Virtual Names
· Define Virtual Names
· Define Schema & Templates
· Advanced Settings

Section H: URL Queries & Templates
· Embedded SQL in URL
· Launch Query
· Architecture of Execution
· XML Template
· Launch Template

Session 2

Section A: Query Analyzer & For XML
· View XML Results
· Set Results Options
· DBCC traceon
· Change View to Text

Section B: FOR XML AUTO & RAW Modes
· Customizing Toolbar in Query Analyzer
· Returning Hierarchical XML
· Changing Hierarchies
· Using the Elements Option
· Choosing Between Attributes & Elements
· FOR XML RAW

Section C: FOR XML EXPLICIT
· Working with FOR XML
· Union Queries
· Tag & Parent Columns
· Column Alias
· Directive Options
· xmltext Directive
· Using ORDERBY

Section D: FOR XML Options
· Using XMLDATA
· Schema Documents
· Binary Data Handling

Section E: XML from URL & Template Queries
· Using SELECT in URL
· Validating XML Results
· Using Template Queries
· Using Parameters in Templates
· Passing Parameters with URLs
· Reference Style Sheets
· Content Type & Output Encoding

Section F: ADO
· Working with Stream Objects
· Using Templates as ADO Command Objects

Section G: Creating XML Views
· XML vs. SQL Views
· SQL Views
· XML Views
· sql:relation & key-relation

Section H: View Mapper
· Using XML View Mapper
· Configure View Mapper
· Schematic Modeling
· Create Mapping

Session 3

Section A: View Mapper
· Complex Relationships
· Mapping Complex Relationships
· Using XDR Editor & XPath Queries

Section B: Queries Using XPath
· Using XPath in Templates & URLs
· SQL Profiler
· Using XPath without a Mapping Schema
· Using ADO with XML Views & XPath Queries

Section C: Parsing with Open XML
· Adding Data to SQL Server
· Get Data from XML Document
· Test Procedure

Section D: Open XML Rowsets
· Flags
· Schema Declaration
· Use Table Names
· Without WITH Statement

Section E: Modifying Data with Open XML
· Insert Data
· Using Stored Procedures

Section F: Updating Data with Updategrams
· Building Updategrams
· Before & After Blocks
· Using Updategrams

Section G: Inserting & Deleting
· Insert with Updategrams
· Delete with Updategrams
· Using returnid
· Multiple Updates
· Using updg.id

Section H: Updategram Issues
· Handling Invalid Characters
· Accessing Databases
· Handling NULL Values
· Handling Parameters
· Calling Updategrams with Parameters
· Handling NULL Parameters

Section I: XML Bulk Load
· Using Visual Basic to Support Bulk Load
· Planning for Bulk Load
· Specifying Data File
· Error Handling
· SQL XML Bulk Load Properties
· Create & Delete SQL Objects
· Using Bulk Load