Online Dotnet Training

C#.NET(Topics & Contents)-30 Hrs

DotNet Introduction(1 Hrs)

- DotNet vs Java vs Php
- Types of Languages
- Types of Applications
- DotNet Introduction
- DotNet Applications
- DotNet Features
- DotNet Architecture
- DotNet Executions
- DotNet Components
- Sample programs in console application

C# Introduction(2 Hrs)

- C# Introduction
- C# Datatypes (Value types, Reference types)
- C# Operators (Arithmetic, Relational, Logical, Bitwise, Assignment, Misc)
- C# Statements - Decision Making Statements - simple if - if else - else if - nested if - switch
- Looping Statements - for - while - do while - foreach
- Uncondition Statements - break - continue - goto
- C#.NET Controls - Button - TextBox - Label - RadioButton - CheckBox - ListBox - ComboBox - RichTextBox - MaskedTexBox - DateTimePicker - GroupBox - Panel - Timer - ProgressBar - etc.,

Array and Types(1 Hrs)

- Array - Array Introduction
- Array Category - Rectangler Array - Jagged Array
- Array Types - One Dimensional Array - Two Dimensional Array - Multi Dimensional Array
- Structure - advantages - (ex) - disadvantages
- Enum - advantages - (ex)

Logical Programs (3 Hrs)

- Number Programs(5Programs)
- Array Programs(5 Programs)
- String Programs
- Pattern Programs

Funcion & Types(2 Hrs)

- Function Introduction
- 4 types - W/o Arguments w/o ReturnType - W Arguments w/o ReturnType - W/o Arguments w ReturnType - W Arguments w ReturnType
- Nested calling function
- Recursive function
- Function Passing Parameter - Option Parameter or Default Parameter - Named Parameter - Call By Value - Call By Reference (ref keyword) - Returning more tn one value (out keyword) - Passing array values (params keyword)
- Array Inbuilt functions
- String Inbuilt functions
OOPS Concepts(6 Hrs) - OOPS - OOPS Introduction
- Advantages
- Features - Class - Object - Abstraction - Encapsulation - Inheritance - Polymorphism
- Sample Project using OOPS (class, object)
- Accessing Private members outside from the class - Property (4 types) - Methods - Constructor
- Constructor - Default Constructor - Parametrized Constructor - Copy Constructor - Static Constructor - Private Constructor
- Destructor
- Keywords - static - const - readonly - is - as - base - this - dynamic - var
- Inheritance and Abstraction - Single Inheritance - Multilevel Inheritance - Multiple Inheritance - Hierarchical Inheritance - Hybrid Inheritance - Why C# does not support Multiple Inheritance (collision problem) (ex) - How to achieve Multiple Inheritance (Interface) (ex) - Class vs Interface - Interface sample program (ex) - Achieving Multiple Inheritance using Interface (ex) - Avoid collision problem using interface (ex) - Abstract class sample program (ex) - purpose of Interface - purpose of Abstract class - Interface vs Abstract class - Diamond problem (ex)
- Polymorphism - Method hiding (shadowing)
- Static Polymorphism - program with single class - program with two classes
- Dynamic Polymorphism - program with virtual keyword - program with abstract keyword
- Encapsulation - Properties (Auto Impemented Property) - Access Specifiers - Private - Protected - Internal - Internal Protected - Public
- Types of classes - Abstract class - Nested class - Partial class - Sealed class - Static class

SQL Server Introduction (3 Hrs)

- Database Introduction
- Sql Queries
- DDL (Create, Alter, Drop, Truncate, Rename)
- DML (Insert, Delete, Update)
- DQL (Select, Merge)
- DCL (Grant, Revoke)
- TCL (Commit, Rollback, SavePoint)
- SELECT - Comparision operator(<,>,<=,>=,<>,!=) - AND, OR, NOT, IN, BETWEEN, LIKE, TOP, DISTINCT - Aggregate functions(COUNT, SUM, AVG, MIN, MAX) - Clauses (Order By, Group By, Having) - Sub Queries (ANY, ALL) - Set Operators (UNION , UNION ALL)
- DateTime Inbuilt functions
- String Inbuilt functions
- Ranking Functions

Constraints & Joins

- Constraints - Primary Key - Unique Key - Not Null - Check - Default - Foreign Key - Composite Key
- Setting constraints when creating tables
- Setting constraints after creating tables
- Joins - Inner Join - Left Join - Right Join - Full Join - Cross Join - Self Join

Advanced SQL( 3 Hrs)

- Functions - Scalar Function - Inline Table Valued Funtion
- Stored Procedure - Without Parameter Without ReturnType - With Parameter Without ReturnType - Without Parameter With ReturnType - With Parameter With ReturnType - Writing multiple queries in a single Stored Procedure
- Triggers - After Triggers (Insert, Delete, Update) - Instead of Triggers (Insert, Delete, Update) - Magic Tables
- Index - Clustered Index - Non Clustered Index
- View - ex - advantages

ADO.Net Introduction(3 Hrs)

- ADO.NET - ADO.NET Introduction
- ADO.NET Architecture
- ADO.NET Object - Connection Object - Command Object - DataReader Object - DataSet Object - DataAdapter Object - DataTable Object
- ADO.NET Connectivity - com.ExecuteNonQuery() - com.ExecuteReader() - com.ExecuteScalar() - DataReader example - DataAdapter example - INSERT, DELETE, LOAD, UPDATE, VIEW - ComboBox data filling - GridView data filling

