- 85-985: Introduction to Project Portfolio Management (Second Edition)
- 85-081: PMI Scheduling Professional (PMI–SP)® Certification
- 85-080: Project Managing Outsourced Resources
- 85-073: PMI Risk Management Professional (PMI–RMP®) Certification
- 85-061: Certified Associate in Project Management (CAPM®) Certification: Fourth Edition
- 85-037: Managing Outsourced Projects as an IT Vendor
- 85-026: Introduction to Agile Project Management
- 85-014: Project Management Skills for Technical Teams
- 85-995: Fundamentals of Databases Using Oracle
- 85-956: Introduction to Programming Using Java
- 85-170: Adobe® ColdFusion® 8 – Level 2
- 85-169: Adobe® ColdFusion® 8 – Level 1
- 85-091: Certified Software Tester (CSTE)
- 85-082: Developing XML–Based Web Applications
- 85-078: Certified Software Quality Engineer (CSQE)
- 85-072: SQL – Advanced Querying (Fourth Edition)
- 85-071: SQL–Fundamentals of Querying (Fourth Edition)
- 85-067: Software Programming – Best Practices
- 85-053: Introduction to Software Life Cycle Models
- 84-755: Adobe® RoboHelp® 8 – Level 1
- 85-983: Security Awareness (Third Edition)
- 85-979: Introduction to Network Design and Management
- 85-954: Certified Information Systems Security Professional (CISSP)®: Second Edition
- 85-063: Certified Information Security Manager (CISM®) Certification
- 85-057: Firewall – A Network Security Me
- 84-705: Introduction to Personal Computers Using Windows® 7
- 84-689: Mac OS® X v10.6 – Introduction
- 84-628: Microsoft® Office Project 2007 – Web Access
- 84-602: Microsoft® Project 2010 – Level 1
- 84-595FL: Microsoft ® Office Outlook ® 2010 – Level 1 (First Look)
- 84-595: Microsoft® Office Outlook™ 2010 – Level 1
- 84-594FL: Microsoft® Office Outlook® 2010 – Transition from Outlook® 2003 (First Look)
- 84-592FL: Microsoft® Office PowerPoint® 2010 – Level 1 (First Look)
- 84-591FL: Microsoft® Office PowerPoint® 2010 – Transition from PowerPoint® 2003 (First Look)
- 84-587FL: Microsoft® Office Access® 2010 – Level 1 (First Look)
- 84-586FL: Microsoft® Office Access® 2010 – Transition from Access® 2003 (First Look)
- 84-583: Microsoft® Office Word 2010 – Level 2
- 84-582FL: Microsoft® Office Word 2010 – Level 1 (First Look)
- 84-581FL: Microsoft® Office Word 2010: Transition from Word 2003 (First Look)
- 84-577: Microsoft® Office Excel® 2010 – Level 2
- 84-576FL: Microsoft® Office Excel® 2010 – Level 1 (First Look)
- 84-575FL: Microsoft® Office Excel® 2010: Transition from Excel 2003 (First Look)
- 84-574FL: Microsoft® Office 2010 – Transition from Office 2003 (First Look)
- 85-070: Motivating IT Teams
- 85-069: Effective Contract Negotiation for IT Managers
- 85-059: IT Infrastructure Library (ITIL®) Foundation Certification v3.0
- 85-035: Fundamentals of Finance for IT Managers
- 85-033: Strategic IT Planning Skills (Includes Simulation)
- 85-013: Effectively Managing Technical Teams
- 84-748: QuickBooks® 2010 for Windows – Advanced
- 84-747: QuickBooks® 2010 for Windows – Introduction
- 84-697: Microsoft® SharePoint® Foundation 2010–Level 2
- 84-696: Microsoft® Windows® SharePoint® Foundation 2010 –
- 84-314: Google™ AdWords for Businesses
- 84-688: Adobe® After Effects® CS4
- 84-502: Adobe® Dreamweaver® CS5 – Level 1 (First Look)
- 84-397: Adobe® InDesign® CS5 – Level 1
- 84-396: Adobe® Illustrator® CS5 – Level 2
- 84-395FL: Adobe® Illustrator® CS5 – Level 1 (First Look)
- 84-389FL: Adobe® Flash® CS5 – Level 1 (First Look)
- 84-385: Adobe® Photoshop® CS5 – Level 2
- 84-384FL: Adobe® Photoshop® CS5 – Level 1 (First Look)
- 84-379: Adobe® CS5 – New Features
- 84-249: Adobe® Fireworks® CS4 (Macintosh)
- 84-248: Adobe® Photoshop® CS4 – Photo Printing & Color
- 85-048: Advanced Wireless Communications
- 85-047: Fundamentals of Multiprotocol Label Switching (MPLS)
- 85-031: Fundamentals of Switching Technologies
- 85-024: Fundamentals of Voice Over IP
- 85-056: Certified Information Systems Auditor (CISA®) Certification
- 84-236: Adobe® InDesign® CS4 – Level 2 (Macintosh)
- 84-214: Adobe® Illustrator® CS4 – Level 2 (Macintosh)
- 84-213: Adobe® Flash® CS4 – Level 2 (Macintosh)
- 84-094: Adobe® Dreamweaver® CS4 – Level 2 (Macintosh)
- 84-091: Adobe® Flash® CS4 – Level 1 (Macintosh)
- 84-085: Adobe® Photoshop® CS4 – Level 2 (Macintosh)
- 84-083: Adobe® InDesign® CS4 – Level 1 (Macintosh)
- 84-071: Making Google™ Work for You
- 84-069: Create Legal Forms Using Microsoft® Word 2007
- 84-066: Adobe® Dreamweaver® CS4 – Level 1 (Macintosh)
- 84-065: Adobe® Illustrator® CS4 – Level 1 (Macintosh)
- 84-064: Adobe® Photoshop® CS4–Level 1 (Macintosh)
- 84-031: Adobe® Photoshop® Elements 6.0
- 84-016: Adobe® RoboHelp® 7 – Level 2
- 84-000: Adobe® RoboHelp® 7 – Level 1
- 58-719 Integrating Your Business Solutions With Microsoft� Office Professional Edition 2003
- 77-972 JavaScript-Advanced Programming Second Edition
- 77-971 JavaScript-Programming Second Edition
- 77-961 NetObjects Fusion 5 Advanced
- 77-960 NetObjects Fusion 5 Introduction
- 77-956 Rational Rose Introduction
- 77-955 Java 2 Advanced Programming
- 77-954 Java 2-Programming Language for Developers
- 77-953 XML-Schema Design Second Edition
- 77-952 XML-DTD Design Second Edition
- 77-951 DHTML Cross-browser Techniques Second Edition
- 77-950 ZENworks 2 Workstation Management
- 77-948 XML An Introduction Second Edition
- 77-944 XML-Document Object Model DOM 1
- 77-942 XML Schema Design
902 ColdFusion Creating Database-driven Web Sites Level 2
click here to download the course outline
ColdFusion: Creating Database-driven Web Sites,
Level 2
Course specifications
Course number: 077-902
Software version number: 4.0 or later
Course length: 1 day
Hardware/software required to run this course
•
At least 32 MB RAM (64 MB is recommended).
•
At least 200 MB of free disk space, depending on what software you may already have to run
this course.
•
A 486 or faster processor (Pentium or faster is strongly recommended).
•
An 800 x 600 or higher resolution monitor set to a minimum of 256 colors. If your monitor
doesn't support 256 colors, graphics will not be displayed as intended. For best image quality, we recommend setting monitors to High Color (16-Bit) at a high resolution, such as 1280 x 1024.
•
Windows 95, 98, or NT installed according to the software documentation.
•
Microsoft Internet Explorer 5.0 or later. If another browser is used, such as Netscape
Navigator 4.x, styles will not be displayed as intended.
•
Allaire HomeSite 4.0 (You can run this course with any text editor, but HomeSite provides
several benefits when coding CFML).
•
Microsoft Access 97 or later.
•
Microsoft Personal Web Server.
•
ColdFusion Express 4.0.
Course description
Overview: This course is designed for the non-programmer. Individuals with programming or scripting
experience probably will not need to cover some of the information in this book to get started with
ColdFusion development. Students taking this course should be experienced with HTML, Internet
concepts, SQL fundamentals, and database fundamentals. This course introduces students to the syntax,
functions, tags, and possible development solutions they're likely to encounter as they begin to develop
ColdFusion applications.
Prerequisites: This course is designed for the experienced computer user who has an understanding of
Internet functionality and fairly extensive experience with HTML. The target student should also
understand database and SQL basics. We strongly recommend that all students considering this course
should first take
ColdFusion: Creating Database-driven Web Sites, Level 1. Many vital concepts are
omitted from this book because they were covered in Level 1 of this course series. A student who is not experienced with HTML, SQL basics, database fundamentals, and ColdFusion fundamentals, should take the following Element K courses before proceeding with this course:
•
HTML 4.0 Level 1
•
HTML 4.0 Level 2
•
SQL Fundamentals
•
Introduction to MS Access 97
•
ColdFusion: Creating Database-driven Web Sites, Level 1
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured handson activities. Benefits: Students will learn how to create dynamic Web sites that interact with databases and user input. What's next: ColdFusion: Creating Database-driven Web Sites, Level 2 is the second course in this series. Students who want to continue to after this course can take ColdFusion: Creating Databasedriven Web Sites, Level 3. IMPORTANT Students, training centers, etc do not need to purchase the full, enterprise or professional edition of ColdFusion to use this book. We’ve developed the course using HomeSite, Microsoft’s Personal Web Server, and ColdFusion Express, a freely available version of ColdFusion. Each of these applications can be found for free on the Web, although it’s suggested that anyone using this book purchase HomeSite from Allaire. This setup was chosen because it opens up the course to anyone who wants to learn ColdFusion, regardless of their ability to purchase the $3000 version ColdFusion. ColdFusion: Creating Database-driven Web Sites, Level 2 Performance-based objectives Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. The concepts and tasks in this book are designed to provide the student with the skills necessary to create a variety of applications, in addition to the specific applications they'll create. Upon successful completion of this course, students will be able to: • Create dynamic tables to output query results, apply date functions to create a date stamp, and
implement a drill-down application. • Create an application that updates existing database records and records the date and time of
modifications. • Create an application that inserts new records and another that deletes existing records. • Enable form field validation with a variety of methods, and re-populate a form with submitted
data. • Create a keyword search application that can handle a variety of user criteria. Course content Lesson 1: Design considerations Choosing the Right Formatting Creating dynamic tables Exploring CFTABLE Creating a Date Stamp ColdFusion functions The Now( ) function The DateFormat( ) function Applying masks Creating drill-down applications Passing URL parameters Passing multiple parameters Outputting images dynamically Storing image filenames Managing "data gaps" with conditional expressions The Trim( ) function The Len( ) function Lesson 2: Updating records Creating database front-ends Populating form controls with existing data Populating text fields Populating a textarea field Using hidden form fields to pass variables Updating records with CFUPDATE Recording the date and time of an update Capturing and storing date values Updating data not passed from a form The TimeFormat( ) function Performing SQL updates Lesson 3: Inserting and deleting records Inserting records with <CFINSERT> Inserting data into multiple tables Inserting data conditionally Using the "AutoNumber" data type to create ID values The CreateODBCDateTime( ) function Using the SQL INSERT INTO statement Deleting records Confirming a deletion request with JavaScript Lesson 4: Validating data entry fields Exploring client-side vs. server-side validation <CFFORM> and <CFINPUT> Embedding form validation rules Applying multiple rules A more customized approach to form field validation Using conditional expressions to test for valid data Applying <CFABORT> Initializing variables with <CFPARAM> Re-using a variable Testing for multiple conditions Comparison operators The IsNumeric( ) function The IsDate( ) function Redirecting a user with <CFLOCATION> Passing parameters via <CFLOCATION> The IsDefined( ) function The URLEncodedFormat( ) function Re-populating form after submission Re-using forms Nesting CFOUTPUT blocks Passing multiple parameters via CFLOCATION Alternative methods for re-populating forms Lesson 5: Creating a keyword search application Database search applications Exploring the Verity Search engine Looping with <CFLOOP> Index loops ColdFusion list functions The ListGetAt( ) function The ListLen( ) function Creating dynamic SQL statements Testing applications; enabling ColdFusion debugging Appendix A: ColdFusion Configuration Whitepaper Introduction ColdFusion Express and PWS High-volume sites Appendix B: Installation Whitepaper Introduction Web server installation Additional information: ColdFusion Express ColdFusion Express doesn't support all of the tags available with the full versions of ColdFusion server, the Professional and Enterprise editions. The most fundamental tags are supported, but as you continue to learn ColdFusion development, you should consult the CFML documentation that comes with all ColdFusion products. This documentation will provide you with more information on all the ColdFusion tags at your disposal. You can access this documentation via ColdFusion Administrator. Also, there are over 200 functions available in ColdFusion 4.0. Of course, we can't cover them all - this course presents certain ColdFusion functions that are best suited for the given task. Your own development efforts are likely to require the use of other ColdFusion functions. ColdFusion 4.0 Express is a freely available, pared-down version of ColdFusion. Because of its availability to anyone interested in learning ColdFusion, and the fact that it supports many of the most fundamental ColdFusion tags, this course was developed with ColdFusion 4.0 Express. Anything developed for ColdFusion Express will work fine on the full versions of ColdFusion Server.
Online Content
IL Training
Online Ordering
Access Our LMS
