This course is provided by Wintrac.
Wintrac
provides one stop shopping for all your IT training needs. Wintrac’s course catalog
of over two thousand courses includes courses on
ColdFusion training
Professional Development Training Overview
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
