Click Here for the Outline in PDF Version Course Outline: Mastering Web Development using Cold Fusion (5 Days) with Hands On Labs Learning Objectives Learn to build web-based solutions quickly Learn to Code efficient SQL Queries within the ColdFusion Framework Learn to create Frames, Netsted Frames and Framesets Learn to create web pages that upload and download files and data This course description should be used to determine whether the course is appropriate for you based on your current skill and technical training needs. Technical information is provided on the intended audience, course prerequisites, and covered topics. Course content, prices, and availability are subject to change without notice. Course Audience This course is designed for people who would like to learn to build efficient web-based, data-driven applications quickly using Cold Fusion. Course Description ColdFusion is the award winning rapid application development system that integrates database, electronic mail, browser and web server technologies into web applications. In this comprehensive five day hands-on course, students will learn how to quickly create polished, professional web sites that interact with SQL-compatible databases such as Oracle and Microsoft Access. Students will learn to write and use SQL queries, create web pages from SQL query results, create email enabled applications, incorporate Java applets, and create applications which allow uploading and downloading of photos, resumes and Acrobat PDF files. Course Objectives At course completion the student will be able to perform the following tasks: Learn to build web-based solutions quickly Learn to Code efficient SQL Queries within the ColdFusion Framework Learn to create Frames, Netsted Frames and Framesets Learn to create web pages that upload and download files and data Prerequisites Basic knowledge of the Internet, HTML, and Active Server Page technology is highly recommended. TOPICS COVERED IN LECTURE & LAB Designing a ColdFusion Web Site Web design considerations Defining a web site structure Controlling layout and appearance Using style sheets Creating Web Pages from SQL Queries Connecting to a database Querying the database Formatting and displaying query results Hyperlinks and Dynamic URL Parameters URL parameter overview Passing URL parameters URL parameters in dynamic queries Controlling Program Flow Conditional logic Looping Conditional transfer to another page Designing and Using HTML Forms HTML forms and form controls HTML update, insert and query forms Filling Select lists from SQL queries Writing SQL Queries Dynamically SQL query basics Dynamic queries Writing SQL queries with ColdFusion Using Persistent Variables Stateless systems and persistent variables ColdFusion Application Framework Improving performance with persistent queries Updating and Inserting SQL Data ColdFusion CFUPDATE and CFINSERT tags SQL UPDATE and INSERT queries Client-side input validation with Javascript Writing server-side validation scripts Confirming the transaction Using Frames Effectively with ColdFusion Creating Framesets and Frames Hyperlinks and Frames Communicating between frames with persistent variables Nested Frames Using Trees, Grids and Arrays Tree controls Displaying data in grids Using grids to update record sets ColdFusion arrays Sending and Receiving E-Mail E-mail overview E-mail message components Sending E-mail from ColdFusion Responding to E-mail automatically Uploading and Downloading Files Protocols and MIME Types Displaying non-HTML files with CFCONTENT Creating web pages to upload files Copying, renaming, and deleting files with CFFILE

Policy