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 400 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 400+ 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 training 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, unlimited access, on over 400 different subjects for an amazing low price!
Benefits of Online Learning
  • Unlimited viewing.
  • 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.
  • 400+ 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 Microsoft Project 2007 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 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, 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 400 other 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 over 4000 hours worth of high quality training for just $30.00 a month.
Tutorials can also be viewed in Flash Format
Try a Free demo, click on any of the links below
Topics covered on this tutorial include:
Welcome
The History of Data Modeling
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

Title Data Modeling Training Course
Author Gavin Powell
Other Training Videos by this author
Duration 6 hours
Number of Movies 103
Only $30 a month
Unlimited Access to over 400 Titles (4000+ hours )
No Minimum Term - No Contract
Instant Access - No Restrictions
Join Now

Own this Training Course on CD

Data Modeling Training 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

Free Certification
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 8 Tutorial »
Autodesk Revit 9 Training »
AutoCAD 2007 Training »
Microsoft Project 2007 Tutorial »
Photoshop CS3 Training »
Beginners FileMaker 9 Tutorial »
PHP Training Video »
Sony Sound Forge 9 »
Apple Shake 4 Tutorial »
Microsoft Excel Training »
Adobe After Effects CS3 Training »

Customer Comments

This is best training I have ever seen. Your customer service is just amazing. I was referred by two friends who are both customers of Apex Web Media and now I will start referring people to Apex too. Keep up the great work and thank you.
William Riding
Pasadena