Data modeling is the act of exploring data-oriented structures. When building a database, data modeling implies the creation of a model for data within that database. Data models can be used for a variety of purposes, from high-level conceptual models to physical data models. VTC author, lt;a href= http://www.vtc.com/files/productlist.php?author=Gavin%20Powell target= _blank gt;Gavin Powelllt;/agt;, covers topics such as normalization and denormalization for relational data modeling, fact dimensional structures for data warehouse data modeling, and basic object data modeling for object databases. Powell also examines useful web sites and vendor software, such as Oracle database, for finding data modeling information. To being learning today, simply click on one of the lt;bgt;Data Modelinglt;/bgt; lessons.
WelcomeWelcomePrerequisites for this CourseAbout this CourseWhere to Find DocumentationSamples and Example Data Models Part pt. 1Samples and Example Data Models Part pt. 2A Relational Database Modeling ToolERWin: Changing Physical StructureERWin: Generating ScriptsThe History of Data ModelingWhat is a Data Model?Types of Data ModelsThe Evolution of Data ModelingFile SystemsHierarchical DatabasesNetwork DatabasesRelational DatabasesObject DatabasesObject-Relational DatabasesThe History of the Relational DatabaseTools for Data ModelingEntity Relationship DiagramsUsing ERWin Part pt. 1Using ERWin Part pt. 2Using ERWin Part pt. 3Modeling in Microsoft AccessThe Parts of an Object Data ModelBasic UML for Object DatabasesBuilding Class StructuresOther UML DiagramsIntroducing Data ModelingThe 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 ModelingWhat 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 ModelingThe 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 ModelingThe 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 DatabaseWhat is Structured Query Language (SQL)?
The Roots of SQL
Queries
Changing Data
Changing Metadata
What is ODQL?
Tuning a Relational Data ModelNormalization 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 ModelDenormalization
Star Versus Snowflake Schemas
Dimensional Hierarchies
Specialized Data Warehouse Toys
Other TricksRAID Arrays and Striping
Standby Databases
Replication
Clustering
Wrapping it UpSome Available Database Engines
The Future: Relational or Object?
What You Have Learned
CreditsAbout the Author
Click here to find out more about the Data Modeling Training CD 
