Asp.Net Course

C# AND .NET

Introduction

Evolution of Microsoft . Net

Architecture of Microsoft . Net

Introduction to . Net Framework 4.0

Assembly in .Net-Types of Assembly

The Framework Class Library

Introduction to Visual Studio .Net

LANGUAGE FUNDAMENTALS

Comments and Documenting

Syntex Comparison of C# and VB.NET

Data Types (Value types, Reference types)

Variables

Operators

Conditional Statement

Looping Structure

Functions

LANGUAGE FEATURES

Boxing and Unboxing

Arrays (One Dimentional, Two Dimentional

Multi Dimentional)

Structures

Enumerations

CLASSES AND OBJECT

Object Oriented Programming

Constructors

Inheritance

Polymorphism

Namespaces

Interface

Creating a Class Library- dll Files

EXCEPTION HANDLING

Defining Exception

Understanding Try and Catch Keywords

Creating User Defined/Custom Exception

FILE HANDLING

Understanding Streams

Working with System.IO namespace

Working with Files, Directory

THREADING

Understanding Thread & Process

Difference between Single & Multi Thread Application

Creating Thread, Thread Methods

GENERICS & DELEGATES

Introduction to Generics

Introduction to Delegates

ADO.NET

DATA ACCESS & DATA BINDING

ADO.NET Overview

.Net Data Providers

Connected & Disconnected Architecture

Using Data Readers

Datasets

Data Tables

Data Adapters

ASP.NET

HTML & JAVASCRIPT

Basics of Html

Designing CSS & Implementation

Basis of Javascript

Javascript Validation

ASP.NET

What is ASP.NET?

Page Life Cycle

Page Layout

Working with Server Controls

Standard Controls

Validation Controls

Navigation Controls

Master Pages

DATA BINDING

Data Sources

Data Control (Gridview)

DataBinding with Controls

EXCEPTION HANDLING

Page Level Exception

STATE MANAGEMENT

Understanding State Management

Client Side Vs Server Side State Management

Viewstate

Session

SECURITY MECHENISM IN .NET

Introduction to Authentication & Authorization

Types of Authentication

JQUERY

Introduction to JQuery

Adding JQuery to asp.net pages

Handling events of controls through JQuery

JQuery Examples

JQuery Validations

AJAX

Introduction to AJAX

Implementing AJAX in Web Form

IIS DEPLOYMENT

SQL SERVER 2012

INTRODUCTION

What’s New in SQL Server?

SQL Server Editions

Internal of SQL Database

BASICS OF DATABASE

Normalization

Denormalization

Introduction to SQL Sever Management Studio

Creating Database

Data Types

Creating Tables

Primary Key Constraints

Foreign Key Constraints

Unique Key Constraints

Creating Constraints

Building Relations

Alteration of Table Design

Using Alter command

WRITING QUERIES

Insert queries

UPDATE queries

Union queries

DELETE queries

SELECT statement

The FROM Clause

The WHERE Clause

The ORDER BY Clause

Using GROUP BY and HAVING

Using Distinct

Using TOP N TOP N PERCENT

SELECT INTO queries

Truncate Table queries

Expressions

Joins

Inner Joins

Outer Joins

T-SQL

What is T-SQL?

Syntax Conventions

Executing SQL Statements

Identifiers

Operators

Variables

Aggregate Functions

Scalar Functions

Date Functions

Sub-queries

If-else Statements

While loop Statements

Try-catch Statements

Writing stored procedure

Writing functions

ViEWS and Triggers

Introduction to view

Types of view

Create view

Alter view

Drop view

Creatind DML Triggers

Altering DML Triggers

Using the Inserted and Deleted Tables

Advanced sql-Server

Transactions

Cursors

Error Handling

Run Time Error Handling

Indexing

Profiling

Security

Introduction

Evolution of Microsoft . Net

Architecture of Microsoft . Net

Introduction to . Net Framework 4.0

Assembly in .Net-Types of Assembly

The Framework Class Library

Introduction to Visual Studio .Net

LANGUAGE FUNDAMENTALS

Comments and Documenting

Syntex Comparison of C# and VB.NET

Data Types (Value types, Reference types)

Variables

Operators

Conditional Statement

Looping Structure

Functions

LANGUAGE FEATURES

Boxing and Unboxing

Arrays (One Dimentional, Two Dimentional

Multi Dimentional)

Structures

Enumerations

CLASSES AND OBJECT

Object Oriented Programming

Constructors

Inheritance

Polymorphism

Namespaces

Interface

Creating a Class Library- dll Files

EXCEPTION HANDLING

Defining Exception

Understanding Try and Catch Keywords

Creating User Defined/Custom Exception

FILE HANDLING

Understanding Streams

Working with System.IO namespace

Working with Files, Directory

THREADING

Understanding Thread & Process

Difference between Single & Multi Thread Application

Creating Thread, Thread Methods

GENERICS & DELEGATES

Introduction to Generics

Introduction to Delegates

ADO.NET

DATA ACCESS & DATA BINDING

ADO.NET Overview

.Net Data Providers

Connected & Disconnected Architecture

Using Data Readers

Datasets

Data Tables

Data Adapters

ASP.NET

HTML & JAVASCRIPT

Basics of Html

Designing CSS & Implementation

Basis of Javascript

Javascript Validation

ASP.NET

What is ASP.NET?

Page Life Cycle

Page Layout

Working with Server Controls

Standard Controls

Validation Controls

Navigation Controls

Master Pages

DATA BINDING

Data Sources

Data Control (Gridview)

DataBinding with Controls

EXCEPTION HANDLING

Page Level Exception

STATE MANAGEMENT

Understanding State Management

Client Side Vs Server Side State Management

Viewstate

Session

SECURITY MECHENISM IN .NET

Introduction to Authentication & Authorization

Types of Authentication

JQUERY

Introduction to JQuery

Adding JQuery to asp.net pages

Handling events of controls through JQuery

JQuery Examples

JQuery Validations

AJAX

Introduction to AJAX

Implementing AJAX in Web Form

IIS DEPLOYMENT

SQL SERVER 2012

INTRODUCTION

What’s New in SQL Server?

SQL Server Editions

Internal of SQL Database

BASICS OF DATABASE

Normalization

Denormalization

Introduction to SQL Sever Management Studio

Creating Database

Data Types

Creating Tables

Primary Key Constraints

Foreign Key Constraints

Unique Key Constraints

Creating Constraints

Building Relations

Alteration of Table Design

Using Alter command

WRITING QUERIES

Insert queries

UPDATE queries

Union queries

DELETE queries

SELECT statement

The FROM Clause

The WHERE Clause

The ORDER BY Clause

Using GROUP BY and HAVING

Using Distinct

Using TOP N TOP N PERCENT

SELECT INTO queries

Truncate Table queries

Expressions

Joins

Inner Joins

Outer Joins

T-SQL

What is T-SQL?

Syntax Conventions

Executing SQL Statements

Identifiers

Operators

Variables

Aggregate Functions

Scalar Functions

Date Functions

Sub-queries

If-else Statements

While loop Statements

Try-catch Statements

Writing stored procedure

Writing functions

ViEWS and Triggers

Introduction to view

Types of view

Create view

Alter view

Drop view

Creatind DML Triggers

Altering DML Triggers

Using the Inserted and Deleted Tables

Advanced sql-Server

Transactions

Cursors

Error Handling

Run Time Error Handling

Indexing

Profiling

Security