Logical and Physical Modeling for Analytical Applications

A good application starts with a good database design. Support analytical applications with a good logical design, get understanding of the problems with data access for queries that deal with large amounts of data, and learn about SQL Server optimizations that help solving these problems.
Course info
Rating
(210)
Level
Intermediate
Updated
Oct 31, 2013
Duration
2h 28m
Table of contents
Description
Course info
Rating
(210)
Level
Intermediate
Updated
Oct 31, 2013
Duration
2h 28m
Description

A bad data model leads to an application that does not perform well. Therefore, when developing an application, you should create a good data model from the start. However, even the best logical model can’t help when the physical implementation is bad. It is also important to know how SQL Server stores and accesses data, and how to optimize the data access. Database optimization starts by splitting transactional and analytical applications. In this course, you learn how to support analytical applications with logical design, get understanding of the problems with data access for queries that deal with large amounts of data, and learn about SQL Server optimizations that help solving these problems.

About the author
About the author

Dejan Sarka, MCT and SQL Server MVP, is an independent consultant, trainer, and developer focusing on database & business intelligence applications. His specialties are advanced topics like data modeling, data mining, and data quality.

More from the author
Data Mining Algorithms in SSAS, Excel, and R
Intermediate
2h 60m
Jul 24, 2015
Working With Temporal Data in SQL Server
Intermediate
3h 7m
May 28, 2014