Antall Training

[ ColdFusion Training, Dreamweaver Training, Flash Training, XML Training, JavaScript Training, Ajax Training ]

 
 
 

 
  coldfusion training

Introduction to Macromedia ColdFusion MX Training

ColdFusion MX is the wildly popular server-side language that allows non-programmers to quickly produce data-driven websites. Since the content is stored in a database, the pages are created dynamically. In addition to learning basic ColdFusion techniques, you will learn basic database concepts using Microsoft Access, including how to create Data Source Names (DSN), SQL statements and relational database basics.

Also see our live eLearning ColdFusion Training...

We also offer instructor-led online training courses on many topics including Adobe ColdFusion. Learn more or sign up for a Free Demo today. See entire eLearning course schedule.

We will use real-life examples to show you how to query the database using the <cfquery> tag and display your resulting records using <cfoutput>, <cftable>, <cfselect> and more. Additionally, we will create an administration section that will allow you and your staff to add, edit or delete records in the database.

No previous database or programming experience is required. Knowledge of HTML is all you will need! In class we will write our code from scratch using Dreamweaver MX, ColdFusio Studio or HomeSite +, and we will explore additional code writing options including ColdFusion Studio, HomeSite+, BBedit and Notepad. (If you are interested in using Dreamweaver's WYSIWYG functions to build dynamic pages, see the class entitled "Using Dreamweaver MX to Build Data-Driven Websites.")

Course Outline

  • Introduction to ColdFusion
    • Writing ColdFusion Templates
    • Software Interface
    • Dreamweaver MX / ColdFusion Studio / HomeSite +
    • EXERCISE: Build a basic HTML page and test it on the server
  • Variables and Built-in Functions
    • cfset and cfoutput
    • Variable Scope and Prefixes
    • Date / Time Functions
    • EXERCISE: Build Dynamic Page Footer that includes Date and Time
  • Passing Variables Between Pages
    • "Two-page method"
    • HTML Form Review
    • Pass Variables with Links
    • Building Forms with Dreamweaver MX
    • Building Forms with ColdFusion Studio
    • EXERCISE: Passing Variables
  • Conditional Statements
    • cfif, cfelseif and cfelse
    • EXERCISE: Basic Form Validation with Conditional Statements
  • Database Basics
    • Introduction to SQL
    • Select Statement
    • Update Statement
    • Delete Statement
    • Use cfquery to query the database
    • Quick output with cfdump
    • EXERCISE: Query the Database with cfquery
  • Display Resulting Records
    • Use cfoutput to customize data display
    • EXERCISE: Display query results
  • Build Dynamic Tables
    • Use cfoutput to build table rows
    • Shortcut: cftable
    • EXERCISE: Display results in a dynamically built table
  • Build Dynamic Select Lists
    • Use cfoutput to build option tags
    • Shortcut: cfselect
    • EXERCISE: Display results in a dynamically built select list
  • Data drill downs
    • Receive a variable and query on it
    • Dynamically build the WHERE clause in SQL Statement
    • EXERCISE: Pass Primary Key to a Query
  • Insert Into the Database
    • Create Form
    • SQL Insert Statement
    • Shortcut: cfinsert
    • EXERCISE: Insert New Record
  • Form Validation
    • Automatic Client-side Form Validation
    • EXERCISE: Use the automatic Client-side Form Validation
    • Automatic Server-side Form Validation
    • EXERCISE: Use the automatic Server-side Form Validation
  • Update Database Records
    • Create Form
    • SQL Update Statement
    • Shortcut: cfupdate
    • EXERCISE: Update Record
  • cflocation
    • Redirect the user with cflocation
    • EXERCISE: Redirecting users
  • Sending Automatic Email
    • cfmail
    • EXERCISE: Use ColdFusion to send an email
  • Delete Records
    • Create Form
    • SQL Delete Statement
    • EXERCISE: Delete Record

See also:

Adobe ColdFusion 8 Training Courses

 

 

Cleveland, Ohio
Columbus, Ohio
Cincinnati, Ohio
Youngstown, Ohio
Toledo, Ohio
Akron, Ohio
Canton, Ohio

Detroit, Michigan
Ann Arbor, Michigan
Grand Rapids, Michigan
Lansing, Michigan

Pittsburgh, Pennsylvania
Johnstown, Pennsylvania
Altoona, Pennsylvania
Erie, Pennsylvania
Harrisburg, Pennsylvania
Philadelphia, Pennsylvania

Phoenix, Arizona
Los Angeles, California
San Diego, California
San Francisco, California
Sacramento, California
San Jose, California
Oakland, California
Denver, Colorado
Hartford, Conneticut
Washington, DC
Orlando, Florida
Jacksonville, Florida
Cape Canaveral, Florida
Tallahassee, Florida
Miami, Florida
Fort Lauderdale, Florida
Chicago, Illinois
Indianapolis, Indiana
Boston, Massachusets
Concord, Massachusets
Baltimore, Maryland
Bethesda, Maryland
St Louis, Missouri
Newark, New Jersey
Princeton, New Jersey
Trenton, New Jersey
New York, New York
Syracuse, New York
Ithaca, New York
Buffalo, New York
Raleigh, North Carolina
Greensboro, North Carolina
Houston, Texas
San Antonia, Texas
Dallas, Texas
Arlington, Virginia
Richmond, Virginia
Seattle, Washington
Milwaukee, Wisconsin
Madison, Wisconsin
Toronto, Ontario
Winsdor, Ontario
Montreal, Quebec

Worldwide

 


© 2002-2010 Antall Training - http://www.scottantall.com/
Cleveland, Ohio | Pittsburgh, Pennsylvania | Detroit, Michigan

Phone:440/623-3738

Fax: 440/236-3346