In this course students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students learn to control privileges at the object and system level.

This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database. This course discusses how to use the regular expression support in SQL.

In this course, students use Oracle SQL Developer as the main development tool. SQL*Plus is introduced as an optional development tool.

In this course students learn new features of SQL and PL/SQL in Oracle Database 11g. This course introduces you to the SQL Developer tool, using which you learn various enhancements in language functionality and triggers.

Students learn to practice the language usability enhancements and utilize the performance improvement features such as in lining and flashback, code trigger enhancements to achieve more control over the triggers. Enhancements to the dynamic SQL features are also discussed in this course. Students also learn about the reengineered LOB data type that offers advanced, next-generation functionality such as intelligent compression and transparent encryption.

Additionally, students explore the data warehousing usability enhancements with the new SQL PIVOT and UNPIVOT operators.

This course introduces students to PL/SQL and explains the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students also learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. Students learn about declaring identifiers and trapping exceptions. Demonstrations and hands-on practice reinforce the fundamental concepts.

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions.

Students learn to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions. Students are introduced to the utilization of some of the Oracle-supplied packages.

Students use Oracle SQL Developer to develop these program units. SQL*Plus and JDeveloper are introduced as optional tools.

This course is designed for application developers with basic SQL language skills. In this course, students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. Students also learn to create and query external tables and use the advanced features of SQL to query and manipulate data within the database.

Students learn to use the dictionary views to retrieve metadata and create reports about their schema objects. Students learn some of the date time functions available in the Oracle 11g Database and use the regular expression support in SQL. In this course, students use Oracle SQL Developer as the main tool and SQL*Plus is introduced as an optional tool.

This course is designed for developers with basic PL/SQL and SQL language skills. Students learn to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage, PL/SQL subprograms and triggers. Students are introduced to the utilization of some of the Oracle-supplied packages. Additionally students learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler and manage dependencies. In this course, students use Oracle SQL Developer as the main tool and SQL*Plus is introduced as an optional tool.

This course introduces students to the fundamentals of SQL using Oracle Database 11g database technology. In this course students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. The students also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts. In this course, students use Oracle SQL Developer as the main tool and SQL*Plus is introduced as an optional tool.

This class is applicable to Oracle 9iAS Discoverer users.

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 class is applicable to Oracle 9iAS Discoverer users.

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.

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.

Students learn to create anonymous PL/SQL blocks, stored procedures, and functions. They learn about declaring variables and trapping exceptions. Students will also learn to develop stored procedures, functions, packages and database triggers. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. Students use iSQL*Plus to develop these program units. Demonstrations and hands-on practice reinforce the fundamental concepts.

This course introduces Oracle Database 10g technology and the relational database concepts and the powerful SQL programming language. This course provides the learners with the essential SQL skills of querying the database, the meta data and creating database objects.

In addition, the course also delves into the advanced querying and reporting techniques, data warehousing concepts and manipulating large data sets in different time zones.

In this course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, extended interface methods, and collections, students learn how to write powerful PL/SQL programs. Programming efficiency, use of external C and Java routines, PL/SQL server pages, and fine-grained access are covered.

Developers learn the concepts and essential elements of the Java language. Participants build stand-alone applications, and acquire the foundation skills needed to attend more advanced courses in the curriculum. The development environment used for this course is Oracle JDeveloper 10g Release 3(10.1.3).

In this course, you will build, test and deploy Internet applications with Oracle Forms. Working in a graphical user interface (GUI) environment, you learn how to build forms with user input items such as check boxes, list items, and radio groups. You will also display Form elements in multiple windows and customize data access by creating event-related triggers.

