[Store]  [Cart]  [Resources]  [Learning]  [About]  [Solutions]  [Consulting]  [News]  [Links]

Authorized Trainer s Contact John Mark Osborne at jmo@filemakerpros.com or 909-393-4664 for more information on public courses or to customize a class for your company.

The FileMaker Training Series is the official training curriculum from FileMaker, Inc. It offers a series of 9 Advanced training modules that cover a comprehensive set of topics designed to help you master the essentials of FileMaker solution development. This new series incorporates the many new features of the FileMaker 18 product line throughout the modules but also stresses good programming skills for FileMaker 7, 8, 8.5, 9, 10, 11, 12, 13, 14, 15, 16, 17 and 18. The Beginner series is only taught by Database Pros upon request and is not taught publicly.

With training centers exclusively authorized by FileMaker, Inc. to deliver the FileMaker Training Series curriculum, and course material that includes in-depth technical information, demo files, videos and exercises, the FileMaker Training Series provides the resources you need to pass the certification test or just become a professional FileMaker developer.
Authorized Trainer

Jump to the public course schedule

This course will allow you to:

Learn best practices for developing professional database solutions with FileMaker 18 products.
Get results more quickly than using self-teaching methods.
Work with certified FileMaker experts who can answer your most technical questions.
Network with others and learn what they are doing and how they accomplish it.
Share your ideas and tips.

You should consider taking this course if you are:

Familiar with the basics and want a solid grounding in key FileMaker development principles.
Comfortable with FileMaker Pro and want to advance your development skills.
An expert developer and want to fill in any gaps in your knowledge.
Planning to become a FileMaker Certified Developer.

Module descriptions:

FileMaker Training Series: Advanced

The FileMaker Training Series: Advanced is for intermediate to advanced FileMaker developers, but anyone who creates FileMaker databases can increase their knowledge from this series. It also serves as a stepping-stone to becoming a FileMaker 14 Certified Developer.

     1. Introduction

Begin your journey of building solid business solutions by learning the steps of planning, creating and deploying successful solutions on the FileMaker Platform. This section gives you an introduction to the foundation and design phase when starting a new project and the key principles to consider for any project such as user experience, building for different devices, and performance.

     2. Data

Gain practical skills required to define FileMaker Pro 14 data tables and fields. Learn how to construct different types of data relationships, ensure data integrity, and implement multiple-table solutions. Cover important topics such as data types and options for auto-entry, validation, field storage and indexing. Plus, learn how to manage images and other objects in container fields.

     3. Interface

Learn how to work efficiently and effectively with layouts, an essential skill for any developer. For solutions accessed by mobile, desktop, and web users, layouts can be tailored to take full advantage of the specific environment, providing for a great user experience. The lessons in this module explore different types of layout objects and the tools and methods for controlling them.

     4. Solution Logic: Calculations

Learn how functions work in the calculation engine and how to apply them in various contexts. Study how custom functions are built and how to use them in database solutions. Lessons also include the set of functions that are especially useful when developing for the mobile user. And discover new functionality in FileMaker Pro 14 for accessing metadata stored with container field data.

     5. Solution Logic: Scripting

Explore the power of the scripting in FileMaker Pro 14, which allows you to create scripted routines that can then be triggered in a variety of ways. Learn about a number of scripting tools that make it easier to write and troubleshoot scripts, as well as best practices for writing scripts, and scripting for the mobile user. Learn how to build navigation and window controls, create custom menus, and study logical branching and looping routines.

     6. Reporting

Practice creating reports in FileMaker Pro 14 using a variety of techniques. Explore basic and advanced sub-summary reports and learn how to build a cross-tab report (with data-driven columns). And see how the ExecuteSQL function can be extremely useful for creating reports and charts with its ability to quickly find, sort and even aggregate data.

     7. Security

Become familiar with the security controls in FileMaker Pro and their relevance to FileMaker Go, FileMaker WebDirect, and Custom Web Publishing. Study the account-based security features of FileMaker Pro 14, and learn how to implement privilege sets, tie access to database solutions to external authentication servers, control both access and authoring rights to systems, and extend security controls with scripting. Learn how to encrypt FileMaker files and network communication and why doing this is important.

     8. Deployment

Understand the various techniques for a deploying a FileMaker solution, with particular considerations for the new FileMaker WebDirect technology, as well as considerations specific to FileMaker Go. Get best practices for installing and configuring FileMaker Server, and learn how to trigger scripts from FileMaker Pro as well as operating system scripts from FileMaker Server.

     9. Integration

Learn how to integrate FileMaker Pro 14 with SQL systems, both through ODBC connections and with the External SQL Data Source capabilities. Discover how the integration of FileMaker with web services opens up a wealth of possibilities for your FileMaker solutions. Review configuration processes and learn to use other data systems in tandem with your FileMaker Pro databases.

