Data Modeling Tutorials

Details

Highly Effective Data Modeling tutorials on video CD, learn from your own desk at a pace that suits you. Low cost high quality training at an affordable price. Works on PC and Mac.

 

These Data Modeling tutorials have been created for users that need to use large and complex data oriented structures. This training course is authored by Data Modeling expert Gavin Powell, the course starts by demonstrating examples of various Data Models before progressing to cover other topics that are essential in forming a solid understanding and practical knowledge of Data Modeling such as Network Databases, Entity Relationships, Object Data Models, SQL, QDQL and much more. This training course can be considered to be a definitive reference on Data Modeling


Close
Data Modeling Training CD / DVD Contents
Professionally created, comprehensive training that's easy to follow at an unbelivable price.

See the quality for yourself. Try a FREE Demo.

The blue links below are Free Data Modeling Tutorial Videos.

Try for FREE - NOW
To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Read before watching the free videos
The sound quality and frame rate of free online tutorials has been reduced to allow for faster streaming. The quality on CD / DVD is far higher.
Quicktime
*QuickTime is needed to view the videos. Some titles have been converted to play via Flash.
This tutorial can also be viewed using Flash:
Click To View in Flash
Welcome Welcome Demo
Prerequisites for this Course Demo
About this Course Demo
Where to Find Documentation Demo
Samples and Example Data Models Part pt. 1 Demo
Samples and Example Data Models Part pt. 2 Demo
A Relational Database Modeling Tool Demo
ERWin: Changing Physical Structure Demo
ERWin: Generating Scripts Demo
The History of Data Modeling What is a Data Model? Demo
Types of Data Models Demo
The Evolution of Data Modeling Demo
File Systems Demo
Hierarchical Databases Demo
Network Databases Demo
Relational Databases Demo
Object Databases Demo
Object-Relational Databases Demo
The History of the Relational Database Demo
Tools for Data Modeling Entity Relationship Diagrams Demo
Using ERWin Part pt. 1 Demo
Using ERWin Part pt. 2 Demo
Using ERWin Part pt. 3 Demo
Modeling in Microsoft Access Demo
The Parts of an Object Data Model Demo
Basic UML for Object Databases Demo
Building Class Structures Demo
Other UML Diagrams Demo
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
Introducing Data Modeling The Relational Data Model
The Object Data Model
The Object-Relational Data Model
Data Warehouse Data Modeling
Client-Server Versus OLTP Databases
Available Database Engines
Relational Data Modeling What is Normalization?
Normalization Made Simple
Relational Terms and Jargon
1st Normal Form
Demonstrating 1st Normal Form
2nd Normal Form
Demonstrating 2nd Normal Form
3rd Normal Form
Demonstrating 3rd Normal Form
4th and 5th Normal Forms
Primary/Foreign Keys/Referential Integrity
The Traditional Relational Database Model
Surrogate Keys and the Relational Model
Denormalization pt. 1
Denormalization pt. 2
Object Data Modeling The Object-Relational Database Model
Relational Versus Object Models
What is the Object Data Model?
What is a Class?
Again - a Class and an Object
What is an Attribute?
What is a Method?
The Simplicity of Objects
What is Inheritance?
What is Multiple Inheritance?
Some Specifics of the Object Data Model
Data Warehouse Data Modeling The Origin of Data Warehouses
Why the Relational Model Fails
The Dimensional Data Model Part pt. 1
The Dimensional Data Model Part pt. 2
Star Schemas and Snowflake Schemas
Data Warehouse Model Design Basics
Getting Data from a Database What is Structured Query Language (SQL)?
The Roots of SQL
Queries
Changing Data
Changing Metadata
What is ODQL?
Tuning a Relational Data Model Normalization Versus Denormalizatrion
Referential Integrity Part pt. 1
Referential Integrity Part pt. 2
Alternate Keys
What is an Index?
Indexing Considerations
Too Many Indexes
Composite Indexing
Which Columns to Index?
Index Types
Match Indexes to SQL Code
Types of Indexing in Detail pt. 1
Types of Indexing in Detail pt. 2
Where Index Types Apply
Undoing Normalization
What to Look For?
Undoing Normal Forms
Some Good and Bad Tricks Part pt. 1
Some Good and Bad Tricks Part pt. 2
Tuning a Data Warehouse Data Model Denormalization
Star Versus Snowflake Schemas
Dimensional Hierarchies
Specialized Data Warehouse Toys
Other Tricks RAID Arrays and Striping
Standby Databases
Replication
Clustering
Wrapping it Up Some Available Database Engines
The Future: Relational or Object?
What You Have Learned
Credits About the Author

Data Modeling Training CD Information

Title : Data Modeling
Tutor : Gavin Powell
Other tutorials and training by this author
Movies : 103 Lessons- Video run time: 6 Hours
Availability : Immediate Dispatch
Compatibility: Vista, 98, 2000, NT, XP, Mac OS, OSX
Released 2005-03-28
Price US / Canadian Sales $99.95

161 In Stock

Add to Cart

Why use this method of video training ?
  • Learn Data Modeling from an accredited expert in days.
  • Ideal for beginners, easy to follow videos that offer visual clarity.
  • Master a full application for a fraction of the cost of classroom based training.
  • Unique teaching method that offers accelerated learning and high retention.
  • Used by many large companies, schools, universities,
  • Learn from your own desk at a speed that suits you
  • Cost effective tuition from leading experts
  • You control the pace, training can be stopped, rewound or fast forwarded as required.

Associated Titles:

Free Certificate. Prove your credentials
online people


We now offer all customers a free certificate to verify they have undertaken a Data Modeling course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your Data Modeling certificate without delay.

Online University Access all our Training for only $30.00

Not sure which training CD titles to purchase ? Why not join our Online University and have unlimited access to all our titles for one low price ?

online people

over 4000 hours of high quality online training for only $30.00. Unlimited access

learn from your own desk -expert tutorials - affordable tuition.
No minimum sign up period.
Want to see how good our online university is? - Why not try a free Demo

For low monthly fee you have unlimited access to all the 300+ training titles in our range, that's over 35,000 tutorials covering 4000 hours+! Watch when ever you like, from any computer - NO LIMITS.

Join Today and learn quicker and cheaper than you ever thought possible.

Become a expert without having to read a book or attend expensive training courses.

Where else can you find step-by-step training for over 300 software applications delivered to your own desk, from a leading expert, for less then a Dollar a day ?

Want to see how good our online university is? - Why not try a free Demo, and if all that's not enough, we add new video tutorials each month for no extra charge!

Free Newsletter

If you would like to be notified as we release new video tutorials, run special offers, or promotions.
Sign up now. Your details are kept secure and never sold rented or used by any other 3rd parties.

Data Modeling Related Product Groups:

FileMaker Pro | Excel Tutorials | MySQL Access Tutorials | Oracle PL/SQL | Microsoft SQL Server 2000 Admin Microsoft SQL Server 2000 Programming | Online Data Modeling Training Courses