XML with SQL Server 2000 For Developers (Program Details)
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
Return To Main Product Page
Price: £219.00
(incl. VAT and Delivery)
for Single User Licence
