Self Study, Data Modeling Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.
These Data Modeling tutorials have been created for users that need to use large and complex data oriented structures. This training course is authored by Data Modeling expert Gavin Powell, the course starts by demonstrating examples of various Data Models before progressing to cover other topics that are essential in forming a solid understanding and practical knowledge of Data Modeling such as Network Databases, Entity Relationships, Object Data Models, SQL, QDQL and much more. This training course can be considered to be a definitive reference on Data Modeling
.
Data Modeling Tutorial CD / DVD
Creates the perfect self-paced learning environmenton your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.
Try for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.
- Professional Tuition by expert
- Free Certificate with each Tutorial
- Works on PC or Mac
Welcome
- 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
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 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
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
About this Data Modeling Training CD
| Title : | Data Modeling |
|---|---|
| Tutor : | Gavin Powell
Other tutorials by Gavin Powell |
| Videos : | 103 Lessons- Video run time: 6 Hours |
| Availability : | Immediate Dispatch |
| Compatibility: | Vista, 98, 2000, NT, XP, Mac OS, OSX |
| Released | 2005-03-28 |
| Price US / Canadian Sales | $99.95   |
119 In Stock
10 Multi User $500- Learn Data Modeling from an accredited expert in days.
- Ideal for beginners, easy to follow videos that offer visual clarity.
- Master a full application for a fraction of the cost of classroom based training, and faster than with a manual.
- Unique teaching method that offers accelerated learning and high retention.
- Used by many large companies, schools, universities,
click to see some of our customers. - Learn from your own desk at a speed that suits you
- Cost effective tuition from leading expert tutors
- You control the pace, training can be stopped, rewound or fast forwarded as required.
- High Quality Tutorial Videos on CD / DVD or Online. PC / Mac Compatible. Great tuition at an affordable price
Want to hear what our customers say about our products?
XML | Microsoft VB | C++ | C Programming | Crystal Reports
Not sure which training CD titles to purchase ? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
You can have access to every title we list on this site for just $30 per month. When you sign up you get instant access with absolutely no restrictions or limits. Log on from any location and watch as much as you like.
