Chapter 1 Microsoft Certification Exams 1
Assessing Exam-Readiness 2
The Exam Situation 3
Exam Layout And Design 5
Recognizing Your Test Type:Fixed-Length Or Adaptive 7
Exam-Taking Basics 9
Question-Handling Strategies 10
Mastering The Inner Game 10
Additional Resources 11
Chapter 2 The Development Environment 15
Overview Of Visual C++ 16
Using Visual C++ 20
SourceSafe 25
SQL Server 29
Microsoft Transaction Server(MTS) 31
Microsoft Message Queue(MSMQ)Server 35
Practice Questions 39
Need To Know More? 44
Chapter 3 MFC Architecture 45
Document/View Architecture 46
Printing With MFC 52
Serialization 55
CFile And Its Derivatives 57
Multithreading 59
Dynamic Link Libraries 65
Basic DLL Theory 65
MFC DLLs 69
Practice Questions 74
Need To Know More? 80
Chapter 4 Creating User Services 83
Menus 85
Toolbars 88
Status Bars 92
Dialog Boxes 94
Dialog Bars 98
Customizing Common Dialog Boxes 98
Property Sheets 99
Common Controls 101
ActiveX Controls 103
WinHelp 107
HTML Help 111
Practice Questions 115
Need To Know More? 121
Chapter 5 Component Object Model 123
The Basics 124
Automation 131
Threading Models 132
Microsoft Foundation Class And COM 142
The Active Template Library 144
Building ActiveX Controls 151
ActiveX Control Containers 158
Practice Questions 161
Need To Know More? 167
Chapter 6 Component Distribution And Scalability 169
Security 170
Microsoft Transaction Server(MTS) 172
Practice Questions 181
Need To Know More? 184
Chapter 7 Writing SQL 185
Relational Database Fundamentals 186
Retrieving Data 187
Using Joins To Retrieve Data 196
Modifying Data 204
Creating Views 206
Practice Questions 209
Need To Know More? 223
Chapter 8 Advanced Data Manipulation 225
Triggers 226
Stored Procedures 230
Cursors 233
Locking Strategies 236
Practice Questions 239
Need To Know More? 251
Chapter 9 Creating A Physical Database 253
Implementing A Data Storage Architecture 254
Creating Databases 260
Indexes 265
Populating The Database 268
Practice Questions 270
Need To Know More? 277
Chapter 10 Data Services 279
Open Database Connectivity 281
ActiveX Data Objects 289
OLE DB 307
Practice Questions 313
Need To Know More? 317
Chapter 11 Debugging And Testing Your Application 319
Debugging And The IDE 320
Debugging Strategies 328
Debugging Tools 334
Debugging COM Clients And Servers 336
Testing 336
Practice Questions 338
Need To Know More? 341
Chapter 12 Deploying Your Application 343
InstallShield Packaging Concepts 344
InstallShield Package And Deployment Wizard 344
Systems Management Server(SMS) 347
Zero Administration Initiative For Windows 349
Internet/Intranet Delivery 351
DCOM 354
Practice Questions 358
Need To Know More? 361
Chapter 13 Sample Test 363
Questions,Questions,Questions 364
Picking Proper Answers 364
Decoding Ambiguity 365
Working Within The Framework 366
Deciding What To Memorize 367
Preparing For The Test 368
Taking The Test 368
Sample Test 370
Chapter 14 Answer Key 395
Glossary 409
Index 427