Texql Workshop


To introduce attendees to the Texql query language interface for Texpress databases. This language is functionally a superset of the standard SQL language and incorporates facilities for text retrieval and nested tables.

Who Should Attend

This course is an essential step for developers wanting to use Texapi - the express Applications Programming Interface for C and C++. The course is also appropriate for Texpress users ready to explore different query interfaces to their databases.


This course is a two day workshop. Each attendee has exclusive access to a PC or terminal connected to a Unix host on which Texpress is installed. Attendees develop and test a range of query, insert, update and delete statements on their own databases and run Texql interactively and in batch mode.


This course assumes that attendees are conversant with Texpress at a user level and are familiar with the query and data manipulation facilities it provides. Some familiarity with Unix and/or SQL would also be considered advantageous.

Course Outline - Day One

  • Texql Introduction
    • Overview
    • Terminology
  • The Texql Interpreter
    • On-line help
    • Listing tables
    • Describing tables
    • Command history
  • Projection of Data
    • The "select" clause
    • Functional notation
    • Renaming projected columns
    • Projecting nested tables
  • Data Types
    • Basic data types
    • Tuples and nested tables
  • Selection of Data
    • The "where" clause
    • Selection using relational operators
  • Text retrieval
    • The "contains" operator
    • Selecting from nested tables
  • References
    • Overview of references
    • Accessing referenced tables

Course Outline - Day Two

  • Aggregate Operators
    • Determining averages, sums, etc.
  • Sorting Query Results
  • Set Operations
    • Merging and intersecting sets of rows
    • Using "union" to search multiple databases
  • Inserting New Rows
    • Simple tuple insertion
    • Nested table insertion
    • Deriving new tuples from queries
  • Updating Rows
    • Simple row updates
    • Updating nested tables
    • Updating rows by inserting into nested tables
  • Deleting Rows
    • Simple row deletion
    • Deleting rows from nested tables
  • Complex Operators
    • Nesting and unnesting data
    • Restructuring tables
    • Joining
    • Joining a table to itself

For further information and bookings, email: This email address is being protected from spambots. You need JavaScript enabled to view it.