Advanced Data Modeling Topics

2014

TL; DR

Go well beyond generally spread knowledge about the relational database design.

Session Details

Every developer should know how to design a relational or a dimensional database. Nevertheless, there are still many advanced problems which are commonly solved in an inappropriate or at least inefficient way, or even not solved at all, because there is no solution out of the box in SQL Server. In addition, although the relational model is more than 40 years old and the dimensional model is also more than 30 years old, there are still many common myths and urban legends around them. In this seminar, we are going to deal with some of the most advanced problems and bust many common myths. The topics include:

Database design myths
Graphs in a relational database – basics, constraints
Optimizing general graphs and spatial data
Dynamic relational schema
Temporal data in SQL Server
Optimizing temporal data

3 things you'll get out of this session

Dejan Sarka's previous sessions

Statistical Analysis in T-SQL

Learn how to analyze your data with pure T-SQL to get the performance you cannot reach with R, Python, or other tools. Learn the math behind as well.

Data Overview and Manipulation - T-SQL, R, Python

Before doing any analysis, you have to prepare the data properly.

Temporal Data in SQL Server

Use temporal support in SQL Server and add what is missing out of the box.

Analysing Text with SQL Server 2014

This session introduces SQL Server 2012 and 2014 text mining capabilities.

Optimizing Temporal Queries

Writing efficient queries with temporal predicates is finally not a problem anymore.

Excel 2013 Analytics

Excel is “The” analytical tool in Microsoft suite for advanced analysts. This session introduces Excel 2013 and 2010 business intelligence capabilities.

A Deep Dive in SQL Server 2012 Data Warehousing

In this session, we are going to explain and test different DW features in SQL Server 2012, including star join optimization through bitmap filters, table partitioning, window functions, columnstore indices and more.