ASP.Net over C# using Sql server

SP.NET Training course:

 Beginning ASP.NET 4.0 with C# 2010 & SQL Server 2008.

ASP.NET 4.0 Training Overview

Enterprise ASP.NET 4.0 training teaches attendees how to build web-based enterprise applications using ASP.NET 4.0 and C# 2010 & SQL Server 2008.

ASP.NET 4.0 Training Objectives
 Gain a thorough understanding of the philosophy and architecture of Web applications using ASP.NET.
Acquire a working knowledge of Web application development using Web Forms and Visual Studio 2010.
Optimize an ASP.NET Web application using configuration..
Access databases using ADO.NET..

·         Write SQL INSERT, UPDATE and DELETE statements.

·         Write SQL SELECT statements, including all allowable WHERE expressions, sorting, functions joins.

·         Get   basic knowledge how to use C#.net with Asp.net and SQL SERVER.
 Implement rich client applications with basic payroll system as an example..

Audience:

§  Application Developers

§  Forms Developer

§  System Analysts

ASP.NET 4.0 Training Outline
  SQL .
 Create database.
Create tables.
 SQL SELECT Statement.
 SQL WHERE Clause.
 SQL AND & OR Operators.
SQL ORDER BY Keyword .
SQL INSERT INTO Statement.
SQL UPDATE Statement.
SQL DELETE Statement.
SQL JOIN.
SQL SUM() Function.
SQL GROUP BY Statement.

 
 HTML.
 HTML skeleton.
HTML tags for text, links.
HTML tags for tables.
Create local HTML pages .
Design and develop basic web pages using HTML .
Use HTML tables in ASP.net Web pages..

 
 Introduction to ASP.NET .
 Web Application Fundamentals.
Using Internet Information Services.
Web Forms.
Web Forms Architecture .
 Page Class.
Web Forms Event Model.
Code-Behind.
Web Applications Using Visual Studio .
 Using Visual Web Developer.
Visual Studio Forms Designer.
Using Components.
State Management .
 Session State.
Pass Values Between ASP.NET Web Forms Pages.
 Using   query string..
Using session state..
Debugging.
ADO.NET .
 ADO.NET Overview.
Connections.
Commands.
Data Readers.
Data Sets .
Data Access in ASP.NET 4.0 .
 Data Source Controls.
Connection String Storage.
Grid View.
Details View.
Object Data Sources.

 
 ASP.NET AJAX.
 Script Manager.
ASP.NET Reports.
 Microsoft report 2010.
Deployment.
 Deploy payroll system to be in production mode..

 

 
  C#.NET.
 OOPs Concept..
Variables, Data types.
Arrays.
Conditional Statements (using  if-else, switch).
Loops & Nested Loops.
Define and Call Methods in C#.
Classes and Objects .
.