Cover image for MCSD fast track : solution architectures
Title:
MCSD fast track : solution architectures
Author:
Matsik, Brian.
Personal Author:
Publication Information:
Indianapolis, Ind. : New Riders, [1999]

©1999
Physical Description:
xii, 308 pages : illustrations ; 23 cm.
General Note:
Includes index.

"Covers exam: 70-100"--Cover.
Language:
English
ISBN:
9780735700291
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Item Holds
Searching...
QA76.3 .M326 1999 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

This book has two parts. Learn it quick inPart I gets you ready for the test FAST, covering just what you need to know to pass the test, assuming you have a working knowledge of the technology to begin with. Review it even quicker in Part II takes you through the test and into the real-world use of the technology and methodology, with chapters on: Fast Facts Review Section: Digest of each chapter from Part I; Hotlists of Exam-Critical Concepts; Sample Test Questions: One question per key point made in the book; Insider's Spin (on taking the exam): What Microsoft doesn't necessarily want you to know; and Did You Know?: Invaluable real-world applications for the technology covered in the exam, taken from the author's training and consulting files.


Author Notes

Brian Matsik is currently the president and senior consultant at Object Oriented Consulting in the Charlotte, North Carolina area. Brian has been working with Microsoft Visual Basic since version 2.0 for Windows and 1.0 for DOS. Brian has worked for many organizations in the Charlotte area, consulting in Windows client/server development, version control/source management, and Visual Basic/COM architecture design.


Table of Contents

