Logical and Physical Modeling for Analytical Applications
        Posted  
        
            by Dejan Sarka
        on SQL Blog
        
        See other posts from SQL Blog
        
            or by Dejan Sarka
        
        
        
        Published on Fri, 01 Nov 2013 06:44:15 GMT
        Indexed on 
            2013/11/01
            10:12 UTC
        
        
        Read the original article
        Hit count: 533
        
analytical applications
|course
|Data Modeling
|logical model
|physical model
|training
I am proud to announce that my first course for Pluralsight is released. The course title is Logical and Physical Modeling for Analytical Applications. Here is the description of the course.
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.
Enjoy the course!
© SQL Blog or respective owner