Learning Data Modeling

Name: Learning Data Modeling
Rating: 4.0 (549 reviews)

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

Created byInfinite Skills

Last updated 1/2017

English

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.

Course content

15 sections • 122 lectures • 7h 56m total length

Important - Download These First - Working Files0:01
About The Course3:24
What Is A Database?2:23
What Is A Data Model?1:52
How To Access Your Working Files3:22

Class And Attribute6:11
Clarify how objects and classes relate, showing objects as data and classes as metadata, and build a data model with UML and IEEE notation using attributes and primary keys.
Operation1:32
Domain3:54
Association4:59
IE Entity Type And Relationship Type3:15
Association Name4:46
Association End4:09
Multiplicity - UML3:40
Multiplicity - IE2:31
Generalization - UML3:32
Generalization - IE4:06
Abstract Versus Concrete Superclass2:11
Practical Tips1:58
Clarify scope by understanding the customer's problem and ensure the data model serves customer needs and business rationale, standardize naming, document terminology, and manage associations, multiplicity, and generalization.
Self Assessment Test4:43

Identity2:34
Derived Data2:33
Current Versus Historical Data1:07
Association Class5:20
Ordered Association5:25
Qualified Association - UML5:12
Qualified Association - IE2:35
Large Taxonomies3:05
Package2:46
Abridged UML Metamodel2:04
Review the abridged uml model, illustrating classes, associations, association classes, attributes with domains, multiplicity, qualifiers, and generalization from superclass to subclasses.
Abridged IE Metamodel1:14
Modeling Pitfalls3:27
Practical Tips1:47
Self Assessment Test3:44

Problem Statement1:52
Finding Classes4:32
Finding Associations - Part 14:59
Finding Associations - Part 25:52
Model optional delivery with diverse delivery types for orders, ensure address and payment associations are captured, and link customers to multiple credit cards and payments.
Finding Generalizations1:37
Iterating And Refining The Model - Part 12:39
Iterating And Refining The Model - Part 24:42
Adding Attributes4:48
Cleaning Up Layout4:04
Simplifying The Model1:55
Evolving A Model - Part 12:13
Evolving A Model - Part 24:46
Enterprise Architect Techniques - Part 13:48
Enterprise Architect Techniques - Part 25:19
Enterprise Architect Techniques - Part 34:24

Creating Subject Areas2:38
Creating Entity Types2:44
Creating Domains6:13
Adding Attributes - Part 16:13
Adding Attributes - Part 23:25
Creating Relationship Types - Part 15:04
Creating Relationship Types - Part 23:33
Creating Relationship Types - Part 35:07
Subtyping3:20
Explore subtyping from customers to ad hoc and account customers, propagate primary key and attributes like address and credit card, and enforce a discriminator for customer type in database design.
Adding Alternate Keys3:36
Cleaning Up The Layout1:38
ERwin Techniques - Part 14:58
ERwin Techniques - Part 23:59

Schema Adjustments4:47
Attribute Details - Part 14:27
Attribute Details - Part 26:27
Attribute Details - Part 37:44
Primary And Alternate Keys8:09
Indexes6:44
Discover how indexes tune a relational database, speeding lookups and enforcing uniqueness, while slowing writes by twenty to thirty percent and boosting foreign key joins.
Referential Integrity - Part 18:22
Referential Integrity - Part 26:27
Check Constraints - Part 16:44
Check Constraints - Part 27:07
Views8:44
Other Aspects Of Design3:52
Self Assessment Test3:14

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.

Learning Data Modeling

What you'll learn

Explore related topics

Course content

Getting Started5 lectures • 11min

Data Model Development Process3 lectures • 6min

Basic Data Modeling14 lectures • 51min

Advanced Data Modeling14 lectures • 43min

Create A UML Data Model15 lectures • 58min

Translate A UML Data Model Into An IE Data Model13 lectures • 52min

Model Quality5 lectures • 21min

Kinds Of Data Models6 lectures • 27min

Database Design13 lectures • 1hr 23min

Create A SQL Server Database5 lectures • 25min

Requirements

Description

Who this course is for: