Data Modeling Training Video - Tutorial CD

This Data Modeling Training Video series details how to build and use databases. Authored by Gavin Powell, this training course covers in detail such subjects as normalization and dimensional data structures. Aimed at the beginner, this Training Video is an ideal learning and reference aid. Training topics covered in this course include File Systems, Object Databases, Access, UML, Relational Data Models, SQL, Metadata, Keys, Index Types, Clustering and a lot more. All lessons are available online or on CD / DVD. To learn more, see the free demos below. This Data Modeling Tutorial is the ideal way to learn at your own pace.

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

This Data Modeling Training video utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that bring a high degree of visual clarity to even the most complex applications. Being over 5.5 hours long this Data Modeling Training on CD / DVD is extremely comprehensive and easy to follow. Video Tutorial taught by Experts - Low Cost

- Easy to Learn
Evaluate the high quality of this Tutorial
try a free demo Below.

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

Select your PlayBack Preference
Quick Time Flash

Topics covered on this Tutorial Video
are Listed Below:-

Welcome The History of Data Modeling Tools for Data Modeling

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

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
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
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

When you order this Data Modeling Training CD you'll receive:-

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

Data Modeling

Gavin Powell

5.5 hours - 102 Movies

US$ 99.95

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

Ground / 2 day / Next Day

33607

140 In Stock
Purchase Orders from Schools, Colleges and Government accepted

Multi User Version Available

This training video is also available in Multi User format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.
$500

Benefits of this Training Video

  • Learn Data Modeling in the shortest time possible
  • Self paced tutorial, training on video, learn at your own pace
  • Just sit back and watch, no books to read, just easy to follow lessons
  • Training can be viewed from any location, on PC or Mac
  • All training is self-contained; you dont even need the application you are learning loaded on your machine
  • The most affordable way to learn, benefit from a world-leading expert
  • High quality content for a fraction of the cost of a classroom training course
  • The tutorials can be rewound, fast forwarded or stopped at any time
  • Learn Data Modeling from the comfort of your own desk.

Prove your Skills. Free Certification

  • With every tutorial purchased a certificate is provided to prove you have embarked upon a course to improve your skills and expand your working knowledge. Each certificate has a unique verification number which enables third parties to check the authenticity of the certification using a special login verification process.


Apex Web Media ( Hyperteach )
P.O Box 398 Bolton BL7 9YS, United Kingdom.
Tel: +44 (0) 1204 592071
Fax: +44 (0) 1204 592092
Email:


Apex Web Media ( Hyperteach )
600 17th Street, Suite 2800, Denver CO 80202
Tel: Toll free 1866 402 1903 (USA) / 434 878 4158
Fax: 1 207 433 4356
Email: