Training
Provided by Goldstar Software Inc.
In 1998, Goldstar Software released the Btrieve 6.15 Service & Support course, and it became an instant hit. Now, continuing one of the longest-running training classes in the Pervasive world, our Pervasive.SQL Service and Support course has been extended to contain loads of real-world expertise to make this the best 3-day training session ever -- covering both Pervasive.SQL 2000 and Pervasive.SQL V8, including Pervasive.SQL V8.5 Security and V8.6! The class focuses on topics such as installing, patching, engine tuning, workstation configuration and troublshooting, relational access via SQL and ODBC, data file internals, data file recovery, proper backup, and more. For 2004, all-new material from Pervasive.SQL V8.5 (and V8.6) has been added, and again new information has been added for Pervasive PSQL v9, allowing you to stay ahead of the curve and support the latest releases from Pervasive Software!
Training Avaliability and Delivery
| This is primarily ilt training |  | Computer Lab Work |  | This class may be available at a classroom in Flossmoor, IL,
|
 | Contact Goldstar Software Inc. for more information |
|
| Course Level: | intermediate | | Schedule: | 3 days | | Training Presented in: | English |
|
Related Keywords:
pervasivesql
pervasive
btrieve
support
troubleshooting
Training Program Details
Web Site Login
^ July Survey: Upgrade Class? ^
June Results: Vacation Work?
57% - Twice normal wage
21% - Paid normal wage
21% - Comp Time Only
0% - No benefits.
[See All Surveys]
|
Pervasive.SQL V8/v9/v10 Service
and Support Course
Register Now!
Course Developer: Goldstar Software - Bill Bach
Level: Beginning to Intermediate
Length: 3 Day
Course Materials: 260+ 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 Btrieve and Pervasive.SQL database engines and other related
products from 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 Pervasive PSQL (currently PSQL v10.10) for this course, the material is relevant to Pervasive.SQL V8 and newer engines, and some material holds true even for the earlier versions of Pervasive.SQL 2000i, Pervasive.SQL 7, and even Btrieve 6.15!
Day 1 concentrates on the background and server installation and configuration. After Day 1, each student should
be able to:
- Describe the Pervasive.SQL database, its history, its
components, and why it is often used.
- Identify the various versions and build numbers of Btrieve
and Pervasive.SQL engines.
- Differentiate between the platforms (Workgroup and Client/Server) and know when to use each.
- Install and patch the Pervasive database engine on a server
and the Client to a workstation.
- Configure the MKDE for all platforms for one or multiple
applications and then fine-tune the engine configuration
for optimal performance.
- Configure the Pervasive client on the workstation for
fastest startup times and best control.
- Interpret the messages in the server-side error logs and
perform other routine maintenance.
Day 2 examines the workstation part of the products 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:
- Understand the necessary DLL requirements for the Windows engine and requester configurations.
- Determine the proper placement of DLL’s in your specific
environment and resolve problems which arise as a result
of an incorrect file.
- Interpret the messages in the workstation-side error logs
and perform system cleanups.
- Explain the purpose of each of the provided (and some not provided) utilites and
know when to use each for troubleshooting various types
of problems.
- 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 during database access
and enable proper backups in 24x7 operations (This discussion
often includes a sidebar evaluation of DataExchange and
other options for fault tolerance, depending on available
time.)
Day 3 concentrates on the relational part of Pervasive.SQL,
covering 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 key 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.
- 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,
with NetWare, Linux, and/or Windows Server experience will be
a great asset, but is not required. An understanding of database
technology and programming techniques will also be beneficial.
Certification Test: This course contains information pertinent to the Certified Pervasive Technician test. Contact Pervasive Software for additional information on their certification process. |
|
|
|
|
|
Copyright © 1997-2008, Goldstar Software Inc., All rights reserved.
|
PRODUCTS |
SERVICES |
TRAINING |
SUPPORT |
DOWNLOADS |
ABOUT US
|
| |
Legal Statements | Privacy Statements | Contact Us |
About Goldstar Software Inc. - Training Provider
Goldstar Software Inc. - Goldstar Software Inc. provides nationwide product sales, installation, certified training and on-site support services to users and developers of Btrieve and Pervasive.SQL database engines and related software products. We currently work with Btrieve 5.x, Btrieve 6.15, Pervasive.SQL 7, Pervasive.SQL 2000i, Pervasive.SQL V8, and Pervasive PSQL v9 database products. Specialties include Btrieve...
More Pervasive Software Training from Goldstar Software Inc.
Click here for more information or to take this course
|
