MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

ColdFusion MX Essential Training

Course Summary

  Reviews skills such as working with databases, using forms, storing persistent data, and creating dynamic charts.   


  • +

    Course Syllabus

     Introduction

    welcome
    1. Introducing ColdFusion
    understanding ColdFusion
    installing
    using the ColdFusion administrator
    setting up the web server
    selecting an editor
    2. Learning CFML Basics
    working with variables
    using numbers
    setting variables
    using strings
    viewing variable values
    retrieving query string variables
    retrieving form variables
    building a storyteller application
    adding conditional logic
    checking if variables are defined
    self posting form
    amending the storyteller application part 2
    dynamically including templates
    amending the storyteller application part 3
    ColdFusion parameters
    defining default values
    understanding default values in context
    using CFPARAM
    using default values with text inputs
    amending the storyteller application part 4
    3. Managing Code
    adding code comments
    debugging code
    4. Working with Databases
    understanding databases
    designing databases
    selecting database management system
    creating a database
    registering a ColdFusion datasource
    configuring the database
    5. Using SQL
    understanding SQL
    using SELECT statements
    selecting fields
    adding WHERE clauses
    selecting data from more than one table
    outputting query data
    building a user list application
    viewing details
    building user list details
    adding ORDER BY clauses
    ordering the user list
    making pageable record sets
    making the userlist pageable
    ordering the user list
    adding a records per page feature
    cleaning up the user list
    cleaning up the user list part 2
    matching partial values
    matching partial values note
    searching the user list
    selecting multiple list items
    using IN
    filtering the user list
    caching queries
    caching the user list query
    inserting records
    registering users
    registering users part 2
    registering users part 3
    pre-filling a form
    registering users part 4
    registering users part 5
    validating form input
    registering users part 6
    updating records
    redirecting pages
    looping through queries
    editing user information
    editing user information part 2
    editing user information part 3
    deleting records
    delete confirmation screen
    deleting users
    6. Managing Applications
    adding an application framework
    specifying a datasource variable
    adding login functionality
    adding login functionality part 2
    building a login application
    building a login application part 2
    getting the user information
    adding conditional logic based on user
    logging out
    checking for roles
    making the administrator role
    hiding the register option for users that are logged in
    adding administrator subnavigation
    adding a user update form
    7. Dates and Times
    creating a dates and times
    formatting dates and times
    parsing dates and times
    introducing CFLOOP
    creating a calendar
    creating a calendar part 2
    inserting dates and times into a database
    adding events to the calendar application
    adding events to the calendar application part 2
    using BETWEEN in SQL
    listing events in the calendar application
    adding an event details page
    adding an event update form
    adding an event update form part 2
    adding an event delete option
    8. Storing Client-side Data
    using CFCOOKIE
    building a color panel feature
    building a color panel feature part 2
    building a color panel feature part 3
    building a color panel feature part 4
    understanding MOD
    building a color panel feature part 5
    adding automatic apply JavaScript
    9. Ordered Data
    introducing arrays
    looping through arrays
    sorting arrays
    using lists
    filtering user list data
    working with structures
    using array access notation with structures
    looping through structures
    creating arrays of structures
    enabling sessions
    adding session variables
    building a store application
    adding a store product list
    building an add to cart feature
    listing the cart items
    managing duplicate items
    deleting items
    updating items
    checking out
    listing the order
    deleting the order
    10. Advanced SQL and Charting
    using SQL function
    working with GROUP BY
    using additional SQL functions
    charting data
    adding a user report chart
    applying chart styles
    11. Email
    using CFMAIL
    adding a password retrieval feature
    12. Working with Files
    using the ExpandPath() function
    using file fields
    uploading files
    adding an update image feature
    adding an update image feature part 2
    writing new files
    emailing charts
    writing charts to files
    emailing attachments
    emailing charts as attachments
    Conclusion
    goodbye
     


Course Fee:
USD 25

Course Type:

Self-Study

Course Status:

Active

Workload:

16 - 17 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top