Database Design Course, Database Design Training, Designing Database, Data Design... - Course

Data Modeling Essentials

Choose your own date

INFORMATION COURSE OUTLINE

3 Days (SQ-DMODESS-301-EN)

Donwload a PDF of this Outline

Other Versions of this course:
Data Modeling Essentials (One-day-Seminar)

Description

A good application starts with a good database design. Data is nowadays the most important assets of a company. In our high competitive world, it is an advantage if decisions are supported with timely information from the data. However, low quality of data leads to unreliable information.

Data Modeling Essentials seminar is a high-end course, intended for SQL Server and other RDBMS professionals, including solution architects and IT managers. The course introduces all modern data models, including relational, dimensional and object-relational. Data quality issues are covered as well. During the course, many design myths are going to be revealed.

Target Audience

This course is intended for solution architects, IT managers who want to understand a correct design of a database, database and other developers and advanced database administrators.

Prerequisites

Before attending this course, it is recommended that students have moderate experience with developing and/or deploying transactional and business intelligence applications.

Course ObjectivesDuring three days of intensive work you will learn:

Relational model in depth, including:

Domains, Tuples and Relations
Relational algebra and calculus
Normalization
Entity-Relationship approach
Using super- and subtypes
Modeling constraints and business rules
Modeling graphs, trees and hierarchies
Using temporal and spatial data
Making relational schema dynamic
Modeling for performance
Modeling for Business Intelligence (BI) applications
Dimensional modeling for Data Warehouses (DW)
Advanced dimensional modeling problems solved by design
Unified Dimensional Model (UDM)
Data preparation for Data Mining
Data quality issues
Data quality dimensions
Modeling for data quality
Measuring data quality and information in data
Merging data from multiple sources for Operational Data Store (ODS), basis for Customer

Relationship Management (CRM) applications:

Object-Relational concepts
Object-Oriented Programming (OOP) basics
What is an object-relational database?

Introduction

Module 00: Relational Mode

Introduction
Domains, Tuples and Relations
Data Integrity
Relational Algebra
Basic Relational Operators
Eight Codd's Relational Algebra Operators
Additional Operators
Relational Calculus

Module 01: Normalization Normalization1st Normal Form2nd Normal Form3rd Normal FormBoyce-Codd Normal Form4th Normal Form5th Normal FormLAB 01: Normalization

Module 02: ER Approach ER ApproachEntitiesRelationshipsAttributesER DiagramsModeling ApproachSuper- and Sub-typesMissing Information>Naming ConventionsLAB 02: Entities and Relationships

Module 03: Constraints Data Integrity SummaryKeysBusiness RulesReferential IntegrityLookup TablesThe Design ProcessLAB 03: Business Rules

Module 04: Advanced Modeling and Constraints Modeling Graphs, Trees and HierarchiesTemporal Support in Relational DatabasesUsing Spatial DataMaking Relational Schema DynamicLAB 04: Advanced Modeling

Module 05: Modeling for Performance Using Data TypesDeclarative ConstraintsDesigning IndexesData PartitioningLAB 05: Modeling for Performance

Module 06: Dimensional Modeling IntroductionBusiness View and Conceptual SchemaStar SchemaData Warehouse and Other TermsOLAP CubesAdvanced ProblemsUnified Dimensional ModelLAB 06: Dimensional Modeling

Module 07: Preparing Data for Data Mining Introduction to Data MiningPreparing the dataCases and VariablesWays to Measure Data ValuesDerived VariablesMissing Values and OutliersTime SeriesDifferent Data SetsLAB 07: Data Preparation for Data Mining

Module 08: Data Quality Data Quality DimensionsMeasuring Data QualityMeasuring Information in Your DataMeasuring ImprovementsMerging data from multiple sources for Operational Data StoreThe Corporate information Factory (CIF)LAB 08: Data Quality

Module 09: Object-Relational Databases Object-Oriented Programming BasicsWhat is an Object-Relational Database?ForewordLogical DifferencesDomain-Key Normal FormXML Data Type