Course Overview and Benefits

Watch to learn more


Installing FileMaker Server is essential to making your data both available and secure, but it can be challenging. In Productive Computing University’s Mastering FileMaker Server (FMS) course, you’ll learn the ins and outs of installing and configuring FileMaker Server, along with learning expert techniques and tips from an experienced FileMaker developer. 

If you need to troubleshoot issues with FileMaker Server or just want to follow best practices, you may need to sift through dozens of pages of help docs, white papers, and online forum posts. We have condensed these best practices into the Mastering FMS course, in addition to practical insight from our FileMaker expert. 

Mastering FileMaker Server will teach you both basic and advanced tips for working with FileMaker Server, including:

  • How to install FileMaker: Our expert FileMaker instructor will give you a clear, accurate walkthrough on how to correctly install FileMaker Server with confidence. 
  • Establishing Connections: Learn how to configure FileMaker Server so your users can access data via FileMaker Pro, FileMaker Go, and a browser. You’ll also learn how to configure FileMaker Server to be available for the FileMaker Data API, custom web publishing, and connections using ODBC / JDBC.
  • Handling SSL installation: Mastering FMS will teach you about compatible SSL certificates as well as how they are installed and handled in FileMaker Server. There are also lessons demonstrating how to set up a domain and bind the domain with the SSL.
  • Troubleshooting and monitoring performance: This course will show you how to troubleshoot, understand network issues, review event logs, and improve performance. You’ll also learn how to view, review, and parse logs that can help you troubleshoot server outages or issues. 
  • Understanding backups: Learn the basics of FileMaker Server backups - how to create automated, custom, and progressive backups. Ensuring that you have a robust backup strategy.  
  • Using command line interface. There is an entire section on working with the command line which is necessary to take your configuration and automation to the next level.
  • Working with Server-Side Scripts: We cover all the basic ground rules for incorporating server-side scripting in your environment and discover how this can be used to remove performance bottlenecks with practical examples demonstrated.


We designed Mastering FileMaker Server for: 

  • New developers: If you're working with the FileMaker platform, you’ll inevitably need to install, configure, manage, maintain, and monitor FileMaker Server. Instead of trying to stumble through manuals and forums by yourself, you can enroll in Mastering FMS to manage your FileMaker Server with confidence. 
  • Experienced FileMaker developers: Do you already know how to install FileMaker Server? While we address the basics in this course, Mastering FMS also includes hours of content tailored specifically to more complex FileMaker Server topics. Learn directly from our industry expert who performs hundreds of FileMaker installations.
  • IT specialists: You might not be a FileMaker developer, but you’re still responsible for managing a FileMaker Server. Mastering FMS helps IT specialists bridge the gap with clear, actionable how-tos and best practices to help you get up and running quickly with a configuration that works best for you and your situation. 


Are you looking for the FileMaker Server SSL Certificate Installation course, we completely revamped the original course to address much more than installing SSL certificates in FileMaker Server. If you’re an existing subscriber to the original course or the PCU University Bundle, you’re grandfathered in and will have immediate access to the content of this course.

Course Curriculum

