Find a Course...Try for FREE

Data Modeling Training Information
Author: Gavin Powell
Duration: 5 hrs
Video Lessons: 102
  30 Days Full Online Access:
  $30.00   $30.00
  €20.00   £15.00
  $35.00

  CLICK HERE to sign up
  (Instant Access to ALL Tutorials)

These tutorials are also available on CD ROM:
Data Modeling Tutorial on CD
Compatibility: Win Vista, XP, 2000, 98, NT, Mac OS X, OS 9


Training Categories
    Graphics & Page Layout
    Internet & Web Design
    Animation & 3D
    Multi Media & Video
    Business
    Certification
    Operating Systems
    Databases
    Programming
    Music & Audio
    Tutorials Coming Soon


Data Modeling Training Description
• Begin to get to grips with exploring data-oriented structures with the help of these online Data Modeling training tutorials.
• Using high quality video training movies, expert instructor, Gavin Powell, takes users through all the essential concepts such as normalization, dimensional structure, object data modeling, denormalization and so much more.
• This visual training method provides a higher learning retention level than most other training methods as each tutorial builds upon the last, reinforcing the points made.
• Start learning right away by viewing the FREE Data Modeling training tutorials by clicking any blue linked lesson above.

Data Modeling Training - FREE Tutorials

FREE Data Modeling Training
Learn Data Modeling in the shortest time possible, start now with the linked tutorials below:   (Please allow a few seconds to load)
To ensure the FREE tutorials below run smoothly, please view our short checklist - CLICK HERE

Welcome
Welcome
Prerequisites for this Course
About this Course
Where to Find Documentation
Samples and Example Data Models Part - Tuition 1
Samples and Example Data Models Part - Tuition 2
A Relational Database Modeling Tool
ERWin: Changing Physical Structure
ERWin: Generating Scripts

The History of Data Modeling
What is a Data Model?
Types of Data Models
The Evolution of Data Modeling
File Systems
Hierarchical Databases
Network Databases
Relational Databases
Object Databases
Object-Relational Databases
The History of the Relational Database

Tools for Data Modeling
Entity Relationship Diagrams
Using ERWin Part - Tuition 1
Using ERWin Part - Tuition 2
Using ERWin Part - Tuition 3
Modeling in Microsoft Access
The Parts of an Object Data Model
Basic UML for Object Databases
Building Class Structures
Other UML Diagrams

We hope you enjoyed the free lessons above. To view the complete contents including the chapters below, please purchase the CD. Alternatively you can sign up to the Online University and gain full, instant access to this, and all 450+ tutorials for only $30/£15 per month by clicking here
CLICK HERE TO BUY THIS TUTORIAL ON 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 - Tuition 1
Denormalization - Tuition 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 - Tuition 1
The Dimensional Data Model Part - Tuition 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 - Tuition 1
Referential Integrity Part - Tuition 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 - Tuition 1
Types of Indexing in Detail - Tuition 2
Where Index Types Apply
Undoing Normalization
What to Look For?
Undoing Normal Forms
Some Good and Bad Tricks Part - Tuition 1
Some Good and Bad Tricks Part - Tuition 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

CLICK HERE TO BUY THIS TUTORIAL ON CD




Sign up to the Online University and view over 400 titles for only $30/£15 per month
BENEFITS:
  1 Minimum Sign Up: ONLY ONE MONTH! - Cancel at any Time
  2 Unlimited Viewing
  3 Downloadable Working Files
  4 Learn from Expert Authors
  5 View on any Computer in the World
  6 Works on PC and Mac
  7 Full Support Offered
  8 450+ Courses for a Low Monthly Fee
  9 New Titles Added Weekly
  10 A Truely Professional Study Guide

Click here to sign up to the Online University

These tutorials are also available on CD ROM:
Data Modeling Tutorial on CD

Multi user options available for large organistions and education
CLICK Here for further info

Free Certificates available when each course has been completed


RECENTLY ADDED TUTORIALS
  ADOBE INDESIGN CS3
  ADOBE PHOTOSHOP CS3
  DREAMWEAVER CS3
  APPLE FINAL CUT PRO 6
  MAYA 8.5 FOR BEGINNERS
  POSER 7
  3DS MAX 2009
  MS PROJECT 2007
  ADOBE ILLUSTRATOR CS3
  MICROSOFT ACCESS 2007
  MICROSOFT VISTA
  ADOBE FLASH CS3
  AUTOCAD 2009