Dedication -- List of Chapters -- Our Contract with You, The Reader -- Table of Contents -- Foreword -- Acknowledgements -- About the Authors -- How to Download the Files -- Introduction -- Who we are -- How we started -- Who you are -- You can do this! -- Why get certified? -- Certification benefits -- Transcript -- Wallet card, lapel pin -- Logo -- Other goodies -- Leveraging your preparation time -- Study in groups -- Know what Microsoft wants -- Know what you do best -- Practice -- Overcoming obstacles -- Scheduling and taking the exams -- Use the pencil! -- Certification requirements -- MCSD requirements -- Exams 70-155 and 70-156 -- Exam 70-100 -- Exam retirement -- Further reading -- Testing centers -- Exam demos -- Chapter 1 Developing the Conceptual and Logical Design -- Conceptual design -- Logical design -- Further reading -- Design -- Object-oriented design -- Chapter 2 Developing a Logical Data Model -- Normalization rules -- First Normal Form (1NF) -- Second Normal Form (2NF) -- Third Normal Form (3NF) -- Boyce-Codd Normal Form (BCNF) -- Fourth Normal Form (4NF) -- Fifth Normal Form (5NF) -- The primary key -- Relationships -- One-to-one relationships -- One-to-many relationships -- Many-to-many relationships -- Foreign keys -- Referential integrity -- Business rules, data integrity and the data model -- Denormalization -- Denormalization for reporting -- Denormalization for data warehousing -- Denormalization for performance -- Further reading -- Chapter 3 Deriving the Physical Design -- Design considerations -- Performance -- Maintainability -- Extensibility -- Availability -- An example with COM -- Class libraries -- Inheritance -- Encapsulation -- Containership -- Delegation -- Polymorphism -- Class libraries -- Designing an interface for data access -- Designing the properties and methods of components.

Designing the presentation tier -- Further reading -- Chapter 4 Establishing the Development Environment -- Installing Visual FoxPro -- Configuring Visual FoxPro -- Registry configurations -- SET commands and configuration files -- Resource files -- Command line switches -- Toolbars -- Configuring Visual SourceSafe -- Configuring Microsoft Transaction Server -- Configuring Microsoft Internet Information Server -- Configuring Microsoft Message Queue -- Further reading -- Third-party software -- Chapter 5 Creating User Services -- Providing a personalized interface -- Personalizing colors -- Keyboard and mouse access -- Sound and focus -- User or group options -- Planning the interface -- Forms -- Menu systems -- Form controls in general -- Toolbars -- User interaction with forms -- Form properties, events, and methods -- Binding data to controls -- Manipulating controls at run time -- Using the _SCREEN.ActiveForms collection -- Validating user input -- Processing entered data -- Form events and methods -- Form control events and methods -- Compiling data in reports -- COM and Office Automation -- Error handling -- Errors in COM objects -- Providing online Help -- Extending functionality through the Windows API -- Visual FoxPro on the Web -- Further reading -- Third-party software -- Chapter 6 Creating and Managing COM Components -- What is COM? -- Creating COM components -- COM server types -- Business rules -- Interacting with other components -- COM error handling -- Designing components for MTS -- Transaction support for COM components in MTS -- Managing and deploying COM components -- Using the Component Gallery -- Registering and unregistering COM components -- Creating packages and managing components with MTS Explorer -- Using role-based security -- Further reading -- Chapter 7 Creating Data Services.

Native tables, views, SQL pass-through, ADO, and OLE DB -- Connecting to the data -- Data access -- Xbase commands for data -- Views -- SQL pass-through -- SQL syntax for creating views or selecting data -- SELECT - SQL -- WHERE and JOIN -- Aggregates -- ORDER BY -- GROUP BY and HAVING -- SQL syntax for modifying data -- Locking, buffering, and transactions to prevent update conflicts -- Buffering of tables -- Locking -- Buffering of views -- Transactions -- What if the record has changed? -- Stored procedure strategies for automatic actions -- Importing and exporting data -- ADO, OLE DB, and RDS -- Using ADO -- Using recordsets -- Further reading -- Chapter 8 Creating a Physical Database -- Database and table design -- Tables -- Local views -- Remote views -- Creating and maintaining views -- Stored procedures -- Persistent relationships -- Referential integrity -- Connections -- The database container -- Programmatically creating and maintaining a database -- GenDBC.PRG -- CREATE TABLE -- ALTER TABLE -- INDEX -- CREATE TRIGGER -- CREATE CONNECTION -- CREATE SQL VIEW -- DBSetProp() -- Stored procedures and Referential Integrity Builder-generated code -- Database container maintenance -- Normalization -- Indexing strategies -- Some expressions can't be optimized -- Special considerations with indexing -- Further reading -- Third-party software -- Chapter 9 Testing and Debugging the Solution -- Testing -- Unit testing -- Regression testing -- Integration testing -- Stress testing -- Beta testing -- Making sure you have tested all of the code -- Testing every line -- Finding where things get slow -- Code bugs you'll encounter -- Typos -- Run-time errors -- Logic errors -- Design errors -- Debugging tools and techniques -- Stop and see what's happening with breakpoints -- Alerting yourself to abnormal conditions with ASSERT.

LISA G and understanding events -- Error handling -- Debugging code and application distribution -- Special debugging issues with COM servers -- Further reading -- Third-party software -- Chapter 10 Deploying an Application -- Setup Wizard -- Installing the application -- Uninstalling the application -- Configuring DCOM on client and server -- Configuring a client to use an MTS component -- Configure remote Automation on a client and server -- Further reading -- The Setup Wizard and installing an application -- Uninstalling an application -- DCOM and MTS -- Remote Automation -- Chapter 11 Maintaining and Supporting an Application -- Planning and implementing disaster recovery procedures -- Table corruption -- Restoring data since the last backup -- Backups that don't work -- The "big one" -- Correcting errors and preventing future errors -- The joys of object-oriented bug fixes -- Reevaluating the data -- Table maintenance -- View maintenance -- Using a local .DBC for views -- Keeping track of problems -- Deploying application updates -- Making changes to an existing database -- Minimizing update size and simplifying deployment -- Updating the application while minimizing user downtime -- Further reading.