Relational Database Design - Advanced FileMaker Pro I

Two days of instructor-led, hands-on training

Focus

In Relational Database Design, you’ll learn how to build more robust, feature-rich databases by learning about relational theory, aggregate functions, complex relationships and referential integrity. We’ll cover developing a thorough data model for an organization and its business logic and using FileMaker Pro’s relationship graph to build solutions and intuitive interfaces. Plus, our expert developer-instructors will share tips and techniques that will shave hours off your development time.

The Support Group is celebrating our 25th year in business by offering significant discounts on many of our classes.  Our Advanced classes, Relational Database Design and Scripting & Calculations are each $499, a savings of nearly $300 per class. These special prices are good through December 31, 2010.

Benefits

By the end of this class, you’ll be able to:

• Understand the principles of relational theory and apply them to your applications
• Use portals to view related data
• Solve many-to-many and self-join relationships
• Create calculations working with related data
• Understand context and how it relates to database design
• Implement complex relationships in FileMaker Pro’s relationship graph
• Understand FileMaker Pro’s security model and how to use it to protect certain records and maintain referential integrity

Who should take this class

You should attend this class if you have already been using FileMaker Pro and you now want to create more sophisticated and complex solutions, typically used by others in your organization.

This class is ideal for students who have previously attended our Intermediate FileMaker Pro training, or have equivalent experience working with fields, layouts, calculations and scripts.

Agenda

• Understanding relational theory
• The nature of relationships (one-to-one, one-to-many, many-to-many)
• Data modeling
• Entity Relationship Diagrams
• Solving many-to-many relationships
• The FileMaker relationship graph
• Aggregate functions
• Relational value lists
• Table occurrence groups and context
• Solving one-to-many self-join relationships
• Complex relationships with multiple predicates and comparative operators
• Using portals to develop user interfaces
• Maintaining referential integrity
• Accounts, privilege sets, and record level security

Pricing

25th Anniversary pricing for our two-day Relational Database Design class, regularly $795, is just $499. Register online now.