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.
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
Tuition for our two-day Relational Database Design class is just $795. Register for both of our advanced classes (this and Scripting and Calculations) for a total of only $1,495, a $95 savings. Register online now.
