ASP.NET

MS.NET Framework Introduction

  • The .NET Framework - an Overview

  • Framework Components

  • Framework Versions

  • Types of Applications which can be developed using MS.NET

  • MS.NET Base Class Library

  • MSIL

  • The Common Language Runtime (CLR)

  • Managed Code

  • MS.NET Memory Management / Garbage Collection

  • Common Type System (CTS)

  • Common Language Specification (CLS)

  • JIT Compilers

Developing Console Application

  • Overview of VS2013

  • Introduction to Project and Solution in VS2013

  • Compiling and Building Projects

Language Basics

  • Datatypes

  • Common Type System

  • Reference Type and Value Type

  • Datatypes & Variables Declaration

  • Implicit and Explicit Casting

  • Casting between other datatypes

  • Boxing and Unboxing

  • Enum and Constant

  • Operators

  • Control Statements

  • Working with String

  • Working with Arrays

Introduction to Object Oriented Features

  • Object Oriented Programming- Overview

  • Encapsulation

  • Inheritance

  • Polymorphism

  • Understanding Polymorphism with Examples.

Programming Object Oriented – Encapsulation

  • Write a class and add field members to the class

  • Create an Object of the Class and understand the difference between object and reference.

  • Access the members of the object

  • Working with Methods

  • Working with Properties

  • Constructor & Destructor.

  • Working with "static" Members

Inheritance

  • Access Modifier

  • Protected Keyword

  • Constructor in Inheritance

  • Abstract Class

Interface & Abstract Class

  • What is Interface

  • Syntax for Implementation of Interface

  • Explicit Implementation of Interface members

  • Abstract Class vs. Interface

Exception Handling

  • What is Exception

  • Understanding & using try, catch keywords

  • Throwing exceptions

  • Importance of finally block

  • "using" Statement

Working with Collections

  • Using ArrayList and Hashtable.

  • Sorting Items in the collection

Working with Components / Assemblies

  • What is a DLL and how is it different from EXE

  • Types of DLL

  • About Assemblies

  • How to build a ClassLibrary?

  • How to use a ClassLibrary in another Application?

  • What is Namespace?

  • Shared Assembly

  • Private Assemblies

Data Access using ADO.NET

  • Session 1:

    • Introduction to SQL.
    • Evolution of ADO.NET
  • Session 2:

    • Creating Database using VS.NET
    • Establishing Connection with Database
  • Session 3:

    • Executing simple Insert, Update and Delete Statements
    • Executing Select Statement and using SqlDataReader
  • Session 4:

    • Prepared Statements
    • Stored Procedures
  • Session 5:Crystal Report

Data Access using ADO.NET – DataSet

  • What is Dataset?

  • Advantages of DataSet

  • Programming DataSet - Walkthrough

    • a.Fetching data using Fill methos of DataAdapter and filling data into Dataset to create a DataTable .
    • b.Working with DataView

Delegates

  • Introduction

  • Delegate Declaration

  • Sample Application

  • Anonymous Methods

ASP.NET:

Web Programming Introduction

  • Understanding role of Web Server and Web Browser.

  • Brief about HTTP Protocol.

ASP.NET Introduction & Sample Programs

  • How to create and run the first ASP.NET application.

  • Understanding the code generated by VS.NET.

  • Example Programs.

  • Understanding AutoPostBack.

  • Types of Server Controls

    • HTML controls.
    • Web Server Controls.
  • Exploring Server Controls.

Validation Controls

  • ValidationSummary

  • RequiredFieldValidator

  • CompareValidator

  • RangeValidator

  • RegularExpressionValidator

  • CausesValidation Property of Button

  • Grouping Controls for Validation

Applying Themes and Styles to Controls

  • Working with CSS

  • Using Themes to Customize a Site

  • Working with Master Page

ASP.NET Architecture

  • What is AppDomain

  • Life cycle of a WebForm when requested by a client.

  • How does a control manages its state

  • EnableViewState property

  • Event Handling in WebForms

Page Navigation Options

  • Response.Redirect

  • Server.Transfer

  • CrossPagePostBack property of Button

User Control

  • Creating a UserControl.

  • Adding a Usercontrol to the WebForm.

  • Register – Directive.

  • Loading UserControl Dynamically.

ASP.NET State Management

  • Need for state management

  • ViewState

  • HiddenField

  • QueryString

  • HttpContext

  • HttpCookie

  • HttpSessionState

  • HttpApplicationState

Databound Controls

  • GridView

  • DetailsView

  • FormsView

  • DataList

  • Repeater

  • ListView

Creating Virtual Directory & Web Application

  • What is Web Applications & Virtual Directory

  • Using VS.NET creating Web Application with Location as IIS.

  • How to create a Virtual Directory & Web Application in IIS

  • Advantages of Web Application

Web Caching

  • Overview of Caching

  • Basic Implementation

Authentication & Authorization

  • Authentication & Authorization

  • Windows Based Authentication

  • Form Based Authentication

  • Authorizing Users and Roles

AJAX.NET

  • Why AJAX

  • Using AJAX.NET Controls

    • Accordion
    • Calendar
    • CascadingDropDown
    • CollapsiblePanel
    • FilteredTextBox
    • NumericUpDown
    • ModalPopup
    • PopupControl

SQL SERVER:

SQL Server Management Studio –Overview

  • Create Database

  • Restore Database

  • Backup Database

  • Create Table

  • Delete Table

  • Drop Table

  • Truncate Table

  • Create Index

Structured Query Language:

  • DML & DDL

  • Create Database, Drop Database using query

  • Create table, Delete Table, Truncate Table, Drop Table using Query

  • Alter table, Alter Colum, Add Column, Delete Column using query

  • Basic CRUD(Create, Read,Update,Delete) Statement using query

  • Case statement in SQL query

JOINS:

  • Inner Joins

  • Outer Joins

  • Left Outer Joins

  • Right Outer Joins

  • Self Joins

  • Cartesian Products

  • Union & Union All

Stored Procedure:

  • Create Stored Procedure

  • Read Stored Procedure

  • Update Stored Procedure

  • Delete Stored Procedure

  • Parameterized Stored Procedure(input, Output)

  • Handling Return value in Stored Procedure

  • Writing Some complex Stored Procedure

UDF (User Defined Function):

  • Inline Function

  • Scalar function

  • Table Valued Function

  • Difference b/n Stored Procedure & UDF

Index:

  • Types of Index(Clustered, Non-Clustered)

  • Create Index

  • Unique Index

  • Composite Index

  • Difference between Clustered & Non-Clustered Index

Trigger:

  • Trigger Overview

  • Types of Trigger

  • Basic Example

Other Important Topics:

  • Built in Function

  • System Stored Procedure

  • Pros & cons of Views

  • Using Database Transaction

  • Primary Key Constraint

  • Foreign Key Constraint

  • Unique key vs. Primary Key

  • Alternate Key, Candidate key, composite key

It's only fair to share...Share on Google+Pin on PinterestTweet about this on TwitterShare on Facebook