SQLskills IECS - SQL Server 2019
Issued by
SQLskills
This badge shows attendance of the SQLskills Immersion Event on Columnstore Indexes. IECS teaches you the differences between rowstore and columnstore indexes and how to plan for, implement, and maintain columnstore indexes in SQL Server using best practices and our extensive real-world experience. Topics covered: columnstore structures and usage strategies, DMVs, data loading strategies, maintenance, and partitioning.
- Type Learning
- Level Advanced
- Time Days
- Cost Paid
Skills
- Architectural Overview Of SQL Server And Components
- Compare And Contrast Row-based And Columnar Indexing In SQL Server
- Compare And Contrast Trickle-insertion And Bulk Loading For Data Into SQL Server
- Creating Effective SQL Server Indexes For Performance
- Designing And Creating Clustered Columnstore Indexes In SQL Server
- Designing And Creating Constraints Using Rowstore Indexes In SQL Server
- Designing And Creating Nonclustered Columnstore Indexes In SQL Server
- Effectively Using Dynamic Management Views (DMVs) For Troubleshooting
- Effective Use Of Partitioning With Columnstore Indexes In SQL Server
- Implement Optimal Data Loading Into Columnstore Indexes In SQL Server
- Maintaining Columnstore Indexes In SQL Server
- SQL Server Database Structures
- SQL Server Index Internals
- SQL Server Internals
- Understand Appropriate Workload Characteristics For Implementing Row-based And Columnar Indexes In SQL Server