Learning Data Modeling

A step by step guide to data modeling concepts and best practices underpinning sound database design.
3.8 (50 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,535 students enrolled
$50
Take This Course
  • Lectures 122
  • Contents Video: 8 hours
    Other: 0 mins
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2014 English

Course 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.

What are the requirements?

  • some knowledge of programming principles is strongly recommended.

What am I going to get from this course?

  • 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 is the target audience?

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started
Important - Download These First - Working Files
Preview
Article
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
Section 2: Data Model Development Process
Data Model Inputs And Outputs
02:05
Data Model Notations
03:00
UML Versus IE - Conceptual, Logical And Physical
01:19
Section 3: Basic Data Modeling
Class And Attribute
06:11
Operation
01:32
Domain
03:54
Association
04:59
IE Entity Type And Relationship Type
03:15
Association Name
04:46
Association End
04:09
Multiplicity - UML
03:40
Multiplicity - IE
02:31
Generalization - UML
03:32
Generalization - IE
04:06
Abstract Versus Concrete Superclass
02:11
Practical Tips
01:58
Self Assessment Test
04:43
Section 4: Advanced Data Modeling
Identity
02:34
Derived Data
02:33
Current Versus Historical Data
01:07
Association Class
05:20
Ordered Association
05:25
Qualified Association - UML
05:12
Qualified Association - IE
02:35
Large Taxonomies
03:05
Package
02:46
Abridged UML Metamodel
02:04
Abridged IE Metamodel
01:14
Modeling Pitfalls
03:27
Practical Tips
01:47
Self Assessment Test
03:44
Section 5: Create A UML Data Model
Problem Statement
01:52
Finding Classes
04:32
Finding Associations - Part 1
04:59
Finding Associations - Part 2
05:52
Finding Generalizations
01:37
Iterating And Refining The Model - Part 1
02:39
Iterating And Refining The Model - Part 2
04:42
Adding Attributes
04:48
Cleaning Up Layout
04:04
Simplifying The Model
01:55
Evolving A Model - Part 1
02:13
Evolving A Model - Part 2
04:46
Enterprise Architect Techniques - Part 1
03:48
Enterprise Architect Techniques - Part 2
05:19
Enterprise Architect Techniques - Part 3
04:24
Section 6: Translate A UML Data Model Into An IE Data Model
Creating Subject Areas
02:38
Creating Entity Types
02:44
Creating Domains
06:13
Adding Attributes - Part 1
06:13
Adding Attributes - Part 2
03:25
Creating Relationship Types - Part 1
05:04
Creating Relationship Types - Part 2
03:33
Creating Relationship Types - Part 3
05:07
Subtyping
03:20
Adding Alternate Keys
03:36
Cleaning Up The Layout
01:38
ERwin Techniques - Part 1
04:58
ERwin Techniques - Part 2
03:59
Section 7: Model Quality
Model Quality
01:01
Normal Forms
04:01
Constraints
03:26
Hillard Graph Complexity
07:04
Hoberman Data Model Scorecard
05:21
Section 8: Kinds Of Data Models
Operational Data Models
03:30
Enterprise Data Models
05:33
Data Warehouses - Part 1
05:12
Data Warehouses - Part 2
04:53
Data Warehouses - Part 3
03:14
Master Data Models
04:08
Section 9: Database Design
Schema Adjustments
04:47
Attribute Details - Part 1
04:27
Attribute Details - Part 2
06:27
Attribute Details - Part 3
07:44
Primary And Alternate Keys
08:09
Indexes
06:44
Referential Integrity - Part 1
08:22
Referential Integrity - Part 2
06:27
Check Constraints - Part 1
06:44
Check Constraints - Part 2
07:07
Views
08:44
Other Aspects Of Design
03:52
Self Assessment Test
03:14
Section 10: Create A SQL Server Database
Creating A New Database
03:39
Executing Schema
02:29

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?
Take This Course