• Usages of . net
• D.N.A. Architecture
• One Tier
• Two Tier
• Three Tier
• N Tier

• CLR Architecture and Service
• The . Net Intermediate Language (IL)
• Just –in-time compilation and CLS
• Disassembling . NET application to IL
• Strict type checking

.NET FRAMEWORK CLASS LIBRARY

• System Namespace
• System. Object Namespace
• System. Collection Namespace
• System. Type
• Exception

SYNTAX AND DATA TYPE

LANGUAGE FUNDAMENTALS

• Data types and control constructs
• Declaring and initializing variables
• Value and reference types
• Unicode characters and strings
• C.T.S. Type
• Implicitly typed Local Variables
• Conditional Syntax
• Array
• Structure

CLASSES

• Encapsulating Attribute
• Defining Constructor
• Defining Method
• Overloading Method
• Overloading Methods and constructor
• Creating Property
• Defining read-only, write – only and indexer property
• Creating and using objects
• The memory allocation with new keywords
• Passing initial values with constructor
• Invoking method and property
• C# 3.0 Feature Object Initialization Expression
• C# 3.0 Feature Lambda Expressions Extension
• Methods and LINQ
• Anonymous Types in C# 3.0 Needed for LINQ
• Query execution

INHERITENCE

• Implementing inheritance hierarchies
• Constructor basic
• Method overriding
• Abstract class and Sealed class
• “ Is a “ Vs “has a” relations ship
• Exposing interface
• Implementation interface in a class
• Interface polymorphism
• Operator Overloading
• Class Access Modifiers
• Namespace

EVENTS AND DELEGATE

• Events overview
• Delegate and events relation
• User define events
• Delegate creations and types

COLLECTION

• Array List
• Hash Table
• Queue
• Stack
• Icollection interface
• Ienumarable interface
• Ienumerator interface
• Idictionaryenumerable interface
• Dictionary & Entry structure
• Boxing v/s Unboxing

GENERIC

• List
• Dictionary
• Stack
• Queue
• Name value collection
• String Dictionary
• Bitvector32

FILE HANDLING

• The system. IO Namespace
• Stream reader and stream write class
• File and directory class
• Path class
• Reading and writing a file

MULTITHREADING

• Namespace System.Threading.Thread
• Namespace System.Threading.Threadstart
• Thread safety concept
• Thread property and methods
• The life Cycle of a Thread
• Check Forllligle cross Thread call property
• Thread Synchronization

DATE & STRING METHODS

• Date Time class
• Date Time class methods and property
• String class methods and property

EXCEPTION HANDLING

• Introduction of Exception and there type
• Built in exception
• Trap execution with try. Catch. Finally
• Throw keyword
• Customizes message assignment
• Custom exception

FORM AND CONTROL

• Building windows form application
• Programming forms and control
• Design windows user interface Constructing MDI interface
• Implementing MDI parent and child Forms Implementing Menu strip, Tool
• Strip, Status, Trip, Rich Text Box, Tool tip, Error Provider Etc.
• Creating Custom Control

MEMORY MANAGEMENT

• Introduction of Memory management
• Garbage collection
• System.GC Namespace
• The Idisposable Pattern
• Suppressing Finalization
• Automating disposal with the using block

EVOLUTION OF ADO.NET

• How ADO.NET works and how it differs from ADO
• Evolution of ADO to ADO.NET

ADO.NET AND IT’S ARCHITECTURE

• The Connection Object
• The Command Object
• The Data Reader Object
• The Data Adapter Object
• Dataset
• Concurrency and the disconnected data architecture
• When to use the Dataset
• Provider

DATASET

• Creating table in Dataset
• Data Column
• Data Row
• Data Table
• Tables Events
• Saving Data set and changes with Command builder

CONNECTION AND COMMAND OBJECT

• Connection Object
• Understanding Connection Pooling
• Command Object
• ExecuteNonQuery
• Execute Scalar

DATA READER

• Reading data in connected mode
• Accessing value
• Execute reader method

DATA VIEW

• Row state filter
• Sort property
• Update records via a data view
• Insert records via a data view
• Delete records via a data view

DATA RELATION

• Creating Relation
• Public properties of data relation

ADDING CONSTRAINTS TO A TABLE

• Foreign key Constraint
• Unique Constraint
• Defining a primary key

SCHEMA

• Schema Type
• Missing Schema action Members

TRANSACTIONS

• Introduction of Transaction (Acid)
• Transaction Class
• Method and property
• Commit and rollback

WHAT IS ASP.NET, AN INTRODUCTION

INTRODUCING WEB FORMS

• What is ASP.NET Web Form?
• Writing your First Web Form page

INTRODUCING TO HTML CONTROL

• HTML Control Classes
• Implementing the controls

WORKING WITH SERVER CONTROLS

• Declaring Server Controls
• Manipulating Server Controls
• Handling Control Action Events
• Handling Multiple Control Action Events
• Performing page Navigation (Scenario 1)
• Performing page Navigation (Scenario 2)
• Http Request Class
• Http Response Class
• Http Server Utility Class

FORM VALIDATION SERVER CONTROL

• Introduction to Validation
• Types of Validation Controls
• Client-Side Validation
• Displaying Validation Errors
• Working with Compare Validator
• Working with Range validator
• Working with regular Expressions
• Performing Custom Validation

WEB FORMS CONTROLS

• Server Control
• Navigation Control
• Standard Control
• Introduction to User Controls
• Exposing User Control Properties
• Encapsulating Events in a User Control

DATA BINDING SERVER CONTROLS

• Data Binding Overview and Syntax
• Binding to simple properties
• Binding to Collection & Lists
• Binding Expressions or Methods
• Data Binder.Eval()

