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 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

Intermediate Pervasive.SQL 2000 Programming (Relational)


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 explores Pervasive.SQL 2000's from the standpoint of relational database application programming.

Lectures, demonstrations, and hands-on exercises give attendees the technical skills required to implement a relational database solution using SQL, ODBC and related database management products from Pervasive Software.

An outline of the course includes:

Section 1 - Review of Architecture and Basics
The MicroKernel Database Engine
Access Modules
Processing Methods
Database Engines


Section 2 - Relational Database Concepts
Data Modeling
Data Normalization
Physical Database Design


Section 3 - Setting up a Relational Database
Creating a Database
Data Dictionary Files
Database Names
Data Source Names
Distributed Tuning Interface (DTI)


Section 4 - Structured Query Language
Introduction to SQL
Creating Tables & Indices
Inserting, Updating, and Deleting Data
Views and Joins
Stored Procedures and Triggers
Referential Integrity
Database Security
Removing a Database


Section 5 - Using the ODBC API
ODBC Introduction
ODBC Architecture
ODBC Environment Functions
ODBC Data Functions
Connecting to a Data Source
Executing SELECT Statements
Using ODBC Cursors


Section 6 - Transaction and Commitment Control
Beginning Transactions
Ending Transactions

Course Prerequisites:
  • Attendance at the Introduction to Pervasive.SQL 2000 Programming class or equivalent knowledge is required.
  • A working knowledge of databases, including fundamental concepts of database design, experience designing and supporting databases, and understanding Data Models and Entity-Relationship theories.
  • Experience in one of three development environments used in the class (Visual BASIC, Visual C++, or Borland Delphi).
  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