SQLskills IEVLT - SQL Server 2019

Issued by SQLskills

This badge shows attendance of the SQLskills Immersion Event on Very Large Tables: Optimizing Performance and Availability through Partitioning. IEVLT gives attendees insight into how to deal with ever-expanding data sets, how to archive them appropriately, and above all how to design / architect structures that will performance well now and even as the data continues to grow.

Type Learning
Level Advanced
Time Days
Cost Paid

Additional Details

Skills

Architecting Very Large Tables In SQL Server
Architectural Overview Of SQL Server And Components
Controlling And Automating The Sliding Window Scenario In SQL Server
Creating Effective SQL Server Databases
Creating Effective SQL Server Indexes For Performance
Effectively Design Very Large Tables Using Horizontal Partitioning Strategies Available In SQL Server
Managing Key Relationships In Very Large Table Structures With SQL Server
Managing SQL Server Index Fragmentation
Partitioning With Views In SQL Server
SQL Server Database Structures
SQL Server Index Internals
SQL Server Internals
SQL Server Locking
Table Partitioning In SQL Server
Troubleshooting And Configuring Compatibility And Cardinality Estimation Models
Troubleshooting And Maintaining SQL Server Statistics

Earning Criteria

This 400-level, online/recording, SQL Server training course complements our suite of training courses on SQL Server and extends the concepts to very large tables (VLTs). Very large tables present complex problems that only appropriate architecture can solve. And, we ensure you understand *why* and *how* a technique works rather than just what the technique is. Our aim is that you can apply what we teach to any situation and justify your solution.