Learning Data Modeling

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

4.00 (536 reviews)
Udemy
platform
English
language
Other
category
instructor
Learning Data Modeling
4,393
students
8 hours
content
Jan 2017
last update
$49.99
regular price

What you will 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.

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.

Content

Getting Started

Important - Download These First - Working Files
About The Course
What Is A Database?
What Is A Data Model?
How To Access Your Working Files

Data Model Development Process

Data Model Inputs And Outputs
Data Model Notations
UML Versus IE - Conceptual, Logical And Physical

Basic Data Modeling

Class And Attribute
Operation
Domain
Association
IE Entity Type And Relationship Type
Association Name
Association End
Multiplicity - UML
Multiplicity - IE
Generalization - UML
Generalization - IE
Abstract Versus Concrete Superclass
Practical Tips
Self Assessment Test

Advanced Data Modeling

Identity
Derived Data
Current Versus Historical Data
Association Class
Ordered Association
Qualified Association - UML
Qualified Association - IE
Large Taxonomies
Package
Abridged UML Metamodel
Abridged IE Metamodel
Modeling Pitfalls
Practical Tips
Self Assessment Test

Create A UML Data Model

Problem Statement
Finding Classes
Finding Associations - Part 1
Finding Associations - Part 2
Finding Generalizations
Iterating And Refining The Model - Part 1
Iterating And Refining The Model - Part 2
Adding Attributes
Cleaning Up Layout
Simplifying The Model
Evolving A Model - Part 1
Evolving A Model - Part 2
Enterprise Architect Techniques - Part 1
Enterprise Architect Techniques - Part 2
Enterprise Architect Techniques - Part 3

Translate A UML Data Model Into An IE Data Model

Creating Subject Areas
Creating Entity Types
Creating Domains
Adding Attributes - Part 1
Adding Attributes - Part 2
Creating Relationship Types - Part 1
Creating Relationship Types - Part 2
Creating Relationship Types - Part 3
Subtyping
Adding Alternate Keys
Cleaning Up The Layout
ERwin Techniques - Part 1
ERwin Techniques - Part 2

Model Quality

Model Quality
Normal Forms
Constraints
Hillard Graph Complexity
Hoberman Data Model Scorecard

Kinds Of Data Models

Operational Data Models
Enterprise Data Models
Data Warehouses - Part 1
Data Warehouses - Part 2
Data Warehouses - Part 3
Master Data Models

Database Design

Schema Adjustments
Attribute Details - Part 1
Attribute Details - Part 2
Attribute Details - Part 3
Primary And Alternate Keys
Indexes
Referential Integrity - Part 1
Referential Integrity - Part 2
Check Constraints - Part 1
Check Constraints - Part 2
Views
Other Aspects Of Design
Self Assessment Test

Create A SQL Server Database

Creating A New Database
Executing Schema
Inspecting Metadata
Loading Sample Data
Querying Sample Data

Create An MS-Access Database

Generating An ERwin Schema
Creating Tables
Creating Indexes
Creating Constraints And Default Values
Defining Foreign Keys
Creating Views
Loading Sample Data
Querying Sample Data

Software Engineering

Development Frameworks
Agile Data Modelling
Documenting A Model - Part 1
Documenting A Model - Part 2
Presenting A Model

Data Modeling Patterns

Overview
Tree - Hardcoded
Tree - Simple
Tree - Structured
Tree - Overlapping
Tree - Changing Over Time
Tree - Degenerate Node and Edge

Database Reverse Engineering

Motives
Comparison With Forward Engineering
Outputs
Inputs
Process
Principles
Example - Part 1
Example - Part 2

Conclusion

Wrap-Up

Reviews

Esther
May 9, 2022
I like the visual presentation and logical walkthrough, but audio was awful. There was no intonation, extremely monotone, and one long run-on sentence. Difficult for intake.
Training01
April 9, 2022
Great materials and examples were applied, but the explanation/ presentation was very monotonous and I was struggling to complete the course.
Ali
November 20, 2021
Very nice course, however it could be much better if there was more notes on slides. Many of important slides have only very briefed key titles while they could have short description. In addition, the use of pointer could be much better, in many slides I lost which part of the slide is being presented since there was no visual pointing to components on the screen.
Cheryl
April 20, 2021
the resources cannot be opened unless you purchase the modeling software. Nothing in the course description said you needed to purchase special software to do this course.
Abhishek
May 18, 2017
The instructor is talking like a robot and feels like he is reading from some script without explaining much
Eric
February 20, 2017
Very solid course that covers fundamentals in detail and raises your awareness of other related areas.
Susan
January 16, 2017
So far, this is review for me from learning it a long time ago. I'm looking forward to the hands on material.
Tony
December 15, 2016
Mike comprehensively covered data modeling for the practitioner at the appropriate level of detail. I had knowledge gaps and needed a refresh. This course filled those gaps and rounded out my knowledge exactly like I wanted to. Highly recommend the course.
Gustavo
November 5, 2016
The teacher's tone takes a bit to get used to, but the content is very deep and very thorough. Far better than any other course I've taken.
Gary
September 17, 2016
more detailed than any other but it would difficult to follow if one has not some back ground in data modeling
Halle
July 5, 2016
Content is great and easy to understand. Pace is excellent. Tone is a little uninspired, however... Can't business data be fun somehow?
Brynne
June 15, 2016
The info is really informative and well-prepared, but the delivery and the pace leave something to be desired. Still, a helpful overview of a complex topic.
logan
February 17, 2016
They don't provide which version of the tools are needed for this course. and the instructor never responds to any of the students feedback.
Mohammad
December 4, 2015
We thank lecturer on this important information in the field of data analysis and the creation of databases I wish him well
Ruhi
January 13, 2015
The course helped me move my basic knowledge of ERWIN to the next level . I recommend the course for all those who aspire to know the modeling concepts of data . The course was gifted to me by my husband, thanks to him for searching this course for me .

Charts

Price

Learning Data Modeling - Price chart

Rating

Learning Data Modeling - Ratings chart

Enrollment distribution

Learning Data Modeling - Distribution chart
357982
udemy ID
11/27/2014
course created date
8/22/2020
course indexed date
Bot
course submited by