JCC Seminar Listings

This page includes a listing of standard JCC seminars, along with a brief description. For on-site delivery, these seminars can be used as a foundation for customized training and can also be combined with site-specific examples, labs, and consulting. If you need the training available in one of these, but do not have enough people for an onsite, let us know.  Special events are planned in response to expressed interest. JCC also offers seminars at the Rdb Technical Forums. For additional information on a specific seminar, click on the seminar title.

Are you having trouble weaving all the different things together into a pleasing shape?

Relational Database Design for Fixing "Broken" Databases  (2 days)

An intensive seminar on relational database design and redesign of existing data stores. The seminar gives in-depth attention to entity-relationship modeling, normalization, transaction tables, concurrency, performance, security, the functional data model (i.e. making relational databases run faster), reengineering, and other issues.

Implementing a Relational Database Using SQL (4 days)

Introduction to Oracle Rdb’s implementation of the SQL standard. Topics that you’ll master include the SQL programming language, program interfaces, and creating and maintaining databases.

Advanced SQL (5 days)

An advanced focus on the use of SQL in the Rdb environment. This seminar teaches you how to achieve maximum performance from database queries and covers advanced SQL language concepts, sub queries, sessions, built-in functions, compound statements, and stored procedures and functions.

Oracle Rdb Database Administration: Creating and Modifying Databases (4 days)

An introduction to maintenance practices for Rdb databases, including responsibilities of the database administrator, database creation, default design, backup, basic tuning, constraints and triggers, and use of RMU.

Oracle Rdb Database Administration: The Care and Feeding of Production Databases (5 days)

More information and insights for the experienced DBA, including verify and backup schedules, security and access control, auditing, planning of upgrades global buffers, AIJ management, and tuning.

Rdb Database Performance and Tuning: Physical Design and Systems Tuning (5 days)

This seminar focuses on the ways you can improve the performance of your Rdb database application by manipulating the "physical" characteristics of your database. Importantly, the seminar also focuses on ways to avoid common pitfalls and known performance issues with the engine.

Database Performance and Tuning: Query Tuning and Locking (4 days)

This seminar focuses on the ways you can improve the performance of your Rdb database application by manipulating the "logical" characteristics of your database. Importantly, the seminar also focuses on ways to avoid common pitfalls and known performance issues with the engine.

Students attending this seminar will receive a license key to the JCC Query Analysis and Performance Tool.

Rdb Internals (5 days)

Have you always wanted to know why Oracle Rdb's optimizer chooses the strategies it does? Would you like to be able to read Rdb's bugcheck dumps? Do you know how Rdb chooses the pages on which it stores new records? Do you know what is actually stored on a database page? If you'd like to know the answers to these questions and dozens of others, plan to attend one of these offerings of the popular Rdb Internals course.

Building Applications with Oracle Developer and Rdb (5 days)

This seminar is intended as an introduction to Oracle Forms for mature software developers. Oracle Forms, part of the Oracle Developer package, supports quick development of sophisticated client/server applications. Forms is closely tied to Oracle’s Oracle8i and Oracle Rdb database products, but can be used with any ODBC-compliant database.  This seminar provides sophisticated tips on tuning performance of a client/server application with Rdb as the database.

JCC's LogMiner Loader: Features and Applications (1 to 3 days)

This seminar provides a thorough view of JCC's LogMiner Loader (and Oracle's Rdb LogMiner) and of the wide variety of applications benefiting from the LogMiner Loader. For a more complete description of the product and the applications see the LogMiner Loader features page.  Options include a quick overview, a two-day introduction with workshop to install and configure a sample installation, or a tuning class for experienced users.