Data Modeling Training Video - Tutorial CD

Affordable Training you can depend on. Learn from an Expert from the comfort of your own desk, at a pace that suits you.

Benefits

• Works on PC or Mac
• Professional Tutition by Experts
• Self-Paced Learning Interface
• Builds Practical Skills Quickly
• Rapid Learning - High Retention
• Free Certificate with each Tutorial

Client Testimonials

• 'I love your PageMill training CD it is concise and to the point. I will continue to purchase other products from your company.'
  Wallace Brown
  Prosperity Portraits & Products, Ltd.,
  Hazel Crest, IL;

Just Released Training

Just Released this week.
• 
Poser 8 Tutorial Video

Select your PlayBack Preference
QuickTime Flash

Topics covered on this Tutorial Video
are Listed Below:-

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

• 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

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

The purchased version of this Training contains all the movies listed below as well as all the featured Movies above. US$ 99.95

• 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

• 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

• 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

• 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

• What is Structured Query Language (SQL)?
• The Roots of SQL
• Queries
• Changing Data
• Changing Metadata
• What is ODQL?

• 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

• Denormalization
• Star Versus Snowflake Schemas
• Dimensional Hierarchies
• Specialized Data Warehouse Toys

• RAID Arrays and Striping
• Standby Databases
• Replication
• Clustering

• Some Available Database Engines
• The Future: Relational or Object?
• What You Have Learned

• About the Author

An effective Tutorial Video that teaches using practical based examples and easy to follow instructions.

A self-paced learning interface that simplifies learning and breaks even the most complex topics down into easy to follow step-by-step instructions making it ideal for users of all levels

A proven video training product that's created by professionals and used by companies, schools, government and individuals the World over.

A verifiable Certificate Proving your Skills

Data Modeling Training - VIDEO INFO

TitleData Modeling

TutorGavin Powell

Duration5.5 hours - 102 Movies

Price US$ 99.95

OSWin 7, Vista XP, 2000, 98. Mac OS X

Delivery Ground / 2 day / Next Day

Product Code33607