Structured Query Language for Sybase iAnywhere 11 for OTS Products

Many customers have used SQL (Structued Query Language) to make modifications to their MET/TRACK database. Even though SQL is very powerful, it can also cause problems if you are not aware of the proper usage of these commands. Three of the most popular On Time Support products, Barcode Magician, E-Mail Notification, and Metrology Xplorer (1&2), utilize SQL scripts as a fast and easy way to obtain data. All that is required is to understand the rules. Also, we want to make sure that the integrity of the Fluke MET/TRACK database is maintained by not making database changes that would impact the Fluke MET/CAL and MET/TRACK applications.

 This is a two day class, with three additional days dedicated to product training and using SQL with the OTS products. You must take the first two days before you take any additional days. There are no exceptions. The following is the schedule and itinerary.

DAY 1 - Monday - General SQL

  • SQL standards
  • Database Backup procedures  of your existing database
  • Using the ISQL Editor and Sybase Central
  • Understanding the Database Schema
  • Using general SQL statements
    • Select Statament
    • Insert Statement
    • Update Statement
    • Delete Statement
  • Table Joins and best practices

DAY 2 - Tuesday - General SQL

  • Creating custom tables
  • Creating and using Views
  • Creating and using Stored Procedures
  • Crystal Reports with the SQL examples

DAY 3 - Wednesday - Barcode Magician

  • Overview of Barcode Magician
  • Setting the System parameters
  • Creating Action Codes
  • Creating and using prompts
  • Using SQL queries with the Action Codes
  • Using Crystal Reports with Barcode Magician

DAY 4 - Thursday - Metrology Xplorer 1 & 2

  • Installing Metrology Xplorer 1
  • Installing Metrology Xplorer 2
  • Configuring the Metrology Xplorer 1 admin functions.
  • Using Crystal Reports with Metrology Xplorer 1
  • Configuring Metrology Xplorer 2
  • Creating SQL queries for Metrology Xplorer 1 & 2

DAY 5 - Friday - E-Mail Notification

  • Installing E-Mail Notification
  • Creating and testing SQL Reports
  • Creating Report Formats
  • Scheduling Email Notification Reports
  • Using Dynamic Email
  • Escalation Topics.

 The customer must take Day 1 and Day 2. The customer may select from Day 3 to Day 5 depending on which product they use. There is a discount for taking all 5 days.

Note: If you have never used any of the OTS software products, then taking the three additional days may help you to understand the power of these products and how they can help your organization.

Vertical Tabs