.NET Certification Training

• Understanding .NET Framework
• .NET Framework Version History
• .NET Framework 4.5 Architecture
• Common Language Runtime (CLR)
• CLR Components
• Microsoft Intermediate language (MSIL)
• Common Type System (CTS)
• Common Language Specification (CLS)
• Relationship Between CTS and CLS
• Framework Class Library (FCL)
• Just-In Time Compilation (JIT)
• Types of JIT Compiler
• Normal JIT, Pre-JIT, Econo JIT

C# Programming Language

• Introduction to C#
• History of C# Version
• C# Advantages

Creating Your First C# Program

• Structure of a C# Program
• Basic Input / Output Operations
• Compiling, Running, and Debugging

Data Type

• Understanding Data Type
• Types of Data Type – Value Type & Reference Type

Variable & Typecasting

• Naming a variable
• Boxing and Unboxing
• Data Conversions – Implicit & Explicit
• Safe Type Casting with IS and AS Operator

Operators

• Different Types of Operators
• Operators precedence

Conditional Statements

• Introduction to conditional statement
• If statements
• If-else statement
• If-else-if ladder
• Switch statement

Loops

• Introduction to loop
• ..while loop
• while loop
• for loop
• foreach loop

Jump Statements

• break statement
• continue statement
• goto statement
• return statement
• throw statement

Arrays

• Introduction to Array
• One Dimensional Array
• Multi-Dimensional Array
• Jagged Array
• Array Class

Strings

• Introduction to strings
• Mutable strings
• Immutable strings
• Strings methods
• Verbatim String

Introduction to Object-Oriented Programming

• Object-Oriented Programming
• Classes and Objects
• Inheritance
• Polymorphism
• Abstraction
• Encapsulation

Class and Objects

• Creating a class
• Access Modifiers
• Instance members
• Creating an object

Constructor and Destructor

• Introduction to Constructor
• Types of Constructor
• Default Constructor
• Parameterized Constructor
• Introduction to Destructor
• Creating Destructor

Inheritance

• Introduction to Inheritance
• Types of inheritance
• Advantage of Inheritance
• Single Level Inheritance
• Multi-Level Inheritance
• Multiple Inheritance
• Hybrid Inheritance

Methods

• Introduction to Methods
• Method Parameters
• Value, Out, Ref, Params and Optional Parameters
• Methods Overloading
• Methods Overriding
• Method Hiding

Property

• Introduction to Property
• Uses of Property
• Types of Property
• Read-Write Property
• Read Only Property
• Write Only Property

Enum

• Introduction to Enum
• Creating Enum
• Using Enum

Exception Handling

• Understanding Exceptions
• Try, Catch and Finally block
• Throw exception
• Handling Exception
• Custom Exception

Attributes

• Introduction to attributes
• Creating attributes
• Custom attributes

Abstract Class

• Introduction to Abstract Class
• Creating Abstract class
• Need of Abstract class
• Advantages of abstract class

Interface

• Introduction to Interface
• Creating Interface
• Need of Interface
• Abstract class vs. Interface

Static Class

• Introduction to static class
• Creating static class and static methods
• Need of static class
• Normal class vs. Static class

Partial Class

• Introduction to partial class
• Creating partial class
• Need of partial class

Anonymous Type, Dynamic Type and Tuples

• Introduction to Anonymous Type
• Using Anonymous Type
• Introduction to Dynamic
• Using Dynamic Type

Anonymous Method and Lambda Expression

• Introduction to Anonymous Method
• Using Anonymous Method
• Introduction to Lambda Expression
• Types of Lambda Expression

Delegates

• Introduction to delegates
• Types of delegates
• Single Delegate
• Multicast Delegate

Events

• Introduction to events
• Creating Events
• Event Handler

Collections

• Introduction to .NET Collections
• Relations between Collection Interfaces and Classes

Collection classes

• ArrayList
• SortedList
• Dictionary
• Hashtable
• Stack
• Queue

Generics

• Understanding .NET Generics
• Generics Advantages
• Collections vs. Generics

Generics Collection Classes

• List<T>
• SortedList<TKey, TValue>
• Dictionary<TKey, TValue>
• Hashset<T>
• Stack<T>
• Queue<T>

SQL Server

• Understanding SQL Server
• SQL Server Version History
• Advantage of SQL Server

T - SQL

• Types of SQL Commands
• Creating Database
• Altering Database
• Deleting Database
• Creating Table
• Altering Table
• Deleting Table

SQL Keys, Commands and Clauses

• Types of SQL Keys
• Using SQL Commands
• Querying Database
• Delete vs. Truncate
• SQL Operators
• SQL Clauses

SQL Joins

• Types of Joins
• Inner Join
• Outer Join
• Cross Join
• Self-Join

Views

• Understanding Views
• Need of Views
• Creating, Altering and Dropping Views
• Simple and Complex Views

Functions

• Built-In Functions
• Scalar Functions
• Aggregate Functions
• Creating, Altering and Dropping Functions

Stored Procedures

• Creating, Altering and Dropping Procedure
• Optional Parameters
• Input and Output Parameters

Triggers

• Understanding Triggers
• Stored Procedures VS Functions VS Triggers
• Types of Triggers
• Creating, Altering and Dropping Triggers

Cursors

• Understanding Cursors
• Types of Cursors
• Using Cursors