XML SQL Server 2000 - SXM2

Description
Course
XML and HTTP have become the standard technologies for marshalling data between the tiers of distributed applications. In the XML with SQL 2000 for Developers training course from ATS, 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

Course Outline

Module 1

Section A: Traditional Text Files • Data Interchange • Text File Types • Shortcomings of Text Data
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 A: View Mapper • Complex Relationships • Mapping Complex Relationships • Using XDR Editor & XPath Queries
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
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
SQD3 - SQL Server for Developers Part 3
SQ2D - SQL Server DTS Data Transformation Services

<<Back <<Contact Us