Aims
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.
Format
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.
Prerequisites
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: