HALLOGRAM PUBLISHING
SHOPPING CARTSITE MAPCONTACT USPRODUCTS
HOMEBARCODESDEVELOPER TOOLSUSER TOOLSTRAINING
Take Note

TNVFP 5301 - Developing Client/Server Applications with Visual FoxPro

This is the final course of both the Advanced and Deluxe Packages.


Course Overview

This two-day course teaches experienced Visual FoxPro developers how to create client/server applications in Visual FoxPro. Students will learn how to use the Upsizing Wizard and the back-end security and data validation features of Microsoft SQL Server for Windows NT. The student will learn how to access back-end databases via ODBC. Both techniques for accessing remote data, Remote Views and SQL Pass Through, will be covered. Client/Server performance optimization techniques will be discussed throughout the course, such as, the advantages of using a combination of local and remote data sources. Upon completion of the course, the student will keep the course materials and will receive a diskette containing all the course examples and exercises.


Course Highlights

Client/Server Overview
bullet Definitions
bullet Benefits
bullet Back-end Databases
bullet Design Considerations
bullet Prototyping

Working with Remote Views
bullet Benefits of Remote Views
bullet Working with ODBC
bullet Building Connections
bullet Using the View Designer
bullet Parameterized Views
bullet Optimizing View Performance

Upsizing to Microsoft SQL Server
bullet The Upsizing Wizard
bullet Upsizing Considerations
bullet Using SQL Server Security

Accessing Data with SQL Pass-Through
bullet SQLCONNECT()
bullet SQLDISCONNECT()
bullet Updating Data
bullet Synchronous vs. Asynchronous
bullet Batch vs. Non-batch

Using Local and Remote Data Effectively
bullet Where to Store Data
bullet Managing Local Data
bullet Manipulating Local and Remote Data

Client/Server Performance Optimization
bullet Speeding Data Retrieval
bullet Cursor Fetching
bullet Transactions
bullet Form Optimization


Course Prerequisites

  • Completion of the TNVFP 5202: Advanced Application Development with Visual FoxPro course or equivalent knowledge.

Return to Take Note Courseware Main Page
TNVFP 101 - Introduction to Application Development with Visual FoxPro
TNVFP 201 - Application Development with Visual FoxPro
TNVFP 202 - Advanced Application Development with Visual FoxPro


Price includes one set of manuals and diskettes. You must purchase one set of manuals and diskettes per student and instructor (i.e., if you are teaching a course of 6 students, you must purchase 7 sets of manuals/diskettes - 1 for each student and 1 for you).
The Fundamentals Package also includes the TakeNote BaseApp Framework.

Fundamentals Package ... $249/set
Advanced Package ... $299/set
Deluxe Package ... $499/set


Home || Shopping Cart || Site Map || Newsletter/Blog
Search HALLoGRAM || Request More Information
CALL TOLL FREE 1-866-340-3404

©Copyright 1999 HALLoGRAM Publishing, Aurora CO. All Rights Reserved.
All products mentioned in this site are trademarks of their respective owners.