Goldstar Logo
Your Source for 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
+ Actian Zen v13
+ Actian PSQL v13
+ Actian PSQL v12
+ Actian PSQL v11
+ Pervasive PSQL v10
+ Pervasive PSQL v9
+ Pervasive.SQL V8
+ Pervasive.SQL 2000i
+ Pervasive.SQL 7
+ Btrieve v12
+ Btrieve 6.15

+ Data Protection Products

+ Goldstar Software Services

+ Goldstar Software Tools

+ Other Solutions

AMS Users: Click Me Fix My PSQL License Repair PSQL Files Get Support Now Join Our Mailing List

Navigation Background

Intermediate Pervasive.SQL 2000 Programming (Relational)

Register Now!

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-2017, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
Goldstar Software Inc. | 3007 Carmel Dr | Flossmoor IL 60422 Legal Statements | EULAs | Uninstall | Privacy Statements | Contact Us