C# Concepts
Introduction
Reading and writing to a console
Built-in data types
String data type
Operators
Nullable Types
Datatype conversions
Arrays
Comments
If statement
Switch statement
Switch continued
While loop
Do while loop
For & foreach loop
Methods
Method parameters
Namespaces
Class - Introduction
Static & Instance members
Inheritance
Method hiding
Polymorphism
Method overriding Vs hiding
Method overloading
Why Properties
Properties
Structs
Classes Vs Structs
Interfaces
Explicit interface implementation
Abstract Classes
Abstract Classes Vs Interfaces
Diamond Problem
Multiple inheritance
Exception Handling
Inner Exceptions
Why Enums
Enums Example
Enums Concepts
Types v/s Type Members
Access Modifiers - Private, Public and Protected
Access Modifiers - Internal and Protected Internal
Access Modifiers for types
Attributes
Generics
Generic Collections
Reason to override ToString() method
Reason to override Equals() method
Difference between [Link]() and ToString() method
Difference between string and stringbuilder
Partial classes in C#
Optional Parameters in c#
Making method parameters optional using method overloading
Making method parameters optional by specifying parameter defaults
Making method parameters optional by using OptionalAttribute
Anonymous methods in c#
Lambda expression in c#
Code snippets in visual studio
What is dictionary in c#
What is dictionary in c# continued
List collection class in c#
List collection class in c# continued
Working with generic list class and ranges in c#
Sort a list of simple types in c#
Sort a list of complex types in c#
Some useful methods of List collection class
When to use a dictionary over list in c#
Async and await in c#
SQL Server:
Connecting to SQL Server
Creating, altering and dropping a database
Creating and working with tables
Default Constraint
Cascading referential integrity constraint
CHECK constraint
Identity Column
Retrieving Identity Column values
Unique key constraint
All about “SELECT”
Group By
JOINS
Advanced JOINS
Self Join
Different ways to replace NULL in SQL Server
COALESCE() function in SQL Server
UNION and UNION ALL
Stored Procedures
Advantages of stored procedures
String functions
DateTime functions in SQL Server
DateTime functions continued
DateTime functions continued
Cast and Convert functions
Temporary Tables
.Net Core(MVC+WEBAPI) Tutorial:
Setting up machine for [Link] core development
Creating [Link] core web application
[Link] core project file
Main method in [Link] core
[Link] Core [Link] file
[Link] Core [Link] file
Middleware in [Link] Core
Configure [Link] Core request processing pipeline
Static Files in [Link] Core
[Link] Core developer exception page
[Link] Core Environment Variables
[Link] Core MVC tutorial
Setup MVC in [Link]
[Link] Core AddMvc vs AddMvcCore
Model in [Link] Core MVC
[Link] Core dependency injection tutorial
Controller in [Link] Core MVC
Views in [Link] Core MVC
Passing data to view in [Link] Core MVC
ViewBag in [Link] Core MVC
Strongly Typed View in [Link] Core MVC
ViewModel in [Link] Core MVC
List view in [Link] core mvc
Layout view in [Link] core mvc
Sections in layout page in [Link] Core MVC
_ViewStart.cshtml in [Link] Core MVC
Routing in [Link] Core MVC
DbContext in entity framework core
Using sql server with entity framework core
Repository pattern in [Link] core
WebAPI:
Introduction to Web API.
Building your first [Link] Core API.
Working with relational data.
Controller Action return types.
[Link] Core Web API Versioning.