|
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
Topics:
- 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
|
