Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

Oracle Data Modeling Training Class

Data Design for Performance


An Intensive data modeling class
© 2016 by Burleson Corporation

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

 

 

Key Features

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

  

Course Description

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.

Book Required

  Physical Database Design using Oracle 

Donald K. Burleson, CRC Press

ISBN: 978-0849318177

Audience

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.

Curriculum Design

This course was designed by Donald K. Burleson, an acknowledged  leader in Oracle database administration.  Author of more than 30 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Physical Database Design using Oracle.  Burleson Corporation instructors offer decades of real world DBA experience in Oracle data modeling features, and they will share their Oracle secrets in this intense Oracle data modeling training

Unlike theoretical courses on data modeling, this course emphasizes the pragmatic application of real-world database design techniques. Through numerous in-class exercises, the attendees will internalize proven Oracle data modeling techniques to create an effective database design and understand how to predict the ramifications of a change to an existing Oracle design.

The course also covers the issues involved in designing an Oracle enterprise data model and how to effectively manage data redundancy in a distributed environment. Object technology and incorporating an object data model into traditional techniques is also covered.

This course has been specifically designed to be a practical, easy way to learn Oracle data modeling. It is indispensable for Oracle professionals who want to understand basic data modeling for performance and deploy a robust data model using Oracle's specialized data structures.



Oracle Data Modeling

Syllabus

(c) 2016 by Don Burleson

Day 1:

Introduction to Data Modeling

Translating business rules into data models (data constraints)

Understanding functional dependency

Normalization (C. J. Date)

Modeling repeating groups

Beyond 3rd normal form (BCNF, 4NF)

Entity relation modeling (Chen diagrams)

Exercise:  Build a data model

Identifying entities, relations and attributes

Unobtrusive data relationships (city, state, zip)

Modeling recursion

 

Day 2:

De-normalizing for performance

Modeling data aggregation (data warehouse design)

Introducing redundancy - size & volatility

Exercise:  Denormalize a data model

Pre-joining tables toigether

Using materialized views

Deploying Oracle replication

Modeling object-orientation and class hierarchies

Modeling polymorphism & inheritance

 

Day 3:

Oracle sorted hash clusters

Oracle nested tables

Oracle VARRAY tables

Oracle index-only tables

Oracle virtual columns

Oracle function-based indexes

Oracle distributed database and data modeling

 

 

(c) 2016 by Burleson Corporation

 
 
 
 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.