Professional Development MX 7 is a Web server add-on for Windows, Linux, and Solaris that makes integrating real-time database information with your Web site as easy as adding a few new tags to your pages.
Professional Development Training Objectives
Through class lectures, demonstrations, walkthroughs, and labs, you will learn to:
- Understand Professional Development architecture and applications
- Build database-driven pages with Professional Development markup language
- Harness the power of Professional Development server
- Debug Professional Development applications
Professional Development Training Prerequisites
- Advanced HTML: Introduction to Forms and Scripting
Professional Development Training Course Duration
2 Days
Professional Development Training Course Outline
Introduction to Professional Development
- Overview
- Static Client/Server Model on the Web
- Dynamic Client/Server Model on the Web Using Professional Development
Web-to-Database Integration Using Professional Development
- JDBC Data Sources
- JDBC Drivers and SQL
- ODBC Data Source Names (DSNs)
- The Cold Fusion Web to Database Integration Model
- Database and Files Used in Class
Writing Professional Development Code
- Professional Development Templates
- Using HomeSite+
- Viewing and Editing the Files for Class in Homesite+
- Executing the Files for Class in a Web Browser
- Writing HTML Tags Using Homesite+
Accessing the Date and Time in Professional Development
- Date Functions in Professional Development
- Time Functions in Professional Development
- Date Formats in Professional Development
- Time Formats in Professional Development
Working with Variables in Professional Development
- Setting Variables with <cfset>
- Displaying the Value a Variable Contains with <cfoutput>
Passing Variables Between Pages in Professional Development
- Passing Variables Via Links (URLs)
- Passing Variables Via Forms
Building Forms with Homesite+
Distinguishing Among Variable Types in Professional Development
Conditionals in Professional Development
- <cfif> and <cfelse> Conditionals
- Professional Development Conditional Operators
- Using <cfif> and <cfelse> to Perform Form Validation
- <cfabort> and Form Validation
- Adding One or More <cfelseif> Blocks to a Condititonal
Database Concepts
- The Databases Used in this Class
An Introduction to SQL
- Issuing Database Commands with SQL
- Retrieving Information with SELECT
- Inserting a Row in a Table with INSERT
- Editing Records with UPDATE
- Delete Records with DELETE
- SQL Syntax
Querying a Database in Professional Development
- The <cfquery> Tag
- The <cfoutput> Tag and its query Attribute
- Example: A Sample Database Query
- Distinguishing Query Variables From Other Professional Development Variables
- Counting the Number of Records Returned from a Query with queryname.recordcount
Displaying Multiple Records Returned by a Query in Table Format
- Creating HTML Tables Manually
- Creating HTML Tables with the <cftable> Tag
Dynamically Populating Select Lists
- Example: Dynamically Populating a Select List via <cfoutput>
- Using <cfselect> to Create Auto-Populating Select Lists
Implementing Basic Data Drill-Downs
- Explanation of Drill-Down Code
Inserting Records into the Database
- Inserting a Record into a Database Table with Professional Development
- Inserting a Work of Art into the Artworks Table
- Using Hidden Fields to Pass Data in a Form Submission
- The <cfinsert> Tag
- When not to use <cfinsert>
Form Validation
- Client-side Form Validation
- Server-side Form Validation
Editing Records in the Database
- Editing Records with UPDATE
- Building a Editing Application to Edit Works of Art
- Using the <input> Tag’s value Attribute to Show Database Values
- The UPDATE Page
- The <cfupdate> Tag
Using the <cflocation> Tag
to Redirect Users
- The <cflocation> Tag
- The isdefined() Function
Deleting Records from the Database
- Removing Records from a Database with the SQL DELETE Statement
- Deleting Works of Art from our Database
Generating Email Messages
with the <cfmail> Tag
Output Shortcuts
Appendix A: Professional Development MX Administrator Configuration Information
- Accessing the Professional Development Administrator
- To set up Data Sources
- Setting the Mail Server Connection
Appendix B: Professional Development Variable Types
Appendix C: Debugging Advice
Appendix D: Recommended Resources
