SQL Server 2000/2005: Performance & Tuning, the Microsoft SQL Server Training Course

	Show all Microsoft SQL Server Courses or Search:

Home

How it works

About the quality of your course

Managed services

Promote CourseMonster

Show all Microsoft SQL Server Courses

Scheduled Dates (sort by: location | date)

Request availability or book by selecting a date:

26/08/08 Berkshire (RG40) £ 1,300

22/09/08 Berkshire (RG40) £ 1,300

20/10/08 Berkshire (RG40) £ 1,300

24/11/08 Berkshire (RG40) £ 1,300

15/12/08 Berkshire (RG40) £ 1,300

Prices exclude VAT.

Have questions or need a better city/date? Ask now.

On-site/international quote? Ask now.

Course Overview

The objective of this course is to provide senior database analysts, developers or database administrators with a good understanding of SQL Server Architecture and Query Performance so that applications and their supporting environment can be tuned for optimal performance.

The course will provide delegates with the knowledge required to size, plan, monitor and tune a SQL Server application for either a OLTP or data warehousing environment. Everything from Operating System & SQL Server service tuning through to query and index tuning will be covered. It is a hands on course with performance and analysis tools being put to use throughout.

Audience

Senior Database Analysts
Developers
Database Administrators

Prerequisites

Delegates should have extensive experience with SQL Server 7 or later and should have a knowledge level equivalent to that provided by the PTR Advanced SQL, Stored Procedures & Triggers For SQL Server course. Knowledge of basic SQL Server 2000 Administration would be beneficial.

Course Outline

Performance & Tuning

Sizing & Planning
Monitoring Performance
Analyzing Performance Data
Tuning & Optimising Performance

SQL Server Internals

Windows & SQL Server Architecture
Process & Thread management
Memory Use & Management
I/O Management
Networking

SQL Server Architecture

Data Storage
Transaction Logging
Locking
Indexing
OLTP databases
Data Warehouses

Planning A SQL Server Database Application

Capacity Planning
Sizing Databases
Sizing Servers

System Performance & Tuning

Hardware Resource Tuning
I/O Performance
Database Layout
SQL Server Configuration Options

Monitoring Tools

Performance Monitor
SQL Profiler
DBCC

Optimal Database Design

Database Design
Table Design
Indexes
OLTP databases
Data Warehouses

Index Optimisation

Index Types
Covering Indexes
Index Strategies

Locking

Lock Types
Locking & Granularity
Blocking
Locking & Transactions
Transaction Isolation Levels
Transaction Design
Analysing Locks

Query Optimisation

Query Optimiser
Recompilation
Query Cache
Query Types
Range
Ordering
Grouping
Table joins & Join Algorithms

Analyzing Queries

Query Analyser & Execution Plans
SHOWPLAN
Graphical
Index Statistics
Index Tuning Wizard

Tuning SQL Statements

Comparing Queries
Avoiding Subqueries
Table Hints

Database Application Tuning

Using Stored Procedures & User Defined Functions
Views
Partitioning Data
Derived Data
Minimising Redundant Data With Triggers
Optimising Transactions
Optimising Cursors

Tuning SQL Server Services & Tasks

Replication Services
DTS Packages
Backup & Recovery

How to make a booking for the MSQ-PT course

CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.

Affiliate Program Training News Privacy Policy Contact us