Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
courses The smart course guide
Courses    
  Most popular search | Share this page  
open My list: 0 courses
peak performance course   performance courses   performance leadership   client server technology   high performance leadership   courses in sql server 2005 for querying berkshire   performance course london   performance management courses ni   sql 2005 courses   sql intermediate course
Homepage › IT, Computing, Telecommunications Courses › Database Administration Courses › SQL Server Courses

SQL Server Performance & Tuning

in PTR Associates Ltd (England)

Classes Course

Place:

Wokingham

Price:

£1,350 + VAT

Duration:

4 Days

Start:

14/12/2008 calendar
See course programme

Requirements:

Delegates should have extensive experience with SQL Server 7 or later and should have a knowledge level ... see more

Request free information

Course objectives:

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...

More courses Subject area
Place
 

Request information

Contact directly and with no obligation with
PTR Associates Ltd
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Average Fast Very fast
 

Course details

Type Course Duration 4 Days
Method / place Contact course provider Classes in Wokingham where
Course objectives 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...
Requirements
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.
Price £1,350 + VAT
Get direct information on how to enrol, venues and availability...

SQL Server courses (from other course providers)

 
Microsoft SQL Server 2005 Solutions MCITP 70-441
We Teach You
Distance - £50 + VAT
 
SQL for the web
ACS Distance Education
Distance - £280 + VAT
 
Server+
focus4training
Multimedia - £298 + VAT
 
Sql Server 6.5 Series
Sales 101 Ltd
Online - £75 + VAT
 
Database Administration
Futures Development Limited
Blended - Price: On request
Compare the selected courses
+ sql server Courses + SQL Server Courses in Berkshire + Courses in Berkshire + PTR Associates Ltd Courses

Course programme

SQL Server Performance & Tuning
Course objectives:
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.

Course content:
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
    • see the full course programme

    on request

    get more information on the programme directly from PTR Associates Ltd.

    Request information for free
    Get direct information on how to enrol, venues and availability...
     

    Venues and dates



    Where Wokingham, 21a Peach Street see map
    When Start: 14/12/2008 Finish: 17/12/2008 See calendar
     
    Get direct information on how to enrol, venues and availability...
     

    Ex-students

     
    Opinions
     
    Have you attended this course?

    Voice your opinion and help thousands of other users

    opinions

    from users who have attended
    this course.
    Get direct information on how to enrol, venues and availability...
     

    On PTR Associates Ltd

    Provider description
    PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company specific courses are available for organisations that have several employees who all need training at the same time or who have a requirement for a tailored course. Closed courses typically provide cost benefits when there are at least four employees who need training simultaneously. Courses can be run at PTR's Training Centre or on-site if suitable facilities exist. Benefit from substantial discounts on technical training with our SAVE IT Scheme. If you, or your organisation has a training requirement of 10+ days then our Save IT Scheme may provide additional savings on your training.
    Advantages of studying with PTR Associates Ltd
    Vendor-independent & Generic Training - unbiased independent knowledge Small Class Sizes - increased interaction with lecturer Hands-on - increased learning efficiency Training Environment - modern, air-conditioned classrooms Course Notes - up-to-date, plain English, excellent reference material Training Experience - friendly, personal service
    Refreshments - morning and afternoon breaks with lunch arrangements second to none, at one of the many local restuarants ROI - our prices and quality mean an excellent Return on Investment   Lecturer Expertise - vendor certified with real-world product experience
    Course provider history
    PTR Associates Ltd was established in 1989.
    Specialises in
    Applications Programming Databases Operating Systems Data Communications and Networking Internet Scripting

    All courses

    by PTR Associates Ltd on emagister.

    See list of courses

    Get direct information on how to enrol, venues and availability...

    Training related to SQL Server

    More related courses
    Data Modelling Price: On request
    + sql server Courses + SQL Server Courses in Berkshire + PTR Associates Ltd Courses
     

    Most searched for in SQL Server

    Courses IT, Computing, Telecommunications | Courses Database Administration | Courses SQL Server | Courses Database Design | Courses Database training |
    International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina
    Words related to the courses viewed: sql database design sql server
    emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights