Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.
Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials please do not hesitate to contact us for download help.
- See right for full details on this Data Modeling Tutorial
- See far right to purchase this Data Modeling Training CD
Data Modeling Tutorial
Professionally created, self-study video training.
If you really want to get to grips with creating models for data then you might like to take a look at this beginners Data Modeling tutorial. Expert author Gavin Powell covers topics such as denormalization,
normalization, basic object data modeling as well as other techniques and concepts, which
are all explained in an easy to follow manner.
Try this training now - See below for FREE tutorials
All Courses on 1 or 2 CDs
For Mac and PC
Complete CD Contents and FREE Video Tutorials
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left
We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters below, please purchase the CD. CLICK HERE TO BUY THIS CD
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 - Lesson 1
Denormalization - Lesson 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 - Lesson 1
The Dimensional Data Model Part - Lesson 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 Denormalization
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
UK & Europe
Marrutt Software Training
Bellbrook Industrial Estate
Uckfield, East Sussex, TN22 1QL
United Kingdom
UK Tel: +44 (0) 1825 764057
UK Fax: +44 (0) 1825 768841
US & Canada
Marrutt Software Training
1133 Broadway, Suite 706
New York, NY 10010
United States
US Tel: 646-736-7932
US Fax: 646-895-7649
Complete CD Contents and FREE Video Tutorials 
UK & Europe
US & Canada