Esperant Administration

An in-depth study of the Esperant environment through lectures, demonstrations, and practical assignments. Esperant is a query, reporting and analysis tool used for accessing SQL-compliant relational databases.

Duration: 2 days

Target Audience

Technical personnel who are responsible for managing the Esperant environment.

Prerequisites

Technical knowledge of the organization’s operating environment and database systems, basic knowledge of SQL and Microsoft^® Windows^TM. Basic knowledge of ODBC is desirable.

Objectives

Students will learn how to set up and manage the Esperant environment, and how to use its query and reporting features.

Key Topics

• Installing Esperant
  • Standalone
  • Network
• Managing repositories and Esperant Data Views
  • Creating a repository
  • Defining database connections
  • Creating and maintaining data views
• Using advanced features
  • Creating aggregate and partitioned sets
  • Creating virtual tables and items
  • Editing complex joins
  • Distributing data views
  • Defining drill hierarchies
• Managing security
  • Defining users and groups
  • Defining external security
• Customizing the user environment
  • Writing scripts for Executive Desktop items
  • Managing batch jobs
• Creating queries and formatting reports

Also available in pdf format

Additional Information

For information about our courses or to register for a course, contact:

Each student in a Speedware course:

• Receives a course documentation kit as part of the registration fee
• Gets the opportunity to apply concepts through hands-on lab exercises
• Learns how to use the documentation for specific factual reference or for guidance on the job.