Online 001 eLearning

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