Online Oracle8i eLearning - Training Resources

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...

Oracle8i Database Administration: Manage an Instance This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course participants will learn about the concepts and procedures associated with Oracle architectural components using the database administration tools managing an Oracle instance and using National Language Support.  more...

Oracle8i Database Administration: Create a Database This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course participants will learn about the concepts associated with storage structure components managing rollback segments temporary segments and indexes. In addition creating and maintaining databases will be covered.  more...

Oracle8i Database Administration: Manage Storage Structures This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course participants will learn the concepts associated with storage structure components. In addition this course will teach users how to create and maintain rollback segments temporary segments and indexes.  more...

Oracle8i Database Administration: Manage Data Storage This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course participants will learn about the concepts associated with tables. In addition this course will teach users about maintaining data integrity clusters and index-organized tables and methods for loading and reorganizing data.  more...

Oracle8i Database Administration: Manage Security This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course participants will learn about the concepts and tasks associated with managing security.  more...

Oracle8i Backup and Recovery: Strategies and Backups This is the first course in a two-part series that covers the critical skills in planning and implementing database backup and recovery strategies. This course introduces the learners to the backup and recovery goals and functions of the various structures and processes in the Oracle architecture. In addition participants learn to manage archive processing and maintain a recovery catalog. This  more...

Oracle8i Backup and Recovery: Troubleshooting and Recovery ...Oracle8i Backup and Recovery: Troubleshooting and Recovery 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  more...

Oracle8i Network Administration: Net8 Architecture and Basic Configuration ...Oracle8i Network Administration. This series introduces participants to the trends and problems associated with business networking and presents the various solutions required to address these problems. This series explains in detail the architecture of Net8 and describes the steps in which connections are established between peers. Participants will learn how to implement a basic connection  more...

Oracle8i Network Administration: Net8 Additional Configuration and Troubleshooting ...Oracle8i Network Administration. This series introduces participants to the trends and problems associated with business networking and presents the various solutions required to address these problems. This series explains in detail the architecture of Net8 and describes the steps in which connections are established between peers. Participants will learn how to implement a basic connection  more...

Oracle8i Performance Tuning: Strategies and Techniques 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 students will overview  more...

Oracle8i Performance Tuning: Managing Memory and Disk I/O ...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 buffer. Finally participants will identify database  more...

Oracle8i Performance Tuning: Optimizing Sorts and Minimizing Contention ...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 Oracle tools to diagnose and resolve  more...