Private Courses

The FileMaker Training Series is designed to be taught at your site and courses are customized to the needs of your workgroup. For assistance is determining the best combination of modules for your workgroup, contact John Mark Osborne at jmo@filemakerpros.com or 909-393-4664.
Fees include $2,000.00 per day of training (regardless of the number of students).
Expenses include lodging, airfare, travel and reproduction of materials.
10 - 12 students recommended per class.
Approximately 2 to 3 modules can be taught in one day with a 2 day minimum course requirement.

Public Courses

The FileMaker Training Series (FTS) is taught publicly at a variety of locations across the United States. Database Pros combines the FileMaker Training Series modules together to fit into a 5 day in-person or 5 week remote format:

    Planning a FileMaker Solution
    Developer Skills
    Advanced Developer Skills
    FileMaker Server

FTS courses are $495.00 per day. Take all 5 days and get a discount of $500.00. Database Pros also offers the FTS course remotely so you take the same course from the comfort of your home or office in 2 hour sessions over a 5 week period at half the price. Take all 5 weeks and get a $250.00 discount.

See below for more information on how the modules are combined into the 5 day or 5 week format.
Courses currently being offered:

*** No Classes are currently being offered since John Mark Osborne is focusing on video training! ***

Find out more about video training

Remote classes
Remote classes offer students the same benefits of a traditional class like asking questions and in-class exercises but without the cost of travel and time away from work. GoToMeeting is used to demonstrate techniques and show slides. Class is held four times a week on Tuesday, Wednesday, Thursday and Friday from 1pm to 3pm Eastern Standard Time for 5 straight weeks. You can sign up for the first 3 weeks, the last 2 weeks or all 5 weeks.

Register for a public course
The 9 modules are divided up into 5 one day classes or 20 two hour remote sessions: Starting a FileMaker Solution, Developer Skills, Advanced Developer Skills, FileMaker Server and Security. Each one day class is $495.00 and each comparable remote day is $250.00. Take four days and get the fifth day free. The Integration module is not covered.
Starting a FileMaker Solution is a 1 day course or 4 two hour remote sessions covering 3 modules ($495.00): Introduction, Data and Interface. See module descriptions above.
Developer Skills is a 1 day course or 4 two hour remote sessions covering 2 modules ($495.00): Solutions Logic: Calculations, Solution Logic: Scripting and Reporting. See module descriptions above.
Advanced Developer Skills is a 1 day course or 4 two hour remote sessions covering 1 module ($495.00): Solutions Logic: Calculations, Solution Logic: Scripting and Reporting (part 2). See module descriptions above.
FileMaker Server is a 1 day course or 4 two hour remote sessions covering 1 module ($495.00): Security. See module descriptions above.
Security is a 1 day course or 4 two hour remote sessions covering 1 module ($495.00): Deployment. See module descriptions above.


John Mark Osborne

For 5 years, John was the Technical Lead for FileMaker Pro at FileMaker, Inc., serving as an escalation path for other technical support representatives and writing a large portion of TechInfo, their technical information reference. When John Mark left FileMaker, Inc., he wrote the wildly popular Scriptology book and CD ROM which is considered the primary source for serious FileMaker developers.

He is also the author of the popular FileMaker Pro web site Database Pros www.databasepros.com with over 35,000 hits a day. John conducts FileMaker classes on behalf of the MacWorld Expositions and is a featured presenter at the FileMaker Developer Conference. In 1999, John Mark received the prestigious FileMaker Excellence award from FileMaker, Inc. for developing outstanding technical resources. John Mark is also one of 25 platinum level FileMaker Business Alliance (FBA) members helping FileMaker with their most important customers and one of a dozen authorized trainers. John Mark is also certified for FileMaker 7, 8, 8.5, 9, 10, 11, 12, 13, 14, 15, 16 and 17.
Steven H. Blackwell

Steven Blackwell is President and founder of Management Counseling Services. Steven has written a multitude of articles for FileMaker Advisor Magazine, white papers for FileMaker, Inc. and the only book on FileMaker security ever written. Steven is a FileMaker 7, 8, 8.5, 9, 10, 11, 12, 13 and 14 certified developer and one of 25 platinum level FBA (FileMaker Business Alliance) members. With 20 years experience in the FileMaker market, he is a legendary developer known by all.
©2002 - 2016 FileMaker, Inc. All rights reserved. FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries and the file folder logo is a trademark of FileMaker, Inc. All other trademarks are the property of their respective owners.

Exclamation s If you'd like to learn the intricacies of scripting and calculations at an intermediate or advanced level, consider my Philosophy of FileMaker courses.

Productive Computing