Training Course Data Sheet

PME201

Aspen SQLplus for Aspen InfoPlus.21:
Using and Configuring for Power Users

Course Number:

PME201

Duration:

5 days

CEUs Awarded:

3.5

Level:

Intermediate

 

Former Course Title/Number

This course was previously known as Essential Aspen SQLplus® for Aspen InfoPlus.21® Power Users, MM436

Objectives

·       W rite and execute SQL queries to maintain, view, or manipulate Aspen InfoPlus.21 data in a flexible way

·       Integrate real-time or historic data from Aspen InfoPlus.21 with other data sources efficiently

·       Configure versatile reports, including custom client-side reports using the Aspen SQLplus Reporting Tool

·       Develop or maintain a SQL-based application for Aspen InfoPlus.21

·       Optimize the way in which SQL is used for processing within AspenTech real-time databases

·       Explore the benefits of using Aspen SQLplus to automate many mundane tasks

·       Organize data more effectively for users of desktop clients such as Excel

·       Utilize the COM enabling features

·       Use the debug tools effectively

·         Access other remote databases using ODBC

Course Benefits

·       Reduce the time and effort required to implement and maintain Aspen InfoPlus.21 applications

·       Using SQL to populate your database saves time and effort – this course shows you how

·      Improve the performance of your existing system by using SQLplus efficiently

·      Versatile reporting means better informed decision making by integrating many data sources

·       Easily transfer your skills to other SQL vendors and organizations

Who Should Attend

·      Users who have no SQL skills yet, but who want to learn what it has to offer and how it can help them to access InfoPlus.21 data

·       Users who already have a basic understanding of SQLplus and who want to extend their knowledge to include more advanced topics and features

·      Users who understand the basics of Aspen SQLplus and who want to create simple applications or to configure reports

·      Existing or prospective system integrators and database system administrators

Approach

·       Interesting and relevant course material taught by knowledgeable instructors; covers all versions including aspenONE v7.1

·       In-depth discussion on the most important Aspen InfoPlus.21 specific extensions to the SQL language

·       Frequent hands-on exercises, featuring examples relevant to a plant information environment, used throughout the course to illustrate language features, useful utilities, and application ideas

Prerequisites

·       Some knowledge of InfoPlus.21 database concepts is expected. Prior completion of the PME101 Aspen InfoPlus.21 Real Time Information Management Foundation Course will greatly enhance the value of this course.

 

PME201 Aspen SQLplus® for Aspen InfoPlus.21® Power Users              Course Agenda

Day 1

 

·         Introduction and Overview, Architecture

·         Use Aspen SQLplus Query Writer to construct simple queries

·         Construct SQL SELECT queries: syntax rules; output formatting, including sorting

·         Filtering data with WHERE clause: specify conditions and time periods to search; use wildcards for “fuzzy” search characters

·         SQL Functions and Expressions: perform calculations and use SQL functions

·         Text Manipulation: read a text file as a SQL table; extract data from text files

·         Creating reports: formatting options, group data by category, web-based reporting tool

·         Calculate column or section statistics

Day 2

·         Working with data sets: Group functions

·         Record based SQL

-          Integrate SQL tightly with the database

-          Schedule queries or execute them upon database event triggers

-          Improve execution speed using compressed queries

·         Modify database values using INSERT, DELETE, UPDATE, and SELECT INTO

·         Protecting the database from unauthorized modification

·         Create and modify Aspen InfoPlus.21 role based security; view existing security permissions

·         Read and extract data from text files

·         Explore the SYSTEM command

 

Day 3

 

·         Write simple programs using Aspen SQLplus programming language extensions

·         Advanced Procedural SQLplus: user-defined functions; stored procedures and exception handling

·         Summative Lab combining skills learned in previous sessions

·         Uses of temporary tables

Day 4

·         Working with the Debug tools to find errors

·         Aspen InfoPlus.21 extensions to SELECT statements : Record and Field Indirection; Pseudo columns and Pseudo tables

·         Using Parameters and Macros

-          Create generic queries

-          Use Macro feature for text substitution

·         Subquery conditions and Tables

·         Joins and Combined Queries

·         Basics of creating Views; creating new views, benefits of Views

Day 5

·         Accessing Remote Databases

-          Configure/use Open Access Modules

-          ODBC server and client configuration

·         Examples including from Microsoft Access and from Visual Basic

·         Extended Summative Lab 2 

·         Accessing the COM Interface

·         Hints and Tips

 

Aspen Technology, Inc. awards Continuing Education Units (CEUs) for training and development activities conducted by our organization in accordance with the definition established by the International Association of Continuing Education & Training (IACET). One CEU is granted for every 10 hours of class participation.