Optimizing SQL Server Table Structures (1 day)


SQL Server is Microsoft's primary database management tool. This course is designed to take you through a critical aspect of SQL Server Administration, with just the right amount of depth, within one day.

The course is most suitable for those that need to know how to configure table structures for a SQL Server system, including heaps vs clustered indexes, table partitioning, compression, filestream, and filetables. While not essential to complete the labs (as full detailed instructions are provided), some knowledge of T-SQL would be helpful.

While our courses are based on SQL Server 2017, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.

 CITY DATES COURSE PRICE EARLY BIRD PRICE
On-demand Please contact us

DAY 1 AD209 UNDERSTANDING SQL SERVER TABLE AND INDEX STRUCTURES
Understanding Table Structures
Understanding Nonclustered Indexes
Understanding Indexed Views
Understanding In-Memory Tables and Natively Compiled Stored Procedures
LAB: Understanding SQL Server Table Structures
DAY 1 AD210 IMPLEMENTING TABLE PARTITIONING
Working with Partition Functions and Partition Schemes
Working with Partitioned Tables
Implementing Sliding-Window Designs
Switching Data In and Out of Partitioned Tables
LAB: Implementing Table Partitioning
DAY 1 AD211 IMPLEMENTING TABLE COMPRESSION

Understanding Compression
Implementing Row and Page Compression
Implementing Column Store Indexes
SQL Server 2014 and 2016 Enhancements
LAB: Implementing Table Compression
DAY 1 AD212 MPLEMENTING FILESTREAM AND FILETABLES
Understanding Filestream
Implementing Filestream
Implementing FileTables
LAB: Implementing Filestream and FileTables