Create and deliver your own elearning using eduslide.net

Browse thousands of lessons. Create your own and share the knowledge.

Sign up for a free eduslide account !
Create your own courses.
Access thousands of lessons.

Data Modeling

Data modeling is the act of exploring data-oriented structures. When building a database, data modeling implies the creation of a model for data within that database. Data models can be used for a variety of purposes, from high-level conceptual models to physical data models. VTC author, Gavin Powell, covers topics such as normalization and denormalization for relational data modeling, fact dimensional structures for data warehouse data modeling, and basic object data modeling for object databases. Powell also examines useful web sites and vendor software, such as Oracle database, for finding data modeling information. To being learning today, simply click on one of the Data Modeling lessons.

Author: Vtc

Welcome

Welcome

Prerequisites for this Course

About this Course

Where to Find Documentation

Samples and Example Data Models Part pt. 1

Samples and Example Data Models Part pt. 2

A Relational Database Modeling Tool

ERWin: Changing Physical Structure

ERWin: Generating Scripts

The History of Data Modeling

What is a Data Model?

Types of Data Models

The Evolution of Data Modeling

File Systems

Hierarchical Databases

Network Databases

Relational Databases

Object Databases

Object-Relational Databases

The History of the Relational Database

Tools for Data Modeling

Entity Relationship Diagrams

Using ERWin Part pt. 1

Using ERWin Part pt. 2

Using ERWin Part pt. 3

Modeling in Microsoft Access

The Parts of an Object Data Model

Basic UML for Object Databases

Building Class Structures

Other UML Diagrams

Introducing Data Modeling

The Relational Data Model

The Object Data Model

The Object-Relational Data Model

Data Warehouse Data Modeling

Client-Server Versus OLTP Databases

Available Database Engines

Relational Data Modeling

What is Normalization?

Normalization Made Simple

Relational Terms and Jargon

1st Normal Form

Demonstrating 1st Normal Form

2nd Normal Form

Demonstrating 2nd Normal Form

3rd Normal Form

Demonstrating 3rd Normal Form

4th and 5th Normal Forms

Primary/Foreign Keys/Referential Integrity

The Traditional Relational Database Model

Surrogate Keys and the Relational Model

Denormalization

Object Data Modeling

The Object-Relational Database Model

Relational Versus Object Models

What is the Object Data Model?

What is a Class?

Again - a Class and an Object

What is an Attribute?

What is a Method?

The Simplicity of Objects

What is Inheritance?

What is Multiple Inheritance?

Some Specifics of the Object Data Model

Data Warehouse Data Modeling

The Origin of Data Warehouses

Why the Relational Model Fails

The Dimensional Data Model Part pt. 1

The Dimensional Data Model Part pt. 2

Star Schemas and Snowflake Schemas

Getting Data from a Database

What is Structured Query Language (SQL)?

The Roots of SQL

Queries

Changing Data

Changing Metadata

What is ODQL?

Tuning a Relational Data Model

Normalization Versus Denormalizatrion

Referential Integrity Part pt. 1

Referential Integrity Part pt. 2

Alternate Keys

What is an Index?

Indexing Considerations

Too Many Indexes

Composite Indexing

Which Columns to Index?

Index Types

Match Indexes to SQL Code

Types of Indexing in Detail pt. 1

Types of Indexing in Detail pt. 2

Where Index Types Apply

Undoing Normalization

What to Look For?

Undoing Normal Forms

Some Good and Bad Tricks Part pt. 1

Some Good and Bad Tricks Part pt. 2

Tuning a Data Warehouse Data Model

Denormalization

Star Versus Snowflake Schemas

Dimensional Hierarchies

Specialized Data Warehouse Toys

Other Tricks

RAID Arrays and Striping

Standby Databases

Replication

Clustering

Wrapping it Up

Some Available Database Engines

The Future: Relational or Object?

What You Have Learned

Credits

About the Author

Course options

Search

Channels

 

Tags

Activity

 No Entry Found