.NET Course | .NET Training With Certification

C# Programming Language

1. Introduction to C#
2. History of C# Version
3. C# Advantages

Creating Your First C# Program

1. Structure of a C# Program
2. Basic Input / Output Operations
3. Compiling, Running, and Debugging

Data Type

1. Understanding Data Type
2. Types of Data Type – Value Type & Reference Type

Variable & Typecasting

1. Naming a variable
2. Boxing and Unboxing
3. Data Conversions – Implicit & Explicit
4. Safe Type Casting with IS and AS Operator

Operators

1. Different Types of Operators
2. Operators precedence

Conditional Statements

1. Introduction to conditional statement
2. If statements
3. If-else statement
4. If-else-if ladder
5. Switch statement

Loops

1. Introduction to loop
2. ..while loop
3. while loop
4. for loop
5. foreach loop

Jump Statements

1. break statement
2. continue statement
3. goto statement
4. return statement
5. throw statement

Arrays

1. Introduction to Array
2. One Dimensional Array
3. Multi-Dimensional Array
4. Jagged Array
5. Array Class

Strings

1. Introduction to strings
2. Mutable strings
3. Immutable strings
4. Strings methods
5. Verbatim String

Introduction to Object-Oriented Programming

1. Object-Oriented Programming
2. Classes and Objects
3. Inheritance
4. Polymorphism
5. Abstraction
6. Encapsulation

Class and Objects

1. Creating a class
2. Access Modifiers
3. Instance members
4. Creating an object

Constructor and Destructor

1. Introduction to Constructor
2. Types of Constructor
3. Default Constructor
4. Parameterized Constructor
5. Introduction to Destructor
6. Creating Destructor

Inheritance

1. Introduction to Inheritance
2. Types of inheritance
3. Advantage of Inheritance
4. Single Level Inheritance
5. Multi-Level Inheritance
6. Multiple Inheritance
7. Hybrid Inheritance

Methods

1. Introduction to Methods
2. Method Parameters
3. Value, Out, Ref, Params and Optional Parameters
4. Methods Overloading
5. Methods Overriding
6. Method Hiding

Property

1. Introduction to Property
2. Uses of Property
3. Types of Property
4. Read-Write Property
5. Read Only Property
6. Write Only Property

Enum

1. Introduction to Enum
2. Creating Enum
3. Using Enum

Exception Handling

1. Understanding Exceptions
2. Try, Catch and Finally block
3. Throw exception
4. Handling Exception
5. Custom Exception

Attributes

1. Introduction to attributes
2. Creating attributes
3. Custom attributes

Abstract Class

1. Introduction to Abstract Class
2. Creating Abstract class
3. Need of Abstract class
4. Advantages of abstract class

Interface

1. Introduction to Interface
2. Creating Interface
3. Need of Interface
4. Abstract class vs. Interface

Static Class

1. Introduction to static class
2. Creating static class and static methods
3. Need of static class
4. Normal class vs. Static class

Partial Class

1. Introduction to partial class
2. Creating partial class
3. Need of partial class

Anonymous Type, Dynamic Type and Tuples

1. Introduction to Anonymous Type
2. Using Anonymous Type
3. Introduction to Dynamic
4. Using Dynamic Type

Anonymous Method and Lambda Expression

1. Introduction to Anonymous Method
2. Using Anonymous Method
3. Introduction to Lambda Expression
4. Types of Lambda Expression

Delegates

1. Introduction to delegates
2. Types of delegates
3. Single Delegate
4. Multicast Delegate

Events

1. Introduction to events
2. Creating Events
3. Event Handler

Collections

1. Introduction to .NET Collections
2. Relations between Collection Interfaces and Classes

Collection classes

1. ArrayList
2. SortedList
3. Dictionary
4. Hashtable
5. Stack
6. Queue

Generics

1. Understanding .NET Generics
2. Generics Advantages
3. Collections vs. Generics

Generics Collection Classes

1. List<T>
2. SortedList<TKey, TValue>
3. Dictionary<TKey, TValue>
4. Hashset<T>
5. Stack<T>
6. Queue<T>

SQL Server

1. Understanding SQL Server
2. SQL Server Version History
3. Advantage of SQL Server

T - SQL

1. Types of SQL Commands
2. Creating Database
3. Altering Database
4. Deleting Database
5. Creating Table
6. Altering Table
7. Deleting Table

SQL Keys, Commands and Clauses

1. Types of SQL Keys
2. Using SQL Commands
3. Querying Database
4. Delete vs. Truncate
5. SQL Operators
6. SQL Clauses

SQL Joins

1. Types of Joins
2. Inner Join
3. Outer Join
4. Cross Join
5. Self-Join

Views

1. Understanding Views
2. Need of Views
3. Creating, Altering and Dropping Views
4. Simple and Complex Views

Functions

1. Built-In Functions
2. Scalar Functions
3. Aggregate Functions
4. Creating, Altering and Dropping Functions

Stored Procedures

1. Creating, Altering and Dropping Procedure
2. Optional Parameters
3. Input and Output Parameters

Triggers

1. Understanding Triggers
2. Stored Procedures VS Functions VS Triggers
3. Types of Triggers
4. Creating, Altering and Dropping Triggers

Cursors

1. Understanding Cursors
2. Types of Cursors
3. Using Cursors