Easy to follow Data Modeling Tutorial Videos and online training courses. These professionally created videos offer the user an accelerated way to master this application from the comfort of their own desktop. In addition to the Data Modeling tutorials we also list over 600 additional titles amounting to over 4000 hours, get unlimited access to all these courses for just $30 per month.

Data Modeling Tutorial Video - Try for FREE

Unlimited Professional Video Training on over 600+ applications and programming languages for only $30.

The fastest and most cost effective way to learn!
Forget boring books! No need for expensive classroom training.

Easy to follow tutorial videos that play right from your own computer. Login from home or office -- the choice is yours. All tutorials are taught by world-leading experts, giving you unlimited access to over 600 different subjects for an amazing low price!

Benefits of Online Learning

Unlimited viewing. No Hidden Costs
Downloadable working files.
Instant Access
Expert instructors.
Use at home / work or both.
Works on PC or Mac.
Telephone Tech support.
Cancel at any time.
600+ courses for 1 low fee.
New titles added monthly.
100% Guaranteed

Your are currently in Demo Mode
You are in Demo mode which only allows access to the first 3 chapters of this Data Modeling training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining.

If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 600 professionally created video tutorials, you will be able to access the content from any location, no restrictions are placed on the amount of content you can watch, and you can also cancel at any time you wish.
Over 4000 hours of training for just $30.00.

Get Instant Access to this Training Title and over 600 other video tutorials for just $30
Once a member you will have instant unrestricted access to this and every other title listed on this site. That’s an Amazing 6000+ hours worth of high quality video training for just $30.00 a month.

Try a Free demo, Click on any of the links below

Topics covered on this tutorial video include:

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

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 Video Tutorial

Title Data Modeling Training Tutorial

Author Gavin Powell
Other Training Videos by this author

Duration 6 hours

Number of Videos 103

Only $30 a month
Unlimited Access to over 600 Titles (6000+ hours )
No Minimum Term - No Contract
Instant Access - No Restrictions

Own this Training Course on CD

Would you like to own this Data Modeling Training title on CD?

You may purchase it from our online store. Because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
Data Modeling tutorial on CD.

Free Certification - Prove Your Skills

After you have completed a tutorial, a Certificate of Completion can be obtained to verify that you have taken a particular course. All certificates are FREE, but the training course must be completed before a certificate can be issued.

Most Viewed Tutorials

Dreamweaver CS3 Tutorial Video »
Microsoft Word 2007 Training Video »
Adobe InDesign CS3 Tutorial Video »
Final Cut Pro 6 Tutorial Video »
3DS Max 2009 Tutorial »
Autodesk Revit 9 Training »
AutoCAD 2009 Tutorial »
Microsoft Project 2007 Tutorial »
Photoshop CS3 Training »
Beginners FileMaker 9 Tutorial »
PHP Training Video »
Adobe Illustrator CS3 Training »
Apple Shake 4 Tutorial »
Microsoft Excel Training »
Adobe After Effects CS3 Training »

Customer Comments

I have been meaning to take the time to jot an e-mail off to you guys. You were referred to me by a friend who found you on the Web. Apex Web Media has met and exceeded my expectations. Being able to speak with a live support technician is very helpful indeed. It's clear to me that I made the right choice. I would not hesitate to recommend you. Thanks!
Regards, Peter Brunswick
Guildford, Surrey (UK)