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.

The goal of this course is to teach Database Administrators how to install the Oracle Database 11g software and perform the tasks required to manage an Oracle database. Enterprise Manager is used throughout to teach students how to quickly accomplish the required task. Emphasis is on the self-managing capabilities and automatic features of Oracle Database 11g. This course is targeted towards Database Administrators of small to medium sized businesses.

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.

In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios. Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices.

Although change can bring improvement, it also can produce disruption. This course focuses on Oracle Database 11g Release 1 innovations that enable you to mitigate the chaos that database and application upgrades can cause. You learn about planned features you can use to record production workloads and then play them back in a test environment so that you can determine and eliminate potential issues before deploying changes to your production environment. The instructor lecture is supported by recorded product demonstrations. By attending this course, you can more effectively realize the positive benefits of database and application upgrades while minimizing the negative side effects.

In this course, you are introduced to the planned key new capabilities of Oracle Database 11g Release 1 and gain an understanding of how to take advantage of them. Topic areas covered include new features for managing storage, ensuring high availability, improving scalability and performance, strengthening security, and managing data warehouses. The instructor lecture is supported by recorded product demonstrations. By attending this course, you can more effectively plan your use of Oracle Database 11g Release 1.

This course is for informational purposes only and is intended solely to assist you in planning for the implementation and upgrade of the product features described. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this course remain at the sole discretion of Oracle.

This course gives students the opportunity to learn about-and practice with the new change management features and other key enhancements in Oracle Database 11g Release 1. Students examine the benefits and use of the new features in managing change, diagnosing and recovering from problems, ensuring high availability, improving scalability and performance, strengthening security, and several other areas that concern database administrators. In addition, the hands-on practice sessions help reinforce students understanding of these new capabilities in Oracle Database 11g Release 1.

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.

This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.

The goal of this course is to teach Database Administrators how to install the Oracle Database 10g software and perform the tasks required to manage an Oracle database. Enterprise Manager is used throughout to teach students how to quickly accomplish the required tasks. Emphasis is on the self-managing capabilities and automatic features of Oracle Database 10g. This course is targeted towards Database Administrators of small to medium sized businesses.

This course introduces students to the new features in Oracle Database 10g - the database for Grid computing. Students learn how to use Oracle Database 10g new features to increase database availability, to simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. The course also covers security and some development platform changes that students need to understand if applications running in databases support the related features. Hands-on practice sessions give students an opportunity to examine many of the new features for themselves.

This seminar will give participants an overview of various new features and enhancements included in Oracle Database 10g, the new release of the Oracle Database. The seminar lessons cover the following focus areas: manageability, high availability, performance, development platform, business intelligence, and data warehousing.

Note: This is a bundled event containing the two 1-day seminars, Oracle Database 10g: New Manageability Features and Oracle Database 10g: New Performance and Availability Features.

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.

This seminar will give participants an overview of the manageability features and enhancements included in Oracle Database 10g, the new release of the Oracle Database. Although this seminar will not give an exhaustive overview of all new features of the Oracle Database 10g, manageability is definitely the most important focus area of this new release, and probably the most interesting one for database administrators.

This course is designed to introduce the participants to Oracle HTML DB. The course provides an overview of the architecture and the user roles in Oracle HTML DB. The course covers the steps to develop a database-centric Web application using Oracle HTML DB components. The student learns how to set and clear session states and administers Oracle HTML DB workspace.

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.

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.

This course introduces students to Oracle Enterprise Manager 10g Grid Control. Students learn how to use Grid Control to install the management agent, configure administrators and groups, manage targets and jobs and establish security of the environment. Hands-on practice sessions give students an opportunity to examine many of the Grid Control capabilities for themselves.

This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 1 for Oracle Real Application Clusters (RAC).

Students learn how to configure and administer a database for use with Real Application Clusters. The course also explains how to setup and use Automatic Storage Management (ASM) in a Real Application Clusters environment. Lectures are reinforced with hands-on practices designed to walk the student through the RAC administration.

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 CD-ROM course is designed for the SQL Server DBA preparing to migrate to Oracle Database 10g. Students gain a conceptual understanding of the Oracle database architecture, design, and implementation through a compare and contrast approach. In class, participants apply best practice guidelines to plan for and perform the migration using Oracle Migration Workbench. The CD-ROM course also covers performing common database administration tasks in the Oracle database after the migration. The lesson topics are reinforced with structured hands-on practices.

