Visual FoxPro certification exams study guide / Cindy Winegarden, Evan Delay.

Format:

Book

Author/Creator:

Winegarden, Cindy.

Contributor:

Delay, Evan.

Language:

English

Subjects (All):

Visual FoxPro for Windows.

Computer programmers--Certification--Study guides.

Computer programmers.

Database management.

Electronic data processing personnel--Certification.

Electronic data processing personnel.

Object-oriented programming (Computer science).

Physical Description:

187 p.

Place of Publication:

Whitefish Bay, Wis. : Hentzenwerke Publishing, c2001.

Language Note:

English

Summary:

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.

Contents:

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

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

Chapter 3 Deriving the Physical Design

Design considerations

Performance

Maintainability

Extensibility

Availability

An example with COM

Class libraries

Inheritance

Encapsulation

Containership

Delegation

Polymorphism

Designing an interface for data access

Designing the properties and methods of components.

Designing the presentation tier

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

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

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

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

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

Chapter 8 Creating a Physical Database

Database and table design

Tables

Local views

Remote views

Creating and maintaining views

Stored procedures

Persistent relationships

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

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

Debugging code and application distribution

Special debugging issues with COM servers

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

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.

Notes:

Title from title screen.

Digitized and made available by: Books 24x7.com.

ISBN:

1-280-54414-7

9786610544141

1-930919-18-2

OCLC:

923121923