O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Learning Data Modeling

Video Description

In this Learning Data Modeling training course, expert author Michael Blaha will teach you how to build data models, as well as prepare a data model for simple problems. This course is designed for users that have some programming experience, however, no data modeling experience is needed.
You will start by learning about the data modeling development process, then jump into basic and advanced data modeling. From there, Michael will teach you how to create a UML data model, including finding classes, adding attributes, and simplifying the model. This video tutorial also covers how to translate a UML data model into an IE data model, model quality, the different kinds of data models, and database design. You will also learn how to create an SQL server database, an MS-Access database, and develop frameworks. Finally, Michael will teach you about data modeling patterns and database reverse engineering.
Once you have completed this computer based training course, you will be fully capable of creating your own data models. Working files are included, allowing you to follow along with the author throughout the lessons.

"Download the working files for this course at http://examples.oreilly.com/0636920038696/

Table of Contents

  1. Getting Started
    1. About The Course 00:03:24
    2. About The Author 00:02:49
    3. What Is A Database? 00:02:23
    4. What Is A Data Model? 00:01:52
    5. How To Access Your Working Files 00:01:15
  2. Data Model Development Process
    1. Data Model Inputs And Outputs 00:02:06
    2. Data Model Notations 00:03:00
    3. UML Versus IE - Conceptual, Logical And Physical 00:01:19
  3. Basic Data Modeling
    1. Class And Attribute 00:06:12
    2. Operation 00:01:32
    3. Domain 00:03:55
    4. Association 00:05:00
    5. IE Entity Type And Relationship Type 00:03:15
    6. Association Name 00:04:46
    7. Association End 00:04:09
    8. Multiplicity - UML 00:03:40
    9. Multiplicity - IE 00:02:32
    10. Generalization - UML 00:03:32
    11. Generalization - IE 00:04:06
    12. Abstract Versus Concrete Superclass 00:02:11
    13. Practical Tips 00:01:59
    14. Self Assessment Test 00:04:44
  4. Advanced Data Modeling
    1. Identity 00:02:35
    2. Derived Data 00:02:34
    3. Current Versus Historical Data 00:01:07
    4. Association Class 00:05:21
    5. Ordered Association 00:05:26
    6. Qualified Association - UM 00:05:12
    7. Qualified Association - IE 00:02:36
    8. Large Taxonomies 00:03:05
    9. Package 00:02:46
    10. Abridged UML Metamodel 00:02:04
    11. Abridged IE Metamodel 00:01:14
    12. Modeling Pitfalls 00:03:27
    13. Practical Tips 00:01:47
    14. Self Assessment Test 00:03:45
  5. Create A UML Data Model
    1. Problem Statement 00:01:52
    2. Finding Classes 00:04:32
    3. Finding Associations - Part 1 00:05:00
    4. Finding Associations - Part 2 00:05:53
    5. Finding Generalizations 00:01:37
    6. Iterating And Refining The Model - Part 1 00:02:39
    7. Iterating And Refining The Model - Part 2 00:04:42
    8. Adding Attributes 00:04:48
    9. Cleaning Up Layout 00:04:04
    10. Simplifying The Model 00:01:55
    11. Evolving A Model - Part 1 00:02:13
    12. Evolving A Model - Part 2 00:04:46
    13. Enterprise Architect Techniques - Part 1 00:03:48
    14. Enterprise Architect Techniques - Part 2 00:05:20
    15. Enterprise Architect Techniques - Part 3 00:04:25
  6. Translate A UML Data Model Into An IE Data Model
    1. Creating Subject Areas 00:02:39
    2. Creating Entity Types 00:02:44
    3. Creating Domains 00:06:13
    4. Adding Attributes - Part 1 00:06:14
    5. Adding Attributes - Part 2 00:03:25
    6. Creating Relationship Types - Part 1 00:05:04
    7. Creating Relationship Types - Part 2 00:03:34
    8. Creating Relationship Types - Part 3 00:05:07
    9. Subtyping 00:03:20
    10. Adding Alternate Keys 00:03:36
    11. Cleaning Up The Layout 00:01:38
    12. ERwin Techniques - Part 1 00:04:58
    13. ERwin Techniques - Part 2 00:04:00
  7. Model Quality
    1. Model Quality 00:01:02
    2. Normal Forms 00:04:02
    3. Constraints 00:03:27
    4. Hillard Graph Complexity 00:07:04
    5. Hoberman Data Model Scorecard 00:05:21
  8. Kinds Of Data Models
    1. Operational Data Models 00:03:30
    2. Enterprise Data Models 00:05:34
    3. Data Warehouses - Part 1 00:05:12
    4. Data Warehouses - Part 2 00:04:54
    5. Data Warehouses - Part 3 00:03:15
    6. Master Data Models 00:04:08
  9. Database Design
    1. Schema Adjustments 00:04:48
    2. Attribute Details - Part 1 00:04:27
    3. Attribute Details - Part 2 00:06:28
    4. Attribute Details - Part 3 00:07:44
    5. Primary And Alternate Keys 00:08:09
    6. Indexes 00:06:45
    7. Referential Integrity - Part 1 00:08:22
    8. Referential Integrity - Part 2 00:06:28
    9. Check Constraints - Part 1 00:06:45
    10. Check Constraints - Part 2 00:07:08
    11. Views 00:08:44
    12. Other Aspects Of Design 00:03:53
    13. Self Assessment Test 00:03:15
  10. Create A SQL Server Database
    1. Creating A New Database 00:03:39
    2. Executing Schema 00:02:29
    3. Inspecting Metadata 00:08:33
    4. Loading Sample Data 00:04:03
    5. Querying Sample Data 00:06:34
  11. Create An MS-Access Database
    1. Generating An ERwin Schema 00:03:08
    2. Creating Tables 00:06:17
    3. Creating Indexes 00:03:22
    4. Creating Constraints And Default Values 00:02:52
    5. Defining Foreign Keys 00:03:44
    6. Creating Views 00:04:32
    7. Loading Sample Data 00:03:55
    8. Querying Sample Data 00:04:21
  12. Software Engineering
    1. Development Frameworks 00:03:25
    2. Agile Data Modelling 00:03:19
    3. Documenting A Model - Part 1 00:03:49
    4. Documenting A Model - Part 2 00:04:25
    5. Presenting A Model 00:02:45
  13. Data Modeling Patterns
    1. Overview 00:01:37
    2. Tree - Hardcoded 00:01:26
    3. Tree - Simple 00:01:37
    4. Tree - Structured 00:01:16
    5. Tree - Overlapping 00:04:06
    6. Tree - Changing Over Time 00:03:22
    7. Tree - Degenerate Node and Edge 00:01:29
  14. Database Reverse Engineering
    1. Motives 00:01:30
    2. Comparison With Forward Engineering 00:02:21
    3. Outputs 00:01:08
    4. Inputs 00:02:08
    5. Process 00:05:35
    6. Principles 00:01:41
    7. Example - Part 1 00:05:54
    8. Example - Part 2 00:08:08
  15. Conclusion
    1. Wrap-Up 00:06:19