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 is a high-end seminar, 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. During the course, many design myths are going to be revealed.

Seminar Outline

• 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
• Advanced Relational Modeling
  • Modeling graphs, trees and hierarchies
  • Using temporal data
  • Making relational schema dynamic
• Object-Relational concepts
  • Object-Oriented Programming (OOP) basics
  • What is an object-relational database?