 |
 |
 |
|
"An excellent class! The right level of detail at the right time. I now fully understand everything that, heretofore, I've muddled through in my application development activities at work."
"It was fantastic! Best class I've ever gone to and I've attended my share with other training companies."
"Jim is excellent at maintaining class attention throughout the highly informative sessions."
|
|
|
 |
|
 |
|
 |
 |
 |
|
|
|
VFP301: Developing Client/Server Applications With VFP 7/8/9
|
|
|
Registration: Click here to register for this class.
Duration: 2 days
Prerequisites: Completion of the TNVFP202: Advanced Application Development With Visual FoxPro course or equivalent knowledge.
The class covers material from Visual FoxPro 9, as well as Visual FoxPro 7 & 8. All three versions are installed on the computer provided for each attendee.
In this hands-on, instructor-led course attendees learn 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. The student will learn how to access back-end databases via ODBC and OLEDB (ADO). Techniques for accessing and updating remote data, including Remote Views, SQL Pass Through and ADO, will be covered. A middle-tier business object will be crafted in class that demonstrates using a number of data access technologies.
Client/Server Overview
Definitions
Benefits
Back-End Databases
Design Considerations
Prototyping
Working With Remote Views
Benefits of Remote Views
Working With ODBC
Building Connections
Using the View Designer
Parameterized Views
Optimizing View Performance
Upsizing to Microsoft SQL Server
The Upsizing Wizard
Upsizing Considerations
Using SQL Server Security
Accessing Data with SQL Pass-Through
SQLCONNECT()
SQLDISCONNECT()
SQLEXEC()
Updating Data
Synchronous vs. Asynchronous
Batch vs. Non-batch
Using Local and Remote Data Effectively
Where to Store Data
Managing Local Data
Manipulating Local and Remote Data
Client/Server Performance Optimization
Speeding Data Retrieval
Cursor Fetching
Transactions
Form Optimization
Designing Three-Tier Client/Server Applications
Definitions and Terminology
Creating Middle-Tier Components
Building Data Controller Objects
|
|
|
 |
|
 |
|
 |
 |
 |
|
Cost: $995
Pricing Special: Combine this class with VFP202: Advanced Application Development With VFP for $2,295. Save $95! |
|
|
 |
|
 |
|