Speedware & RDBMS

In-depth coverage of Speedware's relational database management system (RDBMS) implementation and internal operations during database access. Discussions include transactions, locking and SQL statement processing.

Demonstrations and practical assignments are customized to a specific RDBMS supported by Speedware, as requested by the client.

Duration: 2 days

Target Audience

Application developers who use one of the RDBMS supported by Speedware.

Prerequisites

Basic familiarity with one or more RDBMS (data-manipulation verbs, tables, views), completion of the Speedware I course, and practical experience in Speedware application development.

Objectives

Students will learn to implement Speedware SQL applications while gaining an understanding of performance and maintainability issues.

Key Topics

• Data views
• SQL-ESCAPE-CLAUSE
• Database datatypes
• Null arithmetic
• Embedded SQL vs. traditional Speedware/4GL access verbs
• Transaction processing
• Database maintenance issues and the Speedware data dictionary
• Performance issues
• Portability and maintainability

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.