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

Learn how nonclustered columnstore indexes in SQL Server 2012 can introduce incredible performance benefits when querying very large data sets in relational data warehouses, applicable to developers and DBAs responsible for application data tiers, from SQL Server 2012 onwards

  • +

    Course Syllabus

    Course Introduction
    - 2m 2s

    —Course Introduction 0m 51s
    —Course Structure 1m 11s
    Nonclustered Columnstore Index Fundamentals
    - 30m 22s

    —Module Introduction 1m 6s
    —Demo: Expanding the AdventureWorksDW2012 Database 3m 45s
    —Nonclustered Columnstore Indexes Defined 0m 51s
    —Demo: Nonclustered Columnstore Indexes - Hello World 4m 33s
    —Targeted Workloads and Environments 1m 50s
    —Non-ideal Candidates 1m 31s
    —B-Tree Row Storage 0m 17s
    —Just Accessing a Few Columns? It Doesn't Matter... 0m 22s
    —Columnar Data Storage 0m 24s
    —Segments 0m 24s
    —Demo: Segments 4m 32s
    —Row Groups 0m 39s
    —Syntax (1) 0m 55s
    —Syntax (2) 0m 42s
    —Demo: Syntax 2m 26s
    —This is NOT a B-Tree Index 1m 50s
    —Supported and Unsupported Data Types 0m 55s
    —How Performance is Achieved 1m 47s
    —Dictionary Encoding 0m 44s
    —Batch Execution Mode 0m 49s
    Leveraging Batch-Execution Mode
    - 15m 8s
    Benefiting from Segment Elimination
    - 6m 4s
    Managing Data Modifications
    - 11m 1s
    Deployment Planning
    - 11m 31s

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