News

Training Tools Follow SQL, Visual Studio Launch

Microsoft Learning releases training tools to coincide with launch of the company's relational database and software development suites.

Microsoft finally made the release of SQL Server 2005 and Visual Studio 2005 official with its highly anticipated launch event in San Francisco. The Redmond giant immediately followed the launch with announcements of online assessments, instructor-led, e-learning and self-study training offerings, some of which are available immediately.

For SQL Server 2005:

  MCITP: Database Administrator MCITP: Database Developer MCITP: Business Intelligence Developer
Online Skill Assessment Introducing SQL Server 2005 for Database Administrators
Introducing SQL Server 2005 for Database Developers Introducing SQL Server 2005 for Business Intelligence Developers
Microsoft Press (self-study)

SQL Server 2005 Administrator's Pocket Consultant

[Available soon:
Inside Microsoft SQL Server 2005: The Storage Engine, 1/06

Inside Microsoft SQL Server 2005: T-SQL Programming, 2006

MCTS Self-Paced Training Kit (Exam 70-431): Implementing and Maintaining Microsoft SQL Server 2005, 2006

MCITP Self-Paced Training Kit (Exam 70-443): Designing a Microsoft SQL Server 2005 Database Server Infrastructure, 2006

MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005, 2006]

SQL Server 2005 Programming Step by Step

[Available soon:
Programming Microsoft SQL Server 2005, 3/06

Inside Microsoft SQL Server 2005: The Storage Engine, 1/06

Inside Microsoft SQL Server 2005: T-SQL Programming, 2006

MCTS Self-Paced Training Kit (Exam 70-431): Implementing and Maintaining Microsoft SQL Server 2005, 2006]

[Available soon:
Microsoft SQL Server 2005 Analysis Services Step by Step, 2006

Microsoft SQL Server 2005 Reporting Services Step by Step, 2006

Inside Microsoft SQL Server 2005: The Storage Engine, 1/06

Inside Microsoft SQL Server 2005: T-SQL Programming, 2006

MCTS Self-Paced Training Kit (Exam 70-431): Implementing and Maintaining Microsoft SQL Server 2005, 2006]

Microsoft Official Curriculum (instructor-led)

2733: Updating Your Database Administration Skills to SQL Server 2005

[Available soon:
2779: Implementing a SQL Server 2005 Database

2780: Maintaining a SQL Server 2005 Database

2786: Designing a SQL Server 2005 Infrastructure

2787: Designing Security for SQL Server 2005

2788: Designing High Availability Database Solutions Using SQL Server 2005

2789: Administering and Automating SQL Server 2005 Databases and Services

2790: Troubleshooting and Optimizing Database Servers Using SQL Server 2005]

2734: Updating Your Database Development Skills to SQL Server 2005

[Available soon:
2783: Designing the Data Tier for SQL Server 2005

2782: Designing SQL Server 2005 Databases

2781: Designing SQL Server 2005 Server-Side Solutions

2784: Tuning and Optimizing Queries Using SQL Server 2005]

[Available soon:
2779: Implementing a SQL Server 2005 Database

2780: Maintaining a SQL Server 2005 Database]

E-Learning Courses

2936: Installing and Securing SQL Server 2005

2937: Administering and Monitoring SQL Server 2005

2938: Data Availability Features in SQL Server 2005

[Available soon:
2786 Designing a Microsoft SQL Server 2005 Infrastructure
2787 Designing Security for Microsoft SQL Server 2005

2789: Administering and Automating Microsoft SQL Server 2005 Databases and Services

2790: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
2788 Designing High Availability Database Solutions Using Microsoft SQL Server 2005]

2939: Programming SQL Server 2005

2940: Building Services and Notifications Using SQL Server 2005

2941: Creating the Data Access Tier Using SQL Server 2005

[Available soon:
2782 Designing SQL Server 2005 Databases

2783: Designing the Data Tier for SQL Server 2005

2781: Designing SQL Server 2005 Server-Side Solutions

2784: Tuning and Optimizing Queries Using SQL Server 2005]

2942: New Features of SQL Server 2005 Analysis Services

2943: Updating Your Data ETL Skills to SQL Server 2005 Integration Services

2944: Updating Your Reporting Skills to SQL Server 2005 Reporting Services

For Visual Studio:

  MCPD: Windows Developer MCPD: Web Developer MCPD: Enterprise Application Developer
Online Skill Assessment What’s New in Visual Studio 2005
What's New in ASP.NET 2.0

What’s New in Visual Studio 2005

What's New in ASP.NET 2.0

Microsoft Press (self-study)

Microsoft Visual Basic 2005 Step by Step

Microsoft Visual C# 2005 Step by Step

Programming Microsoft Windows Forms

[Available soon:
Programming Microsoft Visual C# 2005 Core Reference
, 12/05

Programming Microsoft Visual Basic 2005 Core Reference, 1/06

CLR via C#, Second Edition, 2/06

CLR via C++, 2/06

Debugging, Tuning, and Testing Microsoft .NET 2.0 Applications, 4/06

Programming Microsoft Visual C# 2005 Framework Reference, 5/06

MCTS/MCPD Self-Paced Training Kit (Exams 70-526 and 70-548): Developing Windows-Based Applications, 2006

MCTS Self-Paced Training Kit (Exam 70-536): Microsoft .NET Framework 2.0 Foundation, 2006]

