| 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 would
also be able to retrieve data from a database using arithmetic,
logical, comparison, and SQL operators.
Intro to RDBMS and SQL *Plus training covers such topics as:
RDBMS and SQL
Basics of SQL
Controlling Selected Rows
Operators
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
join statements is also covered. Additionally, the course discusses
group functions that operate on sets of rows to give one result.
Related Exam: Oracle Exam #1Z0-001: Introduction to Oracle: SQL
and PL/SQL.
Functions, Tables, and Groups training covers such topics as:
Single Row Functions
Conversion Functions
Display Data From Multiple Tables
Working With Groups
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.
The course discusses the SQL *Plus format commands and script files
and the concept of data dictionary tables and views.
Adv SQL, SQL *Plus & Data Dictionary training covers such
topics as:
Subqueries
SQL *Plus Commands
Creating Reports
Data Dictionary
The course addresses the training needs of IT Professionals
who use Oracle 8i. This course also addresses the needs of IT professionals
who want to become
certified under the Oracle8i Certified Database Administrator (DBA) Track. |