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

SQL Server 2012: Nonclustered Columnstore Indexes

Course Summary

If you need to develop a solution to meet your business intelligence needs but don't have the in-house SQL Server Analysis Services skills to make it happen, don't rule out a SQL Server database engine solution just yet. SQL Server 2012 nonclustered colum

  • +

    Course Syllabus

    ● Course Introduction
        ◦ Course Introduction
        ◦ Course Structure
    ● Nonclustered Columnstore Index Fundamentals
        ◦ Module Introduction
        ◦ Demo: Expanding the AdventureWorksDW2012 Database
        ◦ Nonclustered Columnstore Indexes Defined
        ◦ Demo: Nonclustered Columnstore Indexes - Hello World
        ◦ Targeted Workloads and Environments
        ◦ Non-ideal Candidates
        ◦ B-Tree Row Storage
        ◦ Just Accessing a Few Columns? It Doesn't Matter...
        ◦ Columnar Data Storage
        ◦ Segments
        ◦ Demo: Segments
        ◦ Row Groups
        ◦ Syntax (1)
        ◦ Syntax (2)
        ◦ Demo: Syntax
        ◦ This is NOT a B-Tree Index
        ◦ Supported and Unsupported Data Types
        ◦ How Performance is Achieved
        ◦ Dictionary Encoding
        ◦ Batch Execution Mode
    ● Leveraging Batch-Execution Mode
        ◦ Module Introduction
        ◦ Traditional Row Execution Mode
        ◦ Batch Execution Mode
        ◦ Batch Mode Operator Support
        ◦ Demo: Verifying Batch Execution Mode
        ◦ Batch Execution Inibitors (1)
        ◦ Demo: Serial Plan Batch Execution Inhibitor
        ◦ Batch Execution Inhibitors (2)
        ◦ Demo: NOT IN Batch Execution Inhibitor
        ◦ Demo: Scalar Aggregate Batch Execution Inhibitor
    ● Benefiting from Segment Elimination
        ◦ Module Introduction
        ◦ Segment Elimination (1)
        ◦ Segment Elimination (2) and (3)
        ◦ Demo: Segment Elimination
    ● Managing Data Modifications
        ◦ Module Introduction
        ◦ Restricted Data Modifications
        ◦ Demo: Restricted Data Modifications
        ◦ Delta Table
        ◦ Demo: Delta Table
        ◦ Drop, Load, Create
        ◦ Partition Switching
        ◦ Demo: Partition Switching
    ● Deployment Planning
        ◦ Module Introduction
        ◦ Interoperability Limitations
        ◦ Index Creation Memory Requirements (1)
        ◦ Index Creation Memory Requirements (2)
        ◦ Demo: Index Creation Memory Requirements
        ◦ Deployment Considerations (1)
        ◦ Deployment Considerations (2)
        ◦ vNext Clustered Columnstore Indexes
        ◦ Course Summary


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Data & Information Management 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

Back to Top