Web Processing: Querying and Updating Web Data with htmSQL

Duration: 1.0 day CEUs: 0.6

AUDIENCE
This course is for SQL programmers, including Managers and Analysts, who want to design dynamic Web pages for querying and updating SAS® data files and who need to learn extensive manipulation of htmSQL. Little understanding of HTML is needed. This course teaches you how to combine HTML with SQL in order
to send a request for data services from a Web browser to a SAS/SHARE server.

BENEFITS
Students will learn about:
• HTML
• SQL for querying data
• How the SAS Server works to retrieve data

PREREQUISITES
SQL Processing with SAS Software or equivalent understanding.

COURSE TOPICS
• Create simple HTML from code
• Create HTML tables and forms
• Use an HTML form or URL to invoke htmSQL from the Web
• Create an htmSQL query to display data
• Create dynamic forms for htmSQL
• Update information on the Web using an htmSQL query
• Creating anchors, lists, and images
• Advanced HTML
• Data Services verses Compute Services
• Working with automatic variables

Software Used: Base SAS and SAS/IntrNet Software, along with the htmSQL® program.