MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Logical and Physical Modeling for Analytical Applications

Course Summary

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 Syllabus

    Star and Snowflake Schemas
    - 20m 19s

    —Introduction 2m 43s
    —Normalized Schema 3m 51s
    —Star Schema 2m 29s
    —Shared Dimensions 0m 36s
    —Dimension Denormalization 0m 42s
    —Snowflake Schema 0m 52s
    —Hybrid Approach 1m 14s
    —Granularity 2m 3s
    —Auditing Lineage 1m 39s
    —DWTerms 2m 59s
    —Summary 1m 11s
    Designing Dimensions and Fact Tables
    - 38m 19s

    —Introduction 0m 53s
    —Dimension Columns 2m 27s
    —Hierarchies 2m 14s
    —SCD Classic 3m 15s
    —Referencing Monster 2m 38s
    —SCD Custom 2m 24s
    —Demo Dimensions 5m 45s
    —Fact Columns 1m 30s
    —Measures Additivity 2m 51s
    —Demo Fact 2m 53s
    —MtoM 3m 21s
    —Demo MtoM 7m 10s
    —Summary 0m 58s
    Data Warehousing Data Access Problems
    - 21m 49s
    SQL Server Data Warehousing Support before Version 2012
    - 33m 18s
    Sql Server Data Warehousing Optimizations in Version 2012
    - 34m 1s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Data & Information Management and Digital Media & Games Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url