Data Modeling Essenitals

Oznaka tečaja: SQ-DMODESS-301-EN SATV voucher: Ne Izvedba potrjena: Ne


Cena brez DDV

1.200,00 €

Trajanje (dni)


Število ur:

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.

Course Author(s)

The author of the course is Dejan Sarka.

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.


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

Course Objectives

During three days of intensive work you will learn:
• Relational model in depth, including:
o Domains, Tuples and Relations
o Relational algebra and calculus
o Normalization
o Entity-Relationship approach
o Using super- and subtypes
o Modeling constraints and business rules
o Modeling graphs, trees and hierarchies
o Using temporal and spatial data
o Making relational schema dynamic
o Modeling for performance
• Modeling for Business Intelligence (BI) applications
* o Dimensional modeling for Data Warehouses (DW)
o Advanced dimensional modeling problems solved by design
o Unified Dimensional Model (UDM)
o Data preparation for Data Mining
• Data quality issues
o Data quality dimensions
o Modeling for data quality
o Measuring data quality and information in data
o Merging data from multiple sources for Operational Data Store (ODS), basis for Customer Relationship Management (CRM) applications
• Object-Relational concepts
o Object-Oriented Programming (OOP) basics
o What is an object-relational database?

Course Summary Outline
1. Introduction

2. Module 00: Relational Model
• Introduction
i. Domains, Tuples and Relations
ii. Data Integrity
• Relational Algebra
i. Basic Relational Operators
ii. Eight Codd's Relational Algebra Operators
iii. Additional Operators
• Relational Calculus

3. Module 01: Normalization
• Normalization
i. 1st Normal Form
ii. 2nd Normal Form
iii. 3rd Normal Form
iv. Boyce-Codd Normal Form
v. 4th Normal Form
vi. 5th Normal Form

4. Module 02: ER Approach
• ER Approach
i. Entities
ii. Relationships
iii. Attributes
iv. ER Diagrams
• Super- and Sub-types
• Missing Information
• Naming Conventions

5. Module 03: Constraints
• Keys
• Business Rules
• Referential Integrity
• Lookup Tables
• The Design Process

6. Module 04: Advanced Modeling and Constraints
• Modeling graphs, trees and hierarchies
• Temporal support in relational databases
• Using spatial data
• Making relational schema dynamic

7. Module 05: Modeling for Performance
• Using data types
• Designing indexes
• Data partitioning

8. Module 06: Dimensional Modeling
• Introduction
• Business View and Conceptual Schema
• Star Schema
• Data Warehouse and Other Terms
• OLAP Cubes
• Advanced Problems
• Unified Dimensional Mode

9. Module 07: Preparing Data for Data Mining
• Introduction to Data Mining
• Preparing the data
i. Cases and Variables
ii. Ways to Measure Data Values
iii. Derived Variables
iv. Missing Values and Outliers
v. Time Series
vi. Different Data Sets

10. Module 08: Data Quality
• Data Quality Dimensions
• Measuring Data Quality
• Measuring Information in Your Data
• Measuring Improvements
• Merging data from multiple sources for Operational Data Store, basis for Customer Relationship Management (CRM) applications
• The Corporate information Factory (CIF)

11. Module 09: Object-Relational Databases
• Object-Oriented Programming Basics
• What is an Object-Relational Database?
i. Foreword
ii. Logical Differences
iii. Domain-Key Normal Form
iv. XML Data Type
v. .NET Collections

Course Material
• Printed student manual (in English)
• Student CD with exercises, labs and supporting materials
• The student kit includes a comprehensive set of handouts and other necessary materials for the class
• The following software will be used during the workshop:
o SQL Server 2008 R2 Enterprise or Developer Edition
o Visual Studio 2008 Professional or Team System Edition
o MS Office Visio 2007 / 2010

Prijavite se na listo interesentov