Cena tečaja * 1.200,00 €
Obseg v dneh 3
Število ur 27

Trenutno nimamo razpisanih terminov za ta tečaj. Prijavite se na seznam interesentov in obvestili vas bomo o prvem možnem terminu.
Prijavite se na seznam interesentov

* Cena je brez DDV

Data Modeling Essenitals SQ-DMODESS-301-EN

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