|
|
Course availability is subject to change. Please
contact Empress for course details and availability.
| #100 Empress Data Management Toolkit Overview |
This informative one-day course will give you a general overview of your Toolkit and how its components effectively fit together, and help you determine which tools/interfaces best suit your application. You will learn how to get started building your database and gain a basic understanding of how to use database administration utilities. Also, you will get valuable insight about Empress product features to help you in making application design decisions.
Prerequisite: None
Duration: 1 day |
| #200 Introduction to EMPRESS SQL |
For those who have little or no experience in database systems
this one day course provides an introduction to database systems and EMPRESS SQLcommands. Concepts of databases and basic SQL commands are covered. Users learn
to create and manipulate tables, insert data, query the contents of tables, and
update data.
Prerequisite: None
Duration: 1 day |
| #201 Advanced EMPRESS SQL |
This two-day course covers the advanced concepts and features
of EMPRESS SQL. Those who are familiar with simple SQL commands and want to
learn more will benefit from this course. Advanced topics covered include:
indexing, data integrity, privileges, locking and transactions. Organization of
files associated with EMPRESS tables and the data dictionary are discussed. SQL
commands are discussed in detail.
Prerequisite: #200 Introduction to EMPRESS SQL
Duration: 2 days |
| #300 Introduction to EMPRESS 4GL |
This two-day course covers the fundamentals of the EMPRESS 4GL.
Users are introduced to the 4GL environment. Interactive applications accessing
one or more EMPRESS tables are created without programming. Applications are
customized and menus are created using the Application Generator. Course covers
4GL concepts, form creation, modifying applications, editing scripts, and using
the Application Generator. This course is good for users who want to create
simple interactive applications.
Prerequisite: None
Duration: 2 days |
| #301 Advanced EMPRESS 4GL |
Designed for developers who wish to build custom user interface
applications. This three-day course covers custom application creation using
EMPRESS 4GL. It will cover the following: command language, form editor, key
scripts, multi-record applications, capturing interrupts and errors, and linkingapplications together. Each command in the 4GL language is explained as the userbuilds several 4GL applications (including a multi-record application). The 4GL
debugger is used to set breakpoints, step through the code, and view values of
variables.
Prerequisite: #300 Introduction to EMPRESS 4GL
Duration: 3 days |
| #400 EMPRESS Report Writer |
This one-day course is designed to assist users and developers
who need to produce customized reports. Users learn to use the EMPRESS Report
Writer script language to construct reports. Processing of records and groups
of records is discussed. Format options for printing results are covered. Other
topics include headers, footers, control flow commands, and printing multiple
lines. Students gain experience through numerous exercises.
Prerequisite: #200 Introduction to EMPRESS SQL
Duration: 1 day |
#500 C Language Interface:
EMPRESS MR Routines
|
This two-day course introduces the EMPRESS MR routines for
direct access to the database via the C language. These routines provide the
most efficient and flexible access to EMPRESS databases. Users learn how to
obtain descriptors, set up retrieval loops, build expressions and
qualifications, update tables, deal with locking errors, and use transactions.
This course is recommended for C developers who need maximum performance, and
greater control over retrieved data.
Prerequisite: #201 Advanced EMPRESS SQL
Duration: 2 days |
| #501 C Language Interface: EMPRESS MX Routines
|
A two-day course that introduces the EMPRESS MX routines for
direct access to the database via the C language. These simple routines are
easier to use than the MR routines, although not usually as efficient. Users
learn to open and close tables, set up retrieval loops, build qualifications,
update tables, handle errors, and use transactions. This course is for C
developers who want a simple interface to the EMPRESS RDBMS.
Prerequisite: #201 Advanced EMPRESS SQL
Duration: 2 days |
| #502 C Language Interface: EMPRESS Static & Dynamic
SQL |
Two-day course covers the use of the EMPRESS C Precompiler to
handle SQL commands embedded in a C program. Static SQL commands are hard-coded
in the source program and they are converted to C routines by the precompiler.
Dynamic SQL commands are string variables that are parsed at runtime, and they
can change during the execution of a program. Users learn to use both types of
commands to retrieve records, update tables, handle errors, and use
transactions. Recommended for C developers who want to use standard SQL commandsto access the EMPRESS RDBMS.
Prerequisite: #201 Advanced EMPRESS SQL
Duration: 2 days |
| #504 EMPRESS HYPERMEDIA, Internet Application Toolkit |
This two-day course covers the fundamentals of the Empress Hypermedia Toolkit.
Users are introduced with the design of dynamic HTML ( Hypertext Markup Language )
application for Internet or corporate Intranets. An overview of HTML,
programming with the Empress Hypermedia HTML Toolkit, the administration of
WEB Server and Empress ODBC Server, and the security issues are discussed.
Beginners and experts with HTML, will benefit from this course.
Prerequisite: None
Duration: 2 days |
| # 505 EMPRESS CONNECTIVITY, ODBC Interface |
This course is designed to assist users and developers who need to
write their own ODBC application or to use any of the available ODBC
compliant third party tools, such as MS Visual Basic, MS Visual C++ or
MS Access, and access data located in one of the Empress database. The
course covers both Unix and Windows ODBC concepts. It also gives an overview
of Empress ODBC Server setup, configuration and administering tools.
Both beginners and experts with ODBC concepts will benefit.
Prerequisite: None
Duration: 2 days |
| #506 Java Programming using EMPRESS JDBC Database Solutions |
Learn how to achieve high performance database solutions using Java.
Experience and learn new technologies such as JDBC programming, Java
servlets and Java Server Pages. Participants of this course will learn how
to install, configure and run different scenarios using Empress JDBC
database solutions.
Prerequisite: None
Duration: 2 days |
| #600 EMPRESS Database Design & Tuning |
Two-day course is designed for administrators and application
developers who need an understanding of database design trade-offs, and want to
increase the throughput of the EMPRESS RDBMS. Topics discussed include: the
importance of normalization, the structure of the table files and index files,
the proper use of indices, query optimization in EMPRESS, details of EMPRESS
locking, proper use of shared memory, and database server issues.
Prerequisite: #201 Advanced EMPRESS SQL
Duration: 2 days |
| #700 EMPRESS Database Administration |
A three-day course discussing the role of the Empress database
administrator. It covers the installation procedure and the contents of the
EMPRESS directories. Files and directories of a database are discussed as well
as the system tables. The uses of administrative and system variables are
explained. Recovery procedures, setting up shared memory, and use of the
database server is covered. Introduction to the EMPRESS ODBC interface is also
covered.
Prerequisite: #201 Advanced EMPRESS SQL
Duration: 3 days |
| #701 EMPRESS Replication |
Learn how to achieve high data availability solutions using Empress Replication. Empress Replication will also help you to reduce network data traffic, distribute system load over multiple locations and off load lock contention between database applications. Learn how to configure, start and maintain replication servers and how to perform synchronization tasks.
Prerequisite: #201 Advanced EMPRESS SQL
Duration: 1 day |
| #800 EMPRESS User Defined Functions and User Defined Procedures |
For programmers who want to extend the functionality of the
EMPRESS SQL language this three-day course teaches how to write user-defined
functions for use within SQL, 4GL, Report Writer and MR routines. The course
covers the addition of a keyword to the EMPRESS language, handling of data
conversions, null and error conditions, and handling variable number of
arguments. Both SC and DT type functions are discussed. Students will have an
opportunity to write simple functions.
Prerequisite: #500 C Language Interface: EMPRESS MR Routines
Duration: 3 days |
| #801 EMPRESS Persistent Stored Modules (PSM) |
Learn how to extend the power of your database. Build your own user defined procedures, user defined functions, your own aggregate functions and operators. Learn how to embed knowledge and rules into the database using procedures and triggers. Incorporate the knowledge and operational logic into your database removing it from your applications.
Prerequisite: #500 C Language Interface: EMPRESS MR Routines
Duration: 2 days |
| #900 Introduction to EMPRESS GUI & Script
Language |
This two-day course covers the basic concepts of EMPRESS GUI
Builder. Users will create simple GUI applications accessing EMPRESS tables
using the script language. Course covers various facets of the EMPRESS GUI
development environment. It explains what the components of a GUI application,
are, which objects are available in the toolkit, how they are used, and how to
write scripts.
Prerequisite: #200 Introduction to EMPRESS SQL
Duration: 2 days |
#901 EMPRESS GUI Advanced
Concepts and C API |
Three-day course explains how to write C routines for EMPRESS
GUI Builder applications. It covers advanced topics such as the registry,
resizable objects, inheritance & styles, and user-defined objects. Course
teaches the user how to create applications with multiple modules and how to use
the user object as a drawing area. This course is designed for C programmers whowant to develop complex EMPRESS GUI Builder applications. Certain topics coveredrequire a knowledge of X programming.
Prerequisite: #900 Introduction to EMPRESS GUI & Script Language
Duration: 3 days |
|
|
|
