09889nam 2200673Ia 450 991096098100332120251116142409.01-280-54414-797866105441411-930919-18-2(CKB)111035898514178(CtWfDGI)bks00001565(SSID)ssj0000268060(PQKBManifestationID)12071025(PQKBTitleCode)TC0000268060(PQKBWorkID)10212524(PQKB)11323717(MiAaPQ)EBC3301804(Au-PeEL)EBL3301804(CaPaEBR)ebr10110775(CaONFJC)MIL54414(OCoLC)923121923(BIP)46082309(BIP)7121714(EXLCZ)9911103589851417820020130d2001 uy 0engurzn||||||txtccrVisual FoxPro certification exams study guide /Cindy Winegarden, Evan DelayWhitefish Bay, Wis. Hentzenwerke Publishingc2001187 pTitle from title screen.1-930919-04-2 Intro -- 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.Covers both the Desktop and Distributed exams in one book Visual FoxPro certification is the way for you to present contract customers and employers with an objective assessment of your technical skills as Visual FoxPro developer. Microsoft certification also provides contract customers and employers with additional confidence in their decision to contract with, or hire you as they solve business problems and move forward in our data-driven, digital economy. Microsoft has moved their certification emphasis from knowledge assessment to measuring of the real-life skills we need to do the job at hand. As an experienced developer, you have a good foundation, but don't necessarily have a lot of time to "fine tune" yourself for an exam. In addition, you might not have an understanding of exactly what Microsoft considers important in your developer skill set. As a new developer, you might think that certification is out of your reach, or not know where to begin your preparation, or how far you have to go to reach your goal. This study guide will assist you in efficient, focused VFP certification exam preparation.Computer programmersCertificationStudy guidesDatabase managementElectronic data processing personnelCertificationObject-oriented programming (Computer science)Computer programmersCertificationDatabase management.Electronic data processing personnelCertification.Object-oriented programming (Computer science)005.75/65Winegarden Cindy1867054Delay Evan1867055MiAaPQMiAaPQMiAaPQBOOK9910960981003321Visual FoxPro certification exams study guide4474479UNINA