This course is designed to give the experienced SQL Developer or DBA a firm foundation in SQL tuning techniques. The participant learns the necessary knowledge and skills to effectively tune SQL in the Oracle Database 10g. They learn about tuning methodology as well proactive tuning and reactive tuning methods. Students are introduced to the benefits of the new automatic tuning mechanisms available in Oracle Database 10g. On completion of the course they are able to compare and contrast the steps involved to tune manually as in prior releases as well as use the automatic SQL tuning features provided in the current release. Students gain a thorough conceptual understanding of the Oracle Optimizer, and reinforce instructor-led learning with structured hands-on practices. The course uses a series of challenge-level workshops, allowing students to "play, discover, and learn" at their own level and pace. The students learn to use the Oracle diagnostic tools and facilities: Automatic SQL Tuning components, EXPLAIN, SQL Trace and TKPROF, SQL*Plus AUTOTRACE. Students also learn to influence the behavior of the Optimizer by changing the physical schema and modifying SQL statement syntax.

In this course, students who have experience with other ANSI SQL based databases, are introduced to Oracle Database 10g. They learn about the various Oracle Database extensions to the ANSI SQL standard. The course introduces and familiarizes the students with the Oracle Database environment and iSQL *Plus. The students are provided an overview of the basic elements of SQL and taught how to create, combine and manage tables and other database objects. An introduction to optimization of SQL is provided towards the end of the course. Demonstrations and hands-on practice reinforce all that has been taught.

This course teaches the students, how to develop and deploy Web services in Oracle Application Server 10g (10.1.3.0.0). It introduces some of the Web services open industry standards such as SOAP, UDDI, and WSDL.

This course also provides a complete description on securing a Web service, configuring a Web service to support reliable messaging, implement auditing and logging of SOAP messages, and testing a Web service for interoperability. This course is developed by using Oracle Application Server 10g Release 3 (10.1.3.0.0), Oracle Database 10g R2, and JDeveloper 10g Release 3 (10.1.3).

This class uses OracleAS 10g (Release 9.0.4.0.0).OracleAS Portal provides an environment to create 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. Students learn to build portlets running in an Oracle database by applying the OracleAS 10g Portal Developer Kit (PDK) PL/SQL application programming interface (API). Students also learn to make portlets customizable to enable end user personalization as well as how to secure portlets. Students learn to enhance portlet performance by implementing caching and they learn to build multi-lingual portlets.

OracleAS Portal (10.1.4.1) provides an environment for creating enterprise portals, which are corporate gateways to information access and management. Students learn to create, deploy, and test Java-based portlets, the building blocks of a portal page. The course covers two application programming interfaces (APIs): the standard Java portlet API, which supports JSR 168, and the OracleAS Portal Developer Kit Java API, which is Oracle's proprietary portlet API. The course examines the similarities and differences between the two APIs and discusses the benefits and limitations of each approach.

This course covers the use of Entity Relationship Modeling in detail, through many real life examples, practical business problems and solutions. After several iterations, the ER model captures the data requirements and business rules and forms a sound basis for the initial design of a relational database. The second part of the course is about the design process and presents the considerations for creating a normalized, stable, maint ainable and well defined relational database, such as Oracle9i.

As its name suggests, "First Class" is a required course for all new Oracle Designer users. This highly task-based course focuses on the skills that are essential for using Oracle9i Designer to develop application systems with emphasis on the flow of information through the repository, and the default behavior of the Oracle9i Designer tool set. Following a streamlined path through the Designer development environment, students gain hands-on experience of recording business requirements into the Repository, transforming the analysis model into design level definitions, refining the data and application designs, and generating database objects and simple Oracle Forms and Web PL/SQL applications. A single, small-scale Designer project forms the basis for all hands-on practice exercise.

This course focuses on using Oracle Designer 6i to document the requirements for a business system. Using the various modeling tools, participants learn how to specify the information, functional and process needs through a series of models. The models are then cross-checked against each other to gain the complete picture of the requirements. Participants also learn to use the reporting capability of Oracle Designer 6i to quality check their work. The course emphasizes the need for thorough analysis in order to maximise the design and generation capabilities of Oracle Designer 6i, and examples of best practice, both in terms of using the tool and implementing the technique, will be highlighted. This course is essential for anyone who will use Oracle Designer 6i during the requirements definition phase of a project.

