Data Modeling Tutorial Video

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
Entity Relationship Diagrams Demo
Using ERWin Part pt. 1 Demo
Using ERWin Part pt. 2 Demo
Using ERWin Part pt. 3 Demo
Modeling in Microsoft Access Demo
The Parts of an Object Data Model Demo
Basic UML for Object Databases Demo
Building Class Structures Demo
Other UML Diagrams Demo

If you purchase the CD all the contents listed below are also included.

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