- 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
77-903 ColdFusion Creating Database-driven Web Sites Level 3
click here to download the course outline
ColdFusion: Creating Database-driven Web Sites,
Level 3
Course specifications
Course number: 077-903
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.
•
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 who wants to learn Web application
development with ColdFusion. 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 and Level 2. Many vital
concepts are omitted from this book because they were covered in Level 1 and Level 2 of this course series. Any 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
•
ColdFusion: Creating Database-driven Web Sites, Level 2
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 utilize cookies, global variables, and
other variable types. Students will create a login application and enhance an existing application with a
variety of coding solutions.
Target student: Students enrolling in this course should understand HTML, SQL fundamentals, database
fundamentals, and should first take Levels 1 and 2 in this course series.
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 3
Performance-based objectives
Lesson objectives help students become comfortable with the course, and also provide a means to
evaluate learning. Upon successful completion of this course, students will be able to:
•
Understand and implement the ColdFusion application framework.
•
Set and access global variables.
•
Create a login page that authenticates users and handles common errors.
•
Manage clients with cookies.
•
Collect user preferences to display customized content.
•
Create a previous/next search application and cached queries.
•
Create conditional statements with CFSWITCH
Course content
Lesson 1: The ColdFusion Application Framework
Designing with the application framework
Exploring the Application.cfm template
Exploring Persistent variables
Setting and Referencing Global variables
The CFAPPLICATION tag
Lesson 2: Creating a Login Application
Establishing Basic Security
Using Cookies
Inserting New Users
Lesson 3: Displaying Personalized Content
Gathering User Preferences
Creating Cookies Dynamically
Logging in users Automatically
Lesson 4: Creating Previous/Next Record Sets
Browsing Previous/Next Record Sets
Creating the Application Logic
Determining the Number of Remaining Records
Creating the Next Link
Creating the Previous Link
Lesson 5: Design and Performance Considerations
Caching Query Data
Preventing User Error
Exploring CGI variables
Lesson 6: Conditional Processing with CFSWITCH
Displaying the Average Rating of Each Title
CFCASE and CFDEFAULTCASE
Learning More about ColdFusion Development
Appendix A: Configuration Whitepaper
Appendix B: Installation Whitepaper
Online Content
IL Training
Online Ordering
Access Our LMS
