Home > Training Search > O > Oracle SQL > Online eLearning

Online Oracle SQL eLearning

Oracle SQL Training Provider? - Tell us about your Training!
on-line e-learning cbt (computer based)
online course
 instructor led training
instructor-led class
 study at home
learn at home
 group study and discussion
group study
 self directed
self-directed study
 cd rom
cd-based training
 DVD
DVD video training
 book
printed book
 e-book
e-book digital book
 workshop / seminar
workshop seminar
 train the trainer
train the trainer
 computer lab
computer-based learning
 special pricing!
discount pricing
 on-line tutorial)
online tutorial
Oracle SQL Training Seminars and Classes
From 123-CBT Computer Based Training
Oracle Application Server 10g mod_pl sql CGI Scripts and Database Providers on-line e-learning cbt (computer based)cd rom Oracle Application Server 10g: mod_pl sql, CGI Scripts, and Database Providers Oracle To demonstrate how to configure mod_plsql, CGI-script execution, and database providers in OracleAS  more...
Oracle Database 11g PL SQL Variables Attributes and Executable Statements on-line e-learning cbt (computer based)cd rom Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements Oracle To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.  more...
Oracle Database 11g Using DML DDL Cursors Control Structures and Loops on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops Oracle To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.  more...
Oracle Database 11g Using Data Types INDEX BY Tables and Cursors in PL SQL on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL Oracle To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.  more...
Oracle Database 11g Controlling User Access and Managing Schema Objects on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Controlling User Access and Managing Schema Objects Oracle To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.  more...
Oracle Database 11g Data Dictionary Views and Large Data Sets on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Data Dictionary Views and Large Data Sets Oracle To recognize the steps for querying data dictionary views to viewsschema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows.  more...
Oracle Database 11g Managing Data in Different Time Zones on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Managing Data in Different Time Zones Oracle To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.  more...
Introduction to Oracle and SQL in Oracle Database 10g on-line e-learning cbt (computer based)cd rom Introduction to Oracle and SQL in Oracle Database 10g Oracle To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements  more...
SQL Functions in Oracle Database 10g on-line e-learning cbt (computer based)cd rom SQL Functions in Oracle Database 10g Oracle To describe how to use SQL functions for data retrieval  more...
Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g on-line e-learning cbt (computer based)cd rom Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g Oracle To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases  more...
Group and Datetime Functions in Oracle Database 10g on-line e-learning cbt (computer based)cd rom Group and Datetime Functions in Oracle Database 10g Oracle To demonstrate how to use group and datetime functions in Oracle 10g  more...
Subqueries and Hierarchical Queries in Oracle Database 10g on-line e-learning cbt (computer based)cd rom Subqueries and Hierarchical Queries in Oracle Database 10g Oracle To demonstrate how to use subqueries and hierarchical queries in Oracle 10g  more...
Regular Expressions and User Access in Oracle Database 10g on-line e-learning cbt (computer based)cd rom Regular Expressions and User Access in Oracle Database 10g Oracle To demonstrate how to use regular expression support and control user access in Oracle 10g  more...
Creating and Managing Tables and Constraints in Oracle Database 10g on-line e-learning cbt (computer based)cd rom Creating and Managing Tables and Constraints in Oracle Database 10g Oracle To demonstrate how to create and manage tables and constraints in Oracle 10g  more...
Database Objects in Oracle Database 10g on-line e-learning cbt (computer based)cd rom Database Objects in Oracle Database 10g Oracle To demonstrate how to create database views, sequences, indexes, and synonyms  more...
Managing Database Objects in Oracle Database 10g on-line e-learning cbt (computer based)cd rom Managing Database Objects in Oracle Database 10g Oracle To demonstrate how to create external tables and to use the data dictionary views in Oracle 10g  more...
Manipulating Data in Oracle Database 10g on-line e-learning cbt (computer based)cd rom Manipulating Data in Oracle Database 10g Oracle To demonstrate how to modify rows, control database transactions, and manage large data sets and multitable statements  more...
Introduction to PL SQL on-line e-learning cbt (computer based)cd rom Introduction to PL/SQL Oracle To introduce PL/SQL and provide an introduction to identifiers and variables in PL/SQL  more...
Using PL SQL with an Oracle Server on-line e-learning cbt (computer based)cd rom Using PL/SQL with an Oracle Server Oracle To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block  more...
Using Control Structures on-line e-learning cbt (computer based)cd rom Using Control Structures Oracle To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct  more...
Using Composite Data Types on-line e-learning cbt (computer based)cd rom Using Composite Data Types Oracle To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records  more...
Explicit Cursors and Exception Errors on-line e-learning cbt (computer based)cd rom Explicit Cursors and Exception Errors Oracle To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled  more...
Creating Stored Procedures and Functions on-line e-learning cbt (computer based)cd rom Creating Stored Procedures and Functions Oracle To create and execute a stored function and call, and remove and view stored functions in PL/SQL  more...
PL SQL Packages on-line e-learning cbt (computer based)cd rom PL/SQL Packages Oracle To create and work with Oracle 10g packages  more...
Oracle-Supplied Packages and DBMS_SCHEDULER on-line e-learning cbt (computer based)cd rom Oracle-Supplied Packages and DBMS_SCHEDULER Oracle To use Oracle-supplied packages  more...
Managing Dependencies on-line e-learning cbt (computer based)cd rom Managing Dependencies Oracle To manage dependencies and recompile PL/SQL units  more...
Manipulating Large Objects in PL SQL on-line e-learning cbt (computer based)cd rom Manipulating Large Objects in PL/SQL Oracle To use LOBs and the DBMS_LOB package  more...
PL SQL Triggers on-line e-learning cbt (computer based)cd rom PL/SQL Triggers Oracle To create and manage triggers  more...
Dynamic SQL and Metadata on-line e-learning cbt (computer based)cd rom Dynamic SQL and Metadata Oracle To write dynamic SQL and use the DBMS_METADATA package  more...
Oracle Database 10g Database Interfaces on-line e-learning cbt (computer based)cd rom Oracle Database 10g: Database Interfaces Oracle To explain how to use SQL and SQL*Plus to access an Oracle 10g database and introduce other common database interfaces  more...
Oracle Database 10g The SQL Loader and PL SQL on-line e-learning cbt (computer based)cd rom Oracle Database 10g: The SQL*Loader and PL/SQL Oracle To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database  more...
Oracle Database 11g Getting Started with SQL and PL SQL New Features on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Getting Started with SQL and PL/SQL New Features Oracle To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies  more...
Oracle Database 11g Using Dynamic SQL and Implementing Performance Improvements on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Using Dynamic SQL and Implementing Performance Improvements Oracle To recognize the steps for improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL, language enhancements, and a variety of performance enhancements  more...
Oracle Database 11g Using Trigger Data Warehousing and Pivoting Enhancements on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Using Trigger, Data Warehousing, and Pivoting Enhancements Oracle To recognize the steps for improving performance, managing scalabilty, enhancing control and processing speed, and reducing network load using enhanced features such as compound triggers, SecureFile LOBs, and PIVOT operations  more...
Oracle Database 11g Using the PL SQL Debugger Collections and Data Warehousin on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Using the PL/SQL Debugger, Collections, and Data Warehousin Oracle To recognize ways to utilize the PL/SQL Debugger to analyze your code, identify the uses and benefits of collections, and identify the steps for employing data warehousing enhancements to improve query execution times.  more...
Oracle Database 11g Using SQL to Query Your Database on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Using SQL to Query Your Database Oracle To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting, modifying, and formatting this information.  more...
Oracle Database 11g Conversion Functions Group Functions and Joins on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Conversion Functions, Group Functions, and Joins Oracle To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.  more...
Oracle Database 11g Subqueries Set Operators and Data Manipulation on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation Oracle To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.  more...
Oracle Database 11g Using DDL Views Sequences Indexes and Synonyms on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms Oracle To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.  more...
ORACLE DATABASE 11G PL SQL FUNDAMENTALS on-line e-learning cbt (computer based)cd rom ORACLE DATABASE 11G: PL/SQL FUNDAMENTALS Oracle  more...
ORACLE DATABASE 11G SQL FUNDAMENTALS II on-line e-learning cbt (computer based)cd rom ORACLE DATABASE 11G: SQL FUNDAMENTALS II Oracle  more...
ORACLE DATABASE 10g SQL FUNDAMENTALS I II on-line e-learning cbt (computer based)cd rom ORACLE DATABASE 10g: SQL FUNDAMENTALS I & II Oracle  more...
ORACLE DATABASE 10g PROGRAMMING WITH PL SQL I on-line e-learning cbt (computer based)cd rom ORACLE DATABASE 10g: PROGRAMMING WITH PL/SQL I Oracle  more...
ORACLE DATABASE 10g DEVELOPING PL SQL PROGRAM UNITS on-line e-learning cbt (computer based)cd rom ORACLE DATABASE 10g: DEVELOPING PL/SQL PROGRAM UNITS Oracle  more...
Oracle Database 11g R2 Managing Database Memory Performance on-line e-learning cbt (computer based)cd rom Oracle Database 11g R2: Managing Database Memory & Performance Oracle Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must include a balance between performance, cost, and reliability. You must consider the investment in the system architecture, which  more...
ORACLE DATABASE 11g SQL PL SQL NEW FEATURES on-line e-learning cbt (computer based)cd rom ORACLE DATABASE 11g: SQL & PL/SQL NEW FEATURES Oracle  more...
ORACLE DATABASE 11g SQL FUNDAMENTALS I on-line e-learning cbt (computer based)cd rom ORACLE DATABASE 11g: SQL FUNDAMENTALS I Oracle  more...
Oracle Database 11g Subprograms Packages Exception Handling in PL SQL on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Subprograms, Packages & Exception Handling in PL/SQL Oracle To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.  more...
Oracle Database 11g Packages Dynamic SQL Coding Considerations in PL SQL on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Packages, Dynamic SQL & Coding Considerations in PL/SQL Oracle To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.  more...
Oracle Database 11g Using Triggers the PL SQL Compiler Managing Code on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Using Triggers, the PL/SQL Compiler & Managing Code Oracle To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.  more...
Oracle Database 11g Managing PL SQL Code Dependencies on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Managing PL/SQL Code & Dependencies Oracle To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.  more...
ORACLE DATABASE 11G DEVELOP PL SQL PROGRAM UNITS on-line e-learning cbt (computer based)cd rom ORACLE DATABASE 11G: DEVELOP PL/SQL PROGRAM UNITS Oracle  more...
Oracle Database 11g Querying a Database with SQL on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Querying a Database with SQL Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting, modifying, and formatting this information.  more...
Oracle 11g Conversion Funct Conditional Expressions Group Funct Joins on-line e-learning cbt (computer based)cd rom Oracle 11g: Conversion Funct., Conditional Expressions, Group Funct. & Joins Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.  more...
Oracle Database 11g Manipulating Queries Data on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Manipulating Queries & Data Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.  more...
Oracle Database 11g Using DDL Views Schema Objects on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Using DDL, Views & Schema Objects Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.  more...
Oracle Database 11g Controlling User Access Managing Objects on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Controlling User Access & Managing Objects Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.  more...
Oracle Database 11g Managing Data Dictionary Views Large Data Sets on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Managing Data Dictionary Views & Large Data Sets Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for querying data dictionary views to viewsschema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows.  more...
Oracle Database 11g Managing Time Zones Datetime Functions on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Managing Time Zones & Datetime Functions Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.  more...
Oracle Database 11g Suqueries Regular Expressions on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Suqueries & Regular Expressions Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.  more...
1Z0-047 Oracle Database 11g SQL Expert on-line e-learning cbt (computer based)cd rom 1Z0-047 Oracle Database 11g SQL Expert Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert  more...
Oracle Database 11g Getting Started with PL SQL on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Getting Started with PL/SQL Oracle To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.  more...
Oracle Database 11g Using DML DDL Cursors Loops Control Structures on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Using DML, DDL, Cursors, Loops & Control Structures Oracle To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.  more...
Oracle Database 11g Using Data Types INDEX BY Tables Cursors on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Using Data Types, INDEX BY Tables & Cursors Oracle To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.  more...
Oracle Database 11g Using Exceptions Subprograms JDeveloper REF Cursors on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper & REF Cursors Oracle To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables.  more...
Oracle Database 11g Subprograms Packages Exception Handling on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Subprograms, Packages & Exception Handling Oracle To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.  more...
Oracle Database 11g Packages Dynamic SQL Coding Considerations on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Packages, Dynamic SQL & Coding Considerations Oracle To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.  more...
Oracle Database 11g Using Triggers the PL SQL Compiler on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Using Triggers & the PL/SQL Compiler Oracle To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.  more...
Oracle Database 11g PL SQL Code Dependency Management on-line e-learning cbt (computer based)cd rom Oracle Database 11g: PL/SQL Code & Dependency Management Oracle To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.  more...
ORACLE DATABASE 11G PROGRAM WITH PL SQL on-line e-learning cbt (computer based)cd rom ORACLE DATABASE 11G: PROGRAM WITH PL/SQL Oracle  more...
Oracle Database 11g Performance Tuning Methodology Tools on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Performance Tuning Methodology & Tools Oracle Oracle Database 11g provides a variety of tools that can be used for performance tuning in an Oracle database environment. These tools can be used to diagnose and tune common SQL-related and instance-related problems as well as proactively tune an Oracle database. One such tool, Enterprise Manager, can be used to monitor an  more...
Oracle Database 11g Using AWR Defining Problems on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Using AWR & Defining Problems Oracle Automatic Workload Repository (AWR) is the infrastructure that provides services to Oracle Database 11g components that collect, maintain, and utilize statistics for problem detection and self-tuning purposes. This course explains how to create and manage AWR snapshots, and demonstrates how to use the snapshots to generate individual  more...
Oracle Database 11g Problem SQL Statements Oracle Optimizer on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Problem SQL Statements & Oracle Optimizer Oracle Oracle Database 11g helps to identify problem SQL statements using Oracle Optimizer and execution plans. This course discusses SQL statement processing and the role of the Oracle Optimizer and execution plans. It also explains how to generate and view execution plans using the DBMS_XPLAN package, the EXPLAIN PLAN command,  more...
Oracle Database 11g SQL Performance Database Replay on-line e-learning cbt (computer based)cd rom Oracle Database 11g: SQL Performance & Database Replay Oracle Database Replay allows you to test the impact of a system change by replaying a real-world workload on a test system before it is exposed to a production system. This course demonstrates how to use Database Replay to capture and replay workloads to test the impact of a system change. It also explains how to use SQL Performance  more...
Oracle Database 11g Tuning PGA Temporary Space AMM on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Tuning PGA, Temporary Space & AMM Oracle Oracle Database 11g provides various methods for tuning, monitoring and managing memory and temporary tablespaces. Automatic Program Global Area (PGA) memory management adapts the SQL memory allocation based on PGA memory available, SQL operator needs, and system workload. A temporary tablespace is used to store transient data  more...
Oracle Database 11g Segment Space I O and Performance Tuning on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Segment Space, I/O and Performance Tuning Oracle Oracle Database 11g provides various methods for tuning segment space usage and input/output (I/O). This course explains how to use Automatic Segment Space Management (ASSM) to tune segment space usage, how to shrink segments using SQL or the Enterprise Manager, and how to use table compression. Automatic Storage  more...
Oracle Database 11g Architecture SQL Tuning Optimization on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Architecture, SQL Tuning & Optimization Oracle The Oracle Database server consists of an Oracle Database and one or more Oracle Database instances. SQL (Structured Query Language) is the language with which all programs and users access an Oracle Database. Monitoring the performance of and tuning database components, as well as the SQL statements used to access and  more...
Oracle Database 11g Indexes Access Paths and Join Operations on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Indexes, Access Paths and Join Operations Oracle Access paths are the ways in which data is retrieved from the database, and there are a number of different access paths which can be used for tables and indexes. This course explores the access paths used for tables, such as full table, rowid, and sample table scan. It also examines the access paths used for indexes, such  more...
Oracle Database 11g Execution Plans and Star Transformations on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Execution Plans and Star Transformations Oracle An execution plan is the output of the optimizer and is presented to the execution engine for implementation. The execution plan instructs the execution engine about the operations it must perform for retrieving the data required by a query most efficiently. This course explores gathering, displaying, and interpreting  more...
Oracle Database 11g Optimizer Statistics Hints Cursor Sharing on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Optimizer Statistics, Hints & Cursor Sharing Oracle Optimizer statistics describe details about the database and the objects in the database and are used by the query optimizer to select the best execution plan for each SQL statement. This course covers gathering optimizer and system statistics, setting statistic preferences, using dynamic sampling, and manipulating  more...
Oracle Database 11g Application Tracing Automatic SQL Tuning on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Application Tracing & Automatic SQL Tuning Oracle Oracle Database implements tracing by generating a trace file for each server process when you enable the tracing mechanism. This course explores configuring the SQL Trace facility to collect session statistics, using the TRCSESS utility to consolidate SQL trace files, formatting trace files using the tkprof utility, and  more...
ORACLE DATABASE 11G SQL TUNING on-line e-learning cbt (computer based)cd rom ORACLE DATABASE 11G: SQL TUNING Oracle  more...
Oracle Database 11g Firewalls Oracle Connection Manager and SQL Plus Security on-line e-learning cbt (computer based)cd rom Oracle Database 11g: Firewalls, Oracle Connection Manager and SQL*Plus Security Oracle There is no single best architecture for accommodating Internet requests requiring access to corporate intranets. Instead, trade-offs must be made between two competing goals: security of the intranet against an Internet attack and ease of access to services by both Internet and intranet clients. This  more...
Oracle Database 11g R2 ASM Storage Partitioning Enhancements on-line e-learning cbt (computer based)cd rom Oracle Database 11g R2: ASM, Storage & Partitioning Enhancements Oracle Oracle Database 11g Release 2 provides many improvements from its previous releases. This includes enhancements to ASM and storage to improve performance and to reduce server maintenance down time. This course identifies the enhancements in each of these areas. It also demonstrates how to use ASM fast mirror resync,  more...
Oracle Database 11g R2 Using Change Management Solutions on-line e-learning cbt (computer based)cd rom Oracle Database 11g R2: Using Change Management Solutions Oracle Oracle Database 11g Release 2 is designed for data center environments that are rapidly evolving and changing to keep up with business demands, enabling DBAs to manage change effectively and efficiently. Oracle Database 11g Release 2 offers significant advances in the areas of automatic diagnostics, supportability, and change  more...
Oracle Database 11g R2 Intelligent Infrastructure Enhancements on-line e-learning cbt (computer based)cd rom Oracle Database 11g R2: Intelligent Infrastructure Enhancements Oracle Oracle Database 11g Release 2 offers new intelligent infrastructure features to aid DBAs by automatically gathering performance metrics for problem detection and self-tuning purposes. The information gathered can be viewed by the DBA using either reports or views, as well as the alert log. Oracle Database 11g has expanded  more...
Oracle Database 11g R2 Diagnosability Enhancements on-line e-learning cbt (computer based)cd rom Oracle Database 11g R2: Diagnosability Enhancements Oracle Oracle Database 11g Release 2 offers new diagnosability enhancements to help DBAs in diagnosing, resolving, and preventing problems. These new features include enhancements to problem and incident identification, running health checks, and performing repairs on SQL statements. These features enables the DBA to quickly and efficiently  more...
Oracle Database 11g R2 SQL Monitoring Performance Enhancements on-line e-learning cbt (computer based)cd rom Oracle Database 11g R2: SQL Monitoring & Performance Enhancements Oracle Oracle Database 11g Release 2 offers improvements and new features to provide DBAs a better way to monitor SQL commands in real-time and to allow the database to automatically manage its own memory and gather optimizer statistics. These features enable the DBA to ensure the optimal memory sizes are being used for the  more...
Oracle Database 11g R2 Application Performance Enhancements on-line e-learning cbt (computer based)cd rom Oracle Database 11g R2: Application Performance Enhancements Oracle Oracle Database 11g Release 2 offers improved and new features to provide better application performance. It offers online table redefinition, which allows tables to be modified without affecting the availability of the table to users and does not affect any of its dependencies. This allows for easier application changes and  more...
Oracle Database 11g R2 Oracle Scheduler Secure Backup on-line e-learning cbt (computer based)cd rom Oracle Database 11g R2: Oracle Scheduler & Secure Backup Oracle Oracle Database 11g Release 2 offers improvements to Oracle Scheduler that increases efficiency and usability. These include allowing users to get specific email notifications about job activities, triggering jobs to automatically execute when the specified file is received, enabling jobs to run on multiple nodes while managing  more...
Oracle Database 11g R2 Managing Concurrency Undo Auditing on-line e-learning cbt (computer based)cd rom Oracle Database 11g R2: Managing Concurrency, Undo & Auditing Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 Oracle Database 11g Release 2 is designed to prevent multiple users from changing the same data at the same time by implementing locks. These locks are used to manage data concurrency and are implemented  more...
Oracle Database 11g R2 Moving Data Oracle Support on-line e-learning cbt (computer based)cd rom Oracle Database 11g R2: Moving Data & Oracle Support Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 From time to time Oracle DBAs are required to move data. Oracle Database 11g Release 2 offers various ways to complete this task, including Oracle Data Pump, SQL*Loader, and the use of external tables. DBAs are also  more...
Oracle Database 11g Change Management Overview and SQL Plan Management on-line e-learning cbt (computer based) outline the uses of management tools in Oracle Database 11g, such as SQL Performance Analzer, SQL tuning sets, and SQL plan baselines, and outline how you can use them to effectively manage change and execute SQL plans.  more...
Oracle Database 11g Database Replay and Automatic SQL Tuning on-line e-learning cbt (computer based) Explain the benefits and uses of Oracle Database 11g's crucial developer tools, Database Replay and Automatic SQL Tuning, when setting up and testing a database  more...
Oracle Database 11g Partitioning and Storage-Related Enhancements on-line e-learning cbt (computer based) identify the benefits of Oracle Database 11g's partitioning and storage-related enhancements, and recognize how to use SQL Access Advisor to help you optimize your database in this regard.  more...
Oracle Database 11g Diagnostic Enhancements and Using the Data Recovery Advisor on-line e-learning cbt (computer based) recognize the steps for detecting, diagnosing, and repairing critical errors and data failures in Oracle Database 11g, using its enhanced, proactive, diagnostic tools, such as Automatic Diagnostic Repository, Support Workbench, SQL Repair Advisor, and the Data Recovery Advisor.  more...
Oracle Database 11g Managing the Schema Data and Concurrency on-line e-learning cbt (computer based) Identify the steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency  more...
Oracle Database 11g Database Performance and Space Management on-line e-learning cbt (computer based) To identify the steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces.  more...
Introduction to Oracle and SQL in Oracle9i on-line e-learning cbt (computer based) To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements  more...
SQL Functions in Oracle9i on-line e-learning cbt (computer based) To describe how to use SQL functions for data retrieval  more...
Subqueries Reporting and User-Access Control in Oracle9i on-line e-learning cbt (computer based) To describe the use of subqueries, reporting, and user-access control in an Oracle9i database  more...
Defining and Manipulating Data in Oracle9i on-line e-learning cbt (computer based) To describe how to define database objects and manipulate the data stored within them in an Oracle9i database  more...
Oracle Workflow 11i10 Managing Customizing Workflow Processes on-line e-learning cbt (computer based)cd rom This course covers features, types, and attributes of PL/SQL documents. It also covers how to include PL/SQL documents in messages. Further, it covers forced synchronous processes, selector/callback functions, standard API used to define selector/callback functions, and the code to define a selector/callback function. It also covers master/detail coordination activities. In addition, it covers how  more...
Oracle Workflow 11i10 Configuring Oracle Workflow Components on-line e-learning cbt (computer based)cd rom This course covers the mandatory and optional tasks that are performed to set up Oracle Workflow. It also covers features of service components and specific service components including agent listeners and notification mailers. Finally, it covers queue propagation and agent activity details. Learn To: Identify the mandatory steps for setting up Oracle Workflow. Identify options  more...
Oracle Workflow 11i10 Workflow APIs Procedures Error Handling on-line e-learning cbt (computer based)cd rom This course covers Workflow Engine, background engines, PL/SQL procedures, workflow process APIs, Business Event System APIs, and error handling. It also covers abstract data types used by the Business Event System, event data generate functions, queue handlers, and subscription rule functions, and the error-handling features of workflow processes. Learn To: Identify features of the  more...
Oracle Workflow 11i10 Interacting with Processes Notifications on-line e-learning cbt (computer based)cd rom Oracle users and end users with knowledge of Oracle 9i SQL and PL/SQL, navigating Oracle Applications 11i, and Oracle 11i E-Business Essentials for Implementers. Learn To: Identify options for testing a workflow process. Identify options for administering workflow processes by using the Administrator Monitor. Identify options for administering workflow processes by using the  more...
Oracle Workflow 11i10 Business Event System Subscriptions on-line e-learning cbt (computer based)cd rom This course covers business events, event subscriptions, and event activities. It specifies the features and options to define and maintain business events, event subscriptions, and event activities. It also covers several standard activities that help manage the contents of event messages. Learn To: Identify features of business events. Identify options that enable you to define  more...
Oracle Workflow 11i10 Communications Function Activities on-line e-learning cbt (computer based)cd rom This course covers the fundamentals of Oracle Workflow processes. This course covers function activities, activity details, activity attributes, and standard assign activity. You'll learn about Oracle Workflow directory service, local directory service tables, and loading roles in a workflow process definition. The course also covers systems, agents, and external system registration. Finally, it  more...
Oracle Workflow 11i10 Components Planning Workflow Processes on-line e-learning cbt (computer based)cd rom This course covers the benefits of using Oracle Workflow in an e-business environment. It provides an overview of the architecture and components of Oracle Workflow. It also covers the components of a workflow process. Further, it covers the steps to plan a workflow process. It also covers various standard activities. Learn To: Identify benefits of Oracle Workflow. Identify  more...
Oracle Workflow 11i10 Developing Processes on-line e-learning cbt (computer based)cd rom This course covers the steps to diagram and create a workflow process. It also covers the steps to define item types, process activities, item type attributes, lookup types and lookup codes, messages, message attributes, and notifications activities. In addition, it covers the features of item type attributes, notification activities, and embedded regions. Finally, it covers special message  more...
Oracle Database 10g Administration Workshop II Part 3 on-line e-learning cbt (computer based)cd rom This course covers various functions of the Flashback technology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption. Learn To: Identify features of  more...
Oracle Database 10g SQL Fundamentals I Part 2 on-line e-learning cbt (computer based)cd rom In this course, the learner will learn how to use the advanced features of SQL, such as advanced querying and reporting, schema objects, manipulating large data sets, and storing and retrieving dates according to different time zones. The learner will also learn the concepts of controlling access and privileges for schema objects and using advanced subqueries. . Learn To: Identify  more...
Oracle Database 10g PL SQL Fundamentals Curriculum on-line e-learning cbt (computer based)cd rom The Oracle Database 10g: PL/SQL Fundamentals Curriculum includes the following courses: Oracle Database 10g: PL/SQL Fundamentals (Part 1) Oracle Database 10g: PL/SQL Fundamentals (Part 2) Oracle Database 10g: PL/SQL Fundamentals (Part 3) To review individual course descriptions, please return to the previous page and select the desired title(s).  more...
Oracle Database 10g PL SQL Fundamentals Part 1 on-line e-learning cbt (computer based)cd rom 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 SQL Fundamentals I Curriculum on-line e-learning cbt (computer based)cd rom The Oracle Database 10g: SQL Fundamentals I Curriculum includes the following courses: Oracle Database 10g: SQL Fundamentals I (Part 1) Oracle Database 10g: SQL Fundamentals I (Part 2) To review individual course descriptions, please return to the previous page and select the desired title(s).  more...
Oracle Database 10g SQL Fundamentals I Part 1 on-line e-learning cbt (computer based)cd rom In this course, learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Additionally, the learners will be introduced to the powerful SQL programming language and its features. Learn To: Match the different phases of system development life cycle (SDLC) with their features. Identify features of an Entity Relationship  more...
Oracle Database Administration Workshop I Part 2 on-line e-learning cbt (computer based)cd rom Oracle Database 10g is the first database designed for enterprise grid computing, the most flexible and cost-effective way to manage enterprise information. This course covers salient aspects of Oracle Database 10g such as user and data management. The basic aspects of database management such as database integrity constraints, transferring data, and defining tables and schemas has been discussed  more...
Introduction to Data Warehousing on-line e-learning cbt (computer based)cd rom Course Overview This course presents an introduction to Data Warehousing. Beginning with the basic concepts of data warehousing, this course helps you understand the processes involved in and the architecture of data warehousing. The tools involved in analyzing the warehouse data will also be covered. Finally, you'll learn about the Oracle data warehouse. L earn To: Identify the  more...
Oracle SQL Specifics Retrieving and Formatting Data on-line e-learning cbt (computer based)cd rom ...rview This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands, functions, and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will learn  more...
Oracle SQL Specifics Creating and Managing Database Objects on-line e-learning cbt (computer based)cd rom ...view This course is the second in a two-part series on Oracle SQL Specifics that will teach participants how to use commands, functions, and operators supported by Oracle as extensions to standard SQL. Users will learn how to create and manage tables, build integrity constraints, and use the COMMIT and ROLLBACK statements to control transactions. Learners will create and maintain views,  more...
Oracle SQL and SQL Plus Advanced SELECT Statements on-line e-learning cbt (computer based)cd rom Course Overview This course is the first course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition, this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries. L earn To: Write  more...
Oracle SQL and SQL Plus SQL Plus and Reporting on-line e-learning cbt (computer based)cd rom ... part of this series should have been taken, course 60121 Oracle SQL and SQL*Plus: Advanced Select Statements. T otal Learning Time 7 - 8 Hour(s) Course Contents Unit 1: SQL*Plus Duration: 3 Hour(s) Differentiate between SQL and SQL*Plus. Match the SQL*Plus command categories with sample tasks. Write the code to display the column definitions of a given table.  more...
Oracle SQL Tuning Diagnostics and Tuning Schema on-line e-learning cbt (computer based)cd rom Course Overview This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths, such as partitioned views, B-tree indexes, bitmapped indexes, index clusters, and hash  more...
Oracle SQL Tuning Tuning SQL and the Optimizer on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a two-part series on SQL Statement Tuning. This course will help application developers to design SQL statements that can reuse parsing and influence the optimizer to improve performance. L earn To: Identify the factors that affect network traffic. Identify the factors that affect parsing. Identify the guidelines for the reuse  more...
Oracle Form Builder Forms Fundamentals on-line e-learning cbt (computer based)cd rom Course Overview This course is the first in a six-part Oracle Form Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the key features, components, and capabilities of Developer/2000. In addition, this course will help participants learn how to run, create, and customize a form module. L earn To: Identify the key features,  more...
Oracle Form Builder Enhancing the User Interface on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a six-part Oracle Form Builder series based on Oracle Developer/2000 Release 2. This course helps participants learn how to create input and non-input items, and support text items with Lists of Values (LOVs) and editors. Additionally, users will learn to create triggers and add functionality to them. L earn To: Create input and  more...
Oracle Form Builder Writing and Debugging Code on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a six-part Oracle Form Builder series that is based on Oracle Developer/2000 Release 2. This course will help participants learn to create and control alerts, debug PL/SQL code, and process queries. In addition, transaction processing, Form Builder application customization, and writing flexible code will be covered. L earn To: Identify  more...
Oracle Cert App Developer Track for Developer 2000 R2 Curriculum on-line e-learning cbt (computer based)cd rom ...loper/2000 Release 2 consists of the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retreival Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle PL/SQL: Procedures, Functions and Packages (ID#7745) Oracle PL/SQL: Database Programming (ID#7746) Oracle Form Builder: Form Fundamentals (ID#381) Oracle Form  more...
Oracle Form Builder Managing Module Types on-line e-learning cbt (computer based)cd rom Course Overview This course is the fourth in a six-part Oracle Form Builder series that is based on Oracle Developer/2000 Release 2. This course will introduce participants to Project Builder and teach them how to create and manage a menu module. In addition, users will learn how to customize and implement menu security. L earn To: Identify the benefits and terminology of Project  more...
Oracle Form Builder Handling Multiple Object Relationships on-line e-learning cbt (computer based)cd rom Course Overview This course is the fifth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants to learn about Key triggers, write applications that respond to mouse events, manage windows and canvases, and use Object Navigator. In addition, users will work with multiple form applications, record groups, and list items. L  more...
Oracle Form Builder Including Reusable Oracle Components on-line e-learning cbt (computer based)cd rom Course Overview This course is the sixth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants learn how to implement methods to use data sources, and to integrate charts, reports and timers in Forms. In addition, reusing components, objects and code will be taught. Finally, Form Builder's new features will be covered.  more...
Oracle Report Builder Report Fundamentals on-line e-learning cbt (computer based)cd rom Course Overview This course is the first in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the key features of Report Builder, building a standard tabular report, and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate report  more...
Oracle Report Builder Enhancing Reports on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the ways to enhance a report using the Data and Layout Model. In addition, this course will help participants learn how to modify layout objects and enhance matrix reports. L earn To: Enhance a report using the  more...
Oracle Report Builder Controlling Reports on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course helps participants learn how to develop report templates, code PL/SQL triggers in a report, and use Report Builder's built-in package. Finally, building reports for different environments will be covered. L earn To: Identify the regions of  more...
Oracle8 Database Administration - Manage an Instance on-line e-learning cbt (computer based)cd rom Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...
Oracle8 Database Administration - Create Databases on-line e-learning cbt (computer based)cd rom ... Start a specified instance in the NOMOUNT mode by using Oracle SQL Worksheet. Identify the functionality of the CREATE DATABASE command options. Create a database with specified parameter values by using the CREATE DATABASE command. Identify the commonly encountered situations in which the CREATE DATABASE command fails. Identify the contents of a database after its creation.  more...
Oracle8 Certified Database Administrator Curriculum on-line e-learning cbt (computer based)cd rom ...inistrator Curriculum consists of the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle8 Database Administration - Manage an Instance (ID#421) Oracle8 Database Administration - Create Databases (ID#426) Oracle8 Database Administration - Manage Data  more...
Oracle8 Database Administration - Manage Storage Structures on-line e-learning cbt (computer based)cd rom ...ber of extents and blocks allocated to a segment by using Oracle SQL Worksheet. Retrieve the information to view the extents for a given segment by using Oracle SQL Worksheet. Write a query to check the extents for a given segment by using Oracle SQL Worksheet. Unit 2: Managing Rollback Segments Duration: 1 - 2 Hour(s) Identify the purposes of rollback segments. Identify  more...
Oracle8 Performance Tuning Managing Memory and Disk I O on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a three-part Oracle8 Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log  more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student  more...
Oracle Form Builder R6 Forms Fundamentals on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1:  more...
Oracle Form Builder R6 Enhancing the User Interface on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first part of the Oracle  more...
Oracle Form Builder R6 Writing and Debugging Code on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first two parts of the Oracle  more...
Oracle Form Builder R6 Project Builder and Menu Modules on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first three parts of the  more...
Oracle Form Builder R6 Controlling the User Interface Programmatically on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first four parts of the Oracle  more...
Oracle Form Builder R6 Including Reusable Oracle Components on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first five parts of the Oracle  more...
Oracle Reports R6 Report Fundamentals on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). T otal Learning Time 6 - 8 Hour(s) Course Contents  more...
Oracle Reports R6 Enhance Reports on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). In addition, participants should have taken the first part in  more...
Oracle Reports R6 Control Reports on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). In addition, participants should have taken the first two  more...
SQL and PL SQL PL SQL Basics on-line e-learning cbt (computer based)cd rom ...nt to the computer based training (CBT) courses entitled: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus: DML and DDL (61112) and Oracle 8i. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: PL/SQL: An Introduction Duration: 0.5 - 2 Hour(s) Identify the features of PL/SQL. Identify the benefits of PL/SQL. Select the  more...
SQL and PL SQL Basic SELECT on-line e-learning cbt (computer based)cd rom ...ourse Overview This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing  more...
SQL and PL SQL Data Retrieval Techniques on-line e-learning cbt (computer based)cd rom ...icipants should have taken the first part of this series, Oracle SQL: Basic SELECT Statements (61110). This course will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks: Oracle7.3 Certified Database Administrator, Oracle8 Certified Database Administrator, and Oracle Certified Application Developer,  more...
SQL and PL SQL DML and DDL on-line e-learning cbt (computer based)cd rom ...ourse Overview This course is the third in a three-part Oracle SQL series that is based on the Oracle ILT course, Introduction to Oracle: SQL and PL/SQL. Using the Oracle SQL*Plus environment, this computer-based training course uses Structured Query Language (SQL) to create and populate Oracle database tables. Learners create tables and other database objects and learn to maintain and modify  more...
Oracle8i Database Admin Create Databases on-line e-learning cbt (computer based)cd rom ...cal Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311). This course will help candidates prepare for the Oracle8i Certified DBA  more...
Oracle8i Database Admin Manage Storage Structures on-line e-learning cbt (computer based)cd rom ...cal Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312). This course will  more...
Oracle8i Database Admin Manage Data Storage on-line e-learning cbt (computer based)cd rom ...cal Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312) and Oracle8i  more...
Oracle8i Database Admin Manage Security on-line e-learning cbt (computer based)cd rom ...cal Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312). This course will  more...
Oracle8i Performance Tuning Architecture Strategy on-line e-learning cbt (computer based)cd rom 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 Performance Tuning Managing Memory Disk I O on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a three-part Oracle8i Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log  more...
Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a three-part Oracle8i Performance Tuning series. This interactive course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately.  more...
Oracle 11i 2 6 Implement Workflow Fundamentals Part 2 on-line e-learning cbt (computer based)cd rom The course deals with fundamentals Oracle Workflow 2.6, which is provided by Oracle E-Business Suite for Oracle Application 11i. Oracle Workflow enables you to create, modify, and automate business processes. Learn To: Identify features of item type attributes. Define attributes for Oracle Workflow. Identify guidelines for defining lookups. Identify features of Workflow  more...
Oracle 11i 2 6 Implement Workflow Fundamentals Part 3 on-line e-learning cbt (computer based)cd rom The course deals with fundamentals Oracle Workflow 2.6, which is provided by Oracle E-Business Suite for Oracle Application 11i. Oracle Workflow enables you to create, modify and automate business processes. In part 3, you will learn about Activities, Events, and Workflow APIs. Learn To: Identify the steps to define a function activity. Identify tasks to be performed to define  more...
Oracle 11i 2 6 Implement Workflow Fundamentals Part 1 on-line e-learning cbt (computer based)cd rom The course deals with fundamentals of Oracle Workflow 2.6, which is provided by Oracle E-Business Suite for Oracle Application 11i. Oracle Workflow enables you to create, modify and automate business processes. Learn To: Identify features of Workflow-driven business processes. Identify features of business processes integration using Oracle Workflow. Match Oracle Workflow  more...
OCDBA8i Curriculum on-line e-learning cbt (computer based)cd rom ...ete OCDBA8i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics(ID#322) Oracle 8i Backup and Recovery: Strategies & Backups(ID#7486) Oracle 8i Backup and Recovery: Troubleshooting & Recovery(ID#7487) Oracle 8i Database Admin.: Manage an  more...
Oracle Designer 6i Curriculum on-line e-learning cbt (computer based)cd rom The Complete Oracle Designer 6i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements Oracle SQL: Data Retrieval Techniques Oracle SQL: DML & DDL Oracle SQL: PL/SQL: Basics Oracle Designer 6i First Class: Analysis Oracle Designer 6i First Class: Design & Generation To review individual course descriptions, please return to the previous page and select the  more...
Oracle 11i 2 6 Implement Workflow Fundamentals Part 4 on-line e-learning cbt (computer based)cd rom The course deals with fundamentals of Oracle Workflow 2.6, which is provided by Oracle E-Business Suite for Oracle Application 11i. Oracle Workflow enables you to create, modify and automate business processes. In part 4, you will learn about workflow configuration, Workflow Manager, and utilities. Learn To: Identify necessary setup steps for Oracle Workflow. Identify issues  more...
Oracle Database 10g Administration Workshop II Part 1 on-line e-learning cbt (computer based)cd rom This course will teach learners to configure an Oracle database for multilingual applications and distributed database access. Students will also practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Learn To: Match goals of Oracle Database 10g manageability features with the methods of achieving them. Identify features of the Oracle  more...
Oracle Database 10g New Features for Administrators Part 1 on-line e-learning cbt (computer based)cd rom Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers the new features of Oracle Database 10g that are applicable to database administration. The features include Manageability concepts, Grid computing, enhanced installation features, configuration and performance  more...
Oracle Database 10g New Features for Administrators Part 2 on-line e-learning cbt (computer based)cd rom Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as automatic management, manageability infrastructure, and application tuning and monitoring. Learn To: Identify features of Automatic Database Diagnostic Monitor  more...
Oracle Database 10g New Features for Administrators Part 3 on-line e-learning cbt (computer based)cd rom Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Resource Manager, job Scheduler, tablespace monitoring, shrinking segments, and partitioning enhancements. Learn To: Identify features of Resource Manager in Oracle Database 10g.  more...
Oracle Database 10g New Features for Administrators Part 4 on-line e-learning cbt (computer based)cd rom Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as flash backup and recovery. Learn To: Identify features of the flash backup and recovery strategy. Identify tasks that you perform when using the flash  more...
Oracle Database 10g New Features for Administrators Part 5 on-line e-learning cbt (computer based)cd rom Oracle Database 10g is designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. Oracle Database 10g supports the Oracle vision of creating a self-aware, self-learning, and completely self-managing database. This course covers new features of Oracle Database 10g such as automatic storage management, upgrade methods, RMAN backup, flash  more...
Oracle PL SQL Procedures Functions Packages on-line e-learning cbt (computer based)cd rom ...nt to the computer based training (CBT) courses entitled: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus: DML and DDL (61112). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Subprograms: Procedures Duration: 2 - 3 Hour(s) Match the various sections of a subprogram with their contents. Identify the components of  more...
Oracle PL SQL Database Programming on-line e-learning cbt (computer based)cd rom ...nt to the computer based training (CBT) courses entitled: Oracle SQL and SQL *Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL *Plus: DML and DDL (course 61112), Oracle PL/SQL: Basics (course 61113) and Oracle PL/SQL: Procedures, Functions and Packages (course 61114). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Developing Program Units Duration: 1  more...
Oracle Database 10g Administration Workshop I Part 1 on-line e-learning cbt (computer based)cd rom Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will be taught 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. Learn To:  more...
Oracle SQL for End Users--Part 1 on-line e-learning cbt (computer based)cd rom ...Oracle SQL and SQL*Plus are powerful components of Oracle's relational and object relational database management systems. This course is designed for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties, introduces the Oracle server, and indicates how SQL and SQL*Plus are used in the Oracle product  more...
Oracle SQL for End Users--Part 2 on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a two-part SQL for End Users series that is based on Introduction to Oracle: SQL and PL/SQL. In this course, the learner displays data from multiple tables by using equijoins, non-equijoins, and self joins. In addition, this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database.  more...
Oracle9i Certified Database Administrator Track Curriculum on-line e-learning cbt (computer based)cd rom The Complete Oracle9i Certified Database Administrator Track Curriculum includes the following curriculums: Introduction to Oracle9i: SQL Curriculum (ID#8054) Oracle9i Database: Fundamentals I Curriculum (ID#8058) Oracle9i Database: Fundamentals II Curriculum (ID#8064) Oracle9i Database: Performance Tuning Curriculum (ID#8068) To review individual curriculum descriptions, please select the  more...
Oracle9i SQL Curriculum on-line e-learning cbt (computer based)cd rom The Introduction to Oracle9i: SQL Curriculum includes the following courses: Oracle9i SQL: Basic SELECT Statements Oracle9i SQL: Data Retrieval Techniques Oracle9i SQL: DML and DDL To review individual course descriptions, please return to the previous page and select the desired title(s).  more...
Oracle9i SQL Basic SELECT Statements on-line e-learning cbt (computer based)cd rom This course covers relational database principles and Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. Learn To: o Identify the components of the relational  more...
Oracle9i SQL Data Retrieval Techniques on-line e-learning cbt (computer based)cd rom This course covers joins, group functions, subqueries, and the iSQL*Plus report variables. Additionally, this course shows students how to access data from multiple table using joins, aggregate data using group functions, create subqueries, and use iSQL*Plus commands to create customized queries. Learn To: o Identify the four Oracle join types used to display data from more than one table. o  more...
Oracle9i SQL DML and DDL on-line e-learning cbt (computer based)cd rom ...Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table.  more...
Oracle9i Database Admin Manage an Instance on-line e-learning cbt (computer based)cd rom Course Overview The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are  more...
Oracle9i Database Admin Create a Database on-line e-learning cbt (computer based)cd rom Course Overview The Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this course discusses how to  more...
Oracle9i Database Admin Manage Storage Structures on-line e-learning cbt (computer based)cd rom ...s series 64311 and 64312. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115). Content Emphasis Conceptual Deployment Options  more...
Oracle9i Database Admin Manage Data Storage on-line e-learning cbt (computer based)cd rom ...relationship information and trigger information by using Oracle SQL*Plus Worksheet. • Load data by using direct-load inserts, identify the concepts associated with SQL*Loader, and use SQL*Loader to load data into tables. • Identify the uses of the export and import utilities, the export modes, and the export paths. • Reorganize data using export and import, identify the  more...
Oracle9i Database Admin Manage Security on-line e-learning cbt (computer based)cd rom ...his series (64311-64314). Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115). Content Emphasis Conceptual Deployment Options  more...
Oracle9i Database Admin Perform Database Backups on-line e-learning cbt (computer based)cd rom Course Overview This course introduces students to backup methods for Oracle9i database administration. The backup concepts covered by this course include backup strategies and requirements, Oracle Architecture, archiving data, backup methods, and working with a standby database. Students perform backup procedures using operating system utilities, Oracle9i utilities such as RMAN, standard  more...
Oracle9i Database Admin Recover Databases on-line e-learning cbt (computer based)cd rom Course Overview This course introduces students to Oracle9i database recovery concepts. The recovery concepts course includes recovery with and without archiving, recovery of offline and online databases, recovery with missing data files, and incomplete recovery with and without archiving. Additional concepts covered by this course include time-based recovery, cancel-based recovery, recovery  more...
Oracle9i Database Admin Set Up Oracle Net Services on-line e-learning cbt (computer based)cd rom ...e are Database administrators. Required prerequisites are Oracle SQL, Oracle PL/SQL. Suggested prerequisites include Oracle9i Database Administration: Manage an Instance (64311), and Oracle9i Database Administration: Create a Database (64312). Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options American English  more...
Oracle9i Peformance Tuning Managing Memory and Disk I O on-line e-learning cbt (computer based)cd rom This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the  more...
Oracle SQL PL SQL Using Procedure Builder Curriculum on-line e-learning cbt (computer based)cd rom ...ulum consists of four Skill Builder courses: Course 61110 Oracle SQL: Basic SELECT Statements Course 61111 Oracle SQL: Data Retrieval Techniques Course 61112 Oracle SQL: DML and DDL Course 61113 Oracle PL/SQL: Basics Certification: This curriculum will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks:  more...
Oracle 9i New Features Database Administration on-line e-learning cbt (computer based)cd rom This course introduces learners to the Oracle9i enhancements in server-side manageability, Oracle Enterprise Manager, and globalization. Learn To Identify memory and space management improvements. Describe segment and index management improvements. Identify improvements in database operations and performance.  more...
Oracle 9i New Features Backup Recovery Performance Tuning on-line e-learning cbt (computer based)cd rom This course introduces students to high availability and fault recovery, data protection and disaster recovery, LogMiner enhancements, online operations, and Recovery Manager enhancements. Students also learn about schema improvements, system improvements, and scalable session state management. Learn To Identify the new features designed to reduce unplanned  more...
Oracle8 Database Administration - Manage Data on-line e-learning cbt (computer based)cd rom ...acle Schema Manager. Manually allocate extents by using Oracle SQL Worksheet. Identify the characteristics of the high water mark. Validate a table structure by using Oracle SQL Worksheet. Execute the command used to detect row migration in a table by using Oracle SQL Worksheet. De-allocate the unused space in a table by using Oracle SQL Worksheet. Truncate a table by using Oracle  more...
Oracle8 Database Administration - Manage Security on-line e-learning cbt (computer based)cd rom ...espace quotas for users from the data dictionary by using Oracle SQL Worksheet. Display the account status of users from the data dictionary by using Oracle SQL Worksheet. Unit 2: Managing Profiles Duration: 1.5 - 2 Hour(s) Identify the uses of profiles. Identify the implications of exceeding each type of profile limit. Identify the level at which the limit of a given  more...
Oracle8 Backup and Recovery - Strategies and Backups on-line e-learning cbt (computer based)cd rom Course Overview This is the first course in a two-part series that will introduce participants to the critical task of planning and implementing database backup strategies. In this course, users will be introduced to backup concepts and the Oracle architecture. They will learn how to change the archive mode of a database and configure a database for archive processing. Additionally, users will  more...
Oracle8 Backup and Recovery - Troubleshooting and Recovery on-line e-learning cbt (computer based)cd rom Course Overview This course is the second course in a two-part series that introduces participants to the critical task of planning and implementing database recovery strategies. This course will identify ways of handling different types of failures, diagnosing errors and detecting corruption. Additionally, users will be introduced to the different types of Oracle recovery methods and how to  more...
Oracle8i Database Admin Manage an Instance on-line e-learning cbt (computer based)cd rom ...cal Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023. T otal Learning Time  more...
Oracle Internet App Dev Track for Forms Developer R6 6i Curriculum on-line e-learning cbt (computer based)cd rom ...loper R6/6i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements(ID#378) Oracle SQL: Data Retrieval Techniques(ID#379 Oracle SQL: DML and DDL(ID#380) Oracle PL/SQL: Basics(ID#322) Oracle PL/SQL: Procedures, Functions and Packages(ID#7745) Oracle PL/SQL: Database Programming(ID#7746) Oracle Developer: Forms Fundamentals(ID#470) Oracle Developer: Enhancing the  more...
Oracle Database 10g PL SQL Fundamentals Part 2 on-line e-learning cbt (computer based)cd rom This course introduces learners to PL/SQL and helps them understand the benefits of this programming language. Students learn to create anonymous PL/SQL blocks. They learn to declare variables and trapping exceptions, develop stored procedures, functions, packages and database triggers. Learn To: Identify features of PL/SQL blocks within a subprogram. Match types of PL/SQL named  more...
Oracle Database 10g PL SQL Fundamentals Part 3 on-line e-learning cbt (computer based)cd rom In this course, the learner will get familiar with the procedural language to access Oracle database. Students will learn to manage PL/SQL program units manage dependencies, 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  more...
Oracle Application Server 10g Administration Part 3 on-line e-learning cbt (computer based)cd rom Oracle Application Server 10g is an integrated, standards-based software platform that allows organizations of all sizes to be more responsive to changing business requirements. This course covers managing, configuring OC4J applications, maintaining OC4J Application pages, OracleAS Portal, managing portal users and groups, exporting and importing portal objects, and Oracle portal advanced  more...
Oracle Application Server 10g Administration II Part 3 on-line e-learning cbt (computer based)cd rom This course introduces the various Business Intelligence components such as Discoverer, Reports, Forms, and XML applications. The users learn about configuring and managing OracleAS Discoverer, OracleAS Reports Services, OracleAS Forms, and XML applications. They also learn how to deploy and manage OracleAS Web Services. Learn To: Match the components of Oracle Application Server  more...
From iWare Logic
Certification in Oracle Applications Technologies Hello, Greetings from iWare Logic !!! We are Oracle Approved Education Center which provide Trainings & Certifications in Oracle Applications in 11i & R12 Codes Exams IZ0-007 Introduction to 9i- SQL IZ0-147 Oracle 9i Program with PL/ SQL IZ0-031 Oracle 9i- Database Fundamentals -I IZ0-032 Oracle 9i- Database Fundamentals -II IZ0-033 Oracle 9i Database- Performance Tuning  more...
From Software Training Academy, Inc
JDBC Programming Rev 5 instructor led trainingon-line e-learning cbt (computer based) This one-day course covers the fundamentals of database programming in Java using JDBC (Java Database connectivity) in an incremental fashion, to get the programmer up to speed quickly and then to layer a deeper understanding of JDBC upon that foundation. This course has been designed to work with any of these relational database management systems: Apache Derby, version 10.1 MySQL, version  more...
From Serebra Learning Corporation
Oracle Application Server 10g mod_plsql CGI Scripts and Database Providers on-line e-learning cbt (computer based) To demonstrate how to configure mod_plsql, CGI-script execution, and database providers in OracleAS DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g  more...
Transporting and Loading Data in Oracle9i on-line e-learning cbt (computer based) To describe how to transport and load data in an Oracle9i database Oracle database administrators and database operators  more...
Introduction to Oracle and SQL in Oracle 9i on-line e-learning cbt (computer based) To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements Junior database administrators, application developers, and database operators  more...
SQL Functions in Oracle 9i on-line e-learning cbt (computer based) To describe how to use SQL functions for data retrieval Junior database administrators, application developers, and database operators  more...
Subqueries Reporting and User-Access Control in Oracle 9i on-line e-learning cbt (computer based) To describe the use of subqueries, reporting, and user-access control in an Oracle9i database Junior database administrators, application developers, and database operators  more...
Defining and Manipulating Data in Oracle 9i on-line e-learning cbt (computer based) To describe how to define database objects and manipulate the data stored within them in an Oracle9i database Junior database administrators, application developers, and database operators  more...
Development Platform in Oracle9i on-line e-learning cbt (computer based) To explain the Oracle9i database enhancements that support the Oracle9i database development platform Database operators, administrators, and developers interested in the new technical features and benefits of an Oracle9i database  more...
Tuning Systems and Applications in Oracle9i on-line e-learning cbt (computer based) To describe how to tune systems and applications in Oracle9i Anyone wishing to learn about Oracle9i database performance tuning  more...
Oracle Database 10g The SQL Loader and PL SQL Release 2 on-line e-learning cbt (computer based) To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database Anyone wanting to learn about Oracle Database 10g database administration  more...
Optimizing Database Performance in Oracle 10g on-line e-learning cbt (computer based) To outline the processes and considerations for optimizing an Oracle database using alerts, trace files, and advisors Oracle database administrators and database operators  more...
Using the Scheduler to Automate Tasks in Oracle 10g on-line e-learning cbt (computer based) To outline the processes and considerations for using the Scheduler tool Oracle database administrators and database operators  more...
PL SQL Packages on-line e-learning cbt (computer based) To create and work with Oracle 10g packages Database administrators, application developers, and database operators  more...
Oracle-Supplied Packages and DBMS_SCHEDULER on-line e-learning cbt (computer based) To use Oracle-supplied packages Database administrators, application developers, and database operators  more...
Managing Dependencies on-line e-learning cbt (computer based) To manage dependencies and recompile PL/SQL units Database administrators, application developers, and database operators  more...
Manipulating Large Objects in PL SQL on-line e-learning cbt (computer based) To use LOBs and the DBMS_LOB package Database administrators, application developers, and database operators  more...
PL SQL Triggers on-line e-learning cbt (computer based) To create and manage triggers Database administrators, application developers, and database operators  more...
Dynamic SQL and Metadata on-line e-learning cbt (computer based) To write dynamic SQL and use the DBMS_METADATA package Database administrators, application developers, and database operators  more...
Oracle Database 10g New Resource Scheduling and Task-Management Features on-line e-learning cbt (computer based) To identify the new resource, scheduling, and task-management features of Oracle 10g Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g  more...
Oracle Database 10g New Tuning Performance-monitoring and Analysis Features on-line e-learning cbt (computer based) To use Oracle 10g's new tuning, performance-monitoring, and analysis features Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g  more...
Introduction to PL SQL on-line e-learning cbt (computer based) To introduce PL/SQL and provide an introduction to identifiers and variables in PL/SQL Database administrators, application developers, and database operators  more...
Using PL SQL with an Oracle Server on-line e-learning cbt (computer based) To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block Database administrators, application developers, and database operators  more...
Using Control Structures on-line e-learning cbt (computer based) To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct Database administrators, application developers, and database operators  more...
Using Composite Data Types on-line e-learning cbt (computer based) To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records Database administrators, application developers, and database operators  more...
Explicit Cursors and Exception Errors on-line e-learning cbt (computer based) To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled Database administrators, application developers, and database operators  more...
Creating Stored Procedures and Functions on-line e-learning cbt (computer based) To create and execute a stored function and call, and remove and view stored functions in PL/SQL Database administrators, application developers, and database operators  more...
Introduction to Oracle and SQL in Oracle Database 10g on-line e-learning cbt (computer based) To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements Database administrators, application developers, and database operators  more...
SQL Functions in Oracle Database 10g on-line e-learning cbt (computer based) To describe how to use SQL functions for data retrieval Database administrators, application developers, and database operators  more...
Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g on-line e-learning cbt (computer based) To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases Database administrators, application developers, and database operators  more...
Group and Datetime Functions in Oracle Database 10g on-line e-learning cbt (computer based) To demonstrate how to use group and datetime functions in Oracle 10g Database administrators, application developers, and database operators  more...
Subqueries and Hierarchical Queries in Oracle Database 10g on-line e-learning cbt (computer based) To demonstrate how to use subqueries and hierarchical queries in Oracle 10g Database administrators, application developers, and database operators  more...
Regular Expressions and User Access in Oracle Database 10g on-line e-learning cbt (computer based) To demonstrate how to use regular expression support and control user access in Oracle 10g Database administrators, application developers, and database operators  more...
Oracle Applications Release 11i: Workflow - Part 1 on-line e-learning cbt (computer based) Oracle Applications Release 11i: Workflow - Part 1 course introduces the learner to the architecture and advanced notification components of Oracle Workflow 2.5. In this course, the learner will gain an insight into the use of Workflow in business processes and methods for planning and creating a Workflow process. Oracle Workflow gives end users and technical personnel the ability to automate and  more...
Oracle Database 10g - SQL Fundamentals I Part 1 on-line e-learning cbt (computer based) In this course learners will be introduced to the concepts of relational databases and the Oracle Database 10g database technology. Additionally the learners will be introduced to the powerful SQL programming language and its features.  more...
Oracle Database 10g - Introduction to SQL Part 1 on-line e-learning cbt (computer based) (Currently no course description)  more...
Oracle Database 10g - Introduction to SQL Part 3 on-line e-learning cbt (computer based) (Currently no course description)  more...
Oracle Database 10g - Program with PL/SQL Part 2 on-line e-learning cbt (computer based) (Currently no course description)  more...
Oracle Database 10g - Program with PL/SQL Part 3 on-line e-learning cbt (computer based) (Currently no course description)  more...
Oracle Application Server 10g Administration Part 3 on-line e-learning cbt (computer based) Oracle Application Server 10g is an integrated standards-based software platform that allows organizations of all sizes to be more responsive to changing business requirements. This course covers managing configuring OC4J applications maintaining OC4J Application pages OracleAS Portal managing portal users and groups exporting and importing portal objects and Oracle portal advanced  more...
Oracle8i DBA--SQL*Loader, Oracle Export and Import, and NLS on-line e-learning cbt (computer based) The course is aimed at familiarizing you with the data transfer tools of Oracles. The course will teach you how to use SQL*Loader to load data into an Oracle database. The course will also teach you how to use the Oracle Export and Import Utilities. Next the course will detail explain the NLS feature of Oracle8i. The course initiates the learner into hands-on learning by helping the learner to  more...
Oracle 8i PL/SQL - Intro to RDBMS and SQL *Plus on-line e-learning cbt (computer based) The course aims to familiarize you with the basic concepts of database design. The course also provides a brief overview of relational database model since the Oracle database is based on this model. The course familiarizes you with the use of SQL and SQL *PLUS commands. The course will enable you to construct queries using SELECT statement with clauses such as WHERE ORDER BY and DISTINCT. You  more...
Oracle 8i PL/SQL - Functions, Tables, and Groups on-line e-learning cbt (computer based) This course covers the concepts of single row functions that enable the manipulation of data. The course essentially focuses on three single row functions: character functions number functions and date functions. The course also covers the concept of conversion that enables the conversion of a value from one datatype to another. The concept of retrieving data from more than one table by using  more...
Oracle 8i PL/SQL - Adv SQL, SQL *Plus & Data Dictionary on-line e-learning cbt (computer based) In this course you will learn to create subqueries and queries using SET operators. The course describes the SQL *PLUS file commands and SET commands that are used to customize the SQL *PLUS environment. Furthermore the course discusses the SQL *Plus format commands and script files. The concept of data dictionary tables and views is also covered in the course. Related Exam: Oracle Exam #1Z0-001:  more...
Oracle 8i PL/SQL - DML and DDL Statements on-line e-learning cbt (computer based) This course introduces the DDL and DML statements. It explains the concept of creation of tables and views. It also covers the various commands for manipulating a database. In addition the course explains the transaction processing features. It highlights the concept of altering a table definition in a database dropping a table adding comments to a table and renaming a table. It describes the  more...
Oracle 8i PL/SQL - Database Objects and Security on-line e-learning cbt (computer based) This course is aimed at familiarizing the learner with the inbuilt objects and security options in Oracle. The course includes creating and managing sequences indexes and users. It also includes PL/SQL block PL/SQL records and tables PL/SQL variables and datatypes. Related Exam: Oracle Exam #1Z0-001: Introduction to Oracle: SQL and PL/SQL.  more...
on-line e-learning cbt (computer based)
online course
 instructor led training
instructor-led class
 study at home
learn at home
 group study and discussion
group study
 self directed
self-directed study
 cd rom
cd-based training
 DVD
DVD video training
 book
printed book
 e-book
e-book digital book
 workshop / seminar
workshop seminar
 train the trainer
train the trainer
 computer lab
computer-based learning
 special pricing!
discount pricing
 on-line tutorial)
online tutorial
Home > Training Search > O > Oracle SQL > Online eLearning
tcw11--02/13/12-20:08:14-(20382)[B]-[A]-[A]