Discover Classes. Earn 10% Rewards.

FileMaker Pro Day 2: Data Modeling is unfortunately unavailable

Thankfully we have 1 other Tech Class for you to choose from. Check our top choice below or see all classes for more options.

Artificial Intelligence (AI) Business Essentials Certificate Program

American Management Association See all classes by this school @ 25 Burlington Mall Rd, Burlington, MA

Gain a practical foundation in the technologies, applications, and strategic implications of artificial intelligence in today's business environment. This certificate program covers the current AI landscape, key use cases, and the organizational opportunities that AI opens up. A focused and forward-thinking program for professionals ready to lead in an AI-driven world.

(8) All levels 21 and older
$2,795

2 sessions

Attend
Earn 27,950 points
Gift it!
See all Tech classes Los Angeles

FileMaker Pro Day 2: Data Modeling

  • All levels
  • 16 and older
  • Earn 10% back in points
  • Price Lock

    If you find the same class on the same dates for less on another site within 48 hours of booking, send us the link. We match the price as credit or the difference.

  • 200 Pine Ave, Long Beach, CA

Start Dates (0) $249/person

No upcoming dates are currently available.

Book a Private Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Class Description

Description

In this one-day class, you will learn how to think like a relational database developer, analyzing real-world scenarios and learning to identify the entities, attributes and relationships that will become the tables, fields and relationships in a sound FileMaker database. You will learn how to correctly detect relationship types, how to use primary and foreign keys and how to resolve many-to-many relationships. You will learn in detail how to create fields and apply field auto-entry and validation options, and gain an understanding of field storage and indexing. You will create relationships between table occurrences using key fields and then use them to display related data on layouts. You will also begin to learn the Anchor-Buoy method, an effective strategy for managing FileMaker's relationship graph. This class is taught using the official FileMaker Training Series course manual, is taught by a FileMaker Business Alliance Trainer and is an excellent step in preparing for the FileMaker Certified Developer exam.

Course Outline
Identifying Entities and Attributes
- what are entities and attributes?
- differentiating between entities and attributes
- creating an Entity-Relationship Diagram (ERD)

Identifying Relationships
- understanding the three types of relationships
- examining relationships
- the key to correctly detecting relationship type

Modeling Relationships with Keys
- what are key fields?
- primary keys vs. foreign keys
- understanding the problem with many-to-many
- resolving many-to-many relationships with join tables
- determining appropriate attributes in join tables

Creating Fields
- data types
- defining fields
- auto-entry options
- field validation options

Field Storage and Indexing
- global storage
- indexing

Creating Relationships
- establishing a relationship
- placing related fields on a layout
- using a portal to view related data

Managing the Relationship Graph
- understanding the Anchor-Buoy method
- using multiple table occurrences on the graph
- benefits of Anchor-Buoy when designing layouts

Refund Policy

  • You may cancel or reschedule a class registration at least 8 business days prior to the class without incurring any penalty.
  • After 8 business days, we may charge a penalty of up to 100% of the registration cost.
In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

Reviews of Classes at Accelerate Computer Training (33)

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • No booking fees. You pay the school's price, with nothing added at checkout.
  • Price Lock. If you find the same class on the same dates for less on another site within 48 hours of booking, send us the link. We match the price as credit or the difference.
  • This class will earn you 2490 points. Earn 10% back in points. 100 points = $1 off a later class.

Accelerate Computer Training

Accelerate Computer Training offers hands-on computer training classes in Long Beach, California. Their experienced trainers provide personalized instruction in a variety of software applications, allowing students to improve their skills and enhance their work efficiency.

View school profile
Accelerate Computer Training
Vetted by CourseHorse

A verified Los Angeles educator.

Loading...