Logical and Physical Modeling for Analytical Applications
Offered By: Pluralsight
Course Description
Overview
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.
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.
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.
Syllabus
- Star and Snowflake Schemas 20mins
- Designing Dimensions and Fact Tables 38mins
- Data Warehousing Data Access Problems 21mins
- SQL Server Data Warehousing Support before Version 2012 33mins
- Sql Server Data Warehousing Optimizations in Version 2012 34mins
Taught by
Dejan Sarka
Related Courses
Introduction to Programming for Musicians and Digital ArtistsCalifornia Institute of the Arts via Coursera Models in Architecture – design through physical & digital models
Delft University of Technology via edX Digital Modeling: Volume, Surface, Space
University of Nevada, Las Vegas via Kadenze Modeling of tundish steelmaking process in continuous casting
Indian Institute of Technology Roorkee via Swayam Ultimate Ableton Live 11, Part 4: Synthesis and Sound Design
Kadenze