Learning Data Modeling

  1. Home
  2. Data-modeling
  3. Learning Data Modeling

Tags: Data Modeling

A step by step guide to data modeling concepts and best practices underpinning sound database design.

Last updated 2022-01-10 | 4.3

- conceptually plan a coherent data model to plan and design enterprise-quality databases.
- differentiate between UML and IE data models.
- create databases with SQL and Microsoft Access.

What you'll learn

conceptually plan a coherent data model to plan and design enterprise-quality databases.
differentiate between UML and IE data models.
create databases with SQL and Microsoft Access.

* Requirements

* some knowledge of programming principles is strongly recommended.

Description

Truly effective database design depends on having a coherent data model to work from. This course will help you learn the theory and process of creating data models suitable for everything from small business to enterprise and data center environments. Michael Blaha will teach you how to plan and construct data models, as well as build upon those models through an actual database. 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.

Who this course is for:

  • developers and IT professionals who want a thorough understanding of formal data concepts and models as they relate to database design.

Course content

15 sections • 122 lectures

Getting Started 5 lectures

Important - Download These First - Working Files Preview 00:01

About The Course Preview 03:24

What Is A Database? Preview 02:23

What Is A Data Model? Preview 01:52

How To Access Your Working Files Preview 03:22

Data Model Development Process 3 lectures

Data Model Inputs And Outputs Preview 02:05

Data Model Notations Preview 03:00

UML Versus IE - Conceptual, Logical And Physical Preview 01:19

Basic Data Modeling 14 lectures

Class And Attribute Preview 06:11

Operation Preview 01:32

Domain Preview 03:54

Association Preview 04:59

IE Entity Type And Relationship Type Preview 03:15

Association Name Preview 04:46

Association End Preview 04:09

Multiplicity - UML Preview 03:40

Multiplicity - IE Preview 02:31

Generalization - UML Preview 03:32

Generalization - IE Preview 04:06

Abstract Versus Concrete Superclass Preview 02:11

Practical Tips Preview 01:58

Self Assessment Test Preview 04:43

Advanced Data Modeling 14 lectures

Identity Preview 02:34

Derived Data Preview 02:33

Current Versus Historical Data Preview 01:07

Association Class Preview 05:20

Ordered Association Preview 05:25

Qualified Association - UML Preview 05:12

Qualified Association - IE Preview 02:35

Large Taxonomies Preview 03:05

Package Preview 02:46

Abridged UML Metamodel Preview 02:04

Abridged IE Metamodel Preview 01:14

Modeling Pitfalls Preview 03:27

Practical Tips Preview 01:47

Self Assessment Test Preview 03:44

Create A UML Data Model 15 lectures

Problem Statement Preview 01:52

Finding Classes Preview 04:32

Finding Associations - Part 1 Preview 04:59

Finding Associations - Part 2 Preview 05:52

Finding Generalizations Preview 01:37

Iterating And Refining The Model - Part 1 Preview 02:39

Iterating And Refining The Model - Part 2 Preview 04:42

Adding Attributes Preview 04:48

Cleaning Up Layout Preview 04:04

Simplifying The Model Preview 01:55

Evolving A Model - Part 1 Preview 02:13

Evolving A Model - Part 2 Preview 04:46

Enterprise Architect Techniques - Part 1 Preview 03:48

Enterprise Architect Techniques - Part 2 Preview 05:19

Enterprise Architect Techniques - Part 3 Preview 04:24

Translate A UML Data Model Into An IE Data Model 13 lectures

Creating Subject Areas Preview 02:38

Creating Entity Types Preview 02:44

Creating Domains Preview 06:13

Adding Attributes - Part 1 Preview 06:13

Adding Attributes - Part 2 Preview 03:25

Creating Relationship Types - Part 1 Preview 05:04

Creating Relationship Types - Part 2 Preview 03:33

Creating Relationship Types - Part 3 Preview 05:07

Subtyping Preview 03:20

Adding Alternate Keys Preview 03:36

Cleaning Up The Layout Preview 01:38

ERwin Techniques - Part 1 Preview 04:58

ERwin Techniques - Part 2 Preview 03:59

Model Quality 5 lectures

Model Quality Preview 01:01

Normal Forms Preview 04:01

Constraints Preview 03:26

Hillard Graph Complexity Preview 07:04

Hoberman Data Model Scorecard Preview 05:21

Kinds Of Data Models 6 lectures

Operational Data Models Preview 03:30

Enterprise Data Models Preview 05:33

Data Warehouses - Part 1 Preview 05:12

Data Warehouses - Part 2 Preview 04:53

Data Warehouses - Part 3 Preview 03:14

Master Data Models Preview 04:08

Database Design 13 lectures

Schema Adjustments Preview 04:47

Attribute Details - Part 1 Preview 04:27

Attribute Details - Part 2 Preview 06:27

Attribute Details - Part 3 Preview 07:44

Primary And Alternate Keys Preview 08:09

Indexes Preview 06:44

Referential Integrity - Part 1 Preview 08:22

Referential Integrity - Part 2 Preview 06:27

Check Constraints - Part 1 Preview 06:44

Check Constraints - Part 2 Preview 07:07

Views Preview 08:44

Other Aspects Of Design Preview 03:52

Self Assessment Test Preview 03:14

Create A SQL Server Database 5 lectures

Creating A New Database Preview 03:39

Executing Schema Preview 02:29

Inspecting Metadata Preview 08:32

Loading Sample Data Preview 04:03

Querying Sample Data Preview 06:33

Create An MS-Access Database 8 lectures

Generating An ERwin Schema Preview 03:08

Creating Tables Preview 06:16

Creating Indexes Preview 03:22

Creating Constraints And Default Values Preview 02:51

Defining Foreign Keys Preview 03:44

Creating Views Preview 04:32

Loading Sample Data Preview 03:55

Querying Sample Data Preview 04:21

Software Engineering 5 lectures

Development Frameworks Preview 03:24

Agile Data Modelling Preview 03:18

Documenting A Model - Part 1 Preview 03:49

Documenting A Model - Part 2 Preview 04:25

Presenting A Model Preview 02:45

Data Modeling Patterns 7 lectures

Overview Preview 01:37

Tree - Hardcoded Preview 01:25

Tree - Simple Preview 01:37

Tree - Structured Preview 01:16

Tree - Overlapping Preview 04:05

Tree - Changing Over Time Preview 03:21

Tree - Degenerate Node and Edge Preview 01:29

Database Reverse Engineering 8 lectures

Motives Preview 01:29

Comparison With Forward Engineering Preview 02:20

Outputs Preview 01:07

Inputs Preview 02:08

Process Preview 05:34

Principles Preview 01:41

Example - Part 1 Preview 05:54

Example - Part 2 Preview 08:07

Conclusion 1 lectures

Wrap-Up Preview 06:19