SQL SERVER
Introduction to Basic Database Concepts
Introduction to SQL Server
DDL and DML Statements
Working with Queries (DQL)
Aggregate Functions
Joins and Set Operations
Working with Constraints
Working with Stored Procedures and Functions
ASP.NET CORE
Introduction to .NET Core
.NET CLI
Model,View,Controller & Actions
Razor View Engine
Routing
o Custom Routing in .NET MVC
o Custom Route Constraint
o Attribute Routing
o Attribute Routing vs Conventional Routing
Views
o Layout View
o ViewStart
o Partial Views
o ViewImports
o View Components
Action Results
o View Result
o Partial View Result
o JSON Result
o Redirect Results
o EmptyResult
o StatusResults
Helpers
o HTML Helpers
o Tag Helpers
Model Binding
o Model Binding using FromForm
o Model Binding using FromQuery
o Model Binding using FromRoute
Fluent API Validation
o Fluent API in ASP.NET CORE MVC
o Fluent API Validation
State Management
o Cookies
o Persistent vs Non-Persistent Cookies
o Sessions
o Distributed Sessions
ViewModel and Form Validations
Data Passing Techniques
o ViewData
o ViewBag
o TempData
o Session
o Query String
o Cookies
Entity Framework Core
o EF Core
o Database Modeling
o Database Migrations
o Database First Approach
LINQ Queries
o Linq Query Syntax
o Lambda Expressions
o Linq Queries over Custom Collections
o Linq to SQL
ASP.NET WEB API
API Testing using Postman
Database Crud Operations with API
ASP.NET Core Authentication using Identity
