http://www.academyandcareer.com for Academy And Career Link
• Certification
• Diploma   
• Advance Diploma
• Online Study Material
• Basic of Computer
• Operating Systems
• Courses Module
• Information Technology
• Fundamentals of C#
• Web Scripting & Design
• Fundamentals of C++
• PHP Tutorial
• Hardware & Networking


 
 
 
 

Certificate in Asp.Net, ADO.net (CAA)

  • Computer Fundamentals
  • Asp.Net
  • ADO.Net

Course Contents  (• 3 months     • 6 days a week   • Classes : 1 hr. Theory & 1hr. Practical)

Introduction to ASP Training Overview

In this ASP training course, students will learn to build full-featured, database-driven Web sites. This introductory course for new programmers lays out the basics of server-side Web programming with an introduction to classic programming structures and good programming practices. Students will apply these programming skills to the development of a fully functional data-driven website with ASP written in VBScript. Students will harness the power of ASP to remember users with cookies and sessions, collect and process information users enter into an online form, and provide rich integration with databases to track clients, orders, and products using ASP and the enhanced functionality of ASP components.

Students will also learn to use sophisticated programming strategies and advanced features to add polish, speed and efficiency to Active Server Pages Web applications. In this ASP training course, students will work more thoroughly with ASP components for Web-to-database integration and use the server's file system to add features and functionality to a website. In addition, students will learn to work with other built-in and third-party components.

Introduction to ASP Training Course Goals

  • Learn how ASP works
  • Learn the basic syntax of ASP
  • Learn to create dynamic interactive pages with ASP
  • Learn to work with VBScript control structures
  • Learn to use VBScript built-in functions
  • Learn to work with ASP's built-in objects
  • Learn to validate forms with ASP
  • Learn to write functions and subroutines in ASP
  • Learn to work with ASP Session, Application, and Cookie objects
  • Learn to connect to a database with ASP
  • Learn to send email with ASP

Introduction to ASP Training Course Prerequisites

Experience in the following areas is required:

  • HTML

Experience in the following areas would be beneficial.

  • CSS
  • Basic Programming

Introduction to ASP Training Course Outline

  1. Active Server Pages: A Web Server-Side Technology
    1. Client-side vs. Server-side Web Technologies
    2. The Web's Client-Server Relationship
    3. Which Web Servers Support Active Server Pages?
  2. Writing ASP Pages
    1. ASP Code in an HTML Context
    2. ASP Code is "Language Neutral"
    3. VBScript in ASP
    4. ASP Scriptlets
    5. VBScript Strings
    6. An Abbreviation for Response.Write
    7. Developing ASPs
    8. ASP Directives, Statements, Expressions and Comments
    9. VBScript Flexibility and Good Programming Practices
  3. Processing Data from Online Forms
    1. The FORM Tag and its Attributes
    2. ASP Objects
    3. The Request and Response Objects
    4. Scalar Variables in ASP
    5. Customizing a Page for the Visitor
  4. Conditional Constructs - IF Statements
    1. Comparison Operators in VBScript
    2. Adding an Else Clause
    3. Implementing an IF...ELSE...END IF Conditional
    4. Adding One or More ELSEIF Clauses
    5. The Logical AND and OR
    6. Combining the Form and its Processing Code in One ASP File
  5. Working with Cookies
    1. Setting and Retrieving a Cookie
    2. Cookie Properties
    3. Expiring a Cookie
  6. Maintaining State with the Session and Application Objects
    1. The Session Object
      1. Storing and Retrieving Values in the Session Object
      2. Session Properties and Methods
    2. The Application Object
  7. Working with Components
    1. Instantiating Component Objects
    2. Sending Email with CDONTS
  8. Writing to a Text File
    1. Writing to a Tab-Delimited Text File
  1. Loop Structures in ASP
    1. For...Next Loops
    2. Populating Select Lists
    3. Collections in ASP
    4. For Each...Next Loops and Collections
  2. ASP-to-Database Integration with ADO
    1. Database Commands with SQL
    2. The ADO Object Model
    3. Retrieving a Record from the Database with ASP
    4. The Connection Object's Execute Method
    5. Building an Interface for Updating Client Records
  3. VBScript Subroutines and Functions
    1. Subroutines
    2. Functions
  4. Drilling Down and the Query String
    1. Building the Query String into a Link
    2. Generating Drill Down Links Dynamically
    3. Building an Interface for Deleting a Record

Advanced ASP Training Overview

In this advanced ASP training course, students will learn to use sophisticated programming strategies and advanced features to add polish, speed and efficiency to Active Server Pages Web applications. In this ASP training course, students will work more thoroughly with ASP components for Web-to-database integration and use the server's file system to add features and functionality to a website. In addition, students will learn to work with other built-in and third-party components.

Advanced ASP Training Course Goals

  • Learn to implement advanced drill-downs
  • Learn to debug ASP code
  • Learn to work with stored procedures
  • Learn to use batch updating
  • Learn to work with 3rd-party vendor components
  • Learn to work with the file system of the server

Advanced ASP Training Course Prerequisites

Experience in the following areas is required:

  • Basic ASP Skills

Advanced ASP Training Course Outline

  1. File Conventions
    1. Connection Pooling
    2. Dynamic Connection Strings
    3. Default METHOD and ACTION Values
  2. Advanced Data Drill-Downs
    1. Passing Data via the Query String
    2. Using Drill-Downs to Reformat Data
    3. Creating Sortable Tables
  3. Displaying Variables
    1. Creating an Include to Display Variable Values for Debugging
  4. Displaying a Portion of a Recordset
    1. Displaying the Next n Records
    2. How the Process Works
  5. Password Protection with Session Variables
    1. Adding Password Protection to Pages
  1. Stored Procedures in ASP
    1. Creating a Stored Procedure in the Database
    2. Advantage of Stored Procedures
    3. Calling a Stored Procedure
    4. Using Stored Procedures to Insert and Update Data
  2. Working with the File System in ASP
    1. The FileSystemObject
    2. Creating or Opening a Text File
    3. Methods of the TextStream Object
    4. Storing Text to a File
    5. The File Object
    6. The Folder Object
    7. Working with Files and Directories
  3. Processing File Uploads
    1. Obtaining a Component for Processing File Uploads
    2. The AspUpload Component
    3. Building an HTML Form that Supports File Uploads
    4. Processing the File on the Server with AspUpload
    5. Processing Files and Entered Text
    6. SetMaxSize
    7. Manipulating Files via AspUpload
    8. Creating an New Directory
    9. Restricting Your Upload to Certain File Extensions
    10. Building a Resume Submission Interface
  4. Batch Updating
    1. Opening a Recordset for Batch Updating
    2. Editing the Records Row by Row
    3. Updating the Batch
    4. Benefits of Batches
    5. Some Useful VBScript Functions
  5. Using rs.Update Instead of INSERT
    1. rs.Update
  6. Form Validation with Server-Side JScript
    1. Server-Side Form Validation with JScript
  7. Transactions in ASP
    1. Transactions
    2. Handling Errors
    3. Catching Database Errors
  8. Creating Message Boards
    1. The HTML Files
    2. The Database
    3. The Interface
  9. Regular Expressions
    1. Creating and Executing Regular Expressions with exec()
    2. Special Characters for Pattern Matching
    3. Escape Sequences for Special Characters
    4. Specifying Ranges in Patterns
    5. Matching a Specified Number of Occurrences
    6. Character-Range Escape Sequences
    7. Matching at the Beginning or End of a String with ^ and $
Free Lab Access

Associate | Motivation | Training | Video Tutorial | Reference Books | Advertise with us

Copyright 2009 www.hopeallinfotech.com All Right Reserved