Learn the Active Server Pages skills you need to build full-featured, database-driven Web sites for Microsoft Internet Information Server (IIS). This introductory course for new programmers introduces 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. Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students 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 modularization.
• 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 what ASP components are and use the Server object to instantiate
• ASP components.
• Use the Ad Rotator, Browser Capabilities, and Content Linking components.
• Describe the difference between ASP applications and sessions and use the
• Global.asa file to launch application and session events.
• Describe what Scripting Objects are and use the Dictionary, FileSystemObject, and TextStream objects to further enable your ASP Web sites.
• Describe the relationship between ASP and ADO and create a database connection from a Web site.
• 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.
• Create a data browser that allows forward and backward recordset browsing and a paged recordset display system.

Benefits: Students will learn how to create dynamic, database-driven Web sites. Hands-on tasks follow programming concepts, so that students can immediately implement what they learn.

Target student: Students needing 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.

Students must understand HTML concetps, completion of HTML Fundamentals or equivalent knowledge is required. Some knowledge SQL statements is recommended but not required.