Oracle XML DB with Real-World Examples

In this lecture the student is taught XML database design within the Oracle RDBMS. 

This lecture presents the basic XML theory necessary for adequate coverage of the remainder of the course.  This is the only theory lecture.  All remaining lectures are programming-based.

This lecture covers the creation of XML documents using SQL embedded functions.

This lecture introduces the creation of XML documents using the PL/SQL dbmx_xmlgen package.

This lecture culminates the creation of XML documents using the PL/SQL dbms_xmlgen package.

This lecture covers a real-world PL/SQL package which creates external XML documents.  Upon completion of this lecture the student will have a strong understanding of creating XML documents via the PL/SQL dbms_xmlgen package.

This lecture introduces the learner to parsing XML documents into their corresponding relational tables.

This lecture culminates our discussion of parsing XML documents into their relational table counterparts.

This lecture covers a real-world example of parsing XML documents into relational tables.

This lecture culminates our discussion of a real-world package for parsing XML documents into relational tables.

This lecture introduces the Oracle XML DB Repository.  It covers features, benefits and costs of using the repository.

This lecture discusses some of the SQL and PL/SQL functions and packages available for managing resources within the repository.

This lecture culminates our discussion of SQL and PL/SQL functions and packages available for managing resources and paths within the repository.

This lecture provides a comprehensive review and summary of prior lectures.  This summary covers all learning objectives as well as their inter-relationships.

This lecture provides a comprehensive review and summary of prior lectures.  This summary covers all learning objectives as well as their inter-relationships.