Oracle Training Oracle Support Development Oracle Apps

Free Oracle Tips

HTML Text

 Home
 E-mail Us
 Oracle Articles


 Oracle Training
 Oracle News

 Oracle Forum
 Class Catalog


 Our Staff
 Our Prices
 Help Wanted!

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


 SQL Tuning
 Security

 UNIX
 Oracle UNIX
 Linux
 Oracle Linux
 Monitoring
 Remote help

 Remote plans
 Remote
services
 Oracle C++
 Oracle Java
 Apache
 JDeveloper
 App Server

 Applications
 Oracle Forms
 Oracle Portal
 11i Upgrades
 SQL Server
 Oracle Concepts
 HTML-DB Tips
 Software Help

 Remote Help  
 Development  

 Implementation


 Financials Training
 Oracle 11i
 Oracle Apps 11i
 Oracle Workflow
 Oracle AR 11i Class
 Oracle AP 11i class
 Oracle GL 11i class
 Oracle HR 11i class
 Oracle FA 11i class
 11i Project Mgt
 11i procurement
 11i collections


 Oracle Posters
 Oracle Books

 Oracle Tuning Book
 Oracle RAC Book
 Oracle Security
 Easy Oracle Books
 Oracle Scripts
 SQL Server DBA
 SQL Design Patterns
 Ion
 Excel-DB   


 BC Oracle News


 Rednecks!
 Dress code
 Arabian Stallion

 Burleson Arabians
 Guide Horses
 Don Burleson Blog
 Golf & Travel


 Privacy Policy
 

 

 

Practical Data Modeling for Database Design


An Intensive Two-day hands-on modeling class
© 2007-2009 by Burleson Consulting

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

Click here for on-site course prices

 

 

Key Features

* Understand data modeling practices.

* Learn entities, attributes and functional dependency.

* See real-world data modeling.

* Use clustering member rows.

* Employ unobtrusive data relationships.

* Add a class hierarchy to an E/R model.

* Extend a class hierarchy to provide polymorphism.

* Identify and gather business rules from end-users.

* Understand modeling between diverse databases and hardware.

  

Course Description

At last, a concise and understandable course to teach data modeling without all of the theoretical jargon and double-talk. This seminar teaches you data modeling from the ground-up and do it today. Using real-world examples, and in-class exercises, the student builds a firm foundation that can be applied to any data model, regardless of the complexity. This course is indispensable for anyone faced with the challenge of design a database system who does not have time to earn a master degree in mathematics and wade through the complex and obtuse world of data design theory.

What's Happening?

Today more than ever, the IS professional is expected to deliver database that are designed quickly and efficiently. While academia mires in their theories of data modeling, the professional must struggle with the real-world application of data modeling, and create models that can be directly translated into working databases.

Today's IS professional must insure that they are empowered with the skills to quickly identify and refine data models for implementation in distributed and object-oriented databases.

For the senior data modeler, new techniques and theories are being introduced that incorporate object technology and new CASE tools are constantly being introduced that require knowledge of the latest theories.

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.

What Makes this Seminar 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 Seminar:

Two days of a rigorous, intensive approach that insures a complete understanding of data modeling. We explain the obtuse theory with real-world examples and concentrate on applying data modeling to existing technology.

Book Required

  Oracle Database 10g New Features 
Oracle10g Reference for Advanced Tuning & Administration

Mike Ault, Daniel Liu, Madhu Tumma

ISBN: 0-9740716-0-9

Audience

This seminar is indispensable for any IS professionals who is charged with analyzing and planning the data model, especially those that are incorporating the latest CASE technologies.

Curriculum Design

This course was designed by Donald K. Burleson, an acknowledged  leader in Oracle database administration.  Author of more than 20 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning.  Burleson Consulting instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense hands-on Oracle database training



Practical Data Modeling

Syllabus

(c) 2007-2009 by Don Burleson

Unlike other 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 techniques to create an effective database design and understand how to predict the ramifications of a change to an existing design. The course also covers the issues involved in designing a 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, hands-on way to learn data modeling. It is indispensable for database professionals who want to objectively explore how to leverage their investment in data design CASE tools and how to maximize the effectiveness of their overall data model.

DAY 1
 
9:00 - 10:15 Introduction
 
Historical overview of data modeling practices. Date, Chen.
General concepts review - basic data relationships.
In-class exercise - basic data relationships - University schema

10:15-10:30 Break

10:30-11:45 Setting the foundation

Notation differences - Chen, Rumbaugh, Coad, Booch
Is data modeling an art or a science? De-normalizing
redundancy - size vs. volatility
Horizontal partitioning and data modeling

11:45-1:00 Lunch

1:00-2:15 "Formal" data modeling

Why theory? Introducing Codd, Date and Armstrong.
Introducing entities, attributes and functional dependency.
Normalization and entity/relation models.
In class exercise - E/R vs. normalization.
Intuition vs. formal theory - Barnyard calculus
Beyond third normal form - Is it practical? BCNF, 4NF, 5NF.
In class exercise - Real-world data modeling.
Gerunds, and many-to-many relationships.
The issue of SQL with ternary joins
Recursive data relationships. (use book handout)
In-class exercise - Inferring the data model from output documents.

2:15-2:30 Break

2:30-3:45 Modeling and design issues.

The impact of access paths on data models:
pre-sorting data (IMS)
clustering member rows (Oracle)
Repeating groups vs. normalization.
In-class exercise - Design exercise.
3:45-4:00 Break
4:00-5:00 Homework Project
Homework assignment - data model from job application.
 

 

 
DAY 2
 
9:00-9:30 Exceptions to the rules

Homework review
Transforming E/R diagrams into tables/records. (ternary)
Handling large ternary and gerund relationships.
Unobtrusive data relationships (city-state-zip).

9:30-10:15 The Object-oriented data model - Modeling the real-world

Introducing data aggregates and class hierarchies.
What is object-orientation? Polymorphism and inheritance.
Introducing class hierarchies (the ISA relationship)
In-class exercise - add a class hierarchy to E/R model.

10:15-10:30 Break
 
10:30-11:45 Planning a generalization hierarchy.

Planning for inheritance.
Extending a class hierarchy to provide polymorphism.
In-class exercise - Object vs. traditional E/R data model.
Modeling aggregate entities

11:45-1:00 Lunch

1:00 - 2:45 End-Users and Data Modeling

How do business rules affect the data model? Use case analysis.
Identifying and gathering business rules from end-users.
In class exercise - Use Case Problem.
Involving end-users in the data modeling process.
Designing a data model from output forms.
 

2:45-3:00 Break

3:00-5:00 Enterprise data modeling

Determining the scope of the enterprise.
Introducing data replication. (Is this a violation of design?)
Static snapshots (asynchronous)
Real-time (synchronous replication)
In-class exercise - Replication for a business.
Modeling between diverse databases and hardware
Bridge-building tools
 

 

 
 
 
 

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 -  2009 by Burleson Enterprises, Inc. All rights reserved.

Oracle © is the registered trademark of Oracle Corporation.