This course teaches the skills needed to exploit the extensive server design and generation capabilities of Designer release 6i. The course first focuses on the essential skills for using Oracle Designer to create, refine and implement efficient Online Transaction Processing (OLTP) database designs. Using the development environment provided by the Design Editor, students perform essential design tasks such as denormalization, adding check constraints, database triggers, PL/SQL code and Table API. The course then goes on to show how you can implement Oracle8i database objects with Designer - in particular server-side Java objects that enable you to create globally scalable internet applications.

This course is essential for anyone who will use Oracle9i Designer to design and generate Form applications for the Internet. Class exercises guide students in systems design through the Design Editor. Students learn to streamline the development process by working more productively, using reusable module components, object libraries, and named preference sets. A workshop project helps students consolidate key concepts as they add custom code to their applications using the development environment provided jointly by Oracle9i Designer and Oracle9i Forms.

The Web PL/SQL Generator component of Oracle9i Designer automates the development of Web-based applications that retrieve, insert, update, and delete data from an Oracle database. This course gives students an in-depth introduction to all aspects of Web PL/SQL application design, generation, and deployment. Students begin by exploring the structure of a generated application in detail, focusing on source and result. Then, through extensive hands-on exercises, they gain confidence using the Design Editor and Web PL/SQL Generator to produce fully functional Web-based applications.

• establish and maintain the developers workspace
• perform fine grain versioning
• maintain filesystem files
• analyze dependencies between objects
• support the product release process
• support simultaneous changes to objects The features of the tool are explained within the context of a software configuration management (SCM) method to teach students when and for what purpose the features of the tool are used. In addition, a case study is used throughout the lesson practices giving the students a real-world example of how to use the features of Oracle Repository. Throughout this course students use the Repository Object Navigator (RON) and the Repository Administration Utility (RAU) to perform the practices

This course covers the complete object-oriented development process, teaching students how to identify and model user requirements, and then to progress this model through design to prepare for implementation. The terminology and notation of the Unified Modeling Language (UML) are used throughout.

This course is designed for applications developers, systems analysts, database administrators, and technical support professionals who are experienced with SQL and iSQL*Plus. In this course, students learn to retrieve data using advanced techniques such as ROLLUP, CUBE, SET operators, and hierarchical retrieval. The course covers concepts about multi-table inserts, GROUPING WITH SETS, and the WITH clause. Students learn to write advanced subqueries that involve multicolumn subqueries and scalar subqueries. This course addresses the new single row functions introduced in Oracle9i. It focuses on the DATETIME functions and the functions to handle null values. Demonstrations and hands-on practice reinforce the fundamental concepts.

This course teaches you to develop and deploy Internet applications using Oracle9i Forms. Working in a rapid development environment, participants learn how to customize forms through user input items and how to control data access by creating event-related triggers. In this practical course, you also learn how to test and debug your Web applications through the Forms environment.

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.

Learn about Oracle's rapid application development tool for interactive Internet applications (Oracle Forms 6i), featuring rich, desktop-style, user interfaces. Create a single forms module and deploy it on the web or client/server with no changes to the module. This is the development tool used by Oracle Applications. Learn how to implement it within your enterprise.

In this course students build and test interactive Internet applications. Working in a graphical user interface (GUI) environment, students learn to customize Forms with user input items such as check boxes, list items, and radio groups. They also learn to modify data access by creating event-related triggers.

In this course students broaden their application building skills using Oracle Forms (6i) Developer, a productive development environment for building enterprise-class Internet database applications. Students create multiple-form Internet applications and learn to manage multiple transactions across modules. By adding custom menus, reports, and charts they also learn to enhance their applications. Finally, the course teaches students to enhance the user interface for Web-deployed forms using Java Beans.