Microsoft ASP.NET 2.0 Programming Step By Step

Microsoft ADO.NET 2.0 Step by Step

Programming Microsoft Web Forms

Programming Microsoft ADO.NET 2.0 Applications: Advanced Topics

Programming Microsoft ASP.NET 2.0 Core Reference

[Available soon:
Programming Microsoft ADO.NET 2.0 Core Reference
, 3/06

Programming Microsoft ASP.NET 2.0 Applications: Advanced Applications, 3/06

MCTS/MCPD Self-Paced Training Kit (Exams 70-528 and 70-547): Developing Web Applications, 2006

MCTS Self-Paced Training Kit (Exam 70-536): Microsoft .NET Framework 2.0 Foundation, 2006]

 

Working with Microsoft Visual Studio 2005 Team System

Programming Microsoft ADO.NET 2.0 Applications: Advanced Topics

Programming Microsoft ASP.NET 2.0 Core Reference

[Available soon:
Programming Microsoft Visual C# 2005 Core Reference
, 12/05

Programming Microsoft Visual Basic 2005 Core Reference, 1/06

CLR via C#, Second Edition, 2/06

Programming Microsoft ADO.NET 2.0 Core Reference, 3/06

MCTS/MCPD Self-Paced Training Kit (Exams 70-526 and 70-548): Developing Windows-Based Applications, 2006

MCTS/MCPD Self-Paced Training Kit (Exams 70-528 and 70-547): Developing Web Applications, 2006

MCTS/MCPD Self-Paced Training Kit (Exams 70-529 and 70-549): Distributed Application Development/ Developing Enterprise Applications, 2006

MCTS Self-Paced Training Kit (Exam 70-536): Microsoft .NET Framework 2.0 Foundation, 2006]

Microsoft Official Curriculum (instructor-led)

2364: What's New in Visual Studio 2005 for existing Visual Studio .NET Developers

[Available soon:
2546: Core Windows Application Development with Visual Studio 2005, 12/05

2548: Core Distributed Application Development with Visual Studio 2005, 12/05

2541: Core Data Access Development with Visual Studio 2005, 1/06

2547: Advanced Windows Application Development with Visual Studio 2005, 2/06

2549: Advanced Distributed Application Development with Visual Studio 2005, 3/06 ]

3201: Developing ASP.NET 2.0 Web Applications

[Available soon:
2543: Core Web Application Development with Visual Studio 2005, 12/05

2544: Advanced Web Application Development with Visual Studio 2005, 1/06 ]

2551: Introduction to Visual Studio Team System (also available as an e-Learning course; see below)

[Available soon: 2544: Advanced Web Application Development with Visual Studio 2005, 1/06

2547: Advanced Windows Application Development with Visual Studio 2005, 2/06

2542: Advanced Data Access Development with Visual Studio 2005, 2/06

2549: Advanced Distributed Application Development with Visual Studio 2005, 3/06 ]

E-Learning Courses

2924: Building Data Components in Visual Studio 2005

2925: Building Managed Code for SQL Server 2005 and Creating SOA Applications with Visual Studio 2005

2926: What’s New in Visual Studio 2005 for Windows Forms Development


2927: Building Web Applications with ASP.NET 2.0 Free for a limited time

2928: Implementing Data Access and Security in an ASP.NET 2.0 Web Application

2929: Implementing Wizards, Site Navigation, State Management, and Configuration in ASP.NET 2.0

2930: Implementing Master Pages, Personalization, and Web Parts with ASP.NET 2.0

2551: Introduction to Visual Studio Team System

Microsoft Press titles can be ordered directly from the Microsoft Press site or through Amazon or BookPool.com .

Instructor-led courses can be taken at any Microsoft Certified Partners for Learning Solutions training centers (formerly Microsoft Certified Technical Education Centers) worldwide; click here to locate a training center.

Many of the e-Learning courses listed in the tables above will be available for free for a limited time; those courses retail for $99. Registration is required to sign up for e-Learning courses.

Microsoft is also giving away 150,000 vouchers for exams to launch event attendees; the vouchers retail at $125US. Vouchers can be redeemed only for specific exams, however:

  • 70-431: TS: Microsoft SQL Server 2005—Implementation and Maintenance
  • 70-536: TS: Microsoft .NET Framework 2.0—Application Development Foundation
  • 70-551: UPGRADE: MCAD Skills to MCPD Web Developer by Using the Microsoft .NET Framework
  • 70-552: UPGRADE: MCAD Skills to MCPD Windows Developer by Using the Microsoft .NET Framework
  • 70-553: UPGRADE: MCSD Microsoft .NET Skills to MCPD Enterprise Application Developer by Using the Microsoft .NET Framework: Part 1
  • 70-235: TS: Developing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006

These exams are expected to go live in early 2006; vouchers expire at the end of 2006. Even though the official launch took place Monday, more launch events are scheduled throughout select North American cities and worldwide; to find a launch event near you, go to http://www.microsoft.com/events/2005launchevents/default.mspx. To find out more about the free voucher offer, go to http://www.microsoft.com/learning/2005/cert/.

Featured