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