.Net Placement Oriented IT Training

I. Visual C#

Introduction to .Net

• .Net Framework
• Features of .Net
• Common Type System
• Common Language Specification
• Common Language Runtime
• MSIL
• Base Class Library
• Assemblies
• Garbage Collection
• Stack and Heap
• Architecture of GC
• Application Domain

.Net Framework 3.0 and 3.5 features

• WPF - Windows Presentation Foundation
• WCF - Windows Communication Foundation
• WWF - Windows Workflow Foundation
• Silver light
• Multi-Targeting
• Multi Framework Support
• LINQ

.Net Framework 4.0 features

• Cloud
• ASP.NET MVC web application
• Sharepoint Project
• Silverlight project

.Net Framework 4.5 features

• Metro UI application Develoopmen
• Gaming applications
• HTML5 and CSS 3 integration
• Semantic code analysis

Visual C# Language

• Introduction to VC#
• Features of VC#
• Data Types
• Value Types and Reference Types
• Type Conversion
• Boxing and UnBoxing
• Basic Programming constructs
• Statements & Expressions
• Methods, Arrays
• Structures and Enumerations

Object Oriented Programming with VC#

• Classes and Objects
• Interface
• Data Encapsulation, Data Abstraction
• Fields and Properties
• Access Modifiers
• Abstract Classes and Sealed Classes
• Constructor and Destructor
• Static and Instance Members
• Inheritance
• Method overloading and overriding
• Operator Overloading
• Delegate – Unicast and Multicast
• Event Handling
• Collection,Dictionaries,String,String builder
• Indexers
• Attributes, Namespaces,Generics
• Anonymous methods, Iterators
• Partial Types
• Nullable Types

GUI Application Development

• Windows Forms
• Controls, their properties and Events
• Programming with Advanced controls
• Creating User Defined Controls

Error Handling

• Structured Error Handling
• Debugging the application
• Dubug and Trace classes

ADO.NET

Introduction to ADO.NET

• ADO.NET Architecture
• ADO.NET managed providers
• Connection and Command Objects
• DataReader
• DataAdapter and DataSet
• DataRelations and DataSet
• Connected and Disconnected Environment
• Connection Pooling
• ADO.NET Exceptions
• using Stored Procedures
• N-tier Application
• ADO.NET and XML
• LINQ
  • Linq to object
  • Linq to sql
  • Linq to XML
• ADO.NET Entity Framework
• Object Relational Mapping

XML

• XML basics
• System.Xml Namespace
• Classess related to XML
• XML derived technologies-

XSD,XSL,SOAP,WSDL

File Handling

Multi Threading

• Thread Life Cycle
• Thread Synchronization

Assemblies

• Introduction to Assemblies
• Disadvantages of COM
• Creating Private and Shared Assemblies
• Strong name, GAC, COM Interoperability
• Satellite Assembly

.Net Remoting

• Distributed Architecture
• Remoting & Web Service comparison
• DCOM
• Drawbacks of DCOM
• Channels, Formatters, Activation

Windows Services

• Service Base Class
• Service Installer
• Service Process installer
• Installutil utility

Crystal Reports

• Crystal Reports – Reporting tool
• Different versions of crystal reports
• Developing a crystal Report

Setup and Deployment

Windows Communication Foundation

• Introduction
• Contracts
• Security
• Using different protocols etc

II. ASP.NET 4.5

Introduction to Web Application

• About Web Server
• IIS Web Server 7.0
• Web Support Languages
• Web Browsers
• About Http,TCP/IP, LAN, WAN
• Scripting and Its Importance
• Client-side and Server side Scripting
• HTML
• Java Script
• CSS
• JQuery

Overview of .NET

New Web Features in VS.NET 2010 and

VS.NET 2012

Active Server Pages.Net

• Moving from ASP to ASP.NET
• ASP.NET Namespaces
• ASP.NET – New Scenario in Development
• Process with IDE-VS.NET IDE
• Web Pages to Web Forms
• HTML Controls
• ASP.NET Controls

