What is Aspen SQLplus
- Identify various features of Aspen SQLplus and the potential benefits of these features
- Interpret the Aspen Process Information database as a relational database so that SQL can be applied to it
Select Statements
- Use the Aspen SQLplus Query Writer to create and execute queries
- Apply the syntax of a SELECT statement to query the Aspen database
- Sort data from a query using the ORDER BY
- Workshop: Use the Aspen SQLplus editor to construct simple queries with the SELECT statement and become familiar with the Query Editor.
The WHERE Clause
- Learn how to filter data using the WHERE clause with examples of the following
- Logical and comparison operators
- Character and timestamp constants
- Know which criteria to use to restrict results
- Learn the order of precedence when using Logical Operators
- Introduce Wildcards and show how they can be used in queries
- Workshop: Use a WHERE clause to restrict output from the database using various techniques.
SELECT Revisited
- Create queries that use arithmetic functions, expressions, and apply the rules that govern their use
- Utilize data conversion as performed by Aspen InfoPlus.21
- Use Pseudo Columns and Pseudo Tables to access system-type data from the InfoPlus.21 database
- Workshop: Use arithmetic functions, expressions, and Pseudo columns to enhance the SELECT statement.
Reports
- Create Customized reports using the SQLplus Report “Toolkit”
- Be able to produce formatted server-based reports using pre-defined templates
- Learn to use the Aspen SQLplus web based reporting tool
- Workshop: Create a formatted report featuring; reporting headings, breaks, calculations and page numbering.
SET (Group) Functions
- Create queries that use SET (Group) Functions effectively
- Create subsets using the GROUP BY clause
- Restrict the output with a HAVING clause and comparing with use of WHERE
- Create cross-tabulated lists
- Workshop: Use the SET functions to calculate values for groups of data.
Record Based Queries
- Save queries as files and as records in the InfoPlus.21 Database
- View the structure of a Query Record and see how the query is stored
- Execute query records using different methods of activation
- Demonstrate an understanding of the purpose of Compressed queries
- Create queries that use the system functions ACTIVATION_RECORD and ACTIVATION_FIELD within a Generic Query
- Workshop: Create a query that is saved as a record. Activate the query using various methods.
- Workshop: Create and populate a data record from a prepared custom definition record that allows a link to a query. Write a query to process this record.
Text and System Queries
- Discuss SQL character string handling functions
- How to read ASCII text files and output ASCII text
- How to use Pseudocolumns LINE and LINENUM
- Discuss SYSTEM command and its use as a table
- Workshop: Use the text handling features of Aspen SQLplus to interrogate a text file.
- Workshop: Write a query that uses the SYSTEM command to execute operating system commands.
Parameterized SQL
- Explain how queries can START other queries
- Learn how parameters can be passed, allowing queries to be generic
- Understand what Aspen SQLplus macros are, and how to use them
- Using the Aspen SQLplus PROMPT command to make interactive queries
- Workshop: Create and execute queries that use; parameters, Macros and the PROMPT command.
|
