#100 Empress Embedded  Database  Overview

This informative one-day course will give you a general overview of the Empress Embedded Database 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

#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

#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

# 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