ASP.NET Web Forms

• Introduction to Web Forms, Worker process
• Applying styles to controls, themes, skins
• Server control Form
• Page Directive
• Separating code and Design
• New code behind techniques
• Implementing asp.net server controls
• Validation controls

Cookies

• Defining and using collection of cookies
• Limitations of cookies

ADO.NET for Web Application

• XML, XML to HTML & Database
• XML Schema Definition tool
• Overview of ADO.NET/XML support for .NET
• Retrieve data using DataSets
• Data Adapters
• Understanding Data Tables
• Build Data Table Programmatically
• Filter and Sort Data Table
• Parameters with command object

Bound Controls in ASP.NET

• Data Source controls
• Repeater
• Bind data to drop down list
• DataList control
• Form View and Details View
• Grid View – Paging, Sorting,Editing,Deleting, Runtime Fields, Empty Data Rows etc

ASP.NET Error Handling & Debug

• Page level error handling
• Application level error handling
• Debug using CLR debugger

User Controls

Master Pages

Configuring ASP.NET application

• Web Application Configuration
• Web Application Machine configuration
• Global Assembly Cache
• Working with AssemblyInfo
• Web .config

ASP.NET web applications

• About Session and Application object
• Using the Global.asax file
• Managing Application State
• Http Handlers
• Application and session variable
• Application and session events
• Cache services
• Caching overview
• Advantages of Caching
• Page output caching
• Page data caching
• Fragment Caching

Security

• Authentication and Authorization
• Windows, Forms,Password authenication
• Authoring users and Roles
• User Account Impersonation

ASP.NET XML Web Services

• Introducing XML web Services
• Difference between DCOM/Remoting/Web services
• ASP.NET Web Services
• Xml web services

stack,SOAP,WSDL,UDDI,Sync and Async Calls

• Using Data in Web services
• Using Objects and Intrinsic

Windows Commmunication Foundation

WEB PARTS

• Content Web Part
• Catalog Part
• Editor Part
• Web Part Verbs

Mobile Applications

• Mobile Forms
• WAP, WML overview
• MS mobile explorer
• Open Wave Simulator
• Device Applications

Crystal Reports in ASP.NET

ASP.NET 3.5 Features

• ASP.NET AJAX
• New ListView and DataPager Controls
• LINQ
• WCF Support for RSS, JSON, POX and Partial Trust
• Plain Old XML (POX)
• JavaScript Object Notation (JSON)
• Really Simple Syndication (RSS).
• ASP.NET Merge Tool
• New Assemblies

ASP.NET MVC 4

ASP.NET 4.0 & 4.5 features

Introduction to ASP.NET MVC

Complete ASP.NET AJAX

SilverLight

Setup and Deployment

III. ASP.NET MVC 4:

1) ASP.NET MVC

• Introduction

2) MVC Basics

• * Controller
• * Action Methods
• * View
• * Model
• * MVC Architecture
• * View Engine
• * Razor View Engine & Syntaxes
• * Execution Flow of MVC

3) Layout Views

4) HTML Helpers

5) Working with Forms in MVC

6) Scaffold Templates

7) CRUD (Create, Retrieve, Update, Delete Operations on a db table)

8) Validations in MVC

9) Data Annotations

10) Partial Views

11) Action Filters

12) URL Routing

13) jQuery-AJAX in MVC

14) Return Types of Action Methods

15) What's new in MVC 4:

• * Bundling and Minification
• * jQuery Mobile Integration
• * Web API

16) NuGet Package Manager in MVC 4

17) ASP.NET MVC 5 features

IV. SQL SERVER 2014

• Concepts
• • Database concepts
• RDBMS Concepts
• Data Models
• Constraints
• Normalization- 1NF,2NF,3NF,BCNF etc
• ER Diagrams

Sql Server Concepts