STATE MANAGEMENT

• State management: What’s the big deal?
• What are cookies?
• Http Session state class
• Application Class
• Using the Session
• Cleaning Up After Using Session State
• In-Process Session State
• Session State using a State server
• Storing Session State in SQL Server
• Application State Consideration
• Global.asax
• Web.Config

MASTER PAGE

• How Master Page Work
• Content Place holders
• Content Pages
• Advantages of Master Pages

SKIN AND THEME

• Cascading Style Sheets
• Scoping Themes
• Themes v/s Cascading Style Sheets
• Create a skin
• Apply a theme to a Web Site

CACHING

• Page Output Caching
• Page Fragment caching
• Data Caching
• Expiring items from the Cache

WEB SERVICES

• Introducing XML Web Services
• ASP.NET Web Services
• Accessing Web Services
• Write a simple Web Service
• Precompiled XML Web Services
• Consuming a XML Web Service from a Client Application
• XML Web Service type Marshalling
• Use data in XML Web Services
• The Web services Behavior

ASP.NET AJAX

• Why use ASP.Net AJAX features
• Architecture of AJAX features in ASP.Net
• Creating an ASP.NET AJAX enabled Web Site
• Understanding and working with Update panel
• Understanding the benefits of the Update panel control
• Understand update progress
• Creating an AJAX enabled Web Services

SECURITY

• Windows
• Form
• Passport
• Login Control
• Administrative site

GLOBALIZATION AND LOCALIZATION

• Understand Culture and UI Culture
• The initialize culture method
• Set the culture and UI Culture for ASP.NET web page

XML

• What is XML?
• XML Document Structure and Syntax
• System.xml name space
• Xml documentation, xmlreader, xmlnode, xmlnodelist, xmlwriter, classes
• Reading and writing a xml file

CRYSTAL REPORT

• Crystal Report Overview
• Getting start with Crystal report
• Creating Basic report
• Working with sub report
• Integration with windows Application
• Customizing Appearance and layout of report viewer
• Creating XML Report Web services
• Working with . NET data
• Adding a database or table to a report
• Working with Ado. Net
• Formulas and Logic

REMOTING

• Introduction
• Remoting Architecture and NET Remoting Scenarior
• Creating .NET Remoting Objects
• Hosting a remote object
• Activation type
• Marshal Object
• Creating and using channel

REFLACTION

• Introduction of reflection
• The Core Reflection Classes
• Assembly Class
• Method info class
• Property info class
• Browsing and Querying Members
• Invoking Methods and Setting Fields and Properties

ASSEMBLY AND DEPLOYMENT

• Manifests and Assemblies
• DLL Hell problem
• Private v/s Shared Assemblies
• Assigning Version
• The Global Assembly cache
• Strong name Creation
• Deployment of assembly

QUERY WINDOW

• The foundation statements of T-SQL
• Started with SELECT statement
• Adding data with the INSERT statement
• Changing what you have got with the UPDATE statement
• The DELETE Statements

JOINS

• Inner Joins
• Outer Joins
• Cross Joins

THE UNION

THE CREATE STATEMENT

• Create database
• Create Table

THE ALTER STATEMENT

• Alter database
• Alter table

THE DROP STATEMENT

CONSTRAINTS

• Types of constraints
• Domain Constraints
• Entity Constraints
• Referential Integrity Constraints
• Constraint Naming
• Key Constraints
• PRIMARY KEY Constraints
• FOREIGN KEY Constraints
• UNIQUE Constraints
• CHECK Constraints
• DEFAULT Constraints
• Disabling Constraints

RULES

• Default
• Determining Which tables and data types use a
• Given rule or default
• Triggers for data Integrity
• Choosing what to use

ADDING MORE TO OUR QUERIES

• What is a sub queries?
• Building a Nested sun query
• Correlated sub queries
• How correlated sub queries work
• Correlated sub queries in the WHERE clause
• Dealing with NULL data- the ISNULL function derived tables
• The EXIST operator
• Using Exists in other ways
• Mixing data types: CAST and CONVERT

UNDERSTANDING INDEXES

• How data is Accessed in SQL Server
• Creating, Altering and Dropping Indexes
• The CREATE INDEX statement

VIEWS

• Simple Views
• Views as filters
• More complex views
• Editing Views with T-SQL
• Dropping Views

STORED PROCEDURE

• Basic Syntax
• Changing Stored Procedures with ALTER
• Dropping Sprocs
• Handling Errors

TRANSACTION

• BEGIN TRAN
• COMMIT TRAN
• ROLLBACK TRAN
• SAVE TRAN

TRIGGERS

• What is a Trigger?
• With Encryption
• The For| after v/s The Instead of clause
• With Append
• Not for replication
• Using Triggers for Data Integrity rules
• Dealing with requirements Sourced from other tables
• Using Triggers to check the Delta of an Update
• Using triggers for Custom Error Message
• Other Common Uses for Trigger
• Other Trigger Issues.
• Triggers can be Nested
• Triggers can be Recursive
• Dropping Triggers

USING XML

• Retrieving XML by Using FOR XML
• Shredding XML by using OPEN XML
•   Introducing XQuery
• Using the XML Data type

OTHER ADVANCE TOPICS

• Create databasesand database files
• Create data types and tables3
• Use XML- related features in Microsoft SQL Server 2005
• Plan , Create and optimize indexes
• Implement data integrity in MS-SQL Server 2005 databases
• By using Constraints
• Implement data integrity in MS-SQL Server 2005
• By using triggers
• Implement Views
• Implements stored procedures
• Implement Functions