ASP.NET, VB.NET, and C# Training Classes     
Accelebrate delivers SharePoint , ASP.NET, SQL Server, Java, and other training courses in the USAAccelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Canada     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the UK     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Ireland     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the Netherlands     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses internationally  
1 877 849 1850   0808 234 2132   1 800 550 311   0 800 022 6730   +1 678 648 3113  
Microsoft and .NET TrainingSQL Server TrainingSharePoint TrainingJava TrainingAdobe TrainingDatabase and Reporting TrainingXML, JavaScript, and Other TrainingWeb/Application Server Training
HomeAboutContact Us 


Please contact us
for GSA pricing.

GSA - Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses
Contract #
GS-35F-0307T



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Edmonton & Calgary, Alberta
  • Phoenix, Arizona
  • Tucson, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Amsterdam, The Netherlands / Brussels, Belgium
  • Vancouver, British Columbia
  • Oakland / San Jose / San Francisco, California
  • Sacramento, California
  • San Diego, California
  • Orange County / Los Angeles, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida 
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Boise, Idaho
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Wichita, Kansas
  • Lexington / Louisville, Kentucky
  • Baton Rouge/New Orleans, Louisiana
  • Portland, Maine
  • Hagerstown & Frederick, Maryland
  • Annapolis / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Ann Arbor / Detroit, Michigan
  • Grand Rapids, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • St. Louis, Missouri
  • Kansas City, Missouri
  • Lincoln / Omaha, Nebraska
  • Reno and Las Vegas, Nevada
  • Fredericton / Moncton / Saint John, New Brunswick
  • Albuquerque, New Mexico
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • Albany, New York
  • Buffalo, New York
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Canton / Akron, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Dayton, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • San Juan, Puerto Rico
  • Providence, Rhode Island
  • Saskatoon / Regina, Saskatchewan
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Spartanburg & Greenville, South Carolina
  • Knoxville, Tennessee
  • Memphis / Nashville, Tennessee
  • Houston, Texas
  • El Paso, Texas
  • San Antonio / Austin, Texas
  • Dallas, Texas
  • Salt Lake City, Utah
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Charleston, West Virginia
  • Madison / Milwaukee, Wisconsin

Building Database- and LMS-Driven Authorware Applications Training

Print This Outline
E-mail This Outline
Get A Quote
Course Number: AUTH-200
Duration: 3 days
view class outline

Authorware Training Overview

Most organizations store their learners' information and much of their course content in Learning Management Systems (LMS) and other databases. In this course, attendees learn a variety of techniques for integrating LMS systems and databases with their Authorware applications.

Important Notes

  • We would be delighted to customize this Authorware® training class to the specific database or LMS systems your organization is using.
  • Only Authorware 7 has built-in LMS connectivity. If you are using an earlier version of Authorware and don't wish to upgrade, we can teach a proprietary approach.
  • One section of this Authorware training class deals with integrating Authorware with your database via a middle-tier application written in ColdFusion, Java/JSP, ASP, ASP.NET, PHP, or another language. We would be delighted to teach this section using your preferred language.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals.  To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=categorygroup&page=adobe.

Authorware Training Prerequisites

Beginning Authorware and Intermediate Authorware, or equivalent experience. Provided these prerequisites are met, this course can be customized to any level of programming and database experience.

Hands-on/Lecture Ratio

This Authorware training class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 15 minutes. Students "learn by doing," with immediate opportunities to apply the material they learn to real-world problems.

Authorware Training Materials

All students receive an illustrated course workbook developed by Accelebrate and related materials.

Software Needed on Each Student PC

  • Authorware 7.02 or later (earlier versions taught upon request, but many key features referenced below will not be available)
  • An LMS and/or database system (please contact us to discuss your specific systems — we can accommodate virtually all leading LMS/database systems with ease)

Note: Some additional software setup and configuration, which we can assist you with, will be required depending on your specific goals and requirements. Please contact us to discuss your particular needs.

Authorware Training Objective

  • To learn how to integrate Authorware applications with LMS systems and databases

