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

SQL Server Training

Great material that I can take back to the workplace. Good case and exercises. Monitor setup is good and easy to follow.
Comment from Giant Tiger

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