Part I What's Important to Know About Exam 70-100
1 Analyzing Business Requirementsp. 11
Project Scopep. 12
Defining the Problemp. 15
Determining the Expected Resultsp. 15
Existing Applicationsp. 16
Expected Lifetimep. 16
Project Budgetp. 18
Time and Laborp. 18
Total Costp. 19
Benefit Trade-Offsp. 20
Feature Selectionp. 20
Creating the Feature Listp. 21
Avoiding Feature Creepp. 22
Business Requirementsp. 22
Business Goalsp. 23
Customer Requirementsp. 24
Reading Between the Linesp. 24
Establishing the Type of Problemp. 25
TCO and ROIp. 26
Minimizing Total Cost of Ownershipp. 26
Increasing REturn on Investmentp. 27
Current Infrastructure Designp. 30
Incorporating the Platform and Infrastructure into the Solutionp. 30
Analyzing the Impact of New Technologyp. 30
Establishing the Application Environmentp. 31
Establishing a Schedulep. 32
Human Factorsp. 32
Identifying Usersp. 33
Trainingp. 35
Local and Remote Usersp. 36
Localization Issuesp. 38
Integration with Existing Applicationsp. 39
Legacy Applications and Hardwarep. 39
Migration to a New Systemp. 40
Creating and Using Middlewarep. 40
Connectivityp. 42
Data Conversion and Character Translationp. 43
Business Methodologies and Limitationsp. 43
Current Business Practicesp. 44
Business and Organizational Structurep. 44
Customer's Needsp. 46
Securityp. 46
Security Modelsp. 46
Systemp. 47
Server/Machinep. 47
Userp. 47
Groupp. 47
Filep. 48
Databasep. 48
Identifying Rolesp. 49
Auditingp. 49
Fault Tolerancep. 51
Hardware Fault Tolerancep. 51
Disk Duplexing and Mirroringp. 51
Disk Stripingp. 52
RAIDp. 52
Software Fault Tolerancep. 54
Performancep. 54
Bandwidthp. 54
Peak Usagep. 56
Online/Offline Hoursp. 56
Response Timep. 57
Physical Response Timep. 57
Perceived Response Timep. 58
Transaction Processingp. 58
Maintainabilityp. 59
Application Distribution and Upgradesp. 59
Supportp. 61
Future Planningp. 62
Availabilityp. 63
Geographic Scopep. 63
Operational Timelinesp. 63
Impact of Downtimep. 64
Scalabilityp. 65
Planning for Growthp. 65
Organizational Changesp. 66
Expanding Datap. 67
What Is Important to Knowp. 68
2 Developing Data Modelsp. 69
Logical Designp. 70
Entities, Attributes, and Relationshipsp. 70
Entitiesp. 71
Attributesp. 73
Relationshipsp. 76
Keysp. 77
Primary Keysp. 77
Foreign Keysp. 80
One-to-Onep. 81
One-to-Manyp. 82
Many-to-Manyp. 83
Generating the Modelp. 85
Primary and Foreign Keysp. 89
Normalization and Denormalizationp. 90
First Normal Formp. 91
Second Normal Formp. 91
Third Normal Formp. 95
Denormalizationp. 98
Physical Design Considerationsp. 99
What Is Important to Knowp. 101
3 Developing the Conceptual and Logical Design for an Applicationp. 103
Application Modelsp. 104
Application Typesp. 104
SDIp. 104
MDIp. 105
Consolep. 106
Servicep. 107
Web-Based Applicationsp. 108
Interface Pros and Consp. 110
Client/Server Architecturep. 111
Single Tierp. 113
Single Tier/File Serverp. 113
Thin Client/Terminalp. 114
Two Tierp. 115
Three Tierp. 116
n-Tierp. 117
An Introduction to COMp. 119
Interfacesp. 120
Propertiesp. 121
Methodsp. 123
Eventsp. 124
Object Organizationp. 126
Userp. 126
Businessp. 127
Datap. 128
Object Modelsp. 128
Encapsulating Databasesp. 130
Key Termsp. 132
What Is Important to Knowp. 133
4 Designing a User Interface and User Servicesp. 135
User Interface Basicsp. 136
Using the Windows Common Control Libraryp. 137
Toolbarsp. 137
Tabstripsp. 137
Treeviewp. 138
Listviewp. 138
Trackbarp. 139
Progress barp. 140
Keeping a Clean Interfacep. 141
Navigationp. 143
Menusp. 144
Application Assistancep. 147
Input Validationp. 147
Visual Cuesp. 149
Formatting Inputp. 151
User Feedbackp. 152
Status Barsp. 152
ToolTipsp. 153
What's This Helpp. 153
Wizardsp. 154
Help Filesp. 155
Standardp. 155
HTML Helpp. 155
Errorsp. 156
Presenting Errorsp. 156
Do's and Don'ts of Error Handlingp. 158
Prototypingp. 159
Key Termsp. 160
What Is Important to Knowp. 161
5 Defining the Technical Architecture for a Solutionp. 163
Identifying Appropriate Technologiesp. 164
Data Storage and Designp. 165
Architecturep. 166
Performance Considerationsp. 167
Reportingp. 168
Feasibility Testingp. 168
Meeting the Business Requirementsp. 169
Meeting the Use Casesp. 169
Falling Short of the Solutionp. 169
Deploymentp. 170
What Is Important to Knowp. 172
Objective Review Notesp. 173
Analyzing Business Requirementsp. 175
Developing Data Modelsp. 180
Developing the Conceptual and Logical Design for an Applicationp. 183
Designing a User Interface and User Servicesp. 187
Defining the Technical Architecture for a Solutionp. 189
Part II Inside Exam 70-100
6 Fast Facts Reviewp. 195
What to Studyp. 196
Analyzing Business Requirementsp. 196
Developing Data Modelsp. 202
Developing the Conceptual and Logical Design for an Applicationp. 203
Designing a User Interface for a Solutionp. 207
Defining the Technical Architecture for a Solutionp. 211
7 Hotlist of Exam-Critical Conceptsp. 215
Products, Tools, and Technologiesp. 216
Development Toolsp. 216
Visual Basicp. 216
Visual C++p. 218
Visual FoxProp. 219
Visual InterDevp. 220
Visual J++p. 222
Visual SourceSafep. 223
Database Serversp. 224
SQL Serverp. 224
Accessp. 225
Data Connection Servicesp. 226
ODBCp. 226
ADOp. 227
DAOp. 228
RDOp. 228
OLE DBp. 229
Networking and Infrastructurep. 229
Windows 3.11p. 229
Windows 95/98p. 230
Windows NTp. 230
Workstationp. 230
Serverp. 231
AS/400p. 231
Networkingp. 232
LANp. 232
WANp. 232
Network Speedsp. 232
RAS/VPNp. 233
Internetp. 234
Internet Information Serverp. 234
Mainframe Computingp. 234
Microsoft SNA Serverp. 235
Cicsp. 235
Otherp. 236
Microsoft Transaction Serverp. 236
Microsoft Exchange Serverp. 237
Key Terms and Definitionsp. 238
Other Key Technology Informationp. 245
Development Tools Comparisonp. 245
Database Comparisonp. 247
8 Sample Scenario and Sample Test Questionsp. 249
Sample Scenario-Based Questionsp. 250
Backgroundp. 251
Problem Statementsp. 251
Salespersonp. 251
Order-Entry Specialistp. 252
Information Technology Managerp. 252
Current Systemsp. 252
Customersp. 252
Salespersonp. 252
Information Technology Managerp. 253
Environmentsp. 253
Information Technology Managerp. 253
Chief Information Officerp. 253
Network Administratorp. 253
Envisioned Systemp. 254
Sales Managerp. 254
Order-Processing Managerp. 254
Network Administratorp. 254
Securityp. 254
Sales Managerp. 254
Order Processing Managerp. 255
Performancep. 255
Sales Managerp. 255
System Administratorp. 255
Information Technology Mangerp. 255
Maintainabilityp. 256
Network Administratorp. 256
Information Technology Managerp. 256
Availabilityp. 256
Order-Entry Managerp. 256
Information Technology Managerp. 256
Sample Test Questionsp. 257
Answers and Explanationsp. 263
9 Insider's Spin on Exam 70-100p. 269
Build List and Reorderp. 271
Create a Treep. 271
Drop and Connectp. 273
Get into Microsoft's Mind-Setp. 275
Understand the Exam's TimeFramep. 276
Get Used to Answering Questions Quicklyp. 278
Taking the Testp. 279
Where the Questions Come Fromp. 284
Different Flavors of Questionsp. 285
10 Did You Know?p. 287
Indexp. 291