If you're using a variety of technologies to share and propagate data, events, and messages, it's time to simplify with the help of the powerful and flexible information-sharing feature called Oracle Streams. This course introduces you to Oracle Streams, which allows you to share data, messages, and events between schemas, applications, and databases. The lessons are designed to give you practical experience in configuring and managing a Streams environment. The course includes lessons on the fundamental components of Oracle Streams and how to administer each of these components. Also included are best practice guidelines and troubleshooting practices.

This course introduces students to the new features of Oracle Database 10g and Oracle9i Database. Detailed information on upgrading from Oracle8i to Oracle Database 10g is included. In this course, Database Administrators learn how to perform typical tasks using the new features available with Oracle Database 10g including many of the Advisors. Students learn how to use features to increase database availability, simplify database management, and improve performance.

Hands-on practice sessions provide students with an opportunity to upgrade an Oracle8i database to Oracle Database 10g and use many of the new features.

• Upgrade from 8i to 10g
• Manage the database using Enterprise Manager
• Use Advisors to proactivley manage the database

This course is designed to give the Database Administrator a firm understanding of the components required to successfully deploy an Oracle9i Database on Linux. Students will learn how to configure the Linux operating system for optimal performance with an Oracle9i database. Then they will install and create an Oracle9i database on Linux. The students will also learn how to tune the Oracle9i database to take advantage of the Linux operating system and the Enterprise level feaures of the OS. Basic administration OS tasks as they relate to the database will also be covered; file system choices, automated startup and shutdown scripts, network configuration, customizing the database for Linux, and configuring Oracle Enterprise Manager. Lectures are reinforced with hands-on practices designed to walk the student through the entire installation, tuning and configuration process.

After completing this course, you will know the resources and techniques required for the successful operation of an Oracle database on Windows 2000. The course covers those aspects of database administration that are intimately related to the operating system; installing the Oracle software, creating the database, monitoring the database, and tuning the database.

This course introduces participants to the critical task of planning and implementing database backup and recovery strategies. The class addresses backup and recovery techniques and examines various backup, failure, restore, and recovery scenarios.In hands-on exercises participants examine backup methodologies based on business requirements in a mission critical enterprise. Participants utilize multiple strategies and Oracle tools such as Recovery Manager to perform backups, and restore and recovery operations.

This class includes a one-day interactive workshop that provides participants with the opportunity to walk through numerous real-world backup, restore and recovery case studies. Participants have the opportunity to apply some of the more advanced techniques within a workshop environment. In addition to lecture and hands-on learning, this class addresses answers to frequently asked questions concerning backup and recovery received by Oracle Worldwide Support.

Develop your ability to manage the industry's most advanced information system. Learn several methods to backup and to recover your Oracle database. Hands-on workshops give you experience in a realistic technical environment. Develop skills for basic network administration. Simplify your duties with Oracle Recovery Manager. This course gives the Oracle database administrator (DBA) a firm foundation in Oracle Net administration and backup and recovery operations.

Students learn about transporting data between databases and the utilities used to perform these activities. Students are also introduced to networking concepts and configuration parameters, as well as how to solve some common network problems. In hands-on exercises, students configure network parameters so that database clients and tools can communicate with the Oracle database server.

This course also addresses backup and recovery techniques, and examines various backup, failure, restore and recovery scenarios. Students also examine backup methodologies based on business requirements in a mission critical enterprise. Students use multiple strategies and Oracle Recovery Manager to perform backups, and restore and recovery operations. This course includes two interactive workshops that provide participants with the opportunity to walk through numerous real-world networking, backup, and recovery case studies.

This class will cover Oracle9i and Oracle9i Release 2 features. Database performance tuning is critical to any effective information system. Reducing wait times, increasing users' productivity and maximizing the performance of your Oracle database are critical to success. Learn from the experts the value of intelligent database design and methods for tuning an Oracle database for maximum performance.

This course will introduce participants to the importance of good initial database design, and the method used to tune a production Oracle9i database. The focus is on Database and Instance tuning rather than specific operating system performance issues. Participants will gain practical experience tuning an Oracle database. Using the available Oracle tools, such as Oracle Enterprise Manager (with the Diagnostics and Tuning Packs) and STATSPACK participants also learn how to recognize, troubleshoot and resolve common performance related problems in administering an Oracle database.

This course is taught on Oracle9i Release 2. This course introduces students to the new features in Oracle9i that impact database administration. Students learn how to use Oracle9i capabilities to increase database availability, to simplify database performance monitoring and tuning, and to improve database manageability. The course also covers security and development platform changes that students need to understand if applications running in databases they support use the related features. Hands-on practice sessions give students an opportunity to examine many of the new features for themselves.

