Database Engines
Version Quick-Reference Chart
+ Protecting Your Data
+ Goldstar Services
+ Goldstar Tools
+ Developer Resources
+ Other Solutions
Using AMS?
Status 7224
Fix My PSQL License
Report Engine Crash
Repair PSQL Files
Get Support Now
Join Our Mailing List
|
|
 |
Intermediate Pervasive.SQL 2000 Programming (Btrieve)
Course Developer: Pervasive Software
Level: Intermediate to Advanced
Length: 2 Days
Course Objectives: Intended for programmers with a solid understanding of Pervasive.SQL basics--acquired
through experience or by attending our Introduction to Pervasive.SQL 2000 Programming -- this hands-on course thoroughly
explores Pervasive.SQL's transactional application programming interface (API), otherwise known as the Btrieve
API.
Lectures, demonstrations, and hands-on exercises give attendees all the knowledge and experience they need to successfully
create Pervasive.SQL-based applications. In addition to its presentation of intermediate and advanced Btrieve concepts
and techniques, the course briefly reviews Internet and intranet development options.
An outline of the course includes:
Section 1 - Review of Architecture and Basics
The MicroKernel Database Engine
Access Modules
Client/Server vs. Workstation Processing
Features of Pervasive.SQL
New Features of Pervasive.SQL
Database File Format
Record Addressing Scheme
Transactions and Shadow Paging
Indexing
International Sorting
Installation Overview
Smart Components
Section 2 - Programming Using the Transactional Interface
The Transactional API
The Transactional Function Call
The Transactional Data Buffer
Byte Alignment
Flow of Control
Compiler Interfaces
Tracing the Transactional API Operations
The Event Log
Section 3 - Basic Btrieve Data Access Techniques
Basic Transactional Operations
Opening and Closing Files
Creating Data Files
Single-Record Positioning and Record Navigation
Single-Record Updating
Other Examples
Section 4 - Direct Addressing and Searching
Direct Addressing
Traversal and Direct Addressing Example
Searching
Other Examples
Section 5 - Additional Tools and Techniques
Continuous Operations Mode
Advanced Indexing
GUI Programming and Btrieve Percentage Operations
Other Examples
Section 6 - Multi-User Programming
Multi-User Programming and Concurrency
Transaction Processing
Other Examples
Section 7 - Advanced Application Techniques
Processing BLOBs (Binary Large Objects) and Chunks
Multiple-Record Processing
Other Examples
Course Prerequisites: Students should be experienced in software development, with Windows development background
a plus. Experience in one of three development environments used in the class (Visual BASIC 4/5, Visual C++ or
Borland Delphi) is a plus, but not required for advanced individuals.
|
|
|
