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

Optimizing OLTP and Data Warehousing with SQL Server 2014

Course Summary

This course focuses on SQL Server 2014 and two of the latest additions to the database engine. We first look at how the shift in technology trends established the need for a different breed of technologies. Columnar, or Column-Oriented, databases have bec

  • +

    Course Syllabus

    ● In-Memory OLTP
        ◦ Introduction
        ◦ Course Overview
        ◦ Software Requirements
        ◦ Technology Drivers and Hardware Trends
        ◦ In-Memory OLTP Overview
        ◦ Architecture
        ◦ Durability for In-Memory Tables
        ◦ Scaling Up Efficiently
        ◦ Demo: Memory Optimized Filegroups
        ◦ Demo: Table and Data Setup
        ◦ Demo: Create In-Memory Table - Part 1
        ◦ Demo: Create In-Memory Table - Part 2
        ◦ Summary
    ● Data & Indexes for Memory Optimized Tables
        ◦ Introduction
        ◦ Demo: Loading Data & Transaction Log Impact
        ◦ Indexes on Memory Optimized Tables
        ◦ Demo: Hash Indexes
        ◦ Hash Indexes Architecture
        ◦ Demo: Range Indexes
        ◦ Demo: Index Statistics
        ◦ Demo: Advanced Indexing
        ◦ Summary
    ● Advanced In-Memory OLTP
        ◦ Introduction
        ◦ Natively Compiled Stored Procedures
        ◦ Demo: Natively Compiled Procedures Part 1
        ◦ Atomic Blocks
        ◦ Demo: Natively Compiled Procedures Part 2
        ◦ Concurrency Control
        ◦ Isolation Levels
        ◦ Demo: In-Memory OLTP Isolation Levels
        ◦ Other Considerations
        ◦ Summary
    ● Clustered Columnstore Indexes
        ◦ Introduction
        ◦ Use Cases for Clustered Columnstore Indexes
        ◦ Clustered Column Store vs. Row Store
        ◦ Demo: DDL and DML for CCI
        ◦ Demo: Querying CCI
        ◦ Summary


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

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