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

PSQL v11/v12/v13 Service and Support Course

Register Now!

Course Developer: Goldstar Software - Bill Bach

Level: Beginning to Intermediate

Length: 3 Day

Course Materials: 300+ page, Two-Sided, Color Printed Manual with CDROM and Quick Reference Card (Available Separately for $500)

Course Objectives: This course is designed to provide a technical foundation to software developers, network administrators and consultants who work with the PSQL database engine and other related products from Actian (formerly Pervasive Software). The course manuals are designed to act as a reference for the student after the class is completed. While we use the current version of PSQL (currently PSQL v13.00) for this course, the material is relevant to Pervasive PSQL v11 and newer engines, and some material holds true even for the earlier versions of Pervasive PSQL Summit v10, PSQL v9, Pervasive.SQL V8, Pervasive.SQL 2000i, Pervasive.SQL 7, and even Btrieve 6.15!

Day 1 concentrates on the background information, as well as the server-side installation, licensing, and system configuration. After Day 1, each student should be able to:

  • Describe the PSQL database, its history, its components, and why it is often used.
  • Differentiate between the platforms (Workgroup, Server, and Vx Server) and know when to use each.
  • Determnine the correct licensing requirements for a PSQL installation.
  • Install and patch the PSQL database engine on a server and the PSQL Client to a workstation.
  • Identify the version and build number of an installed PSQL engine.
  • Configure the MKDE on any platform for one or more applications and fine-tune the engine configuration for optimal performance based on existing resources.

Day 2 examines the client side of PSQL in detail, including the use of troubleshooting tools and our unique "troubleshooting chart". It also covers the all-important issues of the database file system, including file rebuilding, data file recovery, and proper backups. After Day 2, each student should be able to:

  • Install and configure the PSQL client on the workstation for fastest startup times and best control.
  • Determine when older DLL's may be impacting a production environment.
  • Explain the purpose of each of the utilities proivided with PSQL (and some third-party tools) and know when to use each for troubleshooting various types of problems.
  • Use the Connection Troubleshooting Diagram to diagnose network connections issues.
  • Identify the basic components of an MKDE database file.
  • Rebuild a data file from one version to another, using command-line and GUI tools.
  • Analyze a data file for corruption and repair basic corruption using command line and GUI tools.
  • Understand the perils of backing up database files during database access and enable proper backups in 24x7 operations with VSS or Backup Agent (and know when to use each).

Day 3 concentrates on the relational components of PSQL, including the importance of data dictionary files, the use of basic SQL commands to retrieve and export data, and the many facets of database security, including owner names, SQL logins, and the advanced security options. After Day 3, each student should be able to:

  • Identify the Data Dictionary Files (DDF's) and their contents.
  • Use the provided tools to build and/or modify DDF's for the database.
  • Understand the concepts behind the Pervasive ODBC drivers and access a Pervasive.SQL database with those drivers from MS Access or another ODBC application.
  • Create simple SQL statements to retrieve data, modify data, and delete data.
  • Create more complex SQL code, including database joins, stored procedures, and views.
  • Enable and work with security for Btrieve applications and SQL databases.
  • Activate the advanced security features to protect a database.
  • Resolve common status code error messages from applications.

Course Prerequisites: Student should have experience with installing and maintaining applications in Windows. Experience in computer networking, Windows, and Linux will be a great asset, but is not required. An understanding of database technology and programming techniques will also be beneficial.

  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