Columnstore Indexes Courses and Certifications

Optimizing Query Performance with Columnstore Indexes

Have you considered creating columnstore indexes to defeat slow queries? Well, this course is for you! Take your skills to the next level by learning how columnstore indexes can boost performance in today's busy database environment.

• Pluralsight
• 2 hours 34 minutes
• On-Demand
• Free Trial Available

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

74 ratings at Udemy

Implement a MS SQL Server Data Warehouse & Power BI Solution

• Udemy
• 10 hours
• 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

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

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

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

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

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

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

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)

Optimizing Query Performance with Columnstore Indexes

18 ratings at Pluralsight

Have you considered implementing columnstore indexes to speed up your queries? Well, this course is for you! Take your skills to the next level by learning how columnstore indexes can boost performance in an operational database environment today.

• Pluralsight
• 2-3 hours
• Finished
• Free Trial Available

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)