
Data Modeling
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, <a href=\'http://www.vtc.com/files/productlist.php?author=Gavin%20Powell\' target=\'_blank\'>Gavin Powell</a>, 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 <b>Data Modeling</b> lessons.
Course content
Welcome9 lessons
- Welcome2:27Free
- Prerequisites for this Course1:23Free
- About this Course2:59Free
- Where to Find Documentation1:30Free
- Samples and Example Data Models Part pt. 13:04Free
- Samples and Example Data Models Part pt. 22:22Free
- A Relational Database Modeling Tool4:25Free
- ERWin: Changing Physical Structure2:29Free
- ERWin: Generating Scripts1:02Free
The History of Data Modeling10 lessons
- What is a Data Model?2:281 credit or ad
- Types of Data Models2:321 credit or ad
- The Evolution of Data Modeling1:391 credit or ad
- File Systems0:541 credit or ad
- Hierarchical Databases1:331 credit or ad
- Network Databases1:051 credit or ad
- Relational Databases2:511 credit or ad
- Object Databases1:561 credit or ad
- Object-Relational Databases1:371 credit or ad
- The History of the Relational Database4:151 credit or ad
Tools for Data Modeling9 lessons
- Entity Relationship Diagrams3:391 credit or ad
- Using ERWin Part pt. 13:201 credit or ad
- Using ERWin Part pt. 21:271 credit or ad
- Using ERWin Part pt. 32:191 credit or ad
- Modeling in Microsoft Access5:231 credit or ad
- The Parts of an Object Data Model5:181 credit or ad
- Basic UML for Object Databases2:201 credit or ad
- Building Class Structures4:121 credit or ad
- Other UML Diagrams4:151 credit or ad
Introducing Data Modeling6 lessons
Relational Data Modeling14 lessons
- What is Normalization?1:241 credit or ad
- Normalization Made Simple1:541 credit or ad
- Relational Terms and Jargon5:481 credit or ad
- 1st Normal Form0:281 credit or ad
- Demonstrating 1st Normal Form4:231 credit or ad
- 2nd Normal Form1:251 credit or ad
- Demonstrating 2nd Normal Form3:201 credit or ad
- 3rd Normal Form1:431 credit or ad
- Demonstrating 3rd Normal Form4:321 credit or ad
- 4th and 5th Normal Forms6:011 credit or ad
- Primary/Foreign Keys/Referential Integrity3:191 credit or ad
- The Traditional Relational Database Model4:201 credit or ad
- Surrogate Keys and the Relational Model5:381 credit or ad
- Denormalization2:261 credit or ad
Object Data Modeling11 lessons
- The Object-Relational Database Model5:141 credit or ad
- Relational Versus Object Models2:161 credit or ad
- What is the Object Data Model?0:381 credit or ad
- What is a Class?2:351 credit or ad
- Again - a Class and an Object5:271 credit or ad
- What is an Attribute?2:241 credit or ad
- What is a Method?3:171 credit or ad
- The Simplicity of Objects5:101 credit or ad
- What is Inheritance?2:231 credit or ad
- What is Multiple Inheritance?2:451 credit or ad
- Some Specifics of the Object Data Model5:331 credit or ad
Data Warehouse Data Modeling5 lessons
Getting Data from a Database6 lessons
Tuning a Relational Data Model19 lessons
- Normalization Versus Denormalizatrion5:051 credit or ad
- Referential Integrity Part pt. 14:451 credit or ad
- Referential Integrity Part pt. 25:001 credit or ad
- Alternate Keys5:041 credit or ad
- What is an Index?1:571 credit or ad
- Indexing Considerations1:071 credit or ad
- Too Many Indexes4:201 credit or ad
- Composite Indexing2:541 credit or ad
- Which Columns to Index?2:171 credit or ad
- Index Types4:121 credit or ad
- Match Indexes to SQL Code4:521 credit or ad
- Types of Indexing in Detail pt. 13:291 credit or ad
- Types of Indexing in Detail pt. 24:211 credit or ad
- Where Index Types Apply1:331 credit or ad
- Undoing Normalization1:081 credit or ad
- What to Look For?5:351 credit or ad
- Undoing Normal Forms6:191 credit or ad
- Some Good and Bad Tricks Part pt. 13:351 credit or ad
- Some Good and Bad Tricks Part pt. 24:061 credit or ad