Microsoft Microsoft SQL Server 2005 Training Courses at GBdirect
This section of the site contains a range of Microsoft SQL Server 2005 training courses.
Courses offered in this topic are as indicated (
Open Public Course 
Closed In-House Course)
- Microsoft Course 2781 - Designing Microsoft SQL Server 2005 Server-Side Solutions — A 3-Day Course
- Microsoft Course 2779 - Implementing a Microsoft SQL Server 2005 Database — A 5-Day Course
- Microsoft Course 2780 - Maintaining a Microsoft SQL Server 2005 Database — A 5-Day Course
- Microsoft Course 2783 - Designing the Data Tier for Microsoft SQL Server 2005 — A 1-Day Course
- Microsoft Course 2782 - Designing Microsoft SQL Server 2005 Databases — A 2-Day Course
- Microsoft Course 50027 Querying and Processing SQL Server Data Using Microsoft SQL Server — A 2-Day
- Microsoft Course 2784 - Tuning and Optimizing Queries using Microsoft SQL Server 2005 — A 3-Day Course
- Microsoft Course 2786 - Designing a Microsoft SQL Server 2005 Infrastructure — A 2-Day Course
- Microsoft Course 2787 - Designing Security for Microsoft SQL Server 2005 — A 2-Day Course
- Microsoft Course 2788 - Designing High Availability Database Solutions Using Microsoft SQL Server 2005— A 3-Day Course
- Microsoft Course 2789 - Administering and Automating Microsoft SQL Server 2005 Databases and Servers — A 1-Day Course
- Microsoft Course 2790 - Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 — A 2-Day Course
- Microsoft Course 2791 - Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services — A 3-Day Course
- Microsoft Course 2792 - Implementing and Maintaining Microsoft SQL Server 2005 Integration Services — A 3-Day Course
- Microsoft Course 2793 - Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services — A 3-Day Course
- Microsoft Course 2797 - Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services — A 2-Day Course
- Microsoft Course 2794 - Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 — A 2-Day Course
- Microsoft Course 2795 - Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services — A 2-Day Course
- Microsoft Course 2796 - Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services — A 3-Day Course
Microsoft SQL Server 2005 is a comprehensive, integrated data management and analysis software that enables organizations to reliably manage mission-critical information and confidently run today’s increasingly complex business applications. SQL Server 2005 allows companies to gain greater insight from their business information and achieve faster results for a competitive advantage.
Business Intelligence - deliver intelligence where users want it
- Integrate data from any data source. Build, manage and deploy scalable integration solutions or populate your data warehouse and build a holistic view of your business.
- Report on enterprise-wide data. Create, manage, and deliver server-based reports with interactive views that provide valuable insights into here business is heading.
- Analyze results. Provide a consolidated view across all business dimensions as the foundation for all relational, multidimensional, and predictive analysis, enabling deep insight into the key drivers impacting businesses today.
High Availablity
- Support Mission Critical Applications - SQL Server Always On Technologies support mission critical applications with the highest level of availability--because any application downtime can impact your business, resulting in loss of revenue, decreased customer satisfaction, and damage to your company's credibility.
- Minimize System Downtime - System downtime occurs for a variety of reasons, such as human error, natural disasters, hardware or software failure, or application upgrades. SQL Server Always On Technologies provide a full range of options to minimize system downtime and maintain appropriate levels of application availability.
- Full-featured Solution - Today, SQL Server 2005 Always on Technologies include database mirroring, failover clustering, database snapshots, snapshot isolation, peer-to-peer replication, log shipping, and online operations. Used separately or in combination, these features help minimize downtime and keep critical enterprise systems available.
Security
- Reliability - Achieve a more secure deployment. SQL Server 2005 provides rich security features to protect data and network resources.
- Confidentiality - Protect your data. SQL Server 2005 clustering supports Kerberos authentication on a virtual server, and Microsoft Windows–style policies on standard logins so that a consistent policy is applied across all accounts in the domain.
- Integrity - SQL Server 2005 supports encryption capabilities within the database itself, fully integrated with a key management infrastructure. By default, client-server communications are encrypted.
Manageability
Microsoft SQL Server 2005 redefines the capabilities that customers should expect from their Database Management System. SQL Server 2005 is designed to help organizations reliably and securely manage enterprise servers. By automating routine tasks, SQL Server 2005 helps lower the cost of ongoing maintenance with increased efficiency and provides deeper insight into system health for monitoring, tuning and optimization.
Developer Productivity - Build and Deploy Critical Business-Ready Applications More Quickly
SQL Server 2005 is a highly productive database platform that enables developers to build and deploy critical business-ready applications more quickly. With close integration with Microsoft Visual Studio 2005, SQL Server 2005 takes the goal of enabling developers to a new level.
If you are looking for a particular Microsoft SQL Server course title or particular Microsoft certification scheme related to Microsoft SQL Server, but don’t see it in the left hand menu or in the list above, you can probably find it by using the site search facility or by browsing through a likely sounding category. If you know an Microsoft SQL Server training title exists, but can’t find it on the site, please telephone or email our training sales department (contact details in the lower left hand column of every page).
Microsoft SQL Server 2005 public courses schedule
M2779: Implement a MS SQL Server 2005 Database, five days (course outline)
London — £995 (+VAT)
- 22–26 Mar 2010
- 26–30 Apr 2010
- 10–14 May 2010
- 7–11 Jun 2010
- 5–9 Jul 2010
- 2–6 Aug 2010
- 6–10 Sep 2010
- 4–8 Oct 2010
- 18–22 Oct 2010
- 1–5 Nov 2010
- 6–10 Dec 2010
Wokingham — £995 (+VAT)
- 10–14 May 2010
- 20–24 Sep 2010
- 22–26 Nov 2010
- 20–24 Dec 2010
Swindon — £995 (+VAT)
- 19–23 Apr 2010
- 20–24 Sep 2010
Milton Keynes — £995 (+VAT)
- 19–23 Jul 2010
Birmingham — £995 (+VAT)
- 13–17 Sep 2010
Leicester — £995 (+VAT)
- 14–18 Jun 2010
- 6–10 Sep 2010
Manchester — £995 (+VAT)
- 26–30 Apr 2010
- 21–25 Jun 2010
- 9–13 Aug 2010
- 15–19 Nov 2010
Leeds — £995 (+VAT)
- 12–16 Apr 2010
- 24–28 May 2010
- 28 Jun–2 Jul 2010
- 5–9 Jul 2010
- 27 Sep–1 Oct 2010
Sunderland — £995 (+VAT)
- 10–14 May 2010
Glasgow — £995 (+VAT)
- 26–30 Jul 2010
- 8–12 Nov 2010
M2780: Maintain a MS SQL Server 2005 Database, five days (course outline)
London — £995 (+VAT)
- 22–26 Mar 2010
- 26–30 Apr 2010
- 10–14 May 2010
- 24–28 May 2010
- 14–18 Jun 2010
- 28 Jun–2 Jul 2010
- 12–16 Jul 2010
- 26–30 Jul 2010
- 9–13 Aug 2010
- 23–27 Aug 2010
- 13–17 Sep 2010
- 27 Sep–1 Oct 2010
- 11–15 Oct 2010
- 25–29 Oct 2010
- 8–12 Nov 2010
- 22–26 Nov 2010
- 6–10 Dec 2010
- 20–24 Dec 2010
Exeter — £995 (+VAT)
- 27 Sep–1 Oct 2010
Wokingham — £995 (+VAT)
- 24–28 May 2010
- 26–30 Jul 2010
- 29 Nov–3 Dec 2010
Reading — £995 (+VAT)
- 10–14 May 2010
- 5–9 Jul 2010
- 11–15 Oct 2010
Bristol — £995 (+VAT)
- 10–14 May 2010
- 2–6 Aug 2010
- 29 Nov–3 Dec 2010
Milton Keynes — £995 (+VAT)
- 12–16 Apr 2010
- 16–20 Aug 2010
Birmingham — £995 (+VAT)
- 22–26 Mar 2010
- 24–28 May 2010
- 5–9 Jul 2010
- 20–24 Sep 2010
Leicester — £995 (+VAT)
- 10–14 May 2010
- 12–16 Jul 2010
- 20–24 Sep 2010
Manchester — £995 (+VAT)
- 10–14 May 2010
- 16–20 Aug 2010
- 23–27 Aug 2010
- 29 Nov–3 Dec 2010
Leeds — £995 (+VAT)
- 22–26 Mar 2010
- 19–23 Apr 2010
- 12–16 Jul 2010
- 6–10 Sep 2010
- 11–15 Oct 2010
Sunderland — £995 (+VAT)
- 24–28 May 2010
- 25–29 Oct 2010
Edinburgh — £995 (+VAT)
- 7–11 Jun 2010
Glasgow — £995 (+VAT)
- 24–28 May 2010
Aberdeen — £995 (+VAT)
- 5–9 Jul 2010
M2781: Design MS SQL Server 2005 Server-Side Solutions, three days (course outline)
London — £595 (+VAT)
- 5–7 Jul 2010
- 8–10 Nov 2010
Wokingham — £595 (+VAT)
- 6–8 Sep 2010
Leeds — £595 (+VAT)
- 10–12 May 2010
M2782: Design MS SQL Server 2005 Databases, two days (course outline)
London — £395 (+VAT)
- 8–9 Jul 2010
- 11–12 Nov 2010
Wokingham — £395 (+VAT)
- 9–10 Sep 2010
Leeds — £395 (+VAT)
- 13–14 May 2010
M2783: Design the Data Tier for MS SQL Server 2005, two days (course outline)
London — £395 (+VAT)
- 1–2 Jun 2010
- 21–22 Oct 2010
Wokingham — £395 (+VAT)
- 23–24 Dec 2010
Leeds — £395 (+VAT)
- 12–13 Aug 2010
M2784: Tune & Optimize Queries using MS SQL Server 2005, three days (course outline)
London — £595 (+VAT)
- 4–6 May 2010
- 14–16 Jun 2010
- 22–24 Sep 2010
- 6–8 Dec 2010
Wokingham — £595 (+VAT)
- 11–13 Oct 2010
Leeds — £595 (+VAT)
- 16–18 Jun 2010
- 2–4 Aug 2010
M2786: Design a MS SQL Server 2005 Infrastructure, two days (course outline)
London — £395 (+VAT)
- 8–9 Apr 2010
- 14–15 Jun 2010
- 17–18 Jun 2010
- 16–17 Sep 2010
- 9–10 Dec 2010
- 16–17 Dec 2010
Wokingham — £395 (+VAT)
- 14–15 Oct 2010
Leeds — £395 (+VAT)
- 5–6 Aug 2010
M2787: Design Security for MS SQL Server 2005, two days (course outline)
London — £395 (+VAT)
- 14–15 Jun 2010
- 16–17 Jun 2010
- 11–12 Oct 2010
- 20–21 Dec 2010
Wokingham — £395 (+VAT)
- 26–27 Apr 2010
- 2–3 Aug 2010
Leeds — £395 (+VAT)
- 24–25 May 2010
- 18–19 Oct 2010
M2788: Design High Availability Database Solutions Using MS SQL Server 2005, three days (course outline)
London — £595 (+VAT)
- 10–12 May 2010
- 16–18 Jun 2010
- 12–14 Jul 2010
- 27–29 Sep 2010
- 15–17 Nov 2010
- 22–24 Dec 2010
Wokingham — £595 (+VAT)
- 28–30 Apr 2010
- 4–6 Aug 2010
Manchester — £595 (+VAT)
- 1–3 Sep 2010
Leeds — £595 (+VAT)
- 26–28 May 2010
- 2–4 Jun 2010
- 20–22 Oct 2010
- 1–3 Dec 2010
M2789: Administer & Automate MS SQL Server 2005 Databases and Servers, one day (course outline)
London — £195 (+VAT)
- 6 Apr 2010
- 4 Jun 2010
- 15 Jul 2010
- 30 Sep 2010
- 22 Oct 2010
- 18 Nov 2010
Wokingham — £195 (+VAT)
- 7 Apr 2010
- 24 Dec 2010
Leeds — £195 (+VAT)
- 13 Aug 2010
M2790: Troubleshoot & Optimize Database Servers Using MS SQL Server 2005, two days (course outline)
London — £395 (+VAT)
- 13–14 May 2010
- 2–3 Jun 2010
- 5–6 Jul 2010
- 27–28 Sep 2010
- 22–23 Nov 2010
- 16–17 Dec 2010
Wokingham — £395 (+VAT)
- 16–17 Sep 2010
Birmingham — £395 (+VAT)
- 27–28 May 2010
Manchester — £395 (+VAT)
- 22–23 Mar 2010
- 19–20 Jul 2010
- 22–23 Nov 2010
Leeds — £395 (+VAT)
- 24–25 May 2010
- 27–28 Sep 2010
M2791: Implement & Maintain MS SQL Server 2005 Analysis Services, three days (course outline)
London — £595 (+VAT)
- 22–24 Mar 2010
- 6–8 Apr 2010
- 19–21 May 2010
- 19–21 Jul 2010
- 2–4 Aug 2010
- 13–15 Sep 2010
- 8–10 Nov 2010
- 6–8 Dec 2010
Wokingham — £595 (+VAT)
- 2–4 Jun 2010
- 18–20 Oct 2010
Birmingham — £595 (+VAT)
- 26–28 Apr 2010
Manchester — £595 (+VAT)
- 24–26 Mar 2010
- 21–23 Jul 2010
- 24–26 Nov 2010
Leeds — £595 (+VAT)
- 19–21 May 2010
- 19–21 Jul 2010
- 29 Sep–1 Oct 2010
M2792: Implement & Maintain MS SQL Server 2005 Integration Services, three days (course outline)
London — £595 (+VAT)
- 12–14 Apr 2010
- 17–19 May 2010
- 23–25 Jun 2010
- 21–23 Jul 2010
- 18–20 Aug 2010
- 13–15 Sep 2010
- 11–13 Oct 2010
- 13–15 Oct 2010
- 10–12 Nov 2010
- 13–15 Dec 2010
Leeds — £595 (+VAT)
- 19–21 Apr 2010
- 21–23 Jul 2010
- 18–20 Oct 2010
Manchester — £595 (+VAT)
- 2–4 Jun 2010
- 6–8 Sep 2010
- 6–8 Dec 2010
Birmingham — £595 (+VAT)
- 5–7 May 2010
Wokingham — £595 (+VAT)
- 10–12 May 2010
- 16–18 Aug 2010
- 20–22 Dec 2010
M2793: Implement & Maintain MS SQL Server 2005 Reporting Services, three days (course outline)
London — £595 (+VAT)
- 7–9 Apr 2010
- 19–21 Apr 2010
- 4–6 May 2010
- 5–7 May 2010
- 9–11 Jun 2010
- 7–9 Jul 2010
- 4–6 Aug 2010
- 11–13 Aug 2010
- 1–3 Sep 2010
- 18–20 Oct 2010
- 22–24 Nov 2010
- 29 Nov–1 Dec 2010
- 20–22 Dec 2010
Wokingham — £595 (+VAT)
- 7–9 Apr 2010
- 12–14 Jul 2010
- 11–13 Oct 2010
Bristol — £595 (+VAT)
- 7–9 Jul 2010
- 8–10 Dec 2010
Manchester — £595 (+VAT)
- 7–9 Apr 2010
- 30 Jun–2 Jul 2010
- 27–29 Sep 2010
- 15–17 Nov 2010
Leeds — £595 (+VAT)
- 5–7 May 2010
- 18–20 Aug 2010
- 13–15 Sep 2010
- 10–12 Nov 2010
Sunderland — £595 (+VAT)
- 29–31 Mar 2010
M2795: Design an ETL Solution Architecture Using MS SQL Server 2005 Integration Services, two days (course outline)
London — £395 (+VAT)
- 15–16 Apr 2010
Wokingham — £395 (+VAT)
- 19–20 Aug 2010
- 23–24 Dec 2010
M2796: Design an Analysis Solution Architecture Using MS SQL Server 2005 Analysis Services, three days (course outline)
London — £595 (+VAT)
- 21–23 Apr 2010
- 17–19 May 2010
- 13–15 Dec 2010
Wokingham — £595 (+VAT)
- 13–15 Sep 2010
Leeds — £595 (+VAT)
- 19–21 Jul 2010
M2797: Design a Reporting Solution Architecture Using MS SQL Server 2005 Reporting Services, two days (course outline)
London — £395 (+VAT)
- 19–20 Apr 2010
- 20–21 May 2010
- 16–17 Dec 2010
Wokingham — £395 (+VAT)
- 18–19 Mar 2010
- 16–17 Sep 2010
Leeds — £395 (+VAT)
- 22–23 Jul 2010
M50027 - Query & Process SQL Server 2005 Data with SQL Statements, two days (course outline)
London — £395 (+VAT)
- 6–7 Apr 2010
- 1–2 Jun 2010
- 2–3 Aug 2010
- 4–5 Oct 2010
- 2–3 Dec 2010
Reading — £395 (+VAT)
- 3–4 Jun 2010
- 2–3 Sep 2010
- 6–7 Dec 2010
Birmingham — £395 (+VAT)
- 31 Mar–1 Apr 2010
- 17–18 May 2010
Leicester — £395 (+VAT)
- 29–30 Mar 2010
- 29–30 Jun 2010
- 6–7 Oct 2010
Leeds — £395 (+VAT)
- 6–7 May 2010
- 26–27 Jul 2010
Manchester — £395 (+VAT)
- 18–19 Mar 2010
- 12–13 Apr 2010
- 6–7 May 2010
- 17–18 Jun 2010
- 2–3 Aug 2010
- 4–5 Oct 2010
Sunderland — £395 (+VAT)
- 26–27 Apr 2010
- 19–20 Jul 2010
Glasgow — £395 (+VAT)
- 7–8 Jul 2010
- 1–2 Nov 2010
