|
| |
|
Microsoft
Certified Solution Developer (MCSD) - Mastering
Enterprise Development Using Microsoft Visual Basic 6
|
|
More Resources by
Google: |
|
|
|
|
Microsoft
Certified Solution Developer (MCSD)
|
Mastering
Enterprise Development Using Microsoft Visual Basic 6
|
|
Course
No.
Course Length:
|
1016
5 Days
|
|
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
At
the end of the course, 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 (MSF) 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 multi-user 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 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 and data integrity features.
-
Apply
basic debugging, error handling, and security techniques in a
three-tier application.
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 application
-
Invoke
and control an Automation server, such as Microsoft Excel or
Microsoft Word, from a Visual Basic application
-
Create
code components using Visual Basic and invoke them from a client
application
-
Use
ActiveX Data Objects to open a database and work with record sets
Completing
either of the following courses satisfies the prerequisite skills listed
above:
|
|
|
|
|
Chapter
1: Introduction to Enterprise Development
|
Topics:
Introduction
to Microsoft enterprise development
Applying
the development tools
Introduction
to Microsoft Visual Studio 98, Enterprise Edition, development studio
tools and features
Case
study using Microsoft technologies
Introduction
to the sample application: Island Hopper
Lab:
Exploring
Island Hopper, the lab case study
Skills:
Students
will be able to:
-
Describe
the architecture of an enterprise solution using the Microsoft
enterprise development strategy.
-
Discuss
and select the Microsoft development tools, products, and
technologies that are most appropriate for solving a given business
problem.
-
Describe
the attributes of the business problem that will be solved in this
course, and in what way Microsoft technologies were used to build
the technical solution.
-
Use
Application Performance Explorer (APE) to analyze the impact of
choosing different technologies for the sample application.
-
Use
the development environment of Visual Basic 6.0, Enterprise Edition,
to accomplish basic tasks such as creating new projects.
|
Chapter
2: Microsoft Solutions Framework
|
|
Topics:
Introduction
to MSF
MSF
Team Model
MSF
Process Model
MSF
Application Architecture Model
Island
Hopper
Lab:
Reviewing
the Island Hopper physical design
Skills:
Students
will be able to:
-
Explain
the origins of MSF, and how it evolved from the best practices at
Microsoft and in the computer industry into a widely accepted
framework for solution development.
-
Explain
the Solution Development Discipline (SDD) as a part of MSF, which is
focused on the construction phase of the information technology life
cycle.
-
Describe
the characteristics of each member's role in the MSF Team Model.
-
List
the Microsoft tools that facilitate team development.
-
List
and describe the major phases and deliverables in the MSF Process
Model, and understand what part of the process this course focuses
on in the construction of the Island Hopper sample application.
-
Describe
the use of user, business, and data services in the MSF Application
Architecture Model.
-
Differentiate
conceptual, logical, and physical design of components in the
Application Architecture Model, and understand the physical design
of the Island Hopper sample application components.
|
|
|
Chapter
3: Building COM DLLs with Visual Basic
|
Topics:
Implementing
business services in Microsoft Visual Basic
Creating
COM DLLs in Visual Basic
Working
with COM DLL projects
Implementing
an interface
Lab:
Building
a component
Skills:
Students
will be able to:
-
List
the various ways that business services are implemented in an
enterprise solution that is developed using Visual Basic.
-
Use
a class module to create an object within a Visual Basic project.
-
Create
a COM DLL that exposes methods.
-
Create
a client application that uses a COM DLL.
-
Debug
and test a COM DLL.
|
Chapter
4: Introduction to Microsoft Transaction Server
|
|
Topics:
Introduction
to MTS
MTS
architecture
Using
MTS Explorer
MTS
security architecture
Deploying
an MTS component
Lab:
Adding
a component to MTS
Skills:
Students
will be able to:
-
List
the issues related to developing multi-user three-tier applications.
-
Explain
how MTS addresses these issues.
-
Describe
the MTS architecture.
-
Create
a package with MTS Explorer.
-
Add
an existing component to the MTS package.
-
Set
declarative security on a component or package.
-
Configure
a client computer to use an MTS component.
|
|
|
Chapter
5: Using MTS Transaction Services
|
Topics:
Transactions
Context
object
Component
configuration issues
Security
(programmatic)
Visual
Basic-related issues
Scaling
MTS
programming tips
Debugging
Error
handling issues
Labs:
Creating
an MTS component
Creating
a shared property
Skills:
Students
will be able to:
-
Describe
what a transaction is, and the benefits of the ACID properties.
-
Describe
how MTS performs a two-phase commit with a distributed transaction.
-
Call
the Context object's methods from a component to participate in
transactions.
-
Use
MTS Explorer to specify transaction properties for a component.
-
Use
programmatic security in a component to authorize a caller's
actions.
|
Chapter
6: Accessing Data from the Middle Tier
|
Topics:
Universal
data access
ActiveX
Data Object architecture
Object
model overview
Connections
Using
ActiveX Data Objects from the middle tier
Using
stored procedures from ActiveX Data Objects
Debugging
Error
handling
Security
Lab:
Using
ActiveX Data Objects to implement data services
Skills:
Students
will be able to:
-
Compare
and contrast the Microsoft data access technologies available for
use in enterprise development.
-
Understand
how ActiveX Data Objects can be used to access and update a data
source.
-
Write
middle-tier components that implement business and data services
using ActiveX Data Objects.
-
Call
a stored procedure from ActiveX Data Objects.
-
Implement
error handling in an ActiveX Data Object component.
|
|
|
Chapter
7: Building Stored Procedures with SQL
|
Topics:
Introduction
to Microsoft SQL Server
Using
data integrity
Querying
data
Programming
with T-SQL
Writing
stored procedures
SQL
Server security
Labs:
Using
the Visual Database tools
Creating
and debugging stored procedures
Skills:
Students
will be able to:
-
Explain
the role of data integrity when implementing data services in an
enterprise solution.
-
Choose
when to implement services in database or MTS objects.
-
Implement
business and data services by using stored procedures.
-
Write
a stored procedure that uses advanced SQL programming constructs,
such as conditional branching and looping structures, and error
checking.
-
Write
a stored procedure that can be used by other services, such as a
client application written with Visual Basic, and that generates
return codes and performs error checking.
-
Debug
a stored procedure.
-
Describe
the characteristics of SQL transactions and explain how they work
with MTS transactions
|
Chapter
8: Advanced Topics
|
|
Topics:
Introduction
to COM
Interfaces
Dual
interfaces
Globally
Unique Identifiers (GUIDs) and the registry
COM
threading models
Labs:
Examining
key registry settings
Using
OLEVIEW
Skills:
Students
will be able to:
-
Describe
what COM is, and the problems COM solves.
-
Create
multiple interfaces per class using Microsoft Visual Basic, and use
OLEVIEW to view IDL files.
-
Describe
Automation and dual interfaces, and use the correct type of Visual
Basic binding based on performance and flexibility requirements.
-
Understand
GUIDs and basic registry settings, and control them with Visual
Basic project settings.
-
Describe
basic threading model concepts, use the Visual Basic Run Unattended
switch, and control reentrancy issues when using the multiple
apartment threading model.
|
|
|
|
|
Topics:
Review
of Microsoft enterprise development
Review of the Microsoft Solutions Framework
Alternative design considerations
Skills:
Students
will be able to:
-
Recall
the architecture of an enterprise solution using the Microsoft
enterprise development strategy, and describe how the lab solution
fits into this architecture.
-
Describe
two additional scenarios to the one presented in the class lab
solution that would require a different approach or different
technologies.
-
Explain
where to find more information on advanced issues, such as
performance, scalability, or security
|
Microsoft
Certified Solution Developer (MCSD)
|
Analyzing
Requirements & Defining Solution Architecture
|
|
Exam
No.
Course
Length:
|
70-100
3 Days
|
|
This
course is intended to help you prepare for the Analyzing Requirements
and Defining Solution Architectures (70-100) exam.
This course combines text, graphics and review questions to teach
you about analyzing requirements and defining solutions architecture. By
completing the course, you will acquire the knowledge and skills
necessary to prepare for the exams. The chapters covered provides
content that supports the skills measured by the exam.
Prerequisites
This
course assumes that the student has a minimum of beginning/intermediate
programming skills as demonstrated by the following competencies:
-
Understands
basic programming terms and concepts
-
Is
familiar with programming tools (any vendor) for the Microsoft
Windows operating system or similar graphical programming
environment
-
Has
built and debugged simple single-user desktop applications
-
Is
interested in Microsoft's recommendations on building distributed
applications using Visual Studio Enterprise Edition
|
|
|
|
|
Chapter
1: Enterprise Architecture
|
Topics:
What
is Architecture?
Microsoft Solutions Framework (MSF)
MSF Enterprise Architecture Model
Business, Application, Information, Technology Perspective
Creating
an Enterprise Architecture
Skills:
Students
will be able to:
-
Describe
the merits of architecture-first designs.
-
Describe
the importance of architecture to IT and application success.
-
Describe
the four perspectives that make up the MSF Enterprise Architecture
Model.
-
List
the elements of each perspective.
-
Describe
the benefits of a planned enterprise architecture.
|
Chapter
2: Enterprise Applications
|
Topics:
Features
of Enterprise Applications
Enterprise Application Architecture
Guiding Software Principles
Enterprise Application Model
MSF Application Model for Development
Skills:
Students
will be able to:
-
Understand
key features of enterprise applications.
-
Understand
modern architecture techniques.
-
Identify
architecture perspectives to use within a typical enterprise
application project.
-
Identify
key principles that guide the Development of enterprise
applications.
-
List
characteristics of the MSF Application Model for Development.
|
|
|
Topics:
Team
Model vs. Hierarchical Model
Project Responsibilities
The MSF Development Team Model
Adapting Team Size to Project Size
Large-Project, Small-Project Scaling
Building,Finding, Improving Successful Teams
Team Management Tools
Skills:
Students
will be able to:
-
Understand
the challenges of the hierarchical resource model.
-
Understand
the rationale behind using the MSF Development Team Model for
application development.
-
Understand
the MSF Development Team Model's roles and responsibilities.
-
Understand
how to scale the MSF Development Team Model for large and small
projects.
-
Understand
the risks involved in combining team roles.
-
Identify
the characteristics of effective leaders.
-
Identify
the means of improving team effectiveness.
-
Identify
subject areas in which the team must be trained.
|
Chapter
4: Development Process
|
Topics:
The
Four MSF Phases
Importance of All Phases
MSF Development Process Model Principles
Using Versioned Releases
Creating Living Documents
Scheduling for an Uncertain Fixture
Managing Tradeoffs, Risks
Performing Daily Builds
Using Bottom-Up Scheduling, Versioned Processes
Team Roles in the MSF Development Process Model
Artifacts and Deliverables
Relationships Between Models
Skills:
Students
will be able to:
-
Understand
the characteristics of the Waterfall and Spiral Models and list
their disadvantages.
-
List
the workflows of the Unified Process.
-
Understand
the benefits of versioned releases and the impact of an interactive
approach on development projects.
-
Relate
team roles and responsibilities to the MSF Development Process
Model.
-
Analyze
development projects to determine process iteration goals.
|
Chapter
5: Project Vision
|
Topics:
Overview
of Project Envisioning
Pitfalls
Envisioning Process
Risk Management Process
Sources of Risk
Types
of Risk Management
Vision Document
Prototype System
Project Structure Document
Master Risk Assessment Document
Communicating the Vision
Expanding
the Envisioning Process
Skills:
Students
will be able to:
-
Explain
the roles that individual team members play during the Envisioning
Phase of the development process.
-
Describe
the Envisioning Phase of the MSF Development Process Model.
-
Understand
the concept of risk and why continual risk management is important.
-
Describe
the process of risk assessment.
-
Understand
the differences between risk mitigation and implementing risk
contingency plans.
|
|
|
|
|
Topics:
Overview
of Project Planning
Planning Phase and the MSF Design Process
Who Does What During Planning
MSF Design Process
Overview of the MSF Design Process
Conceptual, Logical, Physical Design
Ongoing Risk Management Process
Project Plan Approved Milestone and Its Deliverables
Interim Milestones
Functional Specification
Master Project Plan, Schedule
Skills:
Students
will be able to:
-
Describe
the interim milestones and deliverables that lead to the Project
Plan Approved Milestone.
-
List
and explain the purpose of various Planning Phase deliverables.
-
Explain
the roles that individual team members play during the Planning
Phase.
-
Understand
the stages of application design.
-
Analyze
business requirements and their mappings to an application's design.
-
Explain
the importance of a Functional Specification.
-
Explain
the underling principles of MSF scheduling practices.
|
Chapter
7: User Service Layer Technologles
|
Topics:
Determining
the User Interface
User Service Layer Considerations
Selecting a User Service Layer Architecture
Basics of Interface Design
Creating the Ul
Connecting the User and Business Service
Layers
Skills:
Students
will be able to:
-
Use
basic user interface guidelines to create effective user interface
designs.
-
Analyze
user interface requirements to derive the appropriate user interface
technology model.
-
Understand
different technologies that can be used to implement a user service
layer.
-
Understand
the effects of user service technologies on the deployment of
applications.
|
|
|
Chapter
8: Business Service Layer Technologies
|
Topics:
Overview
of Business Services
Component Object
Model (COM)
Automation
COM Support in
DistributeEnvironments
Packaging with MTS
Designing MTS Packages
Windows 2000 COM+ Services
Skills:
Students
will be able to:
-
Understand
the Microsoft Component Object model (COM);
-
Analyze
the role of COM in logical and pysical design models
-
Understand
COM Capabilities in transactional processing using MTS.
-
Understand
how objects are used throughout a network and enterprise.
|
Chapter
9: Data Service Layer Technologies
|
|
Topics:
What
Is the Data Service Layer?
Data Modeling
Microsoft Data Access Compnents (MDAC)
Choosing the Right Data Access Technology
Choosing Data Access STrategy
Accessing Host-Based Data
Skills:
Students
will be able to:
-
Identify
Microsoft data access technologies.
-
Distinguish
between the characteristics of relational and non-relational
databases.
-
Identify
data modeling characteristics
-
Understand
the basics of normalizing data models.
-
Identify
the most ideal data access technologies to be applied to different
types of applications.
|
Chapter
10: Testing and the Production Channel
|
Topics:
Managing
the Development Environment
Testing Enterprise Applications
Performance Validation
Scaling the Production Environment
Bug Management
Skills:
Students
will be able to:
-
Identify
the stages of a production life cycle.
-
Apply
appropriate security measures to the development environment.
-
Understand
the benefits of the development, testing, certification and
production life cycle.
-
Describe
a typical day in the production channel.
-
Identify
performance requirements.
-
Explain
how to perform software testing and application tuning.
-
Understand
the process of bug management.
|
|
Chapter
11: Application Security
|
Topics:
Authentication
Security
Encryption
Access Security
Skills:
Students
will be able to:
-
Understand
how to implement application security requirements.
-
Identify
security authentication methods.
-
Understand
basic authentication capabilities of Web services.
-
Identify
security access methods.
-
Identify
different methods of encrypting information.
-
Understand
the benefits of application auditing.
-
Identify
methods for application auditing.
|
|
Chapter
12: Development Deliverables
|
Topics:
Overview
of the Developing Phase
Development Process
Ongoing Risk Management Process
Scope Complete Milestone and Its Deliverables
Skills:
Students
will be able to:
-
Identify
interim milestones and deliverables that lead to the Scope Complete
and First Use milestones.
-
Understand
the roles played by individual team members during the Developing
Phase.
-
Apply
a zero-defect mindset to development projects.
-
Understand
the testing process's impact on software quality.
-
Understand
the bug-tracking process.
|
|
Chapter
13: Product Stabilization
|
Topics:
Overview
of Stabilization
Stablilization Process
Ongoing Risk Management Process
Release Milestone and Its Deliverables
Product Deployment
Skills:
Students
will be able to:
-
Understand
each team role's responsibilities in shipping the final release.
-
Identify
the steps in the process of stabilizing an application.
-
Understand
the incremental process of shipping the right product.
-
Identify
the deliverable for a Final Product release.
-
Understand
methods for deploying a product.
|
|
Chapter
14: Project Review
|
Topics:
Case
for Project Review
Project Review Considerations
Preparation for a Project Review Meeting
Organizing a Project Review Team
Capturing Feedback
Accountability
Skills:
Students
will be able to:
-
Describe
the benefits of a project review.
-
Evaluate
the relationship between a project review and the Software
Capability Maturity Model.
-
Identify
some practical considerations involved in project reviews.
|
|
| |
|