XML SQL Server 2000 Training - XMSS Description Course Outline Module 1 Section B: From HTML to XML • Introduction • 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 • Introduction • Using
XSLT Style Sheets • XSL Style Sheets • Generate HTML with XML &
XSL Section E: XML & HTTP in SQL 2000 • Introduction • Accessing
SQL Server Over HTTP • Retrieve Data as XML • Create XML Views •
Send Data to SQL Server Section F: Virtual Directories & SQL Security • Introduction •
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 • Introduction • 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
Module 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 • Introduction • 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 • Introduction • Working with Stream Objects •
Using Templates as ADO Command Objects Section G: Creating XML Views • Introduction • XML vs. SQL Views
• SQL Views • XML Views • sql:relation & key-relation Section H: View Mapper • Introduction • Using XML View Mapper •
Configure View Mapper • Schematic Modeling • Create Mapping Module 3 Section B: Queries Using XPath • Introduction • 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 • Introduction • 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 • Introduction • Insert Data
• Using Stored Procedures Section F: Updating Data with Updategrams • Introduction • Building
Updategrams • Before & After Blocks • Using Updategrams Section G: Inserting & Deleting • Introduction • Insert with
Updategrams • Delete with Updategrams • Using returnid • Multiple
Updates • Using updg.id Section H: Updategram Issues • Introduction • Handling Invalid Characters
• Accessing Databases • Handling NULL Values • Handling Parameters
• Calling Updategrams with Parameters • Handling NULL Parameters Section I: XML Bulk Load • Introduction • 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 Price £550 (Bundle of 3) Complementary Courses
|
