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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Conference Talk

Data Warehouse & Power BI For Beginners -DW ,SSIS, ETL, BI

95 ratings at Udemy

Implement a MS SQL Server Data Warehouse & Power BI Solution

• Udemy
• 9 hours 38 minutes
• On-Demand
• Paid Course

Implementing a Data Warehouse SQL Server 2019

823 ratings at LinkedIn Learning

Create a long-term data storage solution using SQL Server 2019 and Azure SQL Data Warehouse.

• LinkedIn Learning
• 2 hours 7 minutes
• On-Demand
• Free Trial Available

Implementing a Data Warehouse with SQL Server 2022

367 ratings at LinkedIn Learning

Learn how to create a long-term data storage solution using local SQL Server instances and cloud-based Azure Dedicated SQL Pools.

• LinkedIn Learning
• 2 hours 36 minutes
• On-Demand
• Free Trial Available

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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Free Video

SQL Server Performance for Developers

234 ratings at LinkedIn Learning

Review concepts and strategies to help you enhance your app's performance on Microsoft SQL Server. Discover best practices for building efficient, scalable database applications.

• LinkedIn Learning
• 3 hours 45 minutes
• Finished
• Free Trial Available

Developing SQL Databases

1 review

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
• Finished
• Free Online Course (Audit)

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
• Finished
• Free Online Course (Audit)