Perpetual Solutions
Tuition House
27-37 St Georges Road, London
SW19 4DS

+44 (0)20 7620 0033
+44 (0)20 7620 0055

Microsoft SQL Server Training Courses

For Oracle PL/SQL and SQL*Plus Training Courses click here

For vendor independent SQL Programming Training Courses click here

Official Microsoft SQL Server Training Courses from the Microsoft curriculum. Courses are available on our public schedule which offers dates across the UK, or we can present an onsite course at your location. If you wish to find out about Microsoft SQL Certification such as the MCITP Database Administrator click here.

Training is available for both SQL Server 2008 which is the latest version, SQL 2005 and SQL Server 2000 which is still in use in many organisations. SQL 2008 and 2005 courses are to be found at the top of this page, and SQL 2000 courses are found towards the bottom of this page.

Click on the course titles below to see the content for your chosen course, click on the course schedule button above to see the public schedule dates.

**Great Offers**

If you wish to enquire about Late Availability Pricing or about our Great Offers; choose your training course, click on a course date at the bottom of the course outline, or in the public course schedule, then fill in the enquiry form. Alternatively call sales on +44 (0) 20 7620 0033.

Writing Queries Using MS SQL Server 2008 & 2005 Transact-SQL
This 3-day Writing Queries Using MS SQL Server 2008 & 2005 Transact-SQL training course covers SQL 2008 but also applies to SQL 2005.

Upgrading Your SQL Server 2000 Skills to SQL Server 2008
This 3-day Upgrading Your SQL Server 2000 Skills to SQL Server 2008 training course will enable delegates to upgrade their DBA skills to SQL Server 2008 DBA.

M6231 Maintaining a Microsoft SQL Server 2008 Database
5 Day Microsoft SQL Server Course - Learn how to use SQL Server 2008 product features and tools related to maintaining a database

M6232 Implementing a Microsoft SQL Server 2008 Database
5 Day Microsoft SQL Server Course - Learn how to implement data integrity in Microsoft SQL Server 2008 databases by using constraints and triggers

M50400: Designing, Optimizing, and Maintaining a Database Administrative Solution for Microsoft SQL Server 2008
This 5-day course provides the skills required to design, optimize and maintain a database administrative solution for Microsoft SQL Server 2008.

MS6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
3 Day Microsoft SQL Server Course - Learn how to implement an Analysis Services solution in an organization and Manage using the administrative tools

MS6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
3 Day Microsoft Windows SQL Server Course - Learn how to implement data transfer or extract, transform, and load (ETL) solutions

MS6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
3 day instructor-led course on implementing a Reporting Services solution.

M6158: Updating Your SQL Server 2005 Skill to SQL Server 2008
3 Day Microsoft SQL Server Course - Provides the knowledge and skills to upgrade from SQL Server 2005 to SQL Server 2008

Advanced T-SQL Querying, Programming and Tuning for SQL Server 2005 & 2008
This 5-day course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2005 and 2008.

Accelerated MCTS SQL Server 2008 Implementation and Maintenance
Focus on earning an MCTS Implementation and Maintenance certification on this intensive ACCELERATED track. Demonstrate your skill in working with SQL Server 2008.

M2733: Updating Your Database Admininstration Skills to MS SQL Server 2005
Training course M2733: Updating Your Database Administration Skills to MS SQL Server 2005 provides SQL 2000 DBA's with skills required to administer and troubleshoot SQL Server 2005.

M2779: Implementing a Microsoft SQL Server 2005 Database
A 5-day Training Course on M2779: Implementing a Microsoft SQL Server 2005 Database; using product features & tools related to implementing a database

M2780: Managing a Microsoft SQL Server 2005 Database
A 5-day Training Course on M2780: Managing a Microsoft SQL Server 2005 Database; using product features & tools related to maintaining a database

M2781: Designing Microsoft SQL Server 2005 Server-side Solutions
A 3-day Training Course on M2781: Designing Microsoft SQL Server 2005 Server-side Solutions; is intended for current professional database developers

