|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Oct. 25, 2002
|
| |
| 402-339-7493 |
| 402-636-3171 |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|
Course Description
The ORACLE SQL AND PL/SQL HANDBOOK
course is designed for the following:
- IT personnel new to relational
database technology
- IT personnel new to Oracle
- Anyone needing a good
understanding of SQL, PL/SQL, and how the tools apply to the
modern information systems
- Developers that want to be
successful using Oracle Report Builder, Discoverer, or Form Builder
- Business personnel that have a
need to develop their own business information
This course introduces the student
to:
- Oracle's version of the
Structured Query Language (SQL). This is the ANSI standard
language for interacting with a relational database
- The six clauses of a Select
statement. Select statements are the database commands used to
extract information from a relational database
- Aggregate, numeric, and
character functions used to compute special values
- Oracle's new analytic functions
that are used rank values, compute moving averages, compute record
differences, and predict future values
- Methods and tools used to
identify database attributes and the paths to the attributes
- Methods of combining records and
attributes from multiple database tables
- Different types of views
(database view, inline view, and materialized view) and when they
should be used
- Various methods of tuning SQL
are also covered
- Oracle's database objects such
as tablespaces, tables, sequences, indexes, and database triggers
- Oracle's Data Control Language (DCL)
used to create and maintain the database objects
- The system and object privileges
used to control the ability to perform Oracle tasks and access to the
data
- Oracle's procedure language,
PL/SQL. This language is used in Oracle Report Builder,
Discoverer, and Form Builder
- How to create and use stored
procedures, functions, and packages
- How to use Java within PL/SQL
- How to create and use Oracle's
object-oriented features
Besides introducing the student to
the Oracle SQL and PL/SQL techniques and tools, the course has a
recurring theme of using the tools in conjunction with a data warehouse.
Throughout the course data warehousing theory and techniques are
discussed. The purpose of the course is to teach the student how
to understand and use the proprietary databases so prevalent in the
business world to create business information, whether it is in a
report, a Discoverer workbook, or on a form.
This course will use the ORACLE SQL
AND PL/SQL HANDBOOK as its courseware. You will find that the
students will continue to use this book in their Oracle book. This
contrasts with normal training courses where the courseware sits on a
shelf immediately after class. This course book was designed to as
training material and to be the most important source of day-to-day
Oracle information.
The course is designed as a five
day course, but it may be easily pared down. The following options
exist:
- Five days covering SQL,
PL/SQL, analytic functions, performance tuning, and an introduction to
database design
- Four days covering SQL
and PL/SQL. Analytic functions and database design are omitted.
The student will only receive a brief overview of SQL tuning
techniques.
- Three days covering SQL,
analytic functions, performance tuning, and an introduction to
database design.
- Two days covering SQL.
Analytic functions and database design are omitted. The student
will only receive a brief overview of SQL tuning techniques.
- Two days covering PL/SQL.
Top
Outline
|
