Online Oracle Exam eLearning Training

Oracle8i DBA--SQL*Loader, Oracle Export and Import, and NLS 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 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 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 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 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 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 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 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 - Oracle Server and Database Architecture This course is aimed to familiarize you with the basic concepts of Oracle 8i Architecture and Oracle Enterprise Manager. This course will introduce you to the concepts of Oracle instances and SGA components. You will learn to identify the memory structures and processes involved with an Oracle instance. You will be introduced to the Oracle Universal Installer and be able to explain the Optimal more...

Oracle 8i DBA - Oracle Instance, the Start-up and Shutdown Procedure The course is aimed at familiarizing the learner with the Oracle instance. It teaches you the learner about the startup and shutdown processes and the different stages of startup and shutdown. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping you the learner type in the commands more...

Oracle 8i DBA - Data Dictionary and Database Files 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...

Oracle 8i DBA - Oracle Storage Architecture This course is designed to give an Oracle DBA the necessary knowledge and skills to manage data storage. It will provide detailed information about logical structures such as tablespaces segments extents and Oracle data blocks. The creation and management of rollback segments will also be covered. The course also provides a list of data dictionary views that help in managing these logical more...

Oracle 8i DBA - Understanding Storage Allocation This course covers the various aspects of optimizing database objects. It discusses tables clusters and index-organized tables. This course explains the different types of tables supported by Oracle 8i the structure of a row the different data types supported by Oracle 8i and the guidelines to create a table. Further the course covers how to create the cluster the cluster index and the tables in more...

Oracle8i DBA: Indexes and Constraints In this course you will learn to create indexes and enforce various constraints. The course describes the reorganization of indexes managing indexes and maintaining constraints. You will also learn how to obtain information about indexes and constraints from the data dictionary. Related Exam: Oracle Exam #1Z0-023: Oracle 8i: Architecture and Administration.  more...

Oracle 8i DBA - Managing Oracle Database Security This course is aimed to familiarize the learner with the basic concepts of Oracle 8i administration of security user roles and resources. The course also provides a list of data dictionary views that help in performing administrative tasks. The course initiates the learner into hands-on learning by helping the learner to type-in the commands to perform administrative tasks. Related Exam: Oracle more...