* Learn practical data normalization
for Oracle databases.
* See how to denormalize a data model by the
intelligent introduction of redundancy.
* See how to design for high performance by
removing unnecessary table joins.
* Understand Oracle data modeling best
practices.
* Learn how to model entities, attributes and functional dependency.
* See real-world data modeling examples for Oracle.
* See when to use specialized data models in Oracle.
* Employ cluster tables and sorted hash clusters.
* See how to model a class hierarchy in an E/R model.
* See when to use non-first normal form Oracle data structures.
* Understand when to use Index only tables and
specialized Oracle indexes,
* Learn Oracle's tools for denormalization,
including materialized views and replication solutions.
|
|
At last, a concise and understandable course to teach data
modeling without all of the theoretical jargon and double-talk.
This data modeling training class teaches you Oracle data modeling from the ground-up and
includes specialized Oracle data structures such as cluster tables, VARRAY
tables, nested tables and Index-organized tables.
Using real-world examples, and in-class exercises, the
student builds a firm data modeling foundation that can be applied to any Oracle data
model, regardless of the complexity. This course is specifically designed to
explain data modeling from an Oracle perspective, complex data modeling
concepts, taught in plain English.
This data modeling
class is indispensable
for anyone faced with the challenge of design a database system who
does not have time to earn an advanced IT degree and wade
through the complex and obtuse world of data design
theory.
What's Happening?
Today more than ever,
the Oracle professional is expected to deliver Oracle database that
are designed quickly and efficiently. While academia remains mired in their
obtuse theories of data modeling, the Oracle professional must struggle with the
real-world application of data modeling, and deploy Oracle data models that can
be directly translated into working databases.
This
seminar is indispensable for showing how the relatively mature data
modeling techniques mesh with the object paradigm.
What
You Will Learn:
The first
day of this seminar will introduce the basic concepts of data
modeling and provide a strong foundation for applying real-world
techniques to complex data models. Complex modeling theory such as
normalization will be explained in plain English, and the student
will gain an in-depth understanding of how to create data
models.
Day two
will cover extensions to the basic data modeling paradigm, and will
show how object-oriented extensions are added to existing data
models.
Day 3 will cover the
Oracle-centric data structures that are unique to Oracle databases, including
non-first-normal form tables (VARRAY tables), nested tables, index-only tables,
and denormalization techniques within Oracle including materialized views and
Oracle replication.
What
Makes this Class Unique?
Unlike
other "overview" seminars, this session explains a complex and
difficult subject in plain English. In addition to being a
practicing data modeler, the instructor is a seasoned professor who
has taught data modeling to thousands of students. Consequently,
the course meshes theory with practicality, and brings a simple
perspective to a very complex topic.
Included in the Class:
This is a rigorous, intensive approach that insures a complete
understanding of data modeling within the context of Oracle's unique data
structures. We explain the obtuse theory with
real-world examples and concentrate on applying data modeling to
existing technology.
 |
|
Physical Database Design using Oracle
Donald K. Burleson, CRC Press
ISBN:
978-0849318177
|
This seminar is indispensable for any Oracle
professionals who is charged with analyzing and planning the data
model, especially those that are incorporating the latest Oracle data design
technologies.
|
