Monday, December 10th 9:30 am - 12:30 pm
Opening - Welcome to the third annual DataExperience Bootcamp!
The Company
The Team
Our Clients
Our Purpose at Bootcamp
Itinerary
Syllabus
Logistics
Guidelines
Presentations by Everyone
Introductions
All Attendees
Monday, December 10th 1:30 pm - 4:00 pm
Database Tools
Spreadsheets
Variety of Database Tools
FileMaker Niche
The Step after Excel
The Step before Raw Iron
Small Businesses
Small to Medium Groups
Backend Database
Frontend User Experience
Basic Relational Design
Normal Forms: First, Second and Third
Monday, December 10th 4:30 pm - 6:30 pm
Fun with Documentation
Class Attributes
Monday, December 10th 7:30 pm - 8:00 pm
Fun with Documentation
Business Requirements Document
Tuesday, December 11th 9:30 am - 12:30 pm
Basic Relational Design
Normal Forms: First, Second and Third
Standards & Conventions
The value of Numbering Elements
Universal Naming Concerns
Schema
Tuesday, December 11th 1:30 pm - 4:00 pm
Relational Methodologies
Squid
Anchor Buoy
Advanced Anchor Buoy Relational Design
Enhanced Anchor Buoy Relational Modeling
Abstraction of Relationships
Tuesday, December 11th 4:30 pm - 6:30 pm
Working with Environments
Purpose
Data Migration and Load
Roll-Overs
Planning
Scripting
Multiple Environments
Tuesday, December 11th 7:30 pm - 8:30 pm
Fun with Documentation
Functional Requirements Specification
Wednesday, December 12th 9:30 am - 12:30 pm
Standards & Conventions
The value of numbering elements
Universal Naming Concerns
Schema
Community Standards
Client Standards
Company Standards
Documented Community Standards
Wednesday, December 12th 1:30 pm - 4:00 pm
Data Parsing
Parsing from records
Parsing from clipboard data
Multiple Child Records
Custom Functions
Iteration
Standardly Used Functions
Creative Use of Variables
Wednesday, December 12th 4:30 pm - 6:30 pm
Navigation
No Menu
Main Menu
Tab Interface
Explorer Interface
Access Levels
Wednesday, December 12th 7:30 pm - 8:30 pm
Business Needs
Overview of Business Intelligence
Strategic Reporting
Predictive Technologies
Thursday, December 13th 9:30 am - 12:30 pm
Project Management
Online Tools - Basecamp
Desktop Tools
Team & Roles
Communication
Documentation
Training & Cross-Training
Thursday, December 13th 1:30 pm - 4:00 pm
Project Management
Phase Work on Multiple Projects
Multi-track Development
Working Remotely
Estimating Time and Costs
Hourly verses Fixed Bid
Development Cycles
Thursday, December 13th 4:30 pm - 6:30 pm
Window Management
Navigation Windows
Data Windows
Body Sections
Pop-up Windows
Header
Body Sections
Footer
Control Icons
Navigation Icons
Thursday, December 13th 7:30 pm - 8:30 pm
DB Relational Design Patterms and Uses
Normal Forms: First, Second and Third
Common Relational Design Patterns
Friday, December 14th 9:30 am - 4:30 pm
Field Trip
The Getty Museum
Friday, December 14th 5:30 pm - 6:30 pm
Business Analysis
Skills Required
Listening to the Business Owner
Role Perspectives
Helpful Tools
Requirements Gathering
Role Play
Interacting with Clients
Friday, December 14th 7:30 pm - 8:30 pm
Build and Version Management
Build Management Tools
Compression
Backups
Version Management
Files and Folders
Saturday, December 15th 9:30 am - 12:30 pm
User Experience Design
Developing Rich Interactive Experiences
Saturday, December 15th 1:30 pm - 4:00 pm
User Interface Design
Task Centered Design
Negative Space
Consistency
Color
Sections
Headers
Field Labels
Fields
Fonts
Sizing
Icons / Buttons
Views
Essential Formatting
Navigation Techniques
Status Indicators
Emulating Web User Experience
Saturday, December 15th 4:30 pm - 6:30 pm
Portal Filtering
Alpha Filters
Status Filters
Complex Filters
Inverse Filters
Saturday, December 15th 7:30 pm - 8:30 pm
Denormalized History & Conformed Dimension
Denormalized History
Conformed Dimension
Sunday, December 16th 9:00 am - 8:00 pm
Cool Break! - Local Wine Tasting in Santa Barbara
Monday, December 17th 9:30 am - 12:30 pm
Relational Methodologies
Squid
Anchor Buoy
Enhanced Anchor Buoy Relational Modeling
Integrating with Other Tools
External Tables
QuickBooks
Spreadsheets
ODBC
JDBC
PHP
Lasso
Run-time Solutions
Monday, December 17th 1:30 pm - 4:00 pm
File Structure Methodologies
Single File
Multiple File
Separation Model
Session Model
Monday, December 17th 4:30 pm - 6:30 pm
Transactional Data Entry
Monday, December 17th 7:30 pm - 8:30 pm
Fun with Documentation
Techinical Specifications
Tuesday, December 18th 9:30 am - 12:30 pm
Advanced Scripting with John Mark Osborne !!!
Tuesday, December 18th 1:30 pm - 4:00 pm
Advanced Scripting with John Mark Osborne !!!
Tuesday, December 18th 4:30 pm - 6:30 pm
More Advanced Scripting
Tuesday, December 18th 7:30 am - 8:30 pm
Fun with Documentation
Entity Relationship Diagram / Process Flow Diagram
Design Specification
Wednesday, December 19th 9:30 am - 12:30 pm
FileMaker, Web 2.0 and beyond
Using XML/XSLT, SOAP and the related "Web 2.0" technologies
Reporting
Native FileMaker Reports
Imports
Traditional Exports
Robust Exports
Wednesday, December 19th 1:30 pm - 4:00 pm
Advanced Reporting
Reporting Tables
Reporting Modules
Reporting History
Data Snapshots
Customizable Reports
Dynamic Menus
Fusion Charts
Flash Presentation
Financing a Small Business
Cash Flow, Small Business Loans and Factoring
Wednesday, December 19th 4:30 pm - 5:30 pm
Reporting
Q & A
Wednesday, December 19th 5:30 pm - 6:30 pm
Creative Processes
Animal Wow
Wednesday, December 19th 7:30 pm - 8:30 pm
Fun with Documentation
Use Cases
Thursday, December 20th 9:30 am - 12:30 pm
Interaction Methodologies
Table-to-table
Session
Direct Entry
Transactional Entry
Thursday, December 20th 1:30 pm - 4:00 pm
Data Entry Validation
Field Level Validation
Scripted Validation
Using Field Comments for Validation Parameters
Data Archiving Routines
Server Synchronization Techniques
Creative Use of Plug-ins
Thursday, December 20th 4:30 pm - 6:30 pm
Developer Mindsets
Development Approaches
Focus
Motivation
Environment
Efficiency
Tools
Planning
Time Management
Re-use of Code
Document Management
Organized Order of Activity
Thursday, December 20th 7:30 pm - 8:00 pm
Fun with Documentation
Use Cases (continued)
UML
Test Cases
Friday, December 21th 9:30 am - 12:30 pm
System Security
Accounts
Privileges
Navigational Security
Internal Role Tables
External Authentication
Scripted Authorization
Conditional Authorization
Sensitive Data
Isolating Tables and Files
Data Masks
Encryption
Encryption Plug-ins
Compliance
Friday, December 21th 1:30 pm - 4:00 pm
Working with Servers
Virtual Machines
FileMaker Application Versions & Releases
Variance in Application Abilities
Mixed Client/Server Enviroonments
Historical Data Management
Audit Trail Techniques
Modification
Amendments
Agency Compliance
HIPAA
Sarbanes-Oxley
FDA 21 CFR Part 11
Friday, December 21th 1:30 pm - 4:00 pm
Industry Directions
The Future
Additional Training Available
Closing