• Introduction to Sql Server 2008 R2
• Sql Server 2008 Features
• Server types
• Editions
• Components
• Management Studio
• T-SQL Features
• New Operators
• DML Statements

T-SQL

• DDL
• Data Types
• System Defined data types
• User defined Data
• Create/modify/delete tables
• Create/modify/delete tables
• Operators
• DML
• DCL
• Using Select Statement

Maintaining Database Integrity

• Constraints
• Rules
• Entity Integrity
• Domain Integrity
• Referential Integrity

Sub Queries

• Built-in function
• Nested sub queries
• Correlated sub queries
• Derived tables
• Recursive queries
• Common table expression
  Joins
• Cross join, inner join, self join, outer join

Indexes

• Types of Indexes
• Creating indexes
• Modifying indexes
• Dropping indexes

Views

• About View
• Creating Views
• Altering Views
• Materialized views
• Distributed view

Stored Procedures

• Advantages
• System stored procedures
• Extended stored procedures
• Parameter handling

User Defined functions

• Returning scalar value
• Returning table of data
• Deterministic functions
• Non deterministic functions
  Triggers
• Constraints Vs triggers
• After triggers
• Instead of Trigger
• DDL triggers
• Altering and Dropping Triggers

Cursors

• Select Vs Cursors
• Types of Cursors
• Creating Cursors
• Open/fetch/close cursors
• Using cursors in Stored

procedures and Triggers.

• Microsoft .NET Frame Work Integration
• CLR integration
• UDA
• UDF
• Stored Procedures
• Triggers

Transactions and locks

• ACID properties
• Implicit Transactions
• Explicit Transactions
• Transaction process
• Concurrency problems
• Lock Types
• Distributed Transactions
• Dead Locks

Data Transformation services

• BCP
• DTS

Administrative tasks

• Creating database
• Copy, maintaining database
• Security concepts
• Schemas, permissions
• Backup and Restore

database

• Sql Server Agent
• Sql Server Profiler
• Database Engine Tuning Adviser

Sql Server Management Objects

• Programming with SMO
• Connecting to Sql Server
• Scripting
• XML in Sql Server Working with Images

Introduction to MS- BI

• SSRS
• Standard, Ad- hoc Embedded Reports
• SSIS
• SSAS

Sql Server 2012 Features

• • Sequence
• OFFSET and FETCH
• WITH RESULT SETS in stored procedure
• THROW in triggers
• Sql Server 2014 features

V. Windows Communication Foundation (WCF)

• .Net Remoting
• Xml web services
• Xml web services Vs. Wcf Service
• WCF Overview
• SOA Overview
• Design goals of SOA
• WCF Architecture
• WCF concepts
• Addresses
• Contracts
• Bindings
• Hosting
• Clients
• Contracts
• Service contracts
• Operation Contracts
• Data Contracts
• Message Contracts
• Implements Contracts
• Configuring Services
• Hosting Services
• Self Hosting, Hosting in IIS and WAS Hosting
• Hosting using configuration
• Creating and binding using end points
• Using behavior configuration
• Securing services
• Sessions, Instancing and concurrency
• Building Clients
• Building client applications
• Using Configuration files
• Calling operations asynchronously
• Client runtime behaviors
• Securing clients
• ADO.NET EDM in WCF
• LINQ in WCF
• AJAX enabled WCF service
• Faults
• Errors and exceptions
• Fault Contracts
• Error handling Extensions
• Transactions
• Security
• Transport and Message security
• Bindings and Security
• Authentication and authorization
• Security techniques using TCP based wcf service
• Security techniques using HTTP base wcf service
• Queues and Reliable Sessions
• Introduction to MSMQ
• Queueing in wcf
• Overview or Reliable Sessions
• REST
• WCF Service in ASP.Net mvc
• Web application.
• WCF 4.5 features
• Improved intellisence support in vs.net 2012
• New Https protocol mapping in IIS
• Multiple authentication support for single endpoint
• UDP (user datagram protocol) endpoint support
• Web Socket support
• Data Services