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

Online Oracle SQL eLearning - Training Resources

Oracle SQL Training Provider? - Tell us about your Training!
on-line e-learning cbt (computer based)
online course
 instructor led training
instructor-led class
 study at home
learn at home
 group study and discussion
group study
 self directed
self-directed study
 cd rom
cd-based training
 DVD
DVD video training
 book
printed book
 e-book
e-book digital book
 workshop / seminar
workshop seminar
 train the trainer
train the trainer
 computer lab
computer-based learning
 special pricing!
discount pricing
 on-line tutorial)
online tutorial
Oracle SQL Training Seminars and Classes
From 123-CBT Computer Based Training
Oracle 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 ...ulum consists of four Skill Builder courses: Course 61110 Oracle SQL: Basic SELECT Statements Course 61111 Oracle SQL: Data Retrieval Techniques Course 61112 Oracle SQL: DML and DDL Course 61113 Oracle PL/SQL: Basics Certification: This curriculum will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks:  more...
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 ...e are Database administrators. Required prerequisites are Oracle SQL, Oracle PL/SQL. Suggested prerequisites include Oracle9i Database Administration: Manage an Instance (64311), and Oracle9i Database Administration: Create a Database (64312). Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options American English  more...
Oracle9i 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 ...his series (64311-64314). Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115). Content Emphasis Conceptual Deployment Options  more...
Oracle9i Database Admin Manage Data Storage on-line e-learning cbt (computer based)cd rom ...relationship information and trigger information by using Oracle SQL*Plus Worksheet. • Load data by using direct-load inserts, identify the concepts associated with SQL*Loader, and use SQL*Loader to load data into tables. • Identify the uses of the export and import utilities, the export modes, and the export paths. • Reorganize data using export and import, identify the  more...
Oracle9i Database Admin Manage Storage Structures on-line e-learning cbt (computer based)cd rom ...s series 64311 and 64312. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115). Content Emphasis Conceptual Deployment Options  more...
Oracle9i Database Admin 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 ...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 ...loper R6/6i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements(ID#378) Oracle SQL: Data Retrieval Techniques(ID#379 Oracle SQL: DML and DDL(ID#380) Oracle PL/SQL: Basics(ID#322) Oracle PL/SQL: Procedures, Functions and Packages(ID#7745) Oracle PL/SQL: Database Programming(ID#7746) Oracle Developer: Forms Fundamentals(ID#470) Oracle Developer: Enhancing the  more...
Oracle PL SQL Database Programming on-line e-learning cbt (computer based)cd rom ...nt to the computer based training (CBT) courses entitled: Oracle SQL and SQL *Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL *Plus: DML and DDL (course 61112), Oracle PL/SQL: Basics (course 61113) and Oracle PL/SQL: Procedures, Functions and Packages (course 61114). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Developing Program Units Duration: 1  more...
Oracle PL SQL Procedures Functions Packages on-line e-learning cbt (computer based)cd rom ...nt to the computer based training (CBT) courses entitled: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus: DML and DDL (61112). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Subprograms: Procedures Duration: 2 - 3 Hour(s) Match the various sections of a subprogram with their contents. Identify the components of  more...
Oracle 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 ...ete OCDBA8i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics(ID#322) Oracle 8i Backup and Recovery: Strategies & Backups(ID#7486) Oracle 8i Backup and Recovery: Troubleshooting & Recovery(ID#7487) Oracle 8i Database Admin.: Manage an  more...
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 ...cal Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312). This course will  more...
Oracle8i Database Admin Manage Data Storage on-line e-learning cbt (computer based)cd rom ...cal Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312) and Oracle8i  more...
Oracle8i Database Admin Manage Storage Structures on-line e-learning cbt (computer based)cd rom ...cal Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312). This course will  more...
Oracle8i Database Admin Create Databases on-line e-learning cbt (computer based)cd rom ...cal Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311). This course will help candidates prepare for the Oracle8i Certified DBA  more...
Oracle8i Database Admin Manage an Instance on-line e-learning cbt (computer based)cd rom ...cal Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023. T otal Learning Time  more...
Oracle 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 ...hould have knowledge equivalent to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). In addition, participants should have taken the first two  more...
Oracle Reports R6 Enhance Reports on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). In addition, participants should have taken the first part in  more...
Oracle Reports R6 Report Fundamentals on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle PL/SQL: Database Programming (course 60131). T otal Learning Time 6 - 8 Hour(s) Course Contents  more...
Oracle Form Builder R6 Including Reusable Oracle Components on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first five parts of the Oracle  more...
Oracle Form Builder R6 Controlling the User Interface Programmatically on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first four parts of the Oracle  more...
Oracle Form Builder R6 Project Builder and Menu Modules on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first three parts of the  more...
Oracle Form Builder R6 Writing and Debugging Code on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first two parts of the Oracle  more...
Oracle Form Builder R6 Enhancing the User Interface on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first part of the Oracle  more...
Oracle Form Builder R6 Forms Fundamentals on-line e-learning cbt (computer based)cd rom ...hould have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1:  more...
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 ...espace quotas for users from the data dictionary by using Oracle SQL Worksheet. Display the account status of users from the data dictionary by using Oracle SQL Worksheet. Unit 2: Managing Profiles Duration: 1.5 - 2 Hour(s) Identify the uses of profiles. Identify the implications of exceeding each type of profile limit. Identify the level at which the limit of a given resource is  more...
Oracle8 Database Administration - Manage Data on-line e-learning cbt (computer based)cd rom ...racle Schema Manager. Manually allocate extents by using Oracle SQL Worksheet. Identify the characteristics of the high water mark. Validate a table structure by using Oracle SQL Worksheet. Execute the command used to detect row migration in a table by using Oracle SQL Worksheet. De-allocate the unused space in a table by using Oracle SQL Worksheet. Truncate a table by using Oracle SQL  more...
Oracle8 Database Administration - Manage Storage Structures on-line e-learning cbt (computer based)cd rom ...ber of extents and blocks allocated to a segment by using Oracle SQL Worksheet. Retrieve the information to view the extents for a given segment by using Oracle SQL Worksheet. Write a query to check the extents for a given segment by using Oracle SQL Worksheet. Unit 2: Managing Rollback Segments Duration: 1 - 2 Hour(s) Identify the purposes of rollback segments. Identify the  more...
Oracle8 Certified Database Administrator Curriculum on-line e-learning cbt (computer based)cd rom ...inistrator Curriculum consists of the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle8 Database Administration - Manage an Instance (ID#421) Oracle8 Database Administration - Create Databases (ID#426) Oracle8 Database Administration - Manage Data  more...
Oracle8 Database Administration - Create Databases on-line e-learning cbt (computer based)cd rom ... Start a specified instance in the NOMOUNT mode by using Oracle SQL Worksheet. Identify the functionality of the CREATE DATABASE command options. Create a database with specified parameter values by using the CREATE DATABASE command. Identify the commonly encountered situations in which the CREATE DATABASE command fails. Identify the contents of a database after its creation. Unit 2 -  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 ...loper/2000 Release 2 consists of the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retreival Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle PL/SQL: Procedures, Functions and Packages (ID#7745) Oracle PL/SQL: Database Programming (ID#7746) Oracle Form Builder: Form Fundamentals (ID#381) Oracle Form  more...
Oracle Form Builder 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 users and end users with knowledge of Oracle 9i SQL and PL/SQL, navigating Oracle Applications 11i, and Oracle 11i E-Business Essentials for Implementers. Learn To: Identify options for testing a workflow process. Identify options for administering workflow processes by using the Administrator Monitor. Identify options for administering workflow processes by using the  more...
Oracle Workflow 11i10 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 ...erview This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands, functions, and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will learn  more...
Oracle SQL Specifics Creating and Managing Database Objects on-line e-learning cbt (computer based)cd rom ...rview This course is the second in a two-part series on Oracle SQL Specifics that will teach participants how to use commands, functions, and operators supported by Oracle as extensions to standard SQL. Users will learn how to create and manage tables, build integrity constraints, and use the COMMIT and ROLLBACK statements to control transactions. Learners will create and maintain views,  more...
Oracle SQL and SQL Plus Advanced SELECT Statements on-line e-learning cbt (computer based)cd rom Course Overview This course is the first course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition, this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries. L earn To: Write single-row  more...
Oracle SQL and SQL Plus SQL Plus and Reporting on-line e-learning cbt (computer based)cd rom ... part of this series should have been taken, course 60121 Oracle SQL and SQL*Plus: Advanced Select Statements. T otal Learning Time 7 - 8 Hour(s) Course Contents Unit 1: SQL*Plus Duration: 3 Hour(s) Differentiate between SQL and SQL*Plus. Match the SQL*Plus command categories with sample tasks. Write the code to display the column definitions of a given table. Complete  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 ...nt to the computer based training (CBT) courses entitled: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus: DML and DDL (61112) and Oracle 8i. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: PL/SQL: An Introduction Duration: 0.5 - 2 Hour(s) Identify the features of PL/SQL. Identify the benefits of PL/SQL. Select the  more...
SQL and PL SQL Basic SELECT on-line e-learning cbt (computer based)cd rom ...ourse Overview This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing  more...
SQL and PL SQL Data Retrieval Techniques on-line e-learning cbt (computer based)cd rom ...icipants should have taken the first part of this series, Oracle SQL: Basic SELECT Statements (61110). This course will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks: Oracle7.3 Certified Database Administrator, Oracle8 Certified Database Administrator, and Oracle Certified Application Developer,  more...
SQL and PL SQL DML and DDL on-line e-learning cbt (computer based)cd rom ...ourse Overview This course is the third in a three-part Oracle SQL series that is based on the Oracle ILT course, Introduction to Oracle: SQL and PL/SQL. Using the Oracle SQL*Plus environment, this computer-based training course uses Structured Query Language (SQL) to create and populate Oracle database tables. Learners create tables and other database objects and learn to maintain and modify  more...
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 ...Oracle SQL and SQL*Plus are powerful components of Oracle's relational and object relational database management systems. This course is designed for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties, introduces the Oracle server, and indicates how SQL and SQL*Plus are used in the Oracle product  more...
Oracle SQL for End Users--Part 2 on-line e-learning cbt (computer based)cd rom Course Overview This course is the second in a two-part SQL for End Users series that is based on Introduction to Oracle: SQL and PL/SQL. In this course, the learner displays data from multiple tables by using equijoins, non-equijoins, and self joins. In addition, this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database.  more...
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 ...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) ...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; restricting and sorting data; and using  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) ...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. Learners also learn how to insert  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) ...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. The  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) ...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 functions can be used in SQL SELECT statements to  more...
Oracle SQL Specifics: Creating and Managing Database Objects on-line e-learning cbt (computer based) ...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 and synonyms. Additionally users will learn how  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) ...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 and synonyms. Additionally users will learn how  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) ...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 Oracle Enterprise Manager. This tutorial  more...
From Teach Me IT
Oracle SQL and PL/SQL: Basic Concepts on-line e-learning cbt (computer based)study at home ...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 SQL > Online eLearning
tcw11-gfc--11/22/09-12:38:27-(20382)[A]-[A]-[B]