- 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-900 ColdFusion Creating Database-driven Web Sites Level 1
click here to download the course outline
ColdFusion : Creating Database-driven Web Sites
Level 1
Course Specifications
Course number: 077900
Course length: 1 day
Software: ColdFusion 4.0
Course Description
Students will learn the benefits of using Cold Fusion to create dynamic, data driven Web sites.
Target Student: Students enrolling in this course should have an intermediate knowledge of HTML,
databases and SQL.
Prerequisites: Proficiency with HTML, some familiarity with databases and SQL.
Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits: Students will learn how to create dynamic, database-driven Web sites.
What's Next: ColdFusion: Creating Database-driven Web Sites Level 1 is the first course in this series.
ColdFusion: Creating Database-driven Web Sites Level 2, the next course in this series, teaches students
how to create Web applications that can add, delete, and edit database information, as well as create
drill-down applications and searching tools.
IMPORTANT
Students, training centers, etc. do not need to purchase the full, enterprise or professional edition of
ColdFusion to take this course. This course was developed with HomeSite 4.0, 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 full version ColdFusion 4.0.
Hardware/Software Requirements
•
Pentium-based PC
•
32 MB RAM (64 recommended)
•
Windows 95,98, or NT
•
Additional 200 MB hard drive space for software
•
Microsoft’s Personal Web Server software
•
Allaire Cold Fusion Express
•
Allaire Homesite 4.0
•
Microsoft Access 97
•
Internet Explorer 5.0
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:
•
Use HomeSite to create and edit ColdFusion applications.
•
Design and create a relational database
•
Link a database to the ColdFusion Server using the ColdFusion Administrator.
•
Create simple ColdFusion application using CFML.
•
Create and include ColdFusion templates.
•
Create CFQUERY blocks and SQL statements that query a database.
•
Debug ColdFusion applications.
•
Create a ColdFusion application that queries a database based on user input.
•
Dynamically populate form fields.
•
Use conditional logic to manipulate application flow.
Course Content
Lesson 1: Introduction to Cold Fusion
Topic 1A: Overview of ColdFusion
Topic 1B: Exploring HomeSite 4.0
Topic 1C: Observing ColdFusion in Action
Lesson 2: Creating a database for use with ColdFusion
Topic 2A: Planning Your Database
Topic 2B: Creating Tables
Topic 2C: Relationships Between Fields
Lesson 3: Connecting a database to the ColdFusion server
Topic 3A: ColdFusion Database Administration
Lesson 4: Getting Started with CFML
Topic 4A: CFML and HTML
Topic 4B: Creating and Reusing Templates
Lesson 5: Querying a Database and Displaying the Results
Topic 5A: Creating Simple Queries
Topic 5B: ColdFusion Debugging Tools
Lesson 6: Creating User-Defined Queries with Forms
Topic 6A: ColdFusion and Forms
Topic 6B: Creating a Form Action Page
Topic 6C: Dynamically Populating Form Fields
Lesson 7: Conditional Expressions
Topic 7A: Conditional Logic
Additional Info
White Papers: A. ColdFusion Configuration Whitepaper B. Installation Whitepaper