Authorware Training Outline

  • Introduction
  • Overview of approaches to be taught
    • ODBC (Open Database Connectivity)
    • Connection with a database via a middleware application on a Web server
    • LMS integration via the LMS (Initialize) and LMS (Send Data) Knowledge Objects
  • SQL review (taught if attendees aren't familiar with Structured Query Language or would like a refresher)
    • Discussion of typical database structures for storing questions, learner profiles, assessment data, and other key e-learning information
    • Creating and dropping tables
    • Using SELECT to retrieve records from the database
      • Basic SELECT statements
      • Selecting records from multiple tables
        • Inner joins
        • Outer joins
      • Logic operators
      • LIKE clauses and wildcards
    • Using INSERT to create new records
    • Using UPDATE to change records in the database
    • Using DELETE to remove records from the database
  • Using ODBC for Authorware-database integration
    • Origins of ODBC
    • Basic ODBC architecture
    • Advantages of ODBC
      • Ubiquitous on Windows
      • Support for most Windows databases
    • Disadvantages of ODBC
      • Obstruction by firewalls
      • Inability to connect to file databases (Access, Paradox, etc.) across a network
      • Connection to a database other than SQL Server or Access requires a DSN (Data Source Name) to be registered on the user's computer
    • ODBC.u32 as a solution for database connectivity
      • Using ODBCOpen() to connect to a database for which a DSN is available
      • Using ODBCOpenDynamic() to connect to Access and SQL Server databases without need for a DSN
      • Executing SQL statements via ODBCExecute()
      • Closing the database connection via ODBCClose()
      • Using ODBCHandleCount() to troubleshoot database connection issues
    • Building common database-driven applications
      • User login
      • Save assessment data to the database
      • Retrieve assessment data from the database
      • Retrieve questions and answers from the database
      • Store learner progress in the database
  • Integrating with databases via Web server-based middleware applications (Note: By default, this section uses Microsoft Active Server Pages [ASP] as the middleware language. However, this class can be easily modified to use ASP.NET, ColdFusion, Java servlets, JSP, PHP, Perl, or another server-side language)
    • Advantages of using Web server-based middleware applications
      • Less prone to firewall difficulties
      • Doesn't require loading of drivers or creation of ODBC DSNs on the user's system
      • Ability to make the client application "thin," with business logic residing on the Web server
      • Flexibility to create multiple front-ends (including Web-based front-ends in HTML) to the same application
      • Database does not have to be exposed directly to the Internet (or, for intranet-based courses, your intranet)
    • Disadvantages of using Web server-based middleware applications
      • Necessity of writing a Web server-based middleware application (takes additional time, requires additional programming skills)
      • Sending data from the Authorware client application to the server takes a little more work than the ODBC approach
    • Deciding which tasks should be handled by the Authorware client and which should be handled by the middle-tier Web application
      • Using a "dumb" middle tier versus a "smart" middle tier
      • Elegant design via Model-View-Controller (MVC) architecture
    • Preparing data for transmission
      • Assembling a query string
      • Encoding the query string via URLEncode()
    • Submitting data to the server
      • Via ReadURL()
      • Via PostURL()
    • Retrieving and processing results from the server
    • Building common database-driven applications using a Web-based middle tier
      • User login
      • Save assessment data to the database
      • Retrieve assessment data from the database
      • Retrieve questions and answers from the database
      • Store learner progress in the database
  • LMS integration
    • The role of LMS systems in learning management and modern e-learning applications
    • E-learning-related tasks commonly handled by LMS systems
    • Overview of relevant standards
      • AICC-LAN
      • AICC-HACP
      • ADL/SCORM
    • Setting up the Authorware LMS Emulator (if you're developing in an environment where you don't have immediate access to an LMS)
    • Using the LMS (Initialize) Knowledge Object to initialize a connection to an LMS
      • Entering variable names (core data)
      • Entering variable names (other data)
      • Setting Resume preferences
      • Setting LMS preferences
    • Using the LMS (Send Data) Knowledge Object to send assessment results and other information from Authorware to the LMS
      • Configuring which data to track and pass to the LMS
      • Controlling how the data is preprocessed
      • Sending the appropriate exit command to the LMS after transmitting the tracking data
    • Using the Authorware Learning Object Content Packager to package a learning object for deployment to an LMS
    • Using the Authorware Learning Object Metadata Editor to configure all the metadata for a learning object being deployed to an LMS
  • Conclusion
    • Topics for further learning
    • Suggested approaches for further learning
 

Print This OutlineE-mail This OutlineGet A Quote


Adobe Authorware® is a registered trademark of AdobeSystems Incorporated in the United States and/or other countries.
Java® and all Java-based marks are registered trademarks of the Oracle Corporation in the U.S. and other countries.
 
Request Information for Group Training at Your Site   Request Information for Group Training at Your Site
 
Accelebrate®
Focuses on You!


Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.

For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.

VB.NET, C#, ASP, & ASP.NET Training Java Training SQL Server Training
SharePoint Training  Adobe Training PHP Training XML Training Perl Training Sitemap

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | Las Vegas, NV | Albany, NY | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK