Learning Data Modeling
3.9 (108 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,893 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learning Data Modeling to your Wishlist.

Add to Wishlist

Learning Data Modeling

A step by step guide to data modeling concepts and best practices underpinning sound database design.
3.9 (108 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,893 students enrolled
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 8 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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.
View Curriculum
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 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 122 Lectures Collapse All 122 Lectures 07:56:30
+
Data Model Development Process
3 Lectures 06:24
Data Model Inputs And Outputs
02:05

Data Model Notations
03:00

UML Versus IE - Conceptual, Logical And Physical
01:19
+
Basic Data Modeling
14 Lectures 51:27
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
+
Advanced Data Modeling
14 Lectures 42:53
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
+
Create A UML Data Model
15 Lectures 57:30
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
+
Translate A UML Data Model Into An IE Data Model
13 Lectures 52:28
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
+
Model Quality
5 Lectures 20:53
Model Quality
01:01

Normal Forms
04:01

Constraints
03:26

Hillard Graph Complexity
07:04

Hoberman Data Model Scorecard
05:21
+
Kinds Of Data Models
6 Lectures 26:30
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
+
Database Design
13 Lectures 01:22:48
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
+
Create A SQL Server Database
5 Lectures 25:16
Creating A New Database
03:39

Executing Schema
02:29

Inspecting Metadata
08:32

Loading Sample Data
04:03

Querying Sample Data
06:33
5 More Sections
About the Instructor
Infinite Skills
4.4 Average rating
36,020 Reviews
677,124 Students
331 Courses
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.