Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both 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

Associated Tutorials: XML | Microsoft VB | C++ | Beginners C Tutorial Video | Database Optimization | Beginners FileMaker | MySQL 5 Development

Data Modeling Tutorial CD / DVD

When you order this Data Modeling Video Tutorial CD You'll Receive...
Over 6 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn Data Modeling from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" I just wanted to say your videos are great. Customer service was also friendly and everything got here on time. "Patrick Ford, Hawaii

Data Modeling Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 6 Hours in Duration and Covers 103 Lessons.
Welcome The History of Data Modeling Tools for Data Modeling
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
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 Lesson 1
  • The Dimensional Data Model Part Lesson 2
  • Star Schemas and Snowflake Schemas
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 Lesson 1
  • Referential Integrity Part Lesson 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 Lesson 1
  • Types of Indexing in Detail Lesson 2
  • Where Index Types Apply
  • Undoing Normalization
  • What to Look For?
  • Undoing Normal Forms
  • Some Good and Bad Tricks Part Lesson 1
  • Some Good and Bad Tricks Part Lesson 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

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

About this Data Modeling Training CD

Title Data Modeling
Tutor Gavin Powell
Other tutorials by Gavin Powell
Videos 103 Lessons- Video run time: 6 hours
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2005
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are not available on this title
14 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract .
No minimum period.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn Data Modeling from an accredited expert in days.

Want to hear what our customers say about our products?

Related Training Videos

Oracle PL/SQL | Microsoft SQL Server Admin Tutorials | Microsoft SQL Server Programming| Online Data Modeling Training Courses

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.