SETC Training844-434-7382
 Find a Course: 
 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

SQL Server Training


The instructor appeared to be very knowledgeable with regard to all aspects of the course. He was quick to point out features which were new or had changed since previous versions, and called specific attention to information he thought was particularly relevant to us.
Comment from DND

1. Title

  • The Complete SQL Server Optimization and Performance Tuning Course (SQLPTO, 4 days)
    View PDF

2. Course Pre-requisites

  • Previous SQL Server experience in a production environment

3. Target Audience

  • IT Professionals who want to learn how to tune the performance of a production grade SQL Server environment

4. Dates and Pricing


Jun 6 to Jun 9, 2017$2,775.00/person
Oct 10 to Oct 13, 2017$2,775.00/person

5. Outline

Module 1: SQL Server Storage Architecture

Topic 1: Understanding Pages and Extents

Topic 2: How SQL Server Allocates Pages and Extents

Topic 3: Exploring Data and Index Placement with Filegroups

Topic 4: About Data Types, Row Size and Page Usage

Topic 5: Determining the Space Requirements of a Table

Topic 6: Working with Standard Data Types

Topic 7: Working with Text Data: Unicode and Non-Unicode

Topic 8: Working with Image Data

Topic 9: About Fragmentation: Data and Indexes

Topic 10: Using TSQL to Display Table and Index Space Usage

Topic 11: Using TSQL to Display Table and Index Fragmentation

Module 2: Tuning SQL Statements

Topic 1: Understanding Query Parsing and Compilation

Topic 2: Using and Understanding Statistics Time and Statistics IO

Topic 3: Displaying and Understanding Graphical Execution Plans

Topic 4: How SQL Server uses Table Scans

Topic 5: How SQL Server Processes Range and Point Queries

Topic 6: Understanding SQL Server Join Strategies

Topic 7: Using Execution Plans to Write Good SQL Statements

Topic 8: Using the Query Optimizer

Topic 9: Implementing the Query Optimizer’s Recommendations

Module 3: Indexes and SQL

Topic 1: About Indexes: Clustered and Non-Clustered

Topic 2: Understanding Index Architecture and Storage

Topic 3: The Essential Role of Covering Indexes

Topic 4: Understanding the Role of Fill Factor and Pad Index

Topic 5: About Indexes and Data

Topic 6: About Indexes and Insert/Update Operations

Topic 7: About Indexes and Delete Operations

Topic 8: About Indexes and Views

Topic 9: About Indexes and Indexed Views

Topic 10: Implementing Sparse Indexes

Module 4: Creating Indexes: Guidelines and Usage

Topic 1: Matching Indexes with Queries: Point and Range Queries

Topic 2: Creating Indexes to Support Point Queries

Topic 3: Creating Indexes to Support Range Queries

Topic 4: Creating Indexes to Support Join Operations

Topic 5: Creating Indexes to Support Ordering Operations

Topic 6: Creating Indexes to Support Aggregate Calculations

Module 5: Maintaining Indexes

Topic 1: How SQL Server uses Statistics

Topic 2: How to Update Statistics

Topic 3: Displaying Fragmentation Statistics

Topic 4: Rebuilding Indexes

Topic 5: Altering Indexes

Topic 6: Automated Index Maintenance

Module 6: SQL Server Memory Management

Topic 1: Understanding the SQL Server Memory Architecture

Topic 2: Understanding the Buffer Pool and the Buffer Manager

Topic 3: The Importance of the Buffer Cache Hit Ratio

Topic 4: Understanding Log Operations

Topic 5: Working with and Tuning for Checkpoints and the Lazy Writer

Topic 6: Working with Log Writer

Module 7: Managing Transactions

Topic 1: About Lock Granularity: Table, Page, Extent and Row

Topic 2: SQL Server Lock Types and their Compatibility: Shared, Exclusive and More

Topic 3: Understanding Lock Types in the Context of Transaction Isolation

Topic 4: Common Locking Conditions: Deadlocks, Livelocks and More

Topic 5: Detecting and Avoiding Deadlocks

Topic 6: Detecting and Avoiding Livelocks

Topic 7: Common Mistakes and How to Avoid Them

Module 8: When Nothing Else Works: De-normalization and Other Strategies

Topic 1: Comparing OLTP and OLAP Databases

Topic 2: Separating Query Data from Transactional Data

Topic 3: The Need for De-Normalization

Topic 4: Implementing Redundant Data: Triggers and Functions

Topic 5: Implementing Surrogate Keys

Topic 6: Implementing Partitioned Tables

Topic 7: Implementing Partitioned Views

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette