Day 1

• Setting up the course database 
• Using ASP retrieve the records from the database table
• Accessing ODBC data from an ASP script
• Creating the ADO connection object,
• Building SQL statements
• Executing SQL Statements 
• Looping through recordsets
• Displaying recordsets 
• Closing a database connection
• Enhancing ASP database recordsets
• Adding a sort interface to retrieved records
• Lab exercises
• Homework assignments 

Day 2

• Working with recordsets
  • adLockReadOnly
  • adLockPessimistic
  • adLockOptimistic
  • adLockBatchOptimistic
• Building ASP Pages with recordsets
• Properties of the recordset object 
  • AbsolutePosition
  • BookMark 
  • BOF 
  • EOF
  • RecordCount
• Methods of the recordset object 
  • Move
  • MoveFirst
  • MoveLast
  • MoveNext
  • MovePrevious 
  • Lab exercises
  • Homework assignment

Day 3 

• Password Protecting ASP pages 
• Using session variables to password protect ASP pages
• Creating the user registration form
• Creating the user login page
• Processing the login input
• Approving a user session
• Rejecting a user session
• Using session variables to track authorized users
• Denying access by unauthorized users
• Handling lost passwords
• Lab exercises
• Homework assignment

Day 4

• Understanding stored procedures
• Using stored procedures 
• The command object
• Working with the command object
• Accessing stored procedures in your ASP scripts
• Lab exercises
• Homework assignment

Day 5

• Working with files and folders
• Referencing a file in an ASP script
• Understanding file permissions
• Copying files with an ASP script
• Moving files with an ASP script
• Deleting files with an ASP script
• Working with properties of the file object 
• Using ASP to retrieve:
  • The date a file was created
  • The last date a file was accessed
  • The last date a file was modified
  • The location of the file
  • The parent folder
  • The name of the file
  • The size of the file
  • The type of file e.t.c.
  • Lab exercises
  • Homework assignment

Day 6

• Uploading Files
• Understanding the HTML file input type
• Using HTML file encoding ( Enctype = "Multipart/form-data" )
• Creating an HTML file upload form
• Using ASP to retrieve file uploads 
• Using direct ASP to upload files 
• Using ASP to determine the uploaded file attributes including the file type, the file size e.t.c.
• Lab exercises
• Homework assignment

Day 7-14

• Course Hands-on real live project

Benefits Explained:
Instructor-led Training: Students can choose either our Instructor-led self-paced training or our Instructor-led one-on-one training. Both training choices guarantee students instructor feedback, evaluation and course concept clarification. Students registering for the Instructor-led one-on-one training will have telephone, instant messenger/net conferencing, and email access to their instructor. Students registering for the Instructor-led self-paced training will have email access to their instructor.

Live server space: We provide students access to Web servers running PHP, ASP, and ColdFusion MX. These servers are available to all registered students for the duration of the course at no additional cost. All students are required to upload their homework assignments to the school server. Instructions on how to upload homework assignments are provided by the school.

Convenient Schedule: Our training requires no time and place commitments. Students can access course lectures, projects, homework assignments, and other course resources at any time. Access is granted 24 hours a day, 7 days a week.

Instructor Support: Our instructors are available to answer questions on course topics, homework assignments, projects and other course related issues.  Instructor Support is available on weekdays between 9am and 4pm Eastern Standard time. Instructors usually respond with in a 2-6hour time frame.

Course/Program Certificate: The Internet Learning Institute issues a certificate of completion to students who successfully complete their course. Completion of a course is based on the completion of the final project. The final project usually includes all concepts covered in the course lectures. 

Grade Report: We maintain a grade reporting system. Students are generally graded for homework assignments and final projects. Students are emailed updated reports as homework assignments and projects are evaluated by instructors. 

Instructor Homework Evaluation and Final Project Evaluation: Our Instructors evaluate, grade and provide feedback on all homework assignments and projects. Evaluation, grading and feedback is generally  based on coding techniques, presentation, mastery, comprehension, utilization and application of course lecture concepts. We always encourage our students to go above and beyond the project requirements.

Ready to Register?
Click Here

*Prerequisite:

• HTML Basics
• Mastering HTML Forms 
• Introduction to Databases
• ASP Fundamentals 
• ASP Intermediate

*Students are strongly encouraged to review prerequisite course requirements. Adequate knowledge of prerequisite courses provide a solid foundation for  successful participation in this course.

Benefits:

• Instructor-led Online Training
• Live server space
• Convenient Schedule (No place or time commitment)
• Instructor Support
• Course/Program Certificate
• Grade Report 
• Official Transcript
• Instructor Homework Evaluation
• Instructor Final Project Evaluation