If you are a tech support professional, database administrator designer or application developer looking to broaden your your skills--and career options--this five-day course will put you on the path to building and running (both in client-server and on the Web) a variety of standard and custom reports using Oracle Reports 6i.

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.

This class is applicable to Oracle9i and Oracle8i users. This course offers students an extensive introduction to data server technology.The class covers the concepts of both relational and object relational databases and the powerful SQL programming language.

Students are taught to create and maintain database objects and to store, retrieve, and manipulate data. Students learn to retrieve data by using advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval.

They also learn to write SQL and SQL*Plus script files using the iSQL*Plus tool to generate report-like output.Demonstrations and hands-on practice reinforce the fundamental concepts.

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create procedures, functions, packages, and database triggers.

Students use iSQL*Plus to develop these program units. Students also learn to manage PL/SQL program units and database triggers, to manage dependencies, to manipulate large objects, and to use some of the Oracle-supplied packages.

In this course, students are presented with the basic concepts, fundamental issues, and techniques for the design of a data warehouse or data mart. Students examine all phases and tasks of the data warehouse design process, including business modeling, entity relationship diagramming, dimensional modeling, physical modeling, and warehouse meta data management. Participants use a case study to apply these concepts and methods. Group discussions and practices are included.

In this course, students learn about the new features of Oracle9i that are relevant to application developers. The lessons provide detailed information on database features and structural changes that are relevant to any programming or application environment students are using. This course primarily contains information on the changes in SQL and PL/SQL, and the enhancements to Object technology. It also covers changes to the Java and XML capabilities of the Oracle database. Administrative features related to performance, security, data warehousing, and globalization are studied from a developer perspective.

This course is designed to give the student a firm foundation in the art of SQL tuning. The participant learns the necessary knowledge and skills to effectively tune SQL against the Oracle9i Server. Students gain a thorough conceptual understanding of the Rule-Based and Cost-Based Optimizer. The course uses a series of challenge-level workshops, allowing students to "play, discover, and learn" at their own level and pace. The students learn to use the Oracle diagnostic tools and facilities: EXPLAIN, SQL Trace and TKPROF, SQL*Plus AUTOTRACE. Students also learn to influence the behavior of the Optimizer by changing the physical schema and modifying SQL statement syntax.

This course teaches participants how to develop J2EE-compliant applications using Business Components for Java (BC4J). Participants learn the benefits of using business components, how to build them using Oracle9i JDeveloper, how to customize business component applications, and how to create various client types. In addition, the course shows you how to deploy your applications to Oracle9iAS Containers for J2EE (OC4J).

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.

This course uses Oracle9iAS (Release 2). This course introduces PL/SQL programmers to features of Oracle9i Application Server for building dynamic Web applications that access an Oracle database. The course introduces the concepts of Web-enabling Oracle databases by using the PL/SQL Gateway and PL/SQL Server Pages. Participants will use the PL/SQL Web Toolkit to build dynamic, data-driven Web pages.

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.

In this course, students learn about relational principles of an Oracle database. The class also covers how to query data and how to use iSQL*Plus to format query output.

This class is applicable to Oracle9i and Oracle8i users. In this course students gain an understanding of Oracle's relational and object relational database management systems through the powerful SQL language. The SQL commands, functions, and operators supported by Oracle as extensions to standard SQL are emphasized. Students learn to create and maintain database objects such as tables, indexes, views, constraints, and sequences. Students also learn to store, retrieve by using advanced techniques such as grouping sets, SET operators, and hierarchical retrieval, and manipulate data. They also learn to write SQL script files using iSQL*Plus tool, and to generate report-like output. Demonstrations and hands on practices reinforce the fundamental concepts.

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 course teaches participants how to develop Java code for Oracle9i database interaction. Topics include JDBC and SQLJ for database access with Java, and development of Java stored procedures in Oracle9i. In addition to command-line work, participants also use Oracle9i JDeveloper to aid the creation and deployment of Java code.

