sign on for mary's
free email newsletter
learn_one_thing
Instructor Bio
Mary Gillen has been an active Web developer since 1995, and has developed SEO-compliant Internet and Intranet Web sites for such organizations as NIH AIDS Research & Reference Reagent Program , The World Bank, The International Brotherhood of the Teamsters, Cancer Research Foundation of America, McKinsey & Company, and many others. She always asks the question: what need is this Web site going to solve? Mary then designs and develops Web applications that truly serve, including Web-based content management systems that fit the work flows of organizations and give clients autonomy to control their own content. She develops Web-based applications using Cold Fusion, PHP, XML, XSLT, CSS, SQL, JavaScript, and third-party e-commerce applications.
She is also an experienced technical instructor who has taught over 8,000 individuals across the U.S. since 1995 via classroom and online instruction environments. Mary instructs XML, XSLT, SQL, JavaScript, ColdFusion, PHP, AJAX, Writing for the Web, e-commerce, Web/Email Marketing, Search Engine Optimization and Using Social Media for Online Marketing courses.
Intro to ColdFusion 9
Live, Instructor-Led Online Course
Intro to ColdFusion
3 Days Online
Instructor: Mary Gillen
Learn how to build a database and create a ColdFusion Web site backed with simple content management system that will allow you to add and modify site information in real time.
Course Prerequisites
To gain the most from the class, you should already have:
- Experience with the HTML tag set and syntax
Course Objectives
- Create a connection to a database using the ColdFusion Administrator
- Use ColdFusion Builder to efficiently develop and troubleshoot code
- Capture information in HTML forms
- Read and write information to/from a database.
- Represent complex structures using abstract data types – lists, arrays, and structures
- Separate your application into a three-tiered architecture of User Interface components, Business Logic, and SQL for easier maintainability and flexibility
- Output dynamic maps, PDF files, Excel files, and Images
- Dynamically send electronic mail
- Secure your application using a password-based framework
- Implement a simple ColdFusion application using best practices.
Course Outline 1: Introducing the Course
- Meeting the Prerequisites
- Understanding the Course Format
- Reviewing the Course Outline
2: Introducing ColdFusion
- Understanding Dynamic HTML generation
- Introducing the ColdFusion Language
- Introducing the ColdFusion Administrator
- Working with ColdFusion Data Sources
- Exercise 1: Configuring ColdFusion
3: Getting Started with ColdFusion Builder
- Understanding the Relationship between Eclipse and ColdFusion Builder
- Exploring the ColdFusion Builder Interface
- Creating a project and your first application
- Debugging Applications
- Accessing help in ColdFusion Builder
- Using Advanced Features
- Exercise 1: Creating a Project
4: Learning ColdFusion Fundamentals
- Creating ColdFusion Variables
- Exercise 1: Creating Local Variables
- Using variables from HTML forms
- Displaying variable values
- Exercise 2: Outputting variables to the screen
- Commenting Code
- Branching with IF statements
- Exercise 3: Using conditional logic
- Reusing code with <cfinclude>
- Exercise 4: Using <cfinclude> to include a page header
5: Publishing Database Content
- Connecting to a Database
- Querying a Database Table
- Viewing Debug Data
- Dumping a Recordset to a Browser
- Exercise 1: Creating a query and dumping the data
- Displaying Database Data
- Exercise 2: Displaying Database Data
- Using the Resultset Structure Data
- Introducing CurrentRow
- Using URL Data in Dynamic Queries
- Exercise 3: Building a dynamic query
- Creating Dynamic SQL for Multiple Search Criteria
- Query Parameters and Caching
- Exercise 4: Add query params and caching
6: Working with Complex Variable Types
- Using ColdFusion functions
- Exercise 1: Displaying the current date
- Looping over data
- Working with lists
- Exercise 2: Working with lists
- Working with Arrays
- Exercise 3: Displaying information using an array
- Working with structures
- Exercise 4: Using an array of structures
7: Introducing ColdFusion Components
- Reusing code
- Using Custom Tags
- Exercise 1: Using Custom Tags
- Creating User Defined Functions
- Exercise 2: Searching for content using a User Defined Funciton
- Introduction to components
- Exercise 3: Creating a Component
8: Introduction to Object Oriented ColdFusion
- Creating Instance Based Components
- Caching Instances in memory
- Exercise 1: Create a component
- Understanding Component Variables and Scopes
- Exercise 2: Creating a constructor with arguments
- Adding methods to a component
- Using property getters and setters
- Exercise 3: Adding methods and properties
9: Using the Application Framework
- Addressing the Web's Statelessness
- Using the Application Framework
- Configuring Application Settings
- Exercise 1: Configuring application settings
- Working with ColdFusion's scopes
- Handling Application Events
- Exercise 2: Handling Application Events
- Handling Request Events
- Exercise 3: Responding to Request Events
- Locking Shared Scope Variables
- Handling Session Events
- Using Session Events
- Using onServerStart() and applicationStop()
10: Tags
- Using <cfmap> to generate a Google Map
- Exercise 1: Adding a map
- Using <cfspreadsheet> to create an Excel spreadsheet
- Exercise 2: Creating a Spreadsheet
- Creating PDF files with <cfdocument>
- Exercise 3: Creating a PDF file
- Using <cfimage> to dynamically construct an image
- Exercise 4: Adding CAPTCHA to a form
- Using <cfmediaplayer> to play video
- Exercise 5: Adding video
- Working with <cfform>
- Exercise 6: Adding data validation to a form
- Working with the File System - <cffile> and <cfdirectory>
- Exercise 7: Adding images to an application
- Sending electronic mail with <cfmail>
- Exercise 8: Generating mail
- Using <cfprogressbar>
- Using <cfmessagebox>
Tuition: $995 per person
Register: November 15-17, 2010
Testimonials
"I took an SQL class with Mary some time ago. She was explaining 'joins'. When she finished, all the students had the 'deer in the headlights' look. We didn't have a clue of what joins were. More advanced concepts were coming after joins, so it wasn't looking good. Not to worry. Mary sent us on break and promised to have a better explanation by the time we returned.
We left the room with no hope of learning anything else that day. However, when we returned from break, Mary had a new approach for explaining joins, and we quickly got the concept.
This is just one example of Mary's willingness to go the extra mile in order to give students what they need. I find that Mary's teaching style works for me, and I will seek her out again and again when I have training needs."
- Toni Tates
Webmaster/Desktop Publisher
NIH AIDS Research & Reference Reagent Program
Germantown, MD
Other instructor-led online classes available:
HTML | CSS | Adobe Acrobat 9 Professional | Search Engine Optimization Essentials | PHP | Javascript | XML | XSLT | Using Social Media for Online Marketing