DB and SQL, T-SQL

• DB: Relational Data Architecture, SQL, DDL, DML
• T-SQL: Query, Advanced Query
• How-tos: Migrate Unique Columns – Ensuring Uniqueness

C# Data Access – ADO.NET

• ADO.NET: Connected Classes, Disconnected Classes

EF (Entity Framework)

• EF Basics: EDMX File Structure,  Base Classes, Querying, Updating
• EF Stored Procedures: EF Queries, EF Queries w/ a Complex Type,
• EF Checklist: Consuming EF DLL, Installing EF over NuGet

EF Code First / DbContext

• EF Code First: Overview, Convention and Configurations, Data Annotation Classes, Fluent API Classes
• Code First Configuration: Databases, Tables, Convention for Properties, Configuring Properties, GUID/TimeStamp, Complex Types, Convention for Relationships, Configuring Relationships
• DbContext: Overview, DbContext, DbSet, Querying Entities, Adding/Updating/Deleting Entities, Repository Pattern
• Validation API: Single Entity, Multiple Entities, SaveChanges
• Migrations: Migrations

SOA(Service Oriented Architecture), WCF (Windows Communication Foundation)

• SOA: Service Oriented,
• WCF : Overview, Services, Clients

ASP.NET Web API

• Web API: Overview, Content Type, Action Binding, Parameter Binding, Implementing Actions, HttpResponseMessage, Views, Sessions
• HttpClent: HttpClent, Sending Data, Authentication using Session
• Others: DI with Ninject