Data Modeling Tutorial - Training Videos

Training CDs > Databases Tutorial Videos > DATA MODELING

Affordable Training you can depend on
This Data Modeling video tutorial utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that brings a high degree of visual clarity to even the most complex applications. Being over 5.5 hours long these Data Modeling tutorials are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Training CDs to buy?
The Online University allows unlimited access to the entire range of training titles for one low fee of only $30 per month. There is no fixed term, no limits, and you can cancel at any time. For corporate users and schools we also offer multi user accounts.
Find out more about the online video tutorials »

About the Free Video Online Training Course Demos
To allow you to evaluate the quality of the Data Modeling training course we have made the first 3 chapters of this tutorial available for free viewing online, the purchased version of this training course contains all the topics listed below. The free demos below have been compressed for faster playback over the internet, the audio and video quality of the purchased CD / DVD is far greater. To play the free demo videos you will need QuickTime,

THIS TUTORIAL COVERS THE FOLLOWING SUBJECTS

Description

This Data Modeling tutorial details how to build and use databases. Authored by Gavin Powell this training CD covers in detail such subjects as normalization and dimensional data structures. Aimed towards the beginner this training CD is an ideal learning and reference aid, topics covered on this tutorial include: File Systems, Object Databases, Access, UML, Relational Data Models, SQL, Metadata, Keys, Index Types, Clustering and a lot more.

Data Modeling Related Groups

Hide Description

The Blue Links below are free demos, when you purchase the video training CD / DVD the enitre content listings below are included , not just the free demo videos.

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

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

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 Tutorials - VIDEO INFO

» Studio quality audio and video
» Works on Pc or Mac
» Ideal for people that learn quicker by being shown
» Master complex application in days

Title	:	Data Modeling
Instructor	:	Gavin Powell
Price	:	US$ 99.95
Duration	:	5.5 hours - 102 Movies
OS	:	Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options	:	Ground / 2 day / Next Day
Product Code	:	33607

BENEFITS OF THIS TRAINING COURSE

Master Data Modeling in the shortest time possible
Self paced tutorial, training on video, at your own pace
Just sit back and watch, no books to read, just easy to follow lessons
Training can be viewed from any location, on PC or Mac
All training is self-contained; you don’t even need the application you are learning loaded on your machine
The most affordable way to learn, benefit from a world-leading expert
High quality content for a fraction of the cost of a classroom training course
The Tutorials can be rewound, fast forwarded or stopped at any time
Learn from the comfort of your own desk.