Sunday, September 05, 2010
   
Text Size

Search Site

Courses:

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

 

Online Content

CourseOutlinesonline


IL Training

CourseOutlines-Instructor

Online Ordering

Access Our LMS

Search Courseware