MasterClass: Data Modeling Essentials

This course is intended for OLTP and BI application developers. Database Administrators can gain a lot from the course as well.

This course assumes experience with SQL Server client tools and basic database development skills, including working knowledge of Transact-SQL.

Module 00: Introduction

Module 01: Relational Design Part 1: Normalization

Module 02: Relational Design Part 2: ER Approach, Super- / Sub-types

Module 03: Relational Design Part 3: More on Constraints

Module 04: Object-Role Modeling (ORM)

Module 05: Multidimensional (DW, OLAP) Design

Module 06: Data Mining Design, Data Preparation and Overview

Module 07: Operational Data Store (ODS) for CRM Applications and Corporate Information Factory (CIF)

Module 08: Object-Oriented Programming (OOP) Concepts and Unified Modeling Language (UML)

Module 09: Object-Relational Database Design Fundamentals

Module 10: Miscellaneous Reflections

Dejan Sarka is a Solid Quality Mentor and holds many industry distinctions including MCP, MCDBA, MCT, MCTS SQL Server, MCITP Database Administrator, MCITP Database Developer, and SQL Server MVP. As a trainer and consultant, he has assisted many CPLSs and development companies in Slovenia and around the world. In addition to this, he continuously works on OLTP, OLAP and Data Mining projects, especially at the design stage. He is a speaker at many important international conferences such as TechEd, PASS and MCT conference. He is the founder of the Slovenian SQL Server Users Group and collaborates with Microsoft TechNet meetings, NT conferences and many other events in Central and Eastern Europe. Dejan has teamed up with Itzik Ben-Gan to author chapters in two books; "Inside Microsoft SQL Server 2005" and "T-SQL Querying and Inside Microsoft SQL Server 2005 - T-SQL Programming". Dejan has also developed two courses for Solid Quality Mentors, Data Modeling Essentials and Data Mining with SQL Server 2005. He also regularly writes articles for Red Gate Simple Talk.