• Introduction of C Language
• How its related to asp.net
• Some Example of C programes If-Else and Nested if
• cases arrays
• Loops(for, while and do while)

• Introduction of Project with n tier architecture What is net
• Version of asp.net Jit compiler
• Component of asp.net CLR
• FCL
• Assemblies and its Type Reflection
• .net framework Garbage Collection
• Comparison between different version of .net (1.0,2.0,3.0,3.5,4.0) Webconfig file
• Wcf,Wpf,Linq Introduction of C# Introduction of Sql Server Introduction of Net

Details Below

• Classes and object
• Hello world with class and object Access modifier
• Constructor and its type Properties
• Event
• Static variable and constructor Private constructor
• Practical Assighnment-1 Notes-1

• Classes with inheritance
• Access moodier with inheritance Upcasting
• Overriding Overloading Abstract Classes Sealed Classes
• Practical Assighnment-2 Notes-2

• Interface implementation
• Difference between abstract class and interface Practical Assighnment-3
• Notes-3

• Type casting and its type Value type and reference type Heap and stack
• Boxing and unboxing Practical Assighnment-4 Notes-4

• Function overloading
• Operator overloading
• Virtual keyword
• Practical
• Assighnment-5
• Notes-5

• Type of exception (Checked and unchecked)
• Try Catch Finally Throws
• Practical Assighnment-6 Notes-6

• 1-d array 2-d array
• Jagged array For loop
• For each loop
• Practical Assighnment-7 Notes-7

• Difference between collection and generics Where use both
• Hash table Stack Queue
• Implementation of both collections and generics Practical Assighnment-8
• Notes-8

• Implementation of string and its different method and properties
• Implementation of stringbuilder and its different method and properties
• Difference between string and string builder
• Practical
• Assighnment-9
• Notes-9

• Memory management Destructor
• Garbage collection implementation Practical Assighnment-10
• Notes-10

• Thread and its property
• Thread and its priority
• Implementation of thread
• Practical
• Assighnment-11
• Notes-11

• Implementation of delegation
• Implementation of event
• Practical
• Assighnment-12
• Notes-12

• Introduction of attribute
• Retrieving metadata using reflection
• Practical
• Assighnment-13
• Notes-13
• Interview Question on C#

Details Below

• Database Rdbms
• Er diagram Dfd Normalization
• Denormalization Relationship
• Overview of sqlserver-2008 Feature of Sql server-2008

• Create and use database datatype
• Create table
• Data integrity
• Ddl statement
• Dml statement
• Primary key and foregn key
• Use constraints

• Notes-1

• Practical
• Assighnment-1

• Simple insert query
• Insert query using select
• Update query
• Delete query
• Practical
• Assighnment-2
• Notes-2

• Select all data
• Select specific column
• Customize the display(change the col name in display)
• Concatenate the text value in the output
• Calculating the column
• Practical
• Assighnment-3
• Notes-3

• Using arithmetic operation
• Using comparisons operator
• Using and/or operator
• Range
• In and not in Like operator
• Null value
• Use of order by
• Top value of the table
• Distinct
• Practical
• Assighnment-4
• Notes-4

• Use of string function Use of date function
• Use of mathematical function Use of ranking function
• Use of system function
• Practical
• Assighnment-5
• Notes-5

• Min
• Max
• Sum
• Count
• Group by
• Compute and compute by Pivot
• Practical
• Assighnment-6
• Notes-6

• Inner join
• Outer join and its type
• Cross join
• Equi join Self join
• Practical
• Assighnment-7
• Notes-7

• Use of subqueries
• Using in and exists
• Nested subqueries Correlated subqueries
• Practical
• Assighnment-8
• Notes-8

• Primary key constraint
• Unique key constraint
• Foreign key constraint
• Checkconstraint
• Default constraint
• Practical
• Assighnment-9
• Notes-9

Alter

Add column Dropping table

Practical Assighnment-10

Notes-10

XML Data

Storing xml data in a table Retrieving xml data from table Use of xquery

Modify the xml data Practical Assighnment-11 Notes-11

Advanced Topic

Indexes Xml indexes

View(create,alter,drop) Use of if-else statement Use of case statement Use of while statement Use of exception handling Practical Assighnment-12 Notes-12

Procedure and Triggers

Create and execute procedure Create and execute triggers Practical Assighnment-13 Notes-13

Extra Topic

Script generation Backup of database Restore database

ADO.NET Overview

Visual Studio .NETOLEDB and SQLServerNamespaces and Classes

Interfaces

First ADO.NET Program.

ADO.NET Connections

