Data Modeling Essenitals

Course ID: SQ-DMODESS-301-EN SATV voucher: No Confirmed: No

Lecturers

Price (without VAT)

1.200,00 €

Duration (days)

3

Number of hours:

27

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

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.

Prerequisites

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:

  • 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?

Course Summary Outline

Introduction

2.Module 00: Relational Model
  • Introduction
    • Domains, Tuples and Relations
    • Data Integrity
  • Relational Algebra
    • Basic Relational Operators
    • Eight Codd's Relational Algebra Operators
    • Additional Operators
  • Relational Calculus
3.Module 01: Normalization
  • Normalization
    • 1st Normal Form
    • 2nd Normal Form
    • 3rd Normal Form
    • Boyce-Codd Normal Form
    • 4th Normal Form
    • 5th Normal Form
4.Module 02: ER Approach
  • ER Approach
    • Entities
    • Relationships
    • Attributes
    • 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
    • Cases and Variables
    • Ways to Measure Data Values
    • Derived Variables
    • Missing Values and Outliers
    • Time Series
    • 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?
    • Foreword
    • Logical Differences
    • Domain-Key Normal Form
    • XML Data Type
    • .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:
  • SQL Server 2008 R2 Enterprise or Developer Edition
  • Visual Studio 2008 Professional or Team System Edition
  • MS Office Visio 2007 / 2010

Subscribe to waiting list

Udeleženec

Shranjujem
Need assistance?
Need assistance?