This course introduces students to the querying and analytical capabilities of Oracle 9iAS Discoverer. Students will learn how to view data stored in a relational database, and analyze and create reports based upon that data using Discoverer Plus. In particular, students will learn how to create, modify, and refine ad hoc queries using Discoverer's intuitive and easy-to-use Workbook Wizard. They will learn how to present data graphically and how to format query results to create customized reports.

Students will learn how to create simple and advanced calculations to perform data analysis and create reports that answer a variety of business questions, such as, year-to-year comparisons and ranking.In addition, students will learn how to schedule reports in batch mode, share workbooks with other users, and export reports to many other applications, including MS Excel, HTML, and Oracle Reports. Finally, students will learn how to use Oracle9iAS Portal to publish and customize Discoverer portlets.

This course introduces students to the Oracle9i Discoverer Administrator. As Discoverer managers, students learn how to create and customize the End User Layer, how to create business areas and folders, and define analytical facilities for end users. Students learn about the different types of connection mechanisms supported by Discoverer and how to control the user access to the End User Layer.

Students also learn how to use Oracle9i materialized views for automated summary management. In addition, students learn how to configure Oracle9iAS Discoverer using Oracle Enterprise Manager, and enable Web Cache for Discoverer Viewer. They will also learn about the integration of Discoverer with Oracle9iAS Portal and Oracle9iAS Single Sign-On.

This course introduces the architecture of Oracle Application Server 10g and enables the participants to effectively install and manage it. The participants learn how to access and use Oracle Application Server management tools, and practice the basic management tasks such as starting and stopping of Oracle Application Server instances and its components.

The participants gain hands-on experience in configuring the OracleAS Infrastructure and the OracleAS middle-tier. They also learn to deploy PL/SQL applications and J2EE applications such as Java Servlets, JavaServer Pages, Enterprise JavaBeans, and Web Services. They learn the concepts of identity management and how to manage and configure Oracle Internet Directory, OracleAS Single Sign-On Server, and the OracleAS Certificate Authority. The participants enable the use of SSL for some OracleAS components.

This course is the follow-up to Oracle Application Server 10g: Administration I. The focus of this class is to introduce how to distribute identity management components as well as the middle tier. The participants learn the high availability concepts provided with Oracle Application Server 10g and the relationship between installation, high availabilty, and scalability. Students learn to effectively install and manage non-default installations. They access and use Oracle Application Server management tools.

OracleAS Portal provides an environment creating enterprise portals. An enterprise portal is a corporate gateway to information access and management. In this course, students learn to create, deploy, and test portlets, the building blocks of a portal page. They learn to integrate J2EE applications with OracleAS Portal, by applying the OracleAS Portal Developer Kit Java application-programming interface (API).

Students also learn to make portlets customizable to enable end user personalization. Students learn to build multi-lingual portlets, to secure portlets, and enhance portlet performance by implementing caching.

This course introduces students to the querying and analytical capabilities of OracleAS Discoverer. Students will learn how to view data stored in a relational database, and analyze and create reports based upon that data using OracleAS Discoverer Plus. In particular, students will learn how to create, modify, and refine ad hoc queries using Discoverer's intuitive and easy-to-use Workbook Wizard. They will learn how to present data graphically and how to format query results to create customized reports. Students will learn how to create simple and advanced calculations to perform data analysis and create reports that answer a variety of business questions, such as year-to-year comparisons and ranking.

In addition, students will learn how to schedule reports in batch mode, share workbooks with other users, and export reports to other applications, including MS Excel, HTML, and Oracle Reports. Finally, students will learn how to view and customize Discoverer portlets using OracleAS Portal. This course also provides students with the prerequisite skills necessary for the "Oracle Discoverer 10g: Develop an EUL" course.

This course introduces students to Oracle Discoverer Administrator 10g. As Discoverer managers, students learn how to create and customize the End User Layer, how to create business areas and folders, and define analytical facilities for end users. Students also learn about the different types of connection mechanisms supported by OracleAS Discoverer and how to control the user access to the End User Layer. Students learn how to use materialized views and automated summary management. In addition, students learn how to use Oracle Enterprise Manager 10g Application Server Control to configure OracleAS Discoverer.

The course will be taught with emphasis on hands-on practices using the new features. After reviewing the Oracle Application Server architecture, participants will install Oracle Application Server Infrastructure and middle-tier components, specifically with performance, security, and high availability in mind. The participants learn to access and use Oracle Application Server management tools to effectively manage and customize configurations of the Oracle Application Server components.

This course introduces students to the basics of XML. The students learn how to create an XML document and format it using XML Stylesheet Language for transformations (XSL). The students validate XML documents using Document Type Definition (DTD) and XML Schema. The course discusses XPath expressions and how to use XPath expressions in XSL to select parts of an XML document to be transformed. XML Namespaces are used to apply uniqueness to elements, and parsing XML documents is done using Document Object Model (DOM). The Simple API for XML (SAX) is also discussed as a technique to parse XML documents. In addition, the students are introduced to the support for XML offered in various Oracle products, such as, the Oracle Database, Oracle XML DB, Oracle XML Developer's Kit, Oracle JDeveloper, and Oracle XSQL pages. The students learn how to format, query, validate, and store their XML documents using Oracle products.

This course provides students with a basic understanding of the architecture, database and file system used in Oracle Applications Release 11i. Students learn about the multi-tier architecture used to provide user access over the Internet or an intranet and the relationship between Oracle Applications and the Oracle database.

The course covers the structure of the file system used to store the Oracle Applications product files, environment files, and additional files required to support multiple languages in Release 11i. Students also learn how to use Rapid Install to perform both single and multi-node installations of Oracle Applications, AD Administration and other AD utilities to maintain Oracle Applications, AutoPatch to automate the application of Oracle Applications patches, and Rapid Clone to clone an Oracle Applications system.