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.
- By Michael Domingo
- November 08, 2005
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/.