Oracle DBAs manage the industry's most advanced information systems and command some of the highest salaries. This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database tasks. In this class, you'll learn how to design, create, and maintain an Oracle database.

Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam: Exam #1Z0-031.

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 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 taught on Oracle9i Release 2. Upon completion of the course, participants are able to deploy Oracle Enterprise Manager and effectively use the tool to administer and monitor the Oracle Database and Operating System. During this class participants learn the Oracle Enterprise Manager architecture, setup the console, use a variety of integrated applications, learn about reports, implement job- and event-based system management.

This enables participants to administer and monitor the Oracle platform from a single, integrated, GUI, and easy-to-use console. Standalone, three-tier, and browser-based configurations are discussed in this course.

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.

The Oracle9i Implement Advanced Queuing is an instructor led training that equips the participants to setup and administer Oracle9i Advanced Queuing (AQ). The course comprises of lecture, practices, and discussions covering the following topics: Setting up and using Advanced queuing, Enqueue and Dequeue messages using different options, Message Propagation across queues, Over Oracle Network protocol, Over HTTP / HTTP(S), Message transformation, Centralized Administration using the Oracle Enterprise Manager, JMS features and enhancements in Oracle9i Advanced Queuing, Tuning and troubleshooting AQ.

During this course the students will learn how to use Oracle Data Guard to help protect their Oracle Database against planned and unplanned downtimes. The Data Guard architecture will be explained to students as well as the setup of both physical and logical standby databases. In addition the course will examine the performance implications of using Data Guard, and offer some troubleshooting tips.

In this course, the student learns about security concepts, security risks, solutions and how to implement a security policy to secure their database using the Oracle Database features that enhance security.

In a distributed environment, the availability of replicated data at multiple sites is crucial to the success of the business. This course introduces you to the Oracle replication facility to increase the availability of data at multiple locations. The lessons are designed to give the student practical experience in understanding and creating a multimaster replication system with materialized views. It includes lessons on the fundamental components of a replication system and how to administer these component

This course is offered on Oracle9i Release 2. If high availability and scalability are important to your organization, take advantage of the capabilities of Oracle Real Application Clusters. In this hands-on course you learn to configure and manage Real Application cluster database environment and learn how RAC delivers Scalability to your organization.

Develop skills to configure, backup, recover, monitor, and tune database components optimally for RAC.This course introduces the student to the general features and capabilities of Oracle9i Real Application Clusters. It helps the student decide when Real Application Clusters is the best solution to a specific problem.

The course allows students to configure a database for use with Real Application Clusters and covers specific design issues for different types of application and characteristics. It also introduces backup and recovery issues specific to Real Application Clusters. Further, the course provides the students with information on how to monitor and tune the database components having specific relevance to Real Application Clusters.

This course is taught on Oracle9i Release 2. The purpose of this course is to teach students how to model and create tables with spatial data, index spatial data, and discuss how to spatially enable applications. Students learn about Oracle's native data type for spatial data (SDO_GEOMETRY) and the geometric primitives it supports. Additionally, students will learn how to load spatial data into Oracle with various Oracle utilities. Students will learn how to appropriately create spatial indexes for optimal performance. Students will also learn how to query spatial data and perform spatial analysis with spatial operators, functions, and procedures. Additional topics include Oracle Spatial's Linear Referencing System (LRS), coordinate systems support in Oracle Spatial, function-based and partitioned indexes with Oracle Spatial, and publishing maps to the web with Oracle9iAS MapViewer.

This course covers in depth the management of table and index partitioning in the Oracle RDBMS. This includes purpose, administration and syntax of commands. Design and performance issues are mentioned. This course is an immediate prerequisite to the course D13289GC10 Oracle9i: Data Warehouse Administration. These two courses can be taken in the same week.

While this course is complete and is targeted at a larger audience, some detail of partitioning performance is deferred to the Data Warehouse course.

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.

In this course, the features of Oracle Net Services which ease the complexities of network configuration and management will be explored. Oracle Net Directory Naming will be discussed in detail and students will learn how to migrate from a Local Naming Configuration and Oracle Names to Directory Naming. Additional scalability features of Oracle Net Services such as Connection Pooling and Session Multiplexing with Oracle Connection Manager will be covered. Students will learn tuning and troubleshooting techniques, including the use of the Trace Assistant.

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.

