Microsoft Certified Solution Developer
As the Windows Development Campus, it is our goal to provide not only the best quality training, but a curriculum that fully encompasses all aspects of application development for Windows. Many of you will not be developing applications from the ground up in C++, but will be writing integration code to take advantage of the components offered by Microsoft Office. Applications written for Microsoft Office are an important part of Microsoft's strategy for the overall success of Windows. To prepare developers for building applications with Office, Microsoft has created the Microsoft Certified Solution Developer program. If you are planning on writing applications using Microsoft Office, you should consider becoming a Microsoft Certified Solution Developer. DevelopMentor can help you through this program by providing the Solution Developer curriculum described on the following pages. Theses courses will help you complete your Microsoft Solution Developer certification.
To become a Microsoft Certified Solution Developer you must complete the following courses and pass a Drake exam.
Core Technologies Requirements
- Microsoft Windows Operating Systems and Services Architecture I
- Microsoft Windows Operating Systems and Services Architecture II
Electives (choose two)
- Microsoft Visual Basic
- Microsoft Excel and Visual Basic for Applications
- Microsoft Access
- Microsoft SQL Server Implementation
CORE TECHNOLOGY REQUIREMENTS
Course Name Course Number September October November December Microsoft Windows Operating Systems and Systems Architectures I/II MS #484 10/20 - 11/22 Essential Visual Basic DM FW150 9/18 - 9/22 10/16 - 10/20 11/13 - 11/17 12/18 - 12/22 Developing Applications for Microsoft Excel using Visual Basic for Applications MS #349 12/11 - 12/15 Programming With Microsoft Access 2.0 MS #435 11/06 - 11/10 Implementing a Database Design on Microsoft SQL Server for Windows NT MS #243 10/23 - 10/27 SOLUTION DEVELOPER CURRICULUM
Microsoft Windows Operating Systems and Services Architecture
At the end of the course, you will be able to: define key architectural constructs of the Windows 32-bit operating system and explain how constructs are related; explain the differences between the user interface design guidelines of the Microsoft Windows 95 and Windows for Workgroups operating systems; define key architectural constructs of OLE and explain how those constructs are related; and define key architectural constructs of Windows Open Services Architecture (WOSA) including Open Database Connectivity (ODBC), Messaging API (MAPI), and Telephony API (TAPI).Developing Applications for Microsoft Excel Using Visual Basic for Applications
Learn to: use Microsoft Excel to develop applications that aggregate and present data; create a structured macro in Visual Basic for Applications with proper placement of main code, subroutines, dialog box definitions, and menu descriptions; properly use names to identify macro code, dialog box definitions, and values; and create sophisticated applications with such features as custom dialog boxes, menus, and toolbars.Programming with Microsoft Access 2.0
Learn to: create powerful applications using the programming capabilities of Access Basic and Data Access Objects; extend the capabilities of Microsoft Access through the use of custom controls, add-ins, object linking and embedding (OLE), and dynamic data exchange (DDE); extend applications using dynamic-link libraries (DLLs) in Microsoft Windows; and increase productivity by creating libraries, wizards, and add-ins.Implementing a Database Design on Microsoft SQL Server for Windows NT
Learn to: create database devices, databases, datatypes, and tables; write Transact-SQL statements to enforce data integrity (Datatypes, Defaults, Rules, and Triggers); create indexes, views, and stored procedures; import and export data; execute remote stored procedures and extended stored procedures; and explain the purpose and function of Open Data Services.