Online Oracle-supplied eLearning - Training Resources
Oracle-supplied Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Oracle9i Database Admin Create a Database

...efits of using stored program units, and the functions of Oracle-supplied packages. Retrieve information about stored objects, identify the common situations when dependent objects may have an INVALID status, and the functions of the control file with the types of information stored. Retrieve control file information, multiplex a control file, and identify the uses of redo log
more...
Oracle PL SQL Database Programming

Course Overview This course is the third in a series of three titles, and discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored
more...
Oracle8i Performance Tuning Architecture Strategy

Course Overview This course is the first in a three-part Oracle8i Performance Tuning series. This interactive course will introduce participants to tools and techniques used to improve the performance of the Oracle8i server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally,
more...
Oracle8i Database Admin Create Databases

...Identify the benefits of stored program units. Match the Oracle-supplied packages with their functions. Retrieve information about invalid objects in a specified database by querying the required data dictionary view. Retrieve information about a stored program unit specification by using the Oracle SQL*Plus Worksheet. Identify the common situations when dependent objects may have an
more...
Oracle8 Database Administration - Create Databases

...Identify the benefits of stored program units.
Match the Oracle-supplied packages with their functions.
Retrieve information about invalid objects in a specified database by querying the required data dictionary view.
Retrieve information about a stored program unit specification by using the Oracle SQL Worksheet.
Identify the common situations when dependent objects may have an invalid
more...
Oracle Database 10g PL SQL Fundamentals Part 1

In this course, the learner will get familiar with the procedural language to access Oracle database. The learner will learn how to write and use anonymous PL/SQL blocks, program constructs, simple and composite PL/SQL data types, programming guidelines, and accessing and manipulating data using PL/SQL. Additionally, the learner will also learn how to write and use PL/SQL program units, such as
more...
Oracle Database 10g PL SQL Fundamentals Part 2

... Identify features of the PL/SQL wrapper utility.
Match Oracle-supplied packages with their uses.
Match procedures provided by the DBMS_OUTPUT package with their features.
Identify features of the UTL_FILE package.
Identify features of the HTP package.
Identify the syntax for sending e-mail messages using the UTL_MAIL package.
Match components of the DBMS_SCHEDULER package with
more...
Oracle Database 10g PL SQL Fundamentals Part 3

...pendencies, manipulate large objects, and use some of the Oracle-supplied packages. The student will also learn about the compilation tools and their options.
Learn To:
Match the stages in the execution of SQL statements with their descriptions.
Identify features of dynamic SQL.
Identify the features of the DBMS_SQL package.
Identify guidelines for standardizing constants and
more...
From Serebra Learning Corporation
Oracle-Supplied Packages and DBMS_SCHEDULER
To use Oracle-supplied packages Database administrators, application developers, and database operators
more...
Advanced Oracle PL/SQL: Implementation and Advanced Features
This course introduces students to advanced interface methods practices and techniques that improve the efficiency and performance of PL/SQL operations. Students also learn about essential Oracle supplied packages that are commonly used in developing applications.
more...
From Software Training Academy, Inc
Oracle 10g Administration

Comprehensive, hands-on class focusing on the day-to-day tasks a DBA will perform to create, maintain and manage an Oracle 10g Database such as security, creating and managing users, creating and managing database objects (tablespaces, tables, indexes, etc.), running utilities, configuring Oracle networking, and simple backup and recovery techniques. Provides an overview of the Oracle Data
more...