For Mastering FileMaker Server

  1. 2
    • About FileMaker Sever (Overview)

      FREE PREVIEW
    • FileMaker Server Sizing and Machine Requirements

    • Install FileMaker Server (Win)

    • Install FileMaker Server (Mac)

    • FileMaker Server Ports (to configure security/firewall)

    • Enable Custom Web Publishing and Install JRE

    • Testing Server with FM Pro & FM Go

    • Admin Console Overview

    • Uploading Database Files (Using FileMaker)

    • Uploading Database Files Manually (Win & Mac)

    • Working With External Containers

    • Getting Users Connected (URL Formats)

    • Stopping and Starting the Server

    • Chapter Resources (Links mentioned in this chapter)

  2. 3
    • SSL Section Overview

    • What is SSL and Why Do We Need It?

    • SSL Certificate Types

    • Purchase SSL Certificate and Domain

    • CSR (Certificate Signing Request) Overview

    • Create CSR

    • Certificate Setup: Configuration with SSL Provider

    • Download Validated Certificates From Provider

    • Import Certificate Parts Into FileMaker Server

    • Set up Domain to Point to FileMaker Server

    • Test the SSL Cert with FileMaker

    • Chapter Resources: (Links mentioned in this chapter)

  3. 4
    • Database Files and Clients

    • Configuration: General Settings

    • Configuration: FileMaker Clients

    • Configuration: Folders

    • Configuration: Notifications

  4. 5
    • Backups Overview

    • Auto Backup and Preserved Backups

    • On-Demand (Custom Backup Schedules)

    • Progressive Backups

    • Other Backup Options

  5. 6
    • FileMaker Scripts and Verify Schedules Overview

    • FileMaker Server-Side Scripts

    • System Scripts

    • System Scripts for MacOS

    • Script Sequences

    • Verify Files

    • Load and Save Schedules

  6. 7
    • Web Direct Publishing

    • PHP Publishing (Deprecated)

    • XML Publishing

    • Data API Publishing

    • Plug-ins

    • ODBC/JDBC

  7. 8
    • FileMaker Licensing

    • External Authentication (Overview)

    • Administrator User Name and Password

  8. 9
    • Log Viewer

    • Log Settings

    • Working With Logs

  9. 10
    • CLI Overview for WIndows

    • CLI Overview for Mac

    • FMS Admin Commands (Part 1)

    • FMS Admin Commands (Part 2)

  10. 11
    • Uninstall FileMaker Server (Windows)

    • Uninstall FileMaker Server (Mac)

    • Installing on Multiple Volumes

    • FileMaker Server Admin API

    • Reset Admin Console Password Via the PIN

  11. 12
    • Renew Your Certificate

    • Rekey Your Certificate

    • Delete the Secure Certificate

    • Using a Dynamic IP Address

  12. 13
    • Client-Side Issues

    • Improving Performance

    • Manually Restart
 Selected Services

    • Abrupt Restarts

    • Failed Consistency Check

    • Apache Loading issue (MacOS)

  13. 14
    • Install FileMaker Server 18 (Windows) [legacy]

    • Install FileMaker Server 17 (Windows) [legacy]

    • Install FileMaker Server 18 (Mac) [legacy]

    • Install FileMaker Server 17 (Mac) [legacy]

    • Enable Custom Web Publishing and use Open JDK (Server 18) [legacy]

    • CSR Overview (FM Server 18 or earlier) [legacy]

    • Create CSR on Windows (FM Server 18 or earlier) [legacy]

    • Create CSR on a Mac (FM Server 18 or earlier) [legacy]

    • Certificate Setup: Configuration with SSL Provider (FM Server 18 or earlier) [legacy]

    • Delete the Secure Certificate (FM Server 17)

    • Chapter Resources: (Links mentioned in this chapter) [legacy]

  14. 15

Prerequisites

While Mastering FileMaker Server is great for both beginners and advanced FileMaker professionals, we do recommend the following prerequisites for the course: 

  1. You have a good understanding of FileMaker development, file structure, and scripting. 
  2. Access to FileMaker Pro 19 or higher (or a trial version). 
  3. Access to FileMaker Server 19 or higher.
  4. Access to a computer/server compatible with FileMaker Server.
  5. SSL installation requires a paid SSL certificate from a third party and a hosted public domain to bind it to.
  • $299.00 first payment, $199.00 / year onwards

    $299.00 first payment, $199.00 / year onwardsEntire University Bundle

    Gain access to all PCU courses with a subscription to the bundle.
    Buy Now

Course Reviews

5 star rating

Detailed and unbeatable explanations

Juan Sans

5 star rating

Awesome

Russell Haney

Great video's and to the point

Great video's and to the point

Read Less
5 star rating

Amazing!

ziouani idir

time + energy saver course , highly commanded

time + energy saver course , highly commanded

Read Less
5 star rating

To the Point

Sayed Bondok

I was waiting some courses like these practical ones - really I've never seen similar videos. Thanks

I was waiting some courses like these practical ones - really I've never seen similar videos. Thanks

Read Less
5 star rating

FileMaker Server SSL Certificate Installation

Alex Mitchell

Very productive. thank you. Got a "green" lock icon!

Very productive. thank you. Got a "green" lock icon!

Read Less

Your Instructor

President/CEO/Founder Productive Computing, Inc.

Marc Larochelle

Starting in 1991, Marc worked for the National Association of Music Merchants (NAMM) for 5 years and built the trade show database in FileMaker which tracked 1000 exhibitors and 12 football fields worth of exhibit space. NAMM is one of the world’s largest trade shows and FileMaker was keeping track of everything. While at NAMM, Marc taught computer classes at night helping users with their Macintosh, MS Word, Excel, etc. In addition, he taught music/multimedia classes at local community colleges. Marc Larochelle and his brother Keith started Productive Computing, Inc. (PCI) in 1996. The company now in its twenty-second year, serves customers who use FileMaker and QuickBooks in the areas of custom development, solutions, plug-ins, hosting and licensing. Marc is certified in FileMaker versions 7 through 18 and he also holds a certification in AWS (Amazon Web Services). Marc has been to 19 FileMaker DevCons (18 as an exhibitor) and is considered a prime influencer within the FileMaker community. 

Mastering FileMaker Server

Install, configure, and maintain FileMaker Server with confidence, no matter your current skill level.