Courses Offered: SCJP SCWCD Design patterns EJB CORE JAVA AJAX Adv. Java XML STRUTS Web services SPRING HIBERNATE  
     
 
.NET

Syllabus :

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