Cart
Home > Learn XML > XML Video Demos > Box Office > Learn SQL/XML > Accessing Databases as XML: Part I
Accessing Relational Databases as XML with Stylus Studio's File Explorer
Stylus Studio's File Explorer provides an easy and intuitive way to extract data from any relational database. This video demonstration covers how to create and re-use database connections that enable you to directly access relational data in real time for use in your XQuery and XSLT applications.
The Camtasia Studio video content presented here requires JavaScript to be enabled and the latest version of the Macromedia Flash Player. If you are you using a browser with JavaScript disabled please enable it now. Otherwise, please update your version of the free Flash Player by downloading here.
Catch the entire Relational Database to XML Mapping series!
Accessing Relational Databases as XML with Stylus Studio's File Explorer covers the following topics:
- Creating a connection to a relational database — for example, Oracle, Microsoft SQL Server, IBM DB2, Informix and Sybase
- Creating the database connection string including server name, user name and password
- Browsing database tables, views, schemas and other database objects from within the Stylus Studio file explorer
- Writing an XQuery expression that accesses a relational data source
- Understanding and using the XQuery collection function
- Specifying which XQuery processor to use, for example, DataDirect XQuery or the built-in Stylus Studio XQuery processor.
- Executing an XQuery application that accesses a relational database and previewing the resulting XML output in Stylus Studio.
XQuery Integration
Learn how new XQuery technologies can simplify legacy data integration by leveraging industry standards, proven open-source XML processing components, and Stylus Studio's integrated XQuery & XML tools.
Validate XML Using XSD
You can validate XML documents against any data model defined using W3C XSD, using any major XSD Validator, including MSXML 3.0, MSXML 4.0, MSXML 6.0, Xerces-J, Xerces-C, Microsoft System.XML (1.0 and 2.0), XSV, the Saxonica XSD Validator and others.
SQL/XML Tutorial
Many developers need to be able to write applications that work for databases from multiple vendors. This SQL/XML Tutorial refers to SQL/XML, XQuery, and Native XML Programming Languages to do just that.
XML Schema Quality Checker
Use IBM's alphaWorks XML Schema Quality Checker to check the quality and style of your XML schema documents. Fully integrated with the Stylus Studio XML Schema Editor and XML validator.
