ColdFusion MX: Talking With the Database
Product Code: CFUS02 Time: 3 Hour(s) CEUs: .30

Summary:

This course introduces the two basic ColdFusion tags used to query a database and display results. The user learns to use CFQUERY to perform queries and CFOUTPUT to display the results on a Web page. The user also learns to use standard SQL to perform basic database operations.

Objectives:

After completing this course, students will be able to:
  • Establish a connection between a Web server and database
  • Write SQL statements to select, insert, update, and delete information
  • Use CFQUERY tags to send and receive database information
  • Use CFOUTPUT tags to display database information
  • Use advanced ColdFusion functions to create new queries and query the results of previous queries

Outline:

  • Making database connections
  • Defining and organizing tables
  • Introduction to SQL
  • Adding and deleting data
  • Using SQL joins
  • Grouping and aggregating results
  • Getting data to and from your database
  • Constructing queries
  • Outputting your data
  • Grouping the data
  • Getting the most from your queries
  • Manipulating data
  • Queries without a database
  • Queries of queries

Features:

  • Exercises that allow users to practice the application
  • A file containing the text of the exercises
  • Activities that allow users to apply course concepts in an interactive questioning environment
  • A glossary
  • A Skill Assessment

Applicability:

This course is for anyone who is interested in learning more about designing Web and database applications with ColdFusion MX.

Prerequisites:

ColdFusion MX: Introduction and Installation

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

  • Macromedia is a registered trademark of Macromedia, Inc. in the United States and/or other countries.
  • Coldfusion is a registered trademark of Macromedia, Inc. in the United States and/or other countries.
  • Flash™ is a trademark of Macromedia, Inc.
  • Microsoft® is a registered trademark of Microsoft Corporation.
  • Windows® is a registered trademark of Microsoft Corporation.
  • Internet Explorer® is a registered trademark of Microsoft Corporation.
  • Java and JSP are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States and other countries.
  • Netscape Navigator is a trademark of Netscape Communications Corporation.

Terms of Use:

None

Copyright © 2004 eLearningDepot.com. All rights reserved.