ADO.NET

Managed Providers Connection Class Connection Strings Connection Pooling Connection Events Connection Factory Pattern Error Handling

ADO.NET Commands

Command Objects Command Types Result Sets Running queries

Running scalar queries Running nonqueries Parameters

Practical Assighnment-1 Notes-1

DataReaders and Connected Access

DataReader Classes Retrieving Data Updating Data

Practical Assighnment-2 Notes-2

Data Sets and Disconnected Access

DataSet DataAdapter Command Objects DataTable DataColumn DataRow

Editing Columns

Row States and Versions

Sorting and Searching DataTables Events

Practical Assighnment-3 Notes-3

Concurrency and Transaction

Concurrency Overview Transaction

Transaction and DataAdapter Isolation Levels

Practical Assighnment-4 Notes-4

XML and ADO.NET

Strong coupling between ADO.NET and XML Typed DataSet

Rendering XML from a DataSet Reading XML into a DataSet Synchronized DataSet Practical Assighnment-5

Notes-5

Data Binding

DataView

Data Binding in Windows Forms Simple Data Binding

DataGrid Binding Master Detail Binding

Data Binding in Web Forms Practical Assighnment-6 Notes-6

Data Binding with Procedure

DataView

Data Binding in Windows Forms Simple Data Binding

DataGrid Binding Master Detail Binding

Data Binding in Web Forms Practical Assighnment-6 Notes-6

Data Binding with Procedure

DataView

Data Binding in Windows Forms Simple Data Binding

DataGrid Binding Master Detail Binding

Data Binding in Web Forms Practical Assighnment-7 Notes-7

Introducing ASP.NET

Understand the basic architecture of a Web application Understanding the role of HTTP

The difference between HTML and XHTML Learn the key features of ASP.NET

The ASP.NET Namespaces

The history of ASP.NET Web development

Contrast the use of IIS vs. the Visual Studio development Web server Work with different versions of IIS

Know the differences between a Visual Studio Web Site and a Web Application project

User Controls and Master Pages

Understanding and creating user controls Creating composite user controls Manipulating user controls on the host page Exposing events from user controls

Host Web pages subscribing the user control events Introducing Master pages

A Master page walkthrough Nested Master pages

Master page events and page access Practical Assighnment-1

Notes-1

Caching

Importance of caching

ASP 3.0 Support for caching Type of caching in ASP.NET

Output caching Web user control vs custom control Fragment caching

Data caching vs. Application object

Practical

Assighnment-2

Notes-2

Site Navigation

Basic page navigation

Response.

Redirect() and Server. Transfer()

Work with the MultiView control Work with the Wizard control

Understand the site map model of ASP.NET Examine the Menu navigation control Examine the Tree

View navigation control Create Web application breadcrumbs

Practical

Assighnment-3

Notes-3

State Management

Define the role of view state Read and write cookies

The role of application state and session state Work with The State Service

Use SQL Server session management

Study the various forms of caching (the Cache object and Output Cache) Work with Cache dependencies, such as a Sql Server dependency Practical Assighnment-4

Notes-4

ASP.NET and Web Services

Web Forms Html Controls Web Controls

Collaborative Web Applications Moving from Web Sites to Web Services

Simple Object Access Protocol (SOAP)

Web Services Description Language Practical Assighnment-5

Notes-5

Reporting

Detail Concept of Crystol Report Implementation of Crystol Report Detail Concept of RDLC Report Implementation of RDLC Report Concept of dataset,mapping in Report Practical Assighnment-6

Notes-6

Security

Login Control Authentication

Authorization

Practical Assighnment-7 Notes-7

ASP.NET AJAX with Toolkit

Know the role of AJAX AJAX in today’s Web world

Understand the role of the XMLHttp

Request object Learn the ASP.NET AJAX controls

Explore the ASP.NET AJAX client libraries

Use the Update Panel and the Update

Progress controls Build a Web site using the ASP.NET AJAX Control Toolkit

Practical

Assighnment-8

Notes-8

Other .NET Services

Interoperating with Win32 Interoperating with COM

Introduction of WCF

Basic concept of wcf Implementation of wcf Concept of protocol, bining Managing in web confi9 Practical Assighnment-9 Notes-9

Introduction of LINQ

Basic concept of linq Implementation of linq Lemda expression Practical Assighnment-10 Notes-10

Introduction of WPF

Basic concept of wpf Implementation of wpf Practical Assighnment-11 Notes-11

Introduction of Silverlight

Basic concept of Silverlight Implementation of Silverlight Practical

Assighnment-12

Notes-12