Advanced Data Modeling Topics
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
Sorry, there are no downloads available for this session.
Dejan Sarka, MCT and
SQL Server MVP, is an independent trainer and consultant that focuses on
development of database & business intelligence applications. Besides projects, he spends about half of the
time on training and mentoring. He is the founder of the Slovenian SQL Server
and .NET Users Group. Dejan Sarka is the main author or coauthor of twelve
books about databases and SQL Server. Dejan Sarka also developed many courses
and seminars for Microsoft, SolidQ and Pluralsight.
The video is not available to view online.
- Session Files Explorer
The network name cannot be found.