Training Tools Follow SQL, Visual Studio Launch -- Redmondmag.com

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
11/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/.

Featured

Using Configuration Files to Control PowerShell Scripts, Part 2: Building Blocks

Learn how to use PowerShell's GUI capabilities to dynamically create configuration files that enhance script flexibility and usability.
U.S. House Leaders Unveil Bipartisan Strategy for AI Governance and Innovation

On Tuesday, U.S. House Speaker Mike Johnson and Democratic Leader Hakeem Jeffries received the final report from the bipartisan House Task Force on Artificial Intelligence, which outlines essential principles and recommendations to bolster American leadership in AI.
Using Configuration Files to Control PowerShell Scripts, Part 1: The Basics

Learn how to use JSON configuration files to make PowerShell scripts more dynamic, flexible and user-friendly.
Exchange Online Receiving Enhanced Message Trace

Microsoft has announced the public preview of its enhanced Message Trace feature in the Exchange admin center (EAC) for Exchange Online.
Major Microsoft Multifactor Authentication Vulnerability Revealed

A vulnerability in Microsoft’s multifactor authentication (MFA) system has been uncovered by cybersecurity firm Oasis Security, allowing attackers to bypass security measures and access sensitive data across services including Outlook, OneDrive, Teams and Azure.