The OCM is the highest level of credential an Oracle professional can earn in the Oracle Certification Program. An Oracle9i Database Administrator Certified Master is a top-level Oracle expert who has in depth technical knowledge of the Oracle data server and industry experience managing mission critical Oracle database systems and applications. An Oracle Certified Master is looked upon as an expert within their organization, amongst their peers and across the industry.

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 you to Oracle Streams, a new feature in Oracle9i Database Release 2. Oracle Streams enables the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another. The stream routes published information to subscribed destinations. Oracle Streams provides greater functionality and flexibility than traditional solutions for capturing and managing events and sharing the events with other databases and applications. The lessons in this course are designed to give the student practical experience in understanding how Streams works and in creating a Streams environment. It includes lessons on the fundamental components of Oracle Streams and how to administer each of these components.

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 is designed to give the student a firm foundation in the tasks that are required to implement an Oracle server application. Its primary goal is to provide the student with the knowledge and skills needed to design and manage the data structures that support Oracle database applications. Students gain a conceptual understanding of the Oracle database server architecture and SQL statement processing, and learn how to organize and create tables and related storage structures in the database. On completion of this course, the students will know how to use and design a schema, load and extract data from the database, enforce business rules with constraints, and develop multilanguage applications.

This inClass introduces the student to data mining using Oracle Data Mining for Java (DM4J). This course explains the steps for creating data mining models as well as viewing the data mining results by using the ODM Components and the ODM Browser of the DM4J tool. At the end of the course, students build a data mining model, test the model, and use the model with new data, using DM4J.

This course should provide the student with a working knowledge of the components required to sucessfully configure Oracle Real Application Clusters on the Linux platform. After completing the course, the student should be able to implement RAC on Linux using either native raw devices or the Oracle Cluster File System.

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.

In this course participants learn about Recovery Manager and use it to perform backup, restore, and recovery operations. In addition, students will learn how to troubleshoot RMAN and related components, the media manager, and operating system errors related to RMAN backup and recovery operations.

This series of highly technical seminars where developed by Oracle University in cooperation with Oracle Worldwide Customer Support to provide the customer an advanced in-depth look into the Database Internals. This seminar series goes far beyond the level of the regular Oracle DBA classes and is designed for an experienced audience. Students learn to use events in diagnosing Oracle problems and to distinguish between hang, loop, and crash situations. In addition, students learn to dump Oracle blocks at the Operating System (binary dumps), to dump and interpret Oracle-formatted block dumps, and to recover from Oracle block corruptions. Students learn what to do with block corruptions occurring in rollback segments. Students will gain in-depth knowledge of the internal storage of Oracle9i data types that are used in defining database structures. The implementation and internal structure of large objects, collections, and user-defined data types will be discussed. Students will gain an understanding of the space allocation algorithms for free list and automatic space managed segments. The internal structures of the different segment types will be discussed, relating the components to the functioning of a transaction. With this understanding, the student will be better placed to perform realtime diagnostics, and be better versed in the internal implementation of Oracle's transaction processing. Attending this seminar series will result in a significant gain of insight about the internals of the Oracle server, minimizing support calls and problem resolution turnaround time. It is a must for each experienced Oracle database administrator (DBA).

This one day seminar introduces the student to the Statspack utility as a means of capturing performance related statistics. You will learn how to configure Statspack for statistical collection, and interpret statistical reports. The Statspack report components are explained in detail. You will be introduced to latching and database architecture structures with respect to the interpretation of the generated Statspack reports. Multiple Statspack "real-life" case studies will be interpreted and performance recommendations made.

This course is designed to prepare students to successfully pass the Oracle 9i OCP Upgrade Exam. It is intended for students who have already completed the Oracle 9i New Features for Administrators course, or have equivalent Oracle 9i job experience. Students attending this course who are already knowledgeable about Oracle 9i will be prepared for the OCP exam through an in-depth review of the features that are new to Oracle when upgrading from release 8i to9i. Instructor demonstrations of key testing topics will be combined with a refresher of the major new features of 9i in order to enhance the student's readiness for the OCP exam. On the afternoon of the second day of the event, the 9i New Features for Administrators OCP exam will be administered as part of the class.

This course is designed for the SQL Server DBA preparing to migrate to Oracle9i. This class will cover the following topics: Oracle 9i Architecture, Data Dictionary, Administration, Storage structures, physical and Logical structures, Managing Undo Data, Loading data into an Oracle database, Migration Strategies, and an Introduction the Oracle Migration workbench. The topics and content covered are sufficient to prepare one for SQL Server migration to Oracle while also allowing the student to continue their Oracle education with the follow up course Oracle9i DBA Fundamentals II.