Custom Search
Home > Training Search > O > Oracle 9i Sql > Online eLearning

Online Oracle 9i Sql eLearning - Training Resources

Oracle 9i 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 9i Sql Training Seminars and Classes
From 123-CBT Computer Based Training
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...
Oracle Database 11g Getting Started with SQL and PL SQL New Features on-line e-learning cbt (computer based) 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) 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) 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) 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) 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) 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) 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) 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...
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 Database 10g Database Interfaces Release 2 on-line e-learning cbt (computer based) 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 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  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...
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  more...
SQL Functions in Oracle Database 10g on-line e-learning cbt (computer based) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) 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) To create and work with Oracle 10g packages  more...
Oracle-Supplied Packages and DBMS_SCHEDULER on-line e-learning cbt (computer based) To use Oracle-supplied packages  more...
Managing Dependencies on-line e-learning cbt (computer based) To manage dependencies and recompile PL/SQL units  more...
Manipulating Large Objects in PL SQL on-line e-learning cbt (computer based) To use LOBs and the DBMS_LOB package  more...
PL SQL Triggers on-line e-learning cbt (computer based) To create and manage triggers  more...
Dynamic SQL and Metadata on-line e-learning cbt (computer based) To write dynamic SQL and use the DBMS_METADATA package  more...
Oracle Database 11g Using Data Types INDEX BY Tables and Cursors in PL SQL on-line e-learning cbt (computer based) 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) 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) 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) 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 PL SQL Variables Attributes and Executable Statements on-line e-learning cbt (computer based) 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) 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 SQL PL SQL Using Procedure Builder Curriculum on-line e-learning cbt (computer based)cd rom The courses in this curriculum cover the concepts of relational databases and the SQL and PL/SQL programming languages. Students learn how to create and maintain database objects and to store, retrieve, and manipulate data. In addition, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. This curriculum  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...
Oracle9i Database Admin Set Up Oracle Net Services on-line e-learning cbt (computer based)cd rom Course Overview This course covers the architecture and configuration of Oracle Net Services. It details client-server and web implementations, in addition to additional features such as Dynamic Service Registration and the use of the Oracle Names Server as an LDAP Proxy. This course also discusses the configuration of the Oracle Shared Server and Oracle Names Server. Learn To •  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 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 Manage Security on-line e-learning cbt (computer based)cd rom Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database. Learn To • Define and maintain the five components of the security domain of a user in a given  more...
Oracle9i Database Admin Manage Data Storage on-line e-learning cbt (computer based)cd rom Course Overview This course is the fourth in the series covering the database administration strategies and procedures provided in Oracle9. This course covers the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. Learn To • Identify the row storage method used by the various tables and the  more...
Oracle9i Database Admin Manage Storage Structures on-line e-learning cbt (computer based)cd rom Course Overview The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course, participants learn the concepts associated with storage structure components. In addition, this course teaches users the procedures for managing segment free space, undo  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 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 SQL DML and DDL on-line e-learning cbt (computer based)cd rom The 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 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 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 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 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...
Oracle Internet App Dev Track for Forms Developer R6 6i Curriculum on-line e-learning cbt (computer based)cd rom The Complete Oracle Internet App. Dev. Track for Forms Developer 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:  more...
Oracle PL SQL Database Programming on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a series of three titles, and discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored  more...
Oracle PL SQL Procedures Functions Packages on-line e-learning cbt (computer based)cd rom 61114 Course Overview This course is the second in a series of three titles. It introduces the learner to the basics of PL/SQL subprograms. This course covers the building and invoking of procedures and functions. Additionally, this course introduces the basics of creating and using packages. L earn To: Identify the types and components of a subprogram. Create a subprogram. Create  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...
OCDBA8i Curriculum on-line e-learning cbt (computer based)cd rom The Complete 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...
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...
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 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 Database Admin Manage Security on-line e-learning cbt (computer based)cd rom Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and tasks associated with managing security. L earn To: Define and maintain the security domains for users in a given environment. Define and maintain a named set of resources and  more...
Oracle8i Database Admin Manage Data Storage on-line e-learning cbt (computer based)cd rom Course Overview This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. L  more...
Oracle8i Database Admin Manage Storage Structures on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes. L earn To: Identify  more...
Oracle8i Database Admin Create Databases on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts associated with storage structure components, managing rollback segments, temporary segments, and indexes. In addition, creating and maintaining databases will be covered. L earn To:  more...
Oracle8i Database Admin 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 Oracle8i. 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...
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 Flashback  more...
Oracle Reports R6 Control Reports on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a three-part Oracle Reports series that is based on Oracle Reports Release 6. This course introduces the learner to features of Oracle Reports that can be used to control report output. This course covers developing templates, creating and using parameters, coding PL/SQL triggers, exporing built-in package procedures, using the Reports Server, and  more...
Oracle Reports R6 Enhance Reports on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a three-part Oracle Reports series that is based on Oracle Reports Release 6. The goal of this course is to enable developers to construct complex reports and charts using Oracle Reports. This course introduces the learner to the key features of the Data Model editor, Layout Model objects and their properties. The course also enables the learner to  more...
Oracle Reports R6 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 Reports Release 6. This course introduces the learner to, the key features of Report Builder, steps involved in 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  more...
Oracle Form Builder R6 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 Developer series that is based on Oracle Developer Release 6. This course will enable learners to implement methods to use additional data sources, to work with Oracle8 objects, and to integrate charts, reports, and timers in form modules. In addition, the course covers the procedures to reuse components, objects, and code and to  more...
Oracle Form Builder R6 Controlling the User Interface Programmatically on-line e-learning cbt (computer based)cd rom Course Overview This course is the fifth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course enables learners to create Key triggers, to write code that responds to mouse events, to manage windows and canvases, and to use the Object Navigator. In addition, learners work with multiple form applications, record groups, and list items. L earn To:  more...
Oracle Form Builder R6 Project Builder and Menu Modules on-line e-learning cbt (computer based)cd rom Course Overview This course is the fourth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course describes the features and benefits of Oracle Project Builder, how to create and deliver projects, and how to create new file types. In addition, the course describes how to create and manipulate menu modules, and how to manage menu modules. L earn To:  more...
Oracle Form Builder R6 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 Developer series that is based on Oracle Developer Release 6. In this course learners will create and control alerts, debug PL/SQL code, and process queries in form modules. In addition, the course will cover transaction processing, Form Builder application customization, and writing flexible code. L earn To: Identify the  more...
Oracle Form Builder R6 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 Developer series based on Oracle Developer Release 6. This course describes how to create input and non-input items, how to create lists of values (LOVs) and editors to support text items, and how to create forms using multiple windows and a variety of canvas styles. Additionally, this course covers ways to add functionality to  more...
Oracle Form Builder R6 Forms Fundamentals on-line e-learning cbt (computer based)cd rom Course Overview This course is the first in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course introduces the learner to the key features, components, and capabilities of Oracle Developer. In addition, this course helps learners to run, create, and customize a form module. L earn To: Identify the key features, components and capabilities of  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...
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 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...
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 Database Administration - Manage Security on-line e-learning cbt (computer based)cd rom Course Overview This course is the last 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 tasks associated with managing security. L earn To: Define and maintain the security domains for users in a given environment. Define and maintain a named set of resources and  more...
Oracle8 Database Administration - Manage Data on-line e-learning cbt (computer based)cd rom Course Overview This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. L  more...
Oracle8 Database Administration - Manage Storage Structures on-line e-learning cbt (computer based)cd rom Course Overview This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes. L earn To: Identify  more...
Oracle8 Certified Database Administrator Curriculum on-line e-learning cbt (computer based)cd rom NETg is Oracle's partner in offering interactive TBT preparation courses for this important certification program. Each of these TBT courses has been co-developed by Oracle Education and NETg to offer step-by-step instruction and hands-on practice in key topic areas. The Complete Oracle8 Certified Database Administrator Curriculum consists of the following courses: Oracle SQL: Basic SELECT  more...
Oracle8 Database Administration - Create Databases on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts associated with storage structure components, managing rollback segments, temporary segments, and indexes. In addition, creating and maintaining databases will be covered. L earn To:  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...
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...
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 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 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. L  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 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 Cert App Developer Track for Developer 2000 R2 Curriculum on-line e-learning cbt (computer based)cd rom NETg is Oracle's partner in offering interactive TBT preparation courses for this important certification program. Each of these TBT courses has been co-developed by Oracle Education and NETg to offer step-by-step instruction and hands-on practice in key topic areas. The Complete Oracle Certified Application Developer Track for Developer/2000 Release 2 consists of the following courses:  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 the  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 non-input  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 and  more...
Oracle Workflow 11i10 Interacting with Processes Notifications on-line e-learning cbt (computer based)cd rom ...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 Self-Service Monitor. Audience: The target  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 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 that  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 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 features of  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 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 the  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 (ER)  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 basic  more...
Oracle SQL Specifics Retrieving and Formatting Data on-line e-learning cbt (computer based)cd rom Course Overview 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  more...
Oracle SQL Specifics Creating and Managing Database Objects on-line e-learning cbt (computer based)cd rom Course Overview 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  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 single-row  more...
Oracle SQL and SQL Plus SQL Plus and Reporting on-line e-learning cbt (computer based)cd rom Course Overview This is the second course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the fundamental concepts of SQL*Plus and queries using SQL*Plus runtime variables. In addition, this course explores saving customizations and enhancing query output. L earn To: Identify the fundamental concepts of SQL*Plus and write queries  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 of  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, components  more...
SQL and PL SQL PL SQL Basics on-line e-learning cbt (computer based)cd rom Course Overview This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.  more...
SQL and PL SQL Basic SELECT on-line e-learning cbt (computer based)cd rom Course 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 basic  more...
SQL and PL SQL Data Retrieval Techniques on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a three-part Oracle series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries.  more...
SQL and PL SQL DML and DDL on-line e-learning cbt (computer based)cd rom Course 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...
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 testing.  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 activity  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 database  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 involved  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 Database  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. Identify  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 recovery  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 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 Course Overview 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  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...
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...
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 blocks  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 with  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 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...
Oracle 8i PL/SQL - Oracle PL/SQL Basic Operations on-line e-learning cbt (computer based) The course is aimed at familiarizing the learner with the basic concepts of PL/SQL. It describes the different datatypes and variables available with PL/SQL. The course provides an overview of PL/SQL records and tables and explains how to access a database from PL/SQL. It also describes the steps to write conditional constructs and controlling structures in PL/SQL along with different types of  more...
Oracle 8i DBA - Introducing Procedure Builder on-line e-learning cbt (computer based) This course aims to introduce you to the various components of Procedure Builder. It explains the features of the Procedure Builder components such as the Object Navigator the PL/SQL Interpreter the Program Unit Editor the Stored Program Unit Editor and the Database Trigger Editor. It describes how you can use the components of Procedure Builder to create debug and execute program units. Related  more...
Oracle 8i DBA - Data Dictionary and Database Files on-line e-learning cbt (computer based) The course is aimed at familiarizing the student with the Data Dictionary views and database files. The course enables the learner to manage log and control files. The uses and contents of control files will be discussed as well as obtaining information from control files. The planning use and troubleshooting of redo log files will also be explained. The course also provides a list of Data  more...
Oracle9i SQL: Basic SELECT Statements on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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.  more...
Oracle9i SQL: DML and DDL on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd The 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 Administration: Create a Database on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 create and maintain  more...
Oracle9i Database Administration: Manage Storage Structures on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course, participants learn the concepts associated with storage structure components. In addition, this course teaches users the procedures for managing segment free space, undo space, temporary  more...
Oracle9i Database Administration: Manage Data Storage on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This course is the fourth in the series covering the database administration strategies and procedures provided in Oracle9. This course covers the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data.  more...
Oracle9i Database Administration: Manage Security on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database.  more...
Oracle9i Database Administration: Strategies and Backups on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 SQL*Plus commands, and  more...
Oracle9i Database Administration: Recover Databases on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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 manager components,  more...
Oracle9i Performance Tuning: Managing Memory and Disk I/O on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd 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.  more...
Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention on-line e-learning cbt (computer based)study at homeweb-based,online cbt,cd The content of this course includes details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views. Students learn about migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting.  more...
Oracle Developer: Writing and Debugging Code on-line e-learning cbt (computer based) This course is the third in a six-part Oracle Developer series that is based on Oracle Developer Release 6. In this course learners will create and control alerts debug PL/SQL code and process queries in form modules. In addition the course will cover transaction processing Form Builder application customization and writing flexible code.  more...
Oracle Reports: Controlling Reports on-line e-learning cbt (computer based) This course is the third in a three-part Oracle Reports series that is based on Oracle Reports Release 6. This course introduces the learner to features of Oracle Reports that can be used to control report output. This course covers developing templates creating and using parameters coding PL/SQL triggers exporting built-in package procedures using the Reports Server and developing reports for  more...
Oracle Application Server: Getting Started with PL/SQL Web Applications on-line e-learning cbt (computer based) This course introduces PL/SQL programmers to the essential concepts and techniques needed to build and deploy applications on Oracle Application Server. You will learn how to create PL/SQL packages that output interactive Web pages with database content including HTML tables and forms.  more...
Oracle8i Performance Tuning: Optimizing Sorts and Minimizing Contention on-line e-learning cbt (computer based) 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. The student will use  more...
Oracle9i Database Administration: Strategies and Backups on-line e-learning cbt (computer based) 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 SQL*Plus commands and the  more...
Oracle SQL for End Users Part 1 on-line e-learning cbt (computer based) 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) 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. This course also covers  more...
Oracle SQL: Basic SELECT Statements on-line e-learning cbt (computer based) 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 basic SQL statements;  more...
Oracle SQL: Data Retrieval Techniques on-line e-learning cbt (computer based) This course is the second in a three-part Oracle series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries. In addition how to  more...
Oracle SQL: DML and DDL on-line e-learning cbt (computer based) 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 these data objects.  more...
Oracle PL/SQL: Basics on-line e-learning cbt (computer based) This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design develop and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming. Numerous  more...
Oracle PL/SQL: Procedures, Functions and Packages on-line e-learning cbt (computer based) This is the first course in a two part series. It introduces the learner to the basics of PL/SQL subprograms. This course covers the building and invoking of procedures and functions. Additionally this course introduces the basics of creating and using packages.  more...
Oracle PL/SQL: Database Programming on-line e-learning cbt (computer based) This is the second course in a two part series that discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored subprograms and  more...
Advanced Oracle PL/SQL: Design Considerations and Object Types on-line e-learning cbt (computer based) This course introduces students to subtypes subprograms cursor variables and the NOCOPY parameter used in advanced function definitions and packages. Students also learn about object types data dictionary views and collections.  more...
Advanced Oracle PL/SQL: Implementation and Advanced Features on-line e-learning cbt (computer based) This course introduces students to advanced interface methods practices and techniques that improve the efficiency and performance of PL/SQL operations. Students also learn about essential Oracle supplied packages that are commonly used in developing applications.  more...
Oracle9i SQL: Basic SELECT Statements on-line e-learning cbt (computer based) 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.  more...
Oracle9i SQL: DML and DDL on-line e-learning cbt (computer based) The 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 PL/SQL: Basics on-line e-learning cbt (computer based) The Oracle9i PL/SQL: Basics course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design develop and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.  more...
Oracle9i PL/SQL: Database Programming on-line e-learning cbt (computer based) This course discusses the features of stored subprograms and packages. Participants will learn how to create and invoke stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. Participants will learn how to manage stored subprograms and packages. This course also introduces  more...
Oracle Form Builder: Writing and Debugging Code on-line e-learning cbt (computer based) 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.  more...
Oracle Report Builder: Controlling Reports on-line e-learning cbt (computer based) 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.  more...
Oracle8 Performance Tuning: Optimizing Sorts and Minimizing Contention on-line e-learning cbt (computer based) 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 will use Oracle tools  more...
Oracle SQL Specifics: Retrieving and Formatting Data on-line e-learning cbt (computer based) 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 how SQL  more...
Oracle SQL Specifics: Creating and Managing Database Objects on-line e-learning cbt (computer based) 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 sequences indexes  more...
Oracle SQL and SQL*Plus: Advanced SELECT Statements on-line e-learning cbt (computer based) 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.  more...
Oracle SQL and SQL*Plus: SQL*Plus and Reporting on-line e-learning cbt (computer based) 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 sequences indexes  more...
Oracle SQL Tuning: Diagnostics and Tuning the Schema on-line e-learning cbt (computer based) 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 clusters. Participants will  more...
Oracle SQL Tuning: Tuning SQL and the Optimizer on-line e-learning cbt (computer based) 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.  more...
Oracle SQL and PL/SQL: Basic Concepts on-line e-learning cbt (computer based) The Oracle SQL and PL/SQL: Basic Concepts WBT is the first course in this curriculum. This course will explain basic concepts regarding a DBMS, RDBMS, and ORDBMS and give an Oracle implementation of these. It will also provide users with the basic functionality of PL/SQL for creating, viewing, maintaining, and altering data in Oracle.  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...
Oracle 10g Administration instructor led trainingon-line e-learning cbt (computer based) Comprehensive, hands-on class focusing on the day-to-day tasks a DBA will perform to create, maintain and manage an Oracle 10g Database such as security, creating and managing users, creating and managing database objects (tablespaces, tables, indexes, etc.), running utilities, configuring Oracle networking, and simple backup and recovery techniques. Provides an overview of the Oracle Data  more...
Oracle 10g PL SQL Programming instructor led trainingon-line e-learning cbt (computer based) This class will teach you how to write efficient and scalable PL/SQL programs to create database-intensive PL/SQL applications. Learning how to create efficient, scalable PL/SQL programs is an important objective of this course. To meet that objective, the course includes instruction on such things as the proper use of bind variables, bulk processing, pipelining, benchmarking different  more...
Oracle 10g - Advanced SQL instructor led trainingon-line e-learning cbt (computer based) This course will give experienced Oracle technologists the advanced SQL skills necessary to design and code complex queries against Oracle databases. You will learn to use many advanced SQL coding techniques such as coding analytic functions for data warehouse and decision support queries, using partition outer join to "densify" data, the Oracle10g MODEL clause ("spreadsheet-like capability  more...
Oracle 10g - Introduction to SQL instructor led trainingon-line e-learning cbt (computer based) This course is designed for developers who are new to relational database and need to know how to query, update and create basic objects in Oracle databases. Students receive a comprehensive introduction to Oracle's implementation of the SQL language and the common query tools, SQL*Plus and iSQL*Plus. The course includes a lesson on basic relational database concepts. LEARNING OBJECTIVES  more...
Oracle Applications Using ADO NET and C instructor led trainingon-line e-learning cbt (computer based) Oracle is a robust and powerful data storage engine that provides services on all levels of an application infrastructure combining programmer-definable objects and tools, data manipulation tools that are capable of retrieving data from a host of data sources and storing those data in a database, and the capability to automate tasks and run them under developer control. This comprehensive course  more...
From BIS
Datawarehouse Online classes by RAM We are conduction online classes for the following subjects 1. Informatica 2. Business Objects 3. Teradata (certification also) 4. Datastage 7 years of Datawarehouse experience in singapore contact: ramswins@gmail. com +91 9940409993 India  more...
From The Virtual Training Company
Oracle Database Administration Fundamentals I on-line e-learning cbt (computer based) This is the second in a series of courses, aimed at preparing the user for Oracle Certification Exam # 1Z0-031. This course will teach Oracle database administration fundamentals; installing Oracle, creating databases, managing objects in the database and more. This course expands on the first course offered by VTC (Introduction to Oracle SQL and PL/SQL). Following courses will include: Oracle  more...
Oracle Database Administration Fundamentals II on-line e-learning cbt (computer based) Oracle Database Administration Fundamentals II is the third in a series of four courses covering Oracle Certification course #1Z0-032, and more. Like the other courses in this series of Oracle Certification titles, this course teaches and demonstrates by example using thoroughly tested examples. In this course, instructor Gavin Powell covers Oracle Net Services, Backup and Recovery including RMAN,  more...
Oracle Performance Tuning 1Z0-033 on-line e-learning cbt (computer based) VTC author, Gavin Powell, covers material in the 1Z0-033 Oracle 9i tuning certification examination, including the basics of performance tuning and tuning tools. Memory tuning covers the shared pool, the database buffer cache and other buffers. From an I/O perspective, topics covered are physical file structures of the database, tablespaces, datafiles and at the block level. Also covered are  more...
Oracle Introduction to Oracle SQL and PL SQL on-line e-learning cbt (computer based) Virtual Training Company's Introduction to Oracle SQL and PL/SQL tutorial will cover the relational Database Model, the Oracle Architecture and the Physical database. The tutorial is aimed at programmers, and individuals who have had prior SQL and relational database experience. Gavin Powell, your instructor, will begin teaching you many Oracle tools such as the SQL Plus, SQL Plus Worksheet, and  more...
From Teach Me IT
Oracle SQL and PL/SQL: Basic Concepts on-line e-learning cbt (computer based)study at home The Oracle SQL and PL/SQL: Basic Concepts WBT is the first course in this curriculum. This curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-001. This course explains the basic concepts regarding a DBMS, RDBMS, and ORDBMS, and give an Oracle implementation of these. It also provides users with the basic functionality of PL/SQL for creating, viewing,  more...
Basic PL/SQL Programming on-line e-learning cbt (computer based)study at home The Basic PL/SQL Programming WBT is the second course in this curriculum. This curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-001. This course enables users to create views, sequences, synonyms, records, tables, functions, and procedures. Additionally, it enables users to create different kinds of PL/SQL blocks. After completing this course, the  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 9i Sql > Online eLearning
tcw11-gfc--11/29/09-09:25:50-(20382)[B]-[A]-[B]