Columnstore Indexes Courses and Certifications

SQLBits

Columnstore Index Compression in a Nutshell

Unlock the secrets of columnstore compression to enhance analytic query performance and optimize database architecture for modern analytics.

• YouTube
• 20 minutes
• Self-Paced
• Free Video

PASS Data Community Summit

Improving Analytics Performance With Columnstore Indexes

Explore columnstore indexes for efficient OLAP data storage and analytics in SQL Server. Learn architecture, optimization techniques, and best practices to enhance query performance on large datasets.

• YouTube
• 1 hour 17 minutes
• Self-Paced
• Conference Talk

PASS Data Community Summit

Columnstore Indexes in 2017-2019

Explore recent enhancements to Columnstore Indexes in SQL Server 2017-2019, focusing on performance improvements for Data Warehouses and BI solutions. Learn about new features and fixes for high-scale environments.

• YouTube
• 1 hour 16 minutes
• Self-Paced
• Conference Talk

PASS Data Community Summit

Columnstore Indexes in SQL Server 2014 - Flipping the DW Faster Bit

Explore optimized columnstore indexes in SQL Server 2014 for data warehousing, including architecture, challenges, and real-world applications. Learn how this hybrid technology can revolutionize your database performance.

• YouTube
• 1 hour 7 minutes
• Self-Paced
• Conference Talk

Azure SQL Database Hyperscale - Customer Use Cases and Benefits

Explore Azure SQL Database Hyperscale's architecture, features, and real-world applications through customer stories, demos, and expert insights on scalability, performance, and multi-model capabilities.

• YouTube
• 1 hour 3 minutes
• Self-Paced
• Free Video

SQLBits

Why is Batch Mode Fast? - SQL Server Query Optimization

Explore SQL/Synapse query optimization techniques, focusing on batch mode processing, modern CPU utilization, and performance enhancements for big data scenarios.

• YouTube
• 49 minutes
• Self-Paced
• Free Video

PASS Data Community Summit

A Lap Around Columnstore and 2016 Operational Analytics

Explore Columnstore and 2016 Operational Analytics in SQL Server, focusing on performance improvements and real-time analytics capabilities for data-driven decision making.

• YouTube
• 56 minutes
• Self-Paced
• Conference Talk

PASS Data Community Summit

Index Internals - RowStore, ColumnStore, and NoStore

Explore index internals in SQL Server, covering RowStore, ColumnStore, and NoStore structures. Learn when to use each type and understand their performance implications.

• YouTube
• 59 minutes
• Self-Paced
• Conference Talk

SQLBits

Next Level Scalability on SQL Server 2022

Explore scalability enhancements in SQL Server 2022, covering default improvements and new capabilities for database administrators to achieve high availability and performance.

• YouTube
• 51 minutes
• Self-Paced
• Free Video

Developing SQL Databases

1 rating

Learn the technologies and features needed to create and design SQL databases, including how to implement SQL views, indexes and tables.

• edX
• 4 weeks, 2-4 hours a week
• Not Currently Offered
• Free Online Course

Implementing In-Memory SQL Database Objects

Learn how to use the SQL server to build efficient databases using In-Memory features.

• edX
• 4 weeks, 2-3 hours a week
• Not Currently Offered
• Free Online Course