Goldstar Logo
Your Source for Actian Zen and PSQL Database Products, Services and Training Since 1997 EMail: Sales@goldstarsoftware.com 
Phone: 1-708-647-7665 
Web Site Login 
Free PSQL Support
Quick Links
Database Engines
 Version Quick-Reference Chart
+ Actian Zen v16
+ Actian Zen v15
+ Actian Zen v14
+ Actian Zen/PSQL v13
+ Actian PSQL v12
+ Actian PSQL v11
+ Pervasive PSQL v10
+ Pervasive PSQL v9
+ Pervasive.SQL V8
+ Pervasive.SQL 2000i
+ Pervasive.SQL 7
+ Btrieve 12
+ Btrieve 6.15
+ Actian Vector

+ 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

Navigation Background

Introduction to Pervasive.SQL 2000 Programming


Course Developer: Pervasive Software

Level: Beginner to Intermediate

Length: 1 Day

Course Objectives: Introduction to Pervasive.SQL Development is a demo course that covers the basics of access methods and programming techniques. Presentations and demonstrations give developers the knowledge they need to rapidly come up to speed programming Pervasive.SQL-based applications.

Intended primarily for those with limited Pervasive.SQL experience, the course is also valuable for anyone who's experienced with just one access method--Btrieve's transactional method, most likely--and who wants to understand the other options available with Pervasive.SQL. You might, for example, wish to know about Pervasive.SQL's powerful SQL/ODBC API for integrating relational capabilities into your application; the ActiveX interface is another highly useful feature with which to acquaint yourself.

An outline of the course includes:

Section 1 - Introduction and Overview
The MicroKernel Database Engine
MKDE Access Modules
Features of the Pervasive.SQL and the MKDE
New Features of Pervasive.SQL and the MKDE
Database File Format
Transactions and Shadow Paging
Indexing
Smart Components
Client/Server and Workstation Processing


Section 2 - Setup, Tools and Development Issues
Installation Overview
The Pervasive Control Center and Tools
Compiler Interfaces and Issues


Section 3 - Using Transactional (Btrieve) Access
Database Basics
The Btrieve API
The Btrieve Function Call
The Btrieve Data Buffer
Basic Btrieve Operations
Opening and Closing Files
Single-Record Positioning and Record Navigation
Single-Record Updating


Section 4 - Relational Access and Other Interfaces
Database Basics
Data Access Module Review
SQL Relational Database Engine (SRDE)
Open Database Connectivity (ODBC)
Defining ODBC Data Sources
Data Dictionaries
Pervasive ActiveX Interface
Demonstration Application


Course Prerequisites: Knowledge of software development, with Windows development background a plus. Experience in database systems is also advantageous.
  Copyright © 1997-2024, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
Goldstar Software Inc. | 1945 Maplewood Ln | Munster IN 46321 Legal Statements | EULAs | Uninstall | Privacy Statements | Contact Us