Class Library, File Handling, Exception Handling,Multi Threading(3 Hrs)

- Class Library - create assembly file (.dll) (ex) - using assembly file in another project - .dll vs .exe
- Exception Handling - Types of error - keywords - try - catch - throw - finally - user defined exceptions (ex)
- MultiThreading - Threading - Thread states - Thread priorities - example program
- File Handling - Files and streams - File modes - File Access - Code of Create, Write, Read, Delete, Open

Delegates,Collections,Generics(2 Hrs)

- Delegates - Simple Delegate program - Multicast Delegate program
- Events - Event sample program - Delegate with event program
- Collections - Disadvantages of Array
- Advantages of collections
- Collection classes - ArrayList - HashTable - SortedList - Stack - Queue - BitArray
- Disadvantages
- Generics - Advantages
- Generic classes - List - HashSet - SortedSet - SortedList - SortedDictionary - Dictionary - LinkedList - LinkedListNode - Stack - Queue

Crystal Report(1 Hr)

- Real Time Windows Project Explanation
- Crystal Report
- Example of Csrystal Report

Advanced Dotnet Training

ASP,AJAX,MVC(30 Hrs)

Introduction to ASP.NET( 2 Hrs)

- Web Technology Basics
- WebPage
- Static WebPage
- Dynamic WebPage
- HomePage
- WebBrowser
- WebApplication
- WebSite
- Intranet
- Internet
- Responsive Application
- Rich Internet Application
- URL
- IP Address
- Protocol
- ASP.NET Introduction - Points about ASP.NET
- ASP.NET Architecture - have to explain with diagram
- Basic Concepts (with partical examples) - PostBack
- AutoPostBack
- IsPostBack
- CrossPagePostBack
- RoundTrip
- Response.Redirect
- Server.Transfer
- ASP.NET Page Lige Cycle Event Order - Events order have to explain
- Standard Controls

Validation Controls(2 Hrs)

Standard Controls - Label
- Button
- TextBox
- DropDownList
- ListBox
- Calendar
- Image
- ImageButton
- HyperLink
- LinkButton
- FileUpload
- Literal
- RadioButton
- RadioButtonList
- CheckBox
- CheckBoxList
- MultiView
- View
- Wizard
Validation Controls - RequiredFieldValidator
- RangeValidator
- RegularExpressionValidator
- CompareValidator
- Validation Summary
- Custom Validator
Property uses (have to tell the use of these properties) - ValidationGroup in validation controls
- CausesValidation in button

Sql Command Parameter(2 Hrs)

ASP.NET Login Form - have to create ASP.NET login
Sql Injection - Hacking Technique (we have to hack and show our code is not secure)
To Avoid Sql Injection - Sql Command Parameter (with example)
- Stored Procedure
Stored Procedure in ASP.NET - 4 types with examples
Rich Data Controls(2 Hr) RichDataControls - GridView
- DetailsView
- FormView
- DataList
- ListView
- DataPager
- Repeater
Dashboard - What is Dashboard?
- have to tell how to use richdatacontrols in DashBoard Page
GridView - Perform INSERT, DELETE, UPDATE operation in GridView manually
DSRC company Task - Tell 5 tasks asked in DSRC company
- Perform 2 tasks

State Managements(3 Hrs)

StateManagement - tell what is the purpose of state management
Client Side Techniques - ViewState
- Cookies
- QueryString
- HiddenField
- ControlState
Server Side Techniques - Session
- Application
Global.asax file - tell the use of Global.asax file
Security using WAT tool( 1 Hrs) - tell how to create websites with Security
- steps in security
- Authentication - Authorization - Authenticatio Modes
- Windows - Forms - Passport - tell about WAT tool
- tell about ASP.NET Login controls
- steps for ASP.NET security using WAT tool

Master Pages, Web User Control, Themes and Skins(2 Hrs)

Master Page - purpose of Master Page
- simple example for Master Page
- Nested Master Page example
Web User Control - purpose of Web User Controls
- example for creating user controls
Themes and Skins - purpose of Themes and Skins
- two types of skins files
- example for default skin
- example for named skin

Caching and tracing( 2 Hrs)

Caching - purpose of Caching
- types of Caching
- example of Page Caching
- example of Partial Caching
- example of Application caching
Tracing - purpose of Tracing
- types of Tracing
- example of Page level tracing
- example of Application level tracing

XML with ASP.NET(3 Hrs)

XML

- purpose of XML
- HTML vs XML
- XML to Web Form (example)
- Web Form to XML (example)
- XML to DB (example)
- DB to XML (example)

DTD

- purpose of DTD
- example for XML with DTD

XSLT

- purpose of XSLT
- example for XML with XSLT

XML Schema

- purpose of XML Schema

Web Service

- What is Web Service
- Advantages of Web Service
- Real Time examples of Web Service
- Tell about WSDL, UDDI
- Web service return 1 values (example)
- web service returning multiple values (examples) (use collection conecpt)
- Tell about ProxyServer
- Updating WebService

AJAX (3 Hrs)

Introduction to AJAX
Advantages of AJAX
AJAX Extension Controls
Introduction to AJAX Toolkit Controls
Examples using Ajax toolkit Controls

MVC(Model View Controller)-8 Hrs

Introduction to ASP.Net MVC and ARCHITECTURE
Selectors, Action Filters and Layouts
State Management in MVC
Razor View and HTML Helper Class
MVC with Entity Framework