Best Training in Chennai

Accord Info Matrix is a Chennai based Software Firm. Our main focus areas are Software Training and Software Development. Accord started with the ambitious aim of providing QUALITY training to Students and Corporate. We are integrated as an organization of talented trainers having extensive expertise in all facets of providing quality training.




Core Dotnet Syllabus

C#.NET(Topics & Contents)


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 Syllabus

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