Java, SQL, XML and Web Services

by Ken North

Description

This class explains how to use the powerful combination of Java, SQL, JDBC and XML to write multi-tier applications and extend databases.
It also explains how to use those technologies to develop Web services, the new paradigm for distributed Internet applications. To create portable, multi-platform software, many developers use Java to access databases and XML to exchange data.
Java database developers write applets, applications, servlets, and classes installed in databases. XML developers can use database extensions for storing and querying XML documents.
Developers creating and using Web services use the Simple Object Access Protocol (SOAP) and the Web Services Description Language (WSDL) when exposing services and methods on remote computers.
This class explains architectures and programming techniques for using XML, Java, SQL and Web services toolkits. The instructor explains JDBC, embedded SQL for Java (SQLJ), XML and Web services concepts.
The instructor explains the Document Object Model (DOM) and Simple API for XML (SAX), and interoperable SQL for ODBC and JDBC. The instructor explains example programs for doing SQL queries, for storing and retrieving XML from databases, for processing XML data, and for database-enabled Web services.

Main Topics

DBMS server architectures that include Java and XML in the database
Java, SQL, and XML as tools for writing database programs and Web services
The programming model for processing SQL statements and metadata
Java database programming techniques
Web services programming techniques
How to use JDBC when extending databases and developing Web services
The programming model and APIs for processing XML documents
How to use SQLJ and interoperable SQL
The role of XML Web services and XML-extended databases
How to add Java stored procedures and UDFs to a database
Benefits and cautions related to server extensions
How to perform content-based queries and section searches over XML documents