Course Catalog

Information Modeling for Information Analysts

Database Design and Performance Tuning

Advanced Topics in Information Modeling

Training Rates

Scheduled Classes

If you are looking for the most effective information modeling training available, then contact us to schedule a class!

Did You Know?

We can tailor our presentations to fit your system development environment?  For example, our Information Modeling course can be presented in any of five different CASE tool dialects, and may be edited to suit the number of days you have available for training. These options come at no additional cost.

Gary Schuldt is also available for consulting projects. Please contact us for rates and schedules.

Course Catalog

Information Modeling for Systems Analysts (IM)

• Information Modeling is a workshop course which teaches fundamental, practical techniques of Information Modeling. This course is unique in the market in that it includes over two dozen expert-style heuristics for discovering and modeling entities, relationships, attributes, and multi-typing. It is offered in several modeling dialects ranging from "nouveau Chen" to "Information Engineering".
• Duration:  5 days
• Full course description

Database Design and Performance Tuning (DBTUN)

• DBTUN teaches practical techniques for designing and tuning relational databases. The design process is organized into two phases: using an Information Model to create a first-cut relational design; and using transaction Access Models to tune the resulting design to meet performance criteria.
• The tuning phase is broken down into three stages--Access Modeling, first-cut tuning, and denormalization. Access Modeling techniques include procedures for creating access profiles for the high-stress business transactions and then prioritizing them so that subsequent tuning can proceed rationally. First-cut tuning draws upon specific DBMS features to streamline performance of the top-priority transactions. Denormalizing techniques are then used to solve the remaining performance problems. All the principles are applicable to a distributed client/server environment.
• Duration:  4 days
• Full course description

Advanced Topics in Information Modeling (ADVIM)

• ADVIM supplements the basic E-R discovery and representation techniques taught in Syncretics' Information Modeling workshop. The Advanced Topics cover extensions to the original Chen E-R model as well as some of the thornier practical problems which most experienced modelers have probably faced.
• For example, ADVIM includes such topics as deciding what is and what isn't an entity (including sub-entities), modeling "time", representing "create and delete" rules, nested relations (violating 1NF), applying the five secrets of attribution, the connections with other models (e.g., process, event, relational and object/class) as well as the natural language connection, and modeling business rules.
• Duration: 3 days
• Full course description