In this course students build reports and run them in client-server mode and on the Web. Working in a graphical user interface environment, students learn to retrieve, display, and format data in numerous reporting styles. They also learn to customize more complex reports, embed graphical charts, and use the Reports Server. The course covers building reports for the Web, calling Java applets, using reports administration and security.

In this course, students design and build a variety of standard and custom Web and paper reports using Oracle9i Reports Developer. Working in the declarative environment of Reports Builder, students learn how to retrieve data from any data source, display it in any format, and publish the output to any destination.

Students learn how to create Web and paper reports using the Report Wizard, add dynamic report data to static HTML pages using custom JSP tags, and publish reports to the Web. They also learn how to customize more complex reports, embed graphical charts, and use Oracle9iAS Reports Services to deploy their reports.

With the help of business intelligence, companies are learning more about their best customers, their supply chains and product life cycles--to the benefit of the bottom line. Accurate business intelligence can lead to competitive advantage, and people who know how to administer such a system play a critical role in its success.

This course is intended for database administrators, system administrators, and database application developers who design, maintain, and use data warehouses. The main topics are: Parallel execution, ETL (Extraction, Transformation, and Loading), materialized views, and star schema optimization. In order to attend this course, you need to be familiar with relational database concepts, basic data warehouse notions, Oracle9i server concepts including application and server tuning, and the operating system environment under which you are running Oracle. Note that this course does not cover Real Application Clusters; that is done in a separate course.

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.

Upon completion of this course, participants will have the foundation for implementing an enterprise-wide data warehousing solution using Oracle Warehouse Builder (OWB). Participants will create and maintain OWB Metadata Repository, Runtime, and Target Warehouse environments using OWB client tools.

This course is an intensive and comprehensive introduction to most components of OWB. For advanced topics such as Data Quality, Scripting, and OLAP Integration, these courses are available in the OU Online Library. While the course is taught using Oracle9i Warehouse Builder and Oracle 9i database, it fully covers all of the features and functionality of the latest Oracle Warehouse Builder 10g that runs on the Oracle 10g database.

This technical, three day hands-on course teaches students how to use the new features of OLAP including deriving critical information from data in Oracle9i. This includes designing and developing OLAP applications and utilizing the different ways of accessing the data.

In addition, tasks for administering the OLAP database including user accessibility, storage concepts and performance monitoring is discussed.

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.

In this course, students learn how to design and build a variety of standard and custom Web and paper reports using Oracle Reports Developer. Working in the declarative environment of Reports Builder, students learn how to retrieve, display, and format data from any data source in numerous reporting styles and publish the output to any destination.

During the course, students learn how to add dynamic content to a static Web page and publish reports to the Web. Students also learn how to customize more complex reports, embed graphical charts, and use OracleAS Reports Services to deploy your reports.