ASP Level 1

Course Overview

Delegates will learn the benefits of using ASP technology to create dynamic, data-driven Web sites. The course introduces the ASP Object Model, several built-in ASP Components, Scripting Objects, and the ActiveX Data Objects (ADO) Model. This course is ideal for those who need to transform their static HTML-only Web site into a dynamic, data-driven Web site that accesses databases, uses COM components, dynamically serves information from a variety of sources, and much more.
Prerequisites

• To attend this course, delegates must be comfortable with using HTML, programming, JavaScript, or VBScript, SQL Fundamentals of Querying.

Objectives

Delegates will be able to :

• Describe what ASP is, what platforms and applications support it, and the role of scripting languages, objects, and components in ASP programming.
• Use Server-side Includes to improve Web programming efficiency through modularisation.
• Describe the role of the ASP Response object and use its Write, Redirect, and output control properties and methods.
• Describe the role of the ASP Request object and use its Form, QueryString, and ServerVariables collections to obtain user-supplied information and environment details.
• Determine the value of cookies in maintaining user state and use the Cookie collections of the Request and Response objects.
• Describe the difference between ASP applications and sessions and use the Global.asa file to launch application and session events.
• Use the Recordset object to display database records, create on-the-fly combo boxes and option groups, and filter records based on user input.
• Add, update, and delete records in a database using both ADO and SQL query methods.
• Use stored procedures and parameter queries to improve database access on the Web.

Training Options

• Bespoke course (a course written to your specific needs) at your company office throughout the UK, at our training venue or at an independent location, convenient to you
• Private course at your company office throughout the UK, at our training room or at an independent location, convenient to you
• Scheduled public course at one of our training venues

Whats Included

• Comprehensive colour course manual and exercises
• Use of a Modern Training suite with 19 inch flat screen monitors
• 1 delegate per computer
• Lunch (When at our training venue)
• Refreshments (When at our training venue)
• Relaxed refreshment area at our training room

Course Content
Day 1
Introduction to ASP

• What is ASP?
• ASP Scripting Languages, objects and components

Server-side Includes

• Using server-side includes
• Using dynamic server-side includes

The Response Object

• What is the response object?
• The write method
• The redirect method
• Controlling output

The Request Object

• What is the request object?
• The Form collection
• The QueryString collection
• The ServerVariables collection

Cookies

• What are cookies?
• The Response.Cookies collection
• The Request.Cookies collection

ASP Components, Part 1

• What are ASP components?
• The server object
• The AdRotator component

ASP Components, Part 2

• The browser capabilities component
• The content linking component

Day 2
Applications, Sessions, and the Global.asa

• What are ASP applications and sessions?
• What is the Global.asa?

Scripting Objects

• The built-in scripting objects
• The FileSystem object
• The TextStream object

ASP and the ADO Model

• ASP, databases, and ADO
• The database environment
• Connecting to the database

Viewing Database Records

• Working with recordsets
• Creating combo boxes and option groups
• Filtering records

Adding, Updating, and Deleting Records

• Adding records to a database
• Updating records in a database
• Deleting records from a database

Stored Procedures and Parameters

• Using stored procedures
• The command object
• Parameter queries

Advanced Recordset Techniques

• Editing records with a data browser
• Paging through a recordset