Server, SQL & Web
Description: A 3-day class that covers FileMaker Server, SQL connectivity and web publishing. Learn to setup, configure and maintain FileMaker Server; setup backup schedules; import data from a SQL database into FileMaker; perform one-way synchronization with SQL database and FileMaker; understand various web publishing options for FileMaker; use Instant Web Publishing and the PHP Site Assistant.
| Class |
Dates |
Price |
|
| Sever, SQL & Web |
TBD |
$695 |
Level: Intermediate to advanced. Want to go further? Try Web Publishing with PHP.
Prerequisites: Introduction to FileMaker, Intermediate FileMaker and Advanced FileMaker; OR 9 months experience creating databases with FileMaker Pro.
FileMaker Server - Learn the best practices for setting up and maintaining FileMaker Server 9 and FileMaker Server 9 Advanced. Review hardware and networking requirements, learn proper backup routines, and be trained in configuration processes.
- Install and configure FileMaker Server and FileMaker Server Advanced
- Upload databases to FileMaker Server
- Back up your databases using FileMaker Server backup tools
- Integrate FileMaker Server backups with organizational backup strategies
- Administer FileMaker Server from the command line
- Trigger FileMaker Pro scripts from FileMaker Server
|
SQL Connectivity - Learn how to integrate FileMaker with SQL systems, both through ODBC connections and with the new External SQL Data Source capabilities in FileMaker Pro 9. Review configuration processes and learn to use other data systems in tandem with your FileMaker Pro databases.
- Understand the different ways of getting data into and out of FileMaker Pro using ODBC technologies
- Configure Data Source Names (DSNs) to connect to specific ODBC data sources
- Use ODBC Import feature in FileMaker Pro to populate a FileMaker Pro database with records from an ODBC data source
- Use ODBC Import feature in FileMaker Pro to perform a one-way synchronization of data from an ODBC data source to FileMaker Pro
- Understand and use the new Extended SQL Sources (ESS) features in FileMaker Pro 9
- Use the ESS feature to integrate SQL data sources directly with your FileMaker Pro solutions
|
Web Publishing - Understand the capabilities of both Instant Web Publishing (IWP) and Custom Web Publishing in FileMaker Pro 9 and learn how to develop solutions to publish via the Web. Review the PHP Site Assistant and gain hands-on experience with IWP.
- Understand the different Web publishing options available with FileMaker Pro
- Configure FileMaker Pro and FileMaker Server Advanced to publish using Instant Web Publishing
- Create Web-friendly layouts and scripts for use with Instant Web Publishing
- Create a custom home page for Instant Web Publishing
- Use the PHP Site Assistant to generate a variety of Web sites that publish FileMaker Pro data by using PHP and Custom Web Publishing
|
|