M2782: Designing Microsoft SQL Server 2005 Databases
A 2-day Training Course on M2782: Designing Microsoft SQL Server 2005 Databases; teaches students to incorporate security requirements throughout their designs.

M2783: Designing the Data Tier for Microsoft SQL Server 2005
A 1-day Training Course on M2783: Designing the Data Tier for Microsoft SQL Server 2005; intended for current professional database developers

M50027: Querying and Processing SQL Server Data Using Microsoft SQL Server
M50027 is a 2-day hands-on training course offering the skills needed for Querying and Processing SQL Server Data Using Microsoft SQL Server

M2784: Tuning and Optimising Queries Using Microsoft SQL Server 2005
A 2-day Training Course on M2784: Tuning and Optimising Queries Using Microsoft SQL Server 2005; learn to evaluate & improve queries & query response times

M2786: Designing a Microsoft SQL Server 2005 Infrastructure
A 2-day Training Course on M2786: Designing a Microsoft SQL Server 2005 Infrastructure; strategies for data archiving, consolidation, distribution, & recovery

M2787: Designing Security for Microsoft SQL Server 2005
A 2-day Training Course on M2787: Designing Security for Microsoft SQL Server 2005; emphasizes thinking about the whole environment during design

M2788: Designing High Availability Solutions for Microsoft SQL Server 2005
A 3-day Training Course on M2788: Designing High Availability Solutions for Microsoft SQL Server 2005; intended for current professional database administrators

M2789: Administering and Automating Microsoft SQL Server 2005 Databases and Services
A 1-Day Training Course on M2789: Administering and Automating Microsoft SQL Server 2005 Databases and Services; intended for professional database administrators

M2790: Troubleshooting and Optimising Database Servers Using Microsoft SQL Server 2005
A 2-day Training Course on M2790: Troubleshooting and Optimising Database Servers Using Microsoft SQL Server 2005; Determine & troubleshoot performance issues

M2791: Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
Training course M2791: Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services is intended for IT professionals and developers

M2792: Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
Develop, deploy, and manage with training course M2792: Implementing and Maintaining Microsoft SQL Server 2005 Integration Services

M2793: Implementing and Maintaining SQL Server 2005 Reporting Services
Create reports & manage a Reporting Services solution with training course M2793: Implementing and Maintaining SQL Server 2005 Reporting Services

M2794: Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005
Two-day instructor-led training course M2794: Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005

M2795: Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services
2-day instructor-led training course M2795: Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services

M2796: Designing on Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services
Training course M2796: Designing on Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services is intended for BI professionals

M2797: Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Service
Support your BI solution with training course M2797: Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Service

SQL Server End to End Business Intelligence
The SQL Server End to End Business Intelligence Workshop training course includes extensive demonstrations and hands-on labs

Microsoft Office PerformancePoint Server 2007
5 Day Course on PerformancePoint 2007 Server - Learn to create and integrate Applications with our BI Technologies

M2071: Querying MS SQL 2000 with Transact SQL
A 2-day Training Course on M2071: Querying MS SQL 2000 with Transact SQL; provides students with the technical skills to write basic Transact-SQL queries

M2072: Microsoft SQL Server 2000 Database Administration
A 5-day Training Course on M2072: Microsoft SQL Server 2000 Database Administration; learn to install, configure, administer, and troubleshoot.

M2073: Microsoft SQL Server 2000 Database Programming
A 5-day Training Course on M2073: Microsoft SQL Server 2000 Database Programming; provides the technical skills required to program a database solution

M2074: Microsoft SQL Server 2000 Designing and Implementing OLAP Solutions
A 5-day Training Course on M2074: Microsoft SQL Server 2000 Designing and Implementing OLAP Solutions; skills to design, implement, & deploy OLAP solutions

Would you like any of these courses to be delivered onsite at your location? Click here to make an onsite training enquiry or call Sales on +44 (0) 20 7620 0033. For public scheduled dates click here .