MICROSOFT TECHNOLOGIES

Syllabus of Asp.net 4.0(with C#.NET or VB.NET/AJAX/LINQ)

Web Architecture

• The Way the Web works
• The Asp.net difference
• Client-Side Processing
• How Asp.net Ties It Together

Setting up and Installing ASP.NET

• Installing Internet Information Server
• IIS Manager
• Creating virtual/home directory
• Folder Settings
• Adding a virtual directory to your neighborhood
• Installing .Net Framework SDK           

Overview of the ASP.NET Framework

• Asp.net and the .NET Framework
• Common Language Runtime
• .Net Framework Class Library
• Understanding Namespaces
• The Structure of asp.net Page
• Directives
• Code Declaration Blocks
• Code Render Block
• C# fundamentals

Using the Standard Controls

• Displaying information
• Label Controls
• Literal Controls
• Accepting User Input
• Textbox controls
• RadioButton And RadioButtonList Controls
• CheckBox And CheckBoxList Controls
• Submitting Form Data
• Button controls
• Link Button Control
• Image Button Control
• Displaying Images
• Image Control
• Using Panel Control
• Using Hyperlink Control

Using the Validation Controls

• RequiredFieldValidator Control
• RegularExpressionValidator Control
• CompareFieldValidator Control
• RangeValidator Control
• ValidationSummary Control
• CustomValidator Control
• Disabling Validation
• Creating a LengthValidator Control
• Creating a AjaxValidator Control
• Summary

Using the Rich Controls

• Accepting File Uploads
• Saving files to file system
• Saving files to database
• Uploading Large files
• Displaying a calendar
• Creating a popup date picker
• Rendering a calendar from a database table
• Displaying advertisements
• Storing advertisements in XML files
• Storing advertisements in database tables
• Tracking impression and transfers
• Displaying Different Page views
• Displaying a Tabbed Page View
• Displaying a Multi-Part Form
• Displaying a wizard
• Summary

Designing Websites with master pages

• Creating master pages
• Creating default contents
• Nesting master pages
• Using images and hyperlinks in master pages
• Registering master pages in web configuration
• Summary

Designing websites with Themes

• Creating Themes
• Adding skins to themes
• Creating named skins
• Themes versus StyleSheetThemes
• Disabling Themes
• Registering Themes in web configuration file
• Summary

Microsoft SQL Server 2005 Express

• Overview of SQL Server 2005 Express
• Installation of SQL Server 2005 Express
• Features of SQL Server Express
• SQL Server 2005 Express management tools
• Server databases versus Local Databases
• Summary

Overview of Data Access

• Using DataBound Controls
• Working with List Controls
• Working with tabular DataBound Controls
• Working with Hierarchical DataBound Controls
• Working with other Controls
• Using Data Source Controls
• Using ASP.NET parameters with data source controls
• Using programmatic DataBinding
• Understanding Templates and Databinding Expressions.
• Using templates
• Using DataBinding Expressions
• Using 2 way DataBinding Expression
• Summary

Using SQLDataSource Control

• Creating database connections
• Connecting to MSSQL Server
• Connecting to ORACLE and MS Access
• Storing connection String in web configuration file
• Executing Database Commands
• Executing inline SQL Statements
• Executing Stored Procedures
• Filtering database rows
• Changing the data source mode
• Handling SQL Command execution errors
• Canceling command execution
• Using ASP.NET parameters with SQL DataSource Control
• Using the ASP.NET cookieparameter object
• Using the QueryStringParameter object
• Programmatically Executing SqlDataSource commands
• Adding ado.net parameters
• Executing Insert, Update and Delete commands
• Executing select commands
• Caching Database Data with SqlDataSource control
• Summary

Using List Controls

• Overview of the List Controls
• Declaring List Items
• Binding to a Data Source
• Determining the selected List Item
• Appending data items
• Enabling automatic post backs
• Using the Items Collection
• Working with the DropDownList control
• Working with the RadioButtonList control
• Working with the ListBox control
• Working with the CheckBoxList control
• Working with BulletedList control
• Summary

Using the GridView Control

• GridView Control fundamentals
• Displaying Data
• Selecting Data
• Using Data Keys
• Sorting Data
• Paging through Data
• Editing Data
• Displaying Empty Data
• Formatting the GridView Control
• Using ViewState with GridView Control
• Using fields with GridView control
• Using BoundFields
• Using CheckBoxFields
• Using CommandFields
• Using Button Fields
• Using HiperLinkField
• Using ImageField
• Using TemplateField
• Working with GridView Control Events
• Highlighting GridView Control

• Displaying Column Summaries
• Displaying nested master/details form
• Extending the GridView Control
• Creating a long text field
• Creating a delete button field
• Creating a validated field
• Summary

Using the DetailsView and FormView Controls

• Using the DetailsView control
• Displaying data with the DetailsView control
• Using Fields with the DetailsView control
• Displaying Empty data with the DetailsView control
• Paging Through Data with the DetailsView control
• Updating Data with the DetailsView control
• Inserting data with the  DetailsView control
• Deleting Data with the  DetailsView control
• Working with the  DetailsView control
• Formatting  the  DetailsView control
• Using the FormView Control
• Displaying Data with the FormView control
• Paging through Data with the FormView control
• Editing data with the FormView control
• Inserting data with the FormView control
• Deleting Data with the FormView control
• Summary

Using Repeater And DataList Controls

• Using Repeater Control
• Displaying data with the Repeater Control
• Using Templates with the Repeater Control
• Using the DataList Controls
• Displaying Data with the DataList Control
• Displaying Data with Multiple Columns
• Using templates with the DataList Control
• Selecting data with the DataList Control
• Editing data with the DataList Control
• Formatting  the DataList Control
• Summary

Using The ListView and DataPager Controls

• ListView Control
• Layout template and ItemTemplate
• Using Group Template
• Selecting a row
• Sorting/editing Data
• Using DataPager Control
• Creating a custom user interface for paging
• DataSource paging
• Summary

Data Access with LINQ to SQL

• New C# and VB.NET Language features
• Understanding Automatic Properties
• Understanding Initializers
• Understanding type inference/lamda exp/generics/anonymous types
• Creating LINQ to SQL Entities
• Performing standard database commands with LINQ to SQL
• Creating a custom LINQ entity Base Class
• Standard Data-access operation
• Performing Validation

Navigation Controls

• Understanding Site Maps
• Using the SiteMapPath Control
• Formating the SiteMapPath Control
• Using the Menu Control
• Using TreeView Control
• Summary  

Using the Login Control

• Overview of Login Controls
• Using Login Controls
• Automatically Redirecting a user to the Referring Page
• Automatically Hiding the Login Control from Authinticated Users
• Authenticated Users
• Using a Template with Login Control
• Performing Custom Authentication with Login Control
• Using LoginStatus Control
• Using LoginName Control
• Using ChangePassword Control
• Sending a change Password Email
• Using Templates with ChangePassword Control
• Using PasswordRecovery Control
• Sending the Original password
• Requiring a Security Question and Answer
• Using Templates with PasswordRecovery Control
• Summary 

Caching Application Pages and Data

• Overview of Caching
• Using Page Output Caching
• Varying the Output Cache by Parameter
• Varying the Output Cache by Control
• Varying the Output Cache by Header
• Varying the Output Cache by Browser
• Varying the Output Cache by Custom Function
• Specifying the Cache Location
• Creating a page output Cache Dependency
• Expiring the Page Output Cache Programmatically
• Manipulating the Page Output Profiles
• Creating Page Output Profiles

Localizing Applications for multiple languages

• Setting the current culture
• Setting a culture manually
• Automatically detecting a culture
• Setting the culture in the web.config file
• Culture and ASP.NET controls

Using Forms-Based Authentication

• Working with forms authentication
• Enabling forms authentication
• Configuring forms authentication
• Retrieving user information
• Configuring form authorization
• Creating a sign-out page
• Authenticating user with the web.cofig file
• Authenticating users with an xml file
• Authenticating users with a database table
• Implementing roles-based authentication
• Creating a custom authentication ticket

Overview of XML

Creating an XML Web Services

• Overview of XML Web Services
• XML Web Services Facilitate Communication
• XML Web Services Enable Aggregation
• Creating an simple XML Web Services
• Setting WebMethod Attribute
• Setting WebServices Attribute
• Precompiling an XML Web Service
• Testing an XML Web Services from browser
• Invoking an XML Web Service with HTTP-Get
• Invoking an XML Web Service with HTTP-Post
• Invoking an XML Web Services with SOAP

Advanced XML Web Services

• Using the WebService Behavior
• Examining Limitations of the WebService Behavior
• Creating a Simple Page with a WebService Behavior
• Using WebService Behavior Callback Functions

AJAX(Asynchronous JavaScript and XML)

• About Ajax
• Server Side Ajax
• Client Side Ajax
• Ajax Toolkit
• Setting up and implementing Ajax

Microsoft SQL Server Administration

• Query analyzer
• Enterprise Manager Console  
• Import/Export of data between Remote and Local Server(Live)
• How to setup Database server of a website
• Converting data between MDF to DBO,DBO to XLS or in any other format.
• How to generate SQL Script
• Backup and Restore of data
• Using Stored Procedure
• Uploading and downloading files from Database server

FTP Management

• Understanding FTP
• Setting up FTP Server (Live)
• Uploading and downloading FTP contents

Sending Emails

• Designing email panel
• How to send an email to various users
• Sending auto emails

Seminars and group discussions

• During the course it is compulsory for every
• Student to take participation in
• Seminars and group discussion.

Live Project

• Getting customer’s requirements
• Preparing designs, database and business logics
• Developing software application project
• Testing and implementing the project
• Troubleshooting the project application after implementation

Note: Duration of the course is 25Hours