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 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.


  • +

    Course Syllabus

    ● Star and Snowflake Schemask
        ◦ Introduction
        ◦ Normalized Schema
        ◦ Star Schema
        ◦ Shared Dimensions
        ◦ Dimension Denormalization
        ◦ Snowflake Schema
        ◦ Hybrid Approach
        ◦ Granularity
        ◦ Auditing Lineage
        ◦ DWTerms
        ◦ Summary
    ● Designing Dimensions and Fact Tables
        ◦ Introduction
        ◦ Dimension Columns
        ◦ Hierarchies
        ◦ SCD Classic
        ◦ Referencing Monster
        ◦ SCD Custom
        ◦ Demo Dimensions
        ◦ Fact Columns
        ◦ Measures Additivity
        ◦ Demo Fact
        ◦ MtoM
        ◦ Demo MtoM
        ◦ Summary
    ● Data Warehousing Data Access Problems
        ◦ Introduction
        ◦ Algorithms Complexity
        ◦ SSAS Addressing
        ◦ Joins
        ◦ Linearize Joins
        ◦ Bitmap
        ◦ Bloom
        ◦ Trans-Relational
        ◦ Columnar Storage
        ◦ Summary
    ● SQL Server Data Warehousing Support before Version 2012
        ◦ Introduction
        ◦ Partitioned Table
        ◦ Sliding Window
        ◦ Demo Partitioning
        ◦ Filtered Index
        ◦ Indexed View
        ◦ Demo Filtered Indexed
        ◦ Data Compression
        ◦ Demo Data Compression
        ◦ Summary
    ● Sql Server Data Warehousing Optimizations in Version 2012
        ◦ Introduction
        ◦ Window Functions
        ◦ Demo Window Fun
        ◦ Columnstore Indexes
        ◦ Columnstore Compression
        ◦ Reducing IO
        ◦ Reducing CPU Batch
        ◦ Columnstore Restrictions
        ◦ Data Loading Usage
        ◦ Demo Columnstore Batch
        ◦ Version 2014 Summary
     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Related Posts:

SQL (Structured Query Language)

 

Security, Trust and Assurance Registry (STAR)

 

Star schema

 

SSAS (Sql Server Analysis Services)

 

Bitmap

 

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
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

Back to Top