Data Modeling Tutorials
Online Contents For This Title
We have made some of the video tutorials for Data Modeling freely available to help you evaluate our training.
Click on any of the linked lesson listings below to preview FREE!
Title Description
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, Gavin Powell, 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 Data Modeling lessons.
Choose your media type:
|
Welcome
|
||
| Welcome | (02:27) | |
| Prerequisites for this Course | (01:23) | |
| About this Course | (02:59) | |
| Where to Find Documentation | (01:30) | |
| Samples and Example Data Models Part pt. 1 | (03:04) | |
| Samples and Example Data Models Part pt. 2 | (02:22) | |
| A Relational Database Modeling Tool | (04:25) | |
| ERWin: Changing Physical Structure | (02:29) | |
| ERWin: Generating Scripts | (01:02) | |
|
The History of Data Modeling
|
||
| What is a Data Model? | (02:28) | |
| Types of Data Models | (02:32) | |
| The Evolution of Data Modeling | (01:39) | |
| File Systems | (00:54) | |
| Hierarchical Databases | (01:33) | |
| Network Databases | (01:05) | |
| Relational Databases | (02:51) | |
| Object Databases | (01:56) | |
| Object-Relational Databases | (01:37) | |
| The History of the Relational Database | (04:15) | |
|
Tools for Data Modeling
|
||
| Entity Relationship Diagrams | (03:39) | |
| Using ERWin Part pt. 1 | (03:20) | |
| Using ERWin Part pt. 2 | (01:27) | |
| Using ERWin Part pt. 3 | (02:19) | |
| Modeling in Microsoft Access | (05:23) | |
| The Parts of an Object Data Model | (05:18) | |
| Basic UML for Object Databases | (02:20) | |
| Building Class Structures | (04:12) | |
| Other UML Diagrams | (04:15) | |
|
Introducing Data Modeling
|
||
| The Relational Data Model | (03:08) | |
| The Object Data Model | (03:03) | |
| The Object-Relational Data Model | (02:15) | |
| Data Warehouse Data Modeling | (04:17) | |
| Client-Server Versus OLTP Databases | (02:23) | |
| Available Database Engines | (02:43) | |
|
Relational Data Modeling
|
||
| What is Normalization? | (01:24) | |
| Normalization Made Simple | (01:54) | |
| Relational Terms and Jargon | (05:48) | |
| 1st Normal Form | (00:28) | |
| Demonstrating 1st Normal Form | (04:23) | |
| 2nd Normal Form | (01:25) | |
| Demonstrating 2nd Normal Form | (03:20) | |
| 3rd Normal Form | (01:43) | |
| Demonstrating 3rd Normal Form | (04:32) | |
| 4th and 5th Normal Forms | (06:01) | |
| Primary/Foreign Keys/Referential Integrity | (03:19) | |
| The Traditional Relational Database Model | (04:20) | |
| Surrogate Keys and the Relational Model | (05:38) | |
| Denormalization | (02:26) | |
|
Object Data Modeling
|
||
| The Object-Relational Database Model | (05:14) | |
| Relational Versus Object Models | (02:16) | |
| What is the Object Data Model? | (00:38) | |
| What is a Class? | (02:35) | |
| Again - a Class and an Object | (05:27) | |
| What is an Attribute? | (02:24) | |
| What is a Method? | (03:17) | |
| The Simplicity of Objects | (05:10) | |
| What is Inheritance? | (02:23) | |
| What is Multiple Inheritance? | (02:45) | |
| Some Specifics of the Object Data Model | (05:33) | |
|
Data Warehouse Data Modeling
|
||
| The Origin of Data Warehouses | (04:52) | |
| Why the Relational Model Fails | (02:35) | |
| The Dimensional Data Model Part pt. 1 | (04:30) | |
| The Dimensional Data Model Part pt. 2 | (02:05) | |
| Star Schemas and Snowflake Schemas | (02:32) | |
|
Getting Data from a Database
|
||
| What is Structured Query Language (SQL)? | (03:00) | |
| The Roots of SQL | (01:15) | |
| Queries | (01:44) | |
| Changing Data | (01:57) | |
| Changing Metadata | (02:06) | |
| What is ODQL? | (02:12) | |
|
Tuning a Relational Data Model
|
||
| Normalization Versus Denormalizatrion | (05:05) | |
| Referential Integrity Part pt. 1 | (04:45) | |
| Referential Integrity Part pt. 2 | (05:00) | |
| Alternate Keys | (05:04) | |
| What is an Index? | (01:57) | |
| Indexing Considerations | (01:07) | |
| Too Many Indexes | (04:20) | |
| Composite Indexing | (02:54) | |
| Which Columns to Index? | (02:17) | |
| Index Types | (04:12) | |
| Match Indexes to SQL Code | (04:52) | |
| Types of Indexing in Detail pt. 1 | (03:29) | |
| Types of Indexing in Detail pt. 2 | (04:21) | |
| Where Index Types Apply | (01:33) | |
| Undoing Normalization | (01:08) | |
| What to Look For? | (05:35) | |
| Undoing Normal Forms | (06:19) | |
| Some Good and Bad Tricks Part pt. 1 | (03:35) | |
| Some Good and Bad Tricks Part pt. 2 | (04:06) | |
|
Tuning a Data Warehouse Data Model
|
||
| Denormalization | (05:05) | |
| Star Versus Snowflake Schemas | (01:32) | |
| Dimensional Hierarchies | (01:33) | |
| Specialized Data Warehouse Toys | (03:10) | |
|
Other Tricks
|
||
| RAID Arrays and Striping | (02:30) | |
| Standby Databases | (02:48) | |
| Replication | (01:48) | |
| Clustering | (01:00) | |
|
Wrapping it Up
|
||
| Some Available Database Engines | (04:54) | |
| The Future: Relational or Object? | (04:19) | |
| What You Have Learned | (00:49) | |
|
Credits
|
||
| About the Author | (02:20) | |
This title is just part of the entire VTC collection of over 625 courses, 66,000 video tutorials (12,500+ free), available to you for just $30 a month.
Tutorial Information
| Title: | Data Modeling |
| Author: | Gavin Powell |
| SKU: | 33607 |
| ISBN: | 1-932808-52-3 |
| Release Date: | 2005-03-28 |
| Duration: | 5.5 hrs / 102 lessons |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
Subscription / Purchase Information
This title is just part of the entire VTC collection of over 625 courses, 65,000 video tutorials (12,500+ free), available to you for just $30 a month.
Select Bandwidth
Now Shipping
Client Testimonials
You guys are great; your tutorials are outstanding. Thumbs up to Mark Bremmer for the Carrara 5 tutorials. He is an excellent teacher.
Todd Price
United States
View All Titles 
Email this Page
Send us Feedback
Purchase/Add to Cart