ASP-200
Linking Databases 
( VBScript, JavaScript, Active X & XML)

Tuition: $900

*Prerequisite*
HTML Programming Levels 1 & 2, Programming Introduction, JavaScript (Level 1) or VBScript (Level 1), ASP-100: Active Server Pages,SQL Fundamentals of Querying; or equivalent knowledge.

What past students had to say about this class:

Exciting, as usually experienced. Kathy's great! ~H.P. \USMC

It's evident that Ms. Quinn loves her position. I've had several courses with her. If it is not correct, she won't do it. Her knowledge base is deep, she teaches with clarity, focused direction and above all, patience. ~V.C. \USMC

Course Content:

ASP Server Object

• Server Object Properties and Methods
• ASP Server-Side Components
• Using the Browser Capabilities Component
• Using the File System Component
• Using the Ad Rotator Component

Introduction to ActiveX Data Objects

• OLE DB Data Providers
• Technologies at Work
• ADO Object Hierarchy
• Connection Object’s Open Method
• Taking a Look at the Example Code
• Creating Recordsets
• Using ADO Constants
• Recordset Properties and Methods
• ShowEmp2.asp Page
• Using Arguments vs. Properties

ADO Recordsets and Error Handling

• Updating Records
• Adding Records
• Deleting Records
• Multiple Resultset Recordsets
• Error Handling
• Default Behavior
• What VBScript Has to Offer
• What JavaScript Has to Offer

ADO Command Objects and Stored Procedures

• Creating a Command Object
• Command Object Properties
• The Command Execute Method
• Using Stored Procedures
• Passing Parameters to Store Procedures
• Dealing with Parameters
• The procDeleteCustomer Stored Procedure
• Using the Parameters Argument
• Using the Refresh Method
• Using the CreateParameter Method
• Adding a New Record Using a Stored Procedure

Security and SSL

• What Do Hackers Want:
• Your Defenses
• Security through Policy
• Security through Technology
• Use a Different Server for Development and Production
• Change the Windows NT/2000 Administrator Account
• Remove Any Non-Necessary Users
• Block Non-Essential Inbound TCP/IP Ports
• Making Internet Information Server (IIS) Secure
• Turn Off Directory Browsing
• Give Appropriate NTFS File Permissions to Web Folders
• Authentication and the Anonymous User
• Setting Up Authentication Schemes
• Anonymous Access
• Basic Authentication
• Windows NT Challenge/Response (or Integrated Windows Authentication)
• The Problem with Delegation
• Secure Transmissions Using SSL
• What is Secure Sockets Layer (SSL)?
• Why Use SSL?
• Why Not Use SSL?
• How To Use SSL
• Five Basic Steps to Using SSL
• A Couple of Suggestion for Using SSL

 
ASP Tips and Tricks

• What’s New for ASP 3.0 and IIS 5.0
• Improved Processing of Scriptless Pages
• New Server Methods
• Buffering Now On
• Scripting Language Changes
• ASP Error Handling
• Using the Dictionary Object
• Sending E-mail Using CDONTS
• Keeping Content Current
• Working with Radio Button and Check Box Controls
• Checking for SSL
• Improving the Performance and Scalability of ASP Applications
• Avoid Using the Visual InterDev DTCs
• Context Switching
• Creating Objects
• Using Components
• ADO tips
• Using Cached Content
• Threading, Components, and Scope
• Session and Scalability

Extensible Markup Language (XML)

• XML Defined
• Working with XML
• XML Elements
• Attributes
• Comments
• Namespaces
• Processing Instructions
• XML Browser Support
• DTDs and XML-Data Schemas
• Document Type Definition (DTD)
• Valid and Well-Formed Documents
• SML-Data and Schema
• Document Validity-Is it Necessary?
• XML Document Object Model
• XML DOM Object Hierarchy
• The XML DOM Objects
• A DOM Example
• Displaying the XML on the Page
• Iterating Through a Document’s Nodes
• Retrieving Attributes
• Just Scratching the Surface
• XML on the Server  

Transforming XML with XSL

• Extensible Stylesheet Language (XSL)
• XSL: Giving Style to XML
• XSL Elements
• Matching Patterns
• Matching By Element Value
• Sorting in XSL
• XSL on the Server
• An ASP XSL Example