The
types of applications MCSDs are able to develop include desktop applications
and multi-user, Web-based, N-tier, and transaction-based applications.
The credential covers job tasks ranging from analyzing business requirements
to maintaining solutions.
The
MCSD Certification is Appropriate for
§
Software engineers.
§
Software applications
engineers
§
Software developers
§
Technical consultants
6
COURSES - PREPARING FOR 4 EXAMS
Code
|
CORE
REQUIREMENTS
Course
Title
|
Afternoons
|
Evenings
|
| |
|
|
|
|
1303
|
|
10
Sessions
|
12
Sessions
|
|
1013
|
Mastering
Visual Basic 6.0 Development
|
10
Sessions
|
12
Sessions
|
|
1016
|
|
10
Sessions
|
12
Sessions
|
|
1608
|
|
6
Sessions
|
7
Sessions
|
|
1609
|
|
6
Sessions
|
7
Sessions
|
| |
|
|
|
|
Code
|
ONE
ELECTIVE REQUIRED
Course
Title
|
Afternoons
|
Evenings
|
| |
|
|
|
|
1017
|
|
10
Sessions
|
12
Sessions
|
|
2073
|
|
N/A
|
12
Sessions
|
| |
|
|
|
Microsoft
Certified Solution Developers are required to pass three core exams
and one elective exam. The core technology exams require candidates
to prove their competency with solution architecture, desktop applications
development and distributed applications development. The elective
exam requires proof of expertise with Microsoft development tools.
The
MCSD track includes certification exams that test the candidate's
ability to build Web-based, distributed, and commerce solutions by
using Microsoft's application server and other products, such as Microsoft
SQL Server™ and Microsoft Visual Studio®.
RECOMMENDED
EXPERIENCE
Candidates
for this certification should have substantial knowledge of the functionality
of both Microsoft Office and Microsoft BackOffice® applications, as
well as at least two years of experience in the following areas:
§
Analyzing customer
needs and creating requirement specification documents for client/server
solutions in multiple business domains.
§
Process modeling, data
modeling, component design, and user interface design.
§
Designing, developing,
and implementing a client/server solution.
§
Integrating new systems
and applications into legacy environments.
§
Developing Windows-based
and Web applications.
BENEFITS
OF MCSD
Microsoft®
Certified Solution Developers receive the following benefits (Effective
January 1, 2000):
§
Industry
recognition of your knowledge
and proficiency with Microsoft products and technologies.
§
Microsoft
Developer Network subscription.
Rebates or discounts on a one-year subscription to the Microsoft Developer
Network (MSDN®) during the first year of certification. (Fulfillment
details will vary, depending on your location; please see your Welcome
Kit.) The rebate or discount amount is $200 US for MSDN Professional
and $500 US for MSDN Universal.
§
Access
to exclusive discounts on
products and services from selected companies. Some offers are available
to premier levels of certification only (Microsoft Certified Systems
Engineer+Internet, Microsoft Certified Systems Engineer, Microsoft
Certified Database Administrator, Microsoft Certified Solution Developer).
Current MCPs can gain access to these benefits by visiting the MCP
secured Web site and selecting "Other Benefits."
Individuals with premier certifications may select "Premier Benefits."
§
Access
to technical and product information
direct from Microsoft through a secured area of the MCP Web site.
§
MCSD
logo, certificate, wallet card, and lapel pin
to identify you as a Microsoft Certified Professional to colleagues
or clients. Electronic files of logos and transcript may be downloaded
from the MCP
secured Web site upon certification.
§
Invitations
to Microsoft conferences, technical training sessions, and special
events.
website optimization
§
Free
access to Microsoft
Certified Professional Magazine Online, a career and professional
development magazine. Secured content on the Microsoft Certified Professional
Magazine Online Web site includes the current issue (available only
to MCPs), additional online-only content and columns, an MCP-only
database, and regular chats with Microsoft and other technical experts.
Additional online benefits are available to individuals with the MCSE+Internet,
MCSE, MCSD, and MCDBA certifications. Enter the MCP
secured Web site for access to the Microsoft Certified
Professional Magazine Online. (All MCPs are eligible for the online
magazine's secured content. Some MCPs may also be eligible to receive
the print version of the magazine free; eligibility is determined
by the magazine.)
Course
1303: Mastering Microsoft Visual Basic 6 Fundamentals
Introduction
This
course teaches programmers the skills necessary to create Microsoft®
Visual Basic® programming system desktop applications and satisfies
the Visual Basic prerequisites for course 1013, Mastering Visual
Basic 6 Development.
At Course Completion
Students
will be able to:
§
Build custom, multiple-form
applications.
§
Incorporate dynamic
menus, pop-up menus, status bars, and custom toolbars into applications.
§
Implement form-level
and field-level input validation.
§
Debug applications
using debugging tools provided in Visual Basic 6.
§
Use standard controls,
control arrays, and create controls dynamically.
§
Execute centralized
error-handling in applications.
§
Use the data control
for database access.
§
Implement drag and
drop in Visual Basic-based applications.
§
Use Microsoft ActiveX®
controls in Visual Basic-based applications.
§
Create setup programs
to distribute applications.
Microsoft Certified
Professional Exams
This
course is not associated with any Microsoft Certified Professional
exams.
Prerequisites
§
Working knowledge of
programming concepts
Course
1013: Mastering Microsoft Visual Basic 6 Development
Introduction
This
course will teach Microsoft® Visual Basic® programmers how to create
database applications using components.
At Course Completion
Students
will be able to:
§
Write a Microsoft Visual
Basic-based application that accesses data from a database.
§
Write a Visual Basic-based
application that uses component object model (COM) components.
§
Create an ActiveX®
control.
§
Create a COM component.
§
List the opportunities
that Visual Basic developers have to incorporate Internet technologies
into their applications.
Microsoft Certified
Professional Exams
This
course will help the student prepare for the following Microsoft Certified
Professional exam(s):
§
Exam
70-176, Designing and Implementing Desktop Applications with Microsoft®
Visual Basic® 6.0
Prerequisites
This
course assumes the student has a good working knowledge of the Microsoft
Visual Basic programming system. Potential students should be able
to accomplish the following tasks before taking this training:
§
Create an application
with multiple forms and add functionality for multiple events to the
controls on those forms
§
Write a Function procedure
and a Sub procedure, and invoke them from Event procedures
§
Declare variables and
use conditional statements
§
Describe the purpose
and use of each of the controls in the Toolbox
§
Add a simple menu interface
to an application
§
Retrieve and validate
information from a user
§
Add a custom control
to a project
§
Describe the relationship
between properties, methods, and objects
§
Add run-time error
handling to an application
§
Run the application
and use debug mode within the Visual Basic environment
§
Create an EXE file
from the project files
§
Design and use a relational
database
§
Use SQL syntax to create
database queries
Course
1016: Mastering Enterprise Development Using Microsoft Visual Basic
6
Introduction
This
course will teach Microsoft® Visual Basic® programmers, who currently
build desktop applications and access corporate databases, the basics
of how to build three-tier client/server solutions.
At
Course Completion
Students
will be able to:
§
Compare traditional
client/server development with Internet development and describe Microsoft's
enterprise development strategy,
§
Use the Application
Architecture Model from the Microsoft Solutions Framework to organize
applications into user, business, and data services.
§
Use the Microsoft Visual
Basic programming system to build component object model (COM) dynamic-link
libraries (DLLs) and implement them in a multiuser environment using
Microsoft Transaction Server (MTS).
§
Use MTS to address
application infrastructure issues associated with building server-side
COM objects that are used by many clients.
§
Create COM objects
that use MTS services to participate in transactions and that use
security.
§
Use programming techniques
to increase the scalability of COM objects.
§
Use ActiveX® Data Objects
(ADO) from the middle tier to access data and invoke business and
data services implemented in SQL.
§
Implement business
and data services in a Microsoft SQL Server™ database through the
use of stored procedures.
§
Apply basic debugging,
error handling, and security techniques in a three-tier application.
Microsoft Certified
Professional Exams
This
course will help the student prepare for the following Microsoft Certified
Professional exam(s):
§
Exam 70-175, Designing
and Implementing Distributed Applications with Microsoft® Visual Basic® 6.0
Prerequisites
This
course assumes that the student has intermediate programming competency
with the Microsoft Visual Basic programming system. Before attending
this course, students must be able to demonstrate the following skills:
§
Build and debug a simple
Visual Basic-based application
§
Invoke and control
an Automation server, such as Microsoft Excel or Microsoft Word, from
a Visual Basic-based application
§
Create COM components
using Visual Basic and invoke them from a client application
§
Use ActiveX Data Objects
toa database and work with record sets
§
Understand and use
basic syntax for SQL
Completing
either of the following courses satisfies the prerequisite skills
listed above:
§
Course 1013, Mastering
Microsoft Visual Basic 6 Development
§
Course 1017, Mastering
Web Site Development Using Microsoft Visual InterDev™ 6
Course
1608: Designing Business Solutions
Introduction
This
five-day workshop teaches participants to use the appropriate Microsoft®
Solutions Framework (MSF) models and processes to create conceptual,
logical, and physical designs for a business solution. Participants
will also learn how to select suitable technologies and architectures
for their solution, based on trade-off analysis.
At Course Completion
Students
will be able to:
§
Use the MSF Process
Model and MSF Application Model to develop conceptual, logical, and
physical designs of a business solution.
§
Select solution technologies
and architecture based on a tradeoff analysis.
§
Address the issues
involved in designing a user interface.
§
Produce a baseline
functional specification that can be used to develop a business solution.
Microsoft Certified Professional Exams
This
course will help the student prepare for the following Microsoft Certified
Professional exam:
§
Exam 70-100, Analyzing
Requirements and Defining Solution Architectures
Prerequisites
Before
attending this course, students must have:
§
Six months experience
as part of a software development team
§
General understanding
of a software development life cycle
§
General knowledge of
Microsoft technologies
§
General understanding
of the process of gathering and analyzing business requirements
Recommended
courses:
§
Course 1585, Gathering
and Analyzing Business Requirements or equivalent experience and knowledge
Course
1609: Designing Data Services and Data Models
Introduction
This
workshop teaches students to analyze business requirements to determine
data storage and data access requirements. Participants will learn
to design data models and the data layer of a Microsoft® Windows®
DNA architecture, and select the appropriate Microsoft technologies.
At Course Completion
Students
will be able to:
§
Derive conceptual data
requirements from business requirements.
§
Develop entity/relationship
(ER) models.
§
Normalize a logical
data model.
§
Create an optimized
physical data model.
§
Select the appropriate
type and location of data integrity requirements to implement, given
a set of constraints.
§
Select appropriate
data access and data storage technologies for a solution.
Microsoft Certified
Professional Exams
This
course will help the student prepare for the following Microsoft Certified
Professional exam:
§
Exam 70-100, Analyzing
Requirements and Defining Solution Architectures
Prerequisites
Before
attending this course, students must be able to demonstrate the following:
§
A general understanding
of the software development life cycle
§
A general understanding
of relational database management systems
§
A general understanding
of the process of gathering and analyzing business requirements
Recommended
course:
§
Course 1585, Gathering
and Analyzing Business Requirements
Course
1017: Mastering Web Application Development Using Microsoft Visual
InterDev 6
Introduction
This
course teaches site developers who perform architectural planning,
technology selection, or Web site programming tasks how to create
enterprise-level Web sites that use component object model (COM) components
on both the client and the server.
At Course Completion
At
the end of the course, students will be able to:
§
Describe the issues
involved in creating an enterprise Web site.
§
Create and publish
a simple Web site with Microsoft® Visual InterDev™ Web development
system version 6.0.
§
Create interactive
content for a Web site.
§
Add server scripting
to a Web page using active server pages (ASP) and COM components.
§
Implement security
in a Web site.
§
Read and write information
to an OLE DB provider from ASP using Visual InterDev data tools.
§
Build reusable, robust
COM components with Microsoft Visual Basic® programming system version
6.0 that are compatible with Microsoft Transaction Server (MTS).
§
Integrate Web solutions
with Microsoft BackOffice® family services.
Microsoft Certified
Professional Exams
This
course will help the student prepare for the following Microsoft Certified
Professional exam(s):
§
Exam 70-152, Designing
and Implementing Web Solutions with Microsoft Visual InterDev 6.0
Prerequisites
Students
should be able to:
§
Browse World Wide Web
sites with Microsoft Internet Explorer.
§
Send and receive electronic
mail with a mail client such as Microsoft Exchange.
§
State differences between
two-tier and three-tier client/server architecture models.
§
Define the Internet
and what it is used for.
§
Compose a new hypertext
markup language (HTML) document with an HTML authoring program such
as the Microsoft FrontPage® Web site creation and management tool.
§
Use ActiveX® controls
and Java applets on a Web page.
§
Use a database development
tool to:
o
Execute queries and
call stored procedures.
o
Discriminate between
record sets and tables.
o
Write a simple SQL
query using SELECT and WHERE.
This
course assumes that the student has intermediate programming competency
with Visual Basic. Before attending this course, students must be
able to demonstrate the following skills, preferably with Visual Basic:
§
Use looping and conditional
constructs.
§
Create Functions and
Sub procedures.
§
Use an object model
in an application.
§
Use the Visual Basic
Object Browser or similar tool to examine the properties, methods,
and events of objects.
Completing
both the Mastering Fundamentals of Web Site
Development and Mastering Microsoft Visual
Basic 5 Fundamentals courses satisfies the prerequisite skills
listed above.
Course
2073: Programming a Microsoft SQL Server 2000 Database
Introduction
This
course provides students with the technical skills required to program
a database solution by using Microsoft®
SQL ServerTM
2000.
At Course Completion
At
the end of the course, students will be able to describe the elements
of SQL Server 2000; design a SQL Server enterprise application architecture;
describe the conceptual basis of programming in Transact-SQL; create
and manage databases and their related components; implement data
integrity by using the IDENTITY column property, constraints, defaults,
rules, and unique identifiers; plan for the use of indexes; create
and maintain indexes; create, use, and maintain data views; implement
user-defined functions; design, create, and use stored procedures;
create and implement triggers; program across multiple servers by
using distributed queries, distributed transactions, and partitioned
views; optimize query performance; analyze queries; and manage transactions
and locks to ensure data concurrency and recoverability.
Prerequisites
§
Before attending this
course, students must have:
Experience
using the Microsoft Windows®
2000 operating system to:
- Connect
clients running Windows 2000 to networks and the Internet.
- Configure
the Windows 2000 environment.
- Create
and manage user accounts.
- Manage
access to resources by using groups.
- Configure
and manage disks and partitions, including disk striping and mirroring.
- Manage
data by using the NTFS file system.
- Implement
Windows 2000 security.
- Optimize
performance in Windows 2000.
o
For
students who do not meet this prerequisite, the following courses
provide students with the necessary knowledge and skills:
- Course
2151, Microsoft Windows 2000 Network and Operating System Essentials
- Course
2152, Implementing Microsoft Windows 2000 Professional and Server
§
An understanding of
basic relational database concepts, including:
o
Logical and physical
database design.
o
Data integrity concepts.
o
Relationships between
tables and columns (primary key and foreign key, one-to-one, one-to-many,
many-to-many).
o
How data is stored
in tables (rows and columns).
§
For
students who do not meet this prerequisite, the following course provides
students with the necessary knowledge and skills:
o
Course 1609, Designing
Data Services and Data Models
§
Knowledge of basic
Transact-SQL syntax (SELECT, UPDATE, and INSERT statements).
For
students who do not meet this prerequisite, the following course provides
students with the necessary knowledge and skills:
o
Course 2071, Querying
Microsoft SQL Server 2000 with Transact-SQL
§
Familiarity with the
role of the database administrator.
Microsoft
Certified Professional Exams
This
course will help the student prepare for the following Microsoft Certified
Professional exam:
Exam
70-229, Designing and Implementing Databases with Microsoft SQL
Server 2000 Enterprise Edition