In this course, students will learn how to create an analytic workspace to perform multidimensional analysis. Students create and populate the elements in an analytic workspace using the OLAP Worksheet tool and the OLAP DML language, and populate elements from data stored in relational tables. They explore online analytical processing functionality, including how to aggregate and allocate data, create custom elements, work with subsets, and use the built-in functions to analyze data.

This course teaches experienced Release 6i Forms users how to migrate to Oracle9i Forms and utilize its new features to provide effective Internet applications. In this practical course, you will migrate forms from earlier releases, and then enhance the application using new features of Oracle9i Forms Developer.

In this course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of packages, cursors, extended interface methods, and advanced object types, students learn how to write powerful PL/SQL programs. Programming efficiency, use of external C and Java routines, PL/SQL server pages, email interface and fine-grained access are covered.

This course introduces the student to the basics of XML. The students learn what is XML , why it is useful, what are the different parts of an XML document and how to create an XML document using JDeveloper. They learn how to format it using XML Stylesheet Language for Transformations (XSLT). The student also validates their XML document using Document Type Definition (DTD) and XML Schema. The students learn about using XPath expressions and XML Namespaces. In addition the student is introduced to the support for XML offered in various Oracle products such as the Oracle9i Release 2 database, XML Developers Kit, JDeveloper and XSQL pages. They learn how to format, query, validate and store their XML documents using these Oracle products.

This course introduces students to Web services and some of the open industry standards such as SOAP, UDDI, and WSDL. This course also discusses the J2EE specification and provides an overview of Enterprise Java Beans. Students will learn how to develop and deploy Web services using standalone OC4J, and how to use Oracle9i JDeveloper, an integrated Java, XML, and Web services environment for developing, debugging, and deploying Web services.

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 teaches students how to use Oracle9iAS TopLink to solve the problem of object persistence in Java applications using relational databases. The course utilizes a series of examples and exercises that illustrate the power of Oracle9iAS TopLink as well exposing the issues inherent in combining object and relational technologies. Students are presented with hands-on exercises that reflect design decisions they will face while developing and delivering Java applications that use relational databases.

In this course, students study the issues involved in planning, designing, building, populating, and maintaining a successful data warehouse. Students learn the reasons why data warehousing is a compelling decision-support solution in today's business climate. During the course, students examine Oracle warehouse technology, and identify the technology available from Oracle Partners for designing, implementing, and running a data warehouse.

This course teaches participants how to develop Java programs. The course focuses on teaching the core Java language (J2SE), including essential object-oriented principles.

In addition to Java, participants learn how to use Oracle9i JDeveloper as an aid to program development. During the course, participants will develop stand-alone applications and Java Web Start web modules, including their generation and testing through Oracle9i JDeveloper's IDE. Participants will also learn the fundamentals of JDBC (Java Database Connectivity). This essential training provides participants with the necessary skills for progressing to other courses in the Java developer curriculum.

This course teaches developers how to create J2EE applications using servlets, JavaServer Pages (JSP), Enterprise JavaBeans (EJB), and Web services. Students learn how to design and develop J2EE applications using Oracle9i JDeveloper and make decisions about when to use the various J2EE components. Additionally, students deploy the applications to Oracle9i Application Server.

This allows for pre-registration in an Oracle Certification Program Exam delivered at an Oracle University Location. Not all OU locations offer certification exams, please verify that a location is accessible to you before registering. Each exam costs the local equivalent of $125 US. Exams are between 90 minutes and 120 minutes depending on the title. Upon arriving for your exam, please notify our OU staff at reception in regards to the exact exam you wish to attempt. The Oracle9i Introduction to SQL exam can be taken online at www.oracle.prometric.com

Get Certified and Get Ahead. Earning your Oracle Certification can increase your value and open up more opportunities for jobs and career growth.

All Exam Topics are listed in Oracle Certification Program Candidate Guides, available on the OCP Global Web Site at www.oracle.com/education/certification