Database Courses:
|
21a Peach Street, Wokingham, Berkshire, UK Tel: 0118 979 4000 Fax: 0118 979 4035 Email: training@ptr.co.uk Web: www.ptr.co.uk |
SQL Server Performance & Tuning CourseCourse Description 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 pre-requisites: 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.
Topics covered on the 4 day SQL Server Performance & Tuning coursePerformance & Tuning
SQL Server Internals
SQL Server Architecture
Planning A SQL Server Database Application
System Performance & Tuning
Monitoring Tools
Optimal Database Design
Index Optimisation
Locking
Query Optimisation
Analyzing Queries
Tuning SQL Statements
Database Application Tuning
Tuning SQL Server Services & Tasks
Course Classification: Technical Training Course Course Fee = £1300 (excl.VAT)
Scheduled course dates
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite SQL Server 2000 Training and bespoke SQL Server 2000 courses
If you want to attend the course but can't make the dates published then click here for details of our one-to-one training packages.
The SQL Server Performance & Tuning course qualifies for the PTR SAVE IT Scheme, which offers discounts on bookings for multiple courses and/or multiple delegates. View SAVE IT Scheme Details PTR Associates Limited21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United KingdomTel: 0118 979 4000 Fax: 0118 979 4035 Email: training@ptr.co.uk |