Essential Concepts for a .NET Programmer

• C-Sharp(course-outline)

• Basic Language features of C#

• .Net Framework Introduction

• T-Sql basic language features

• Interface.

• Classes.

• Console Application.

• Enumeration.

• Properties.

• Events.

• Access modifiers.

• Delegates.

• Language-Features.

• Generics.

• Linq.

• Extension Method.

• Lamda Expression.

• Anonymous Function & Type.

• Collections.

• Collection Intializers.

• Collection-Dictionary.

• Array List.

• Parallel Programming

• Threading.

• Exception Handling

• File Reading/Writing(SystemI/O).

• System.String & String Operations.

• System.Data.SqlClient(ADO.NET)

• Reflection.

• Send Email.

• Download file from url.

• Encryption/Decryption.

• Entity Framework(5 or 6).

• App.configg & web.Config basic & advanced techniques

•

• MS SQL Server Installation

• Create Table

• Create Primary key.

• Foreign key.

• Index(cluster,non-cluster).

• Create view.

• Stored Procedure.

• Cursor.

• Trigger.

• Normalization(3-Forms).

• Data access from ado.net & Entity Framework. 

Good C# Tutorials on Pluralsite

http://www.pluralsight.com/courses/csharp-from-scratch
 http://www.pluralsight.com/courses/csharp-from-scratch-part2
http://www.pluralsight.com/courses/csharp-fundamentals-csharp5
http://www.pluralsight.com/courses/csharp-generics
http://www.pluralsight.com/courses/csharp-interfaces
http://www.pluralsight.com/courses/csharp-collections
http://www.pluralsight.com/courses/csharp-extension-methods
http://www.pluralsight.com/courses/skeet-async
http://www.pluralsight.com/courses/csharp-events-delegates