ASP.NET, WEB API, SQL Server

Module 1: Introduction & Setup (2 hours)

·       Overview of .NET ecosystem (Framework vs Core vs .NET 6/7/8)

·       Installing Visual Studio 2022 & SQL Server

·       Project templates (MVC, API, Razor)

·       Creating your first ASP.NET Core project

Module 2: ASP.NET Core MVC (20 hours)

MVC Fundamentals (6 hours)

·       Understanding MVC architecture

·       Razor views & pages

·       Tag helpers & view components

·       Layout pages and partial views

·       Model binding and validation (Data Annotations)

Routing & Middleware (2 hours)

·       Conventional & attribute routing

·       Middleware pipeline (Startup.cs, Program.cs in .NET 6+)

·       Static files, CORS, exception handling middleware

Dependency Injection & Services (2 hours)

·       Built-in DI in ASP.NET Core

·       Registering and injecting services

·       Scoped, Singleton, Transient

Form Handling & State Management (3 hours)

·       GET/POST methods

·       Model binding with forms

·       TempData, ViewBag, Session, Cookies

Authentication & Authorization (4 hours)

·       Identity in ASP.NET Core

·       Login/Registration using Identity

·       Role-based access

·       JWT basics (link to Web API part)

Project Work: Basic Employee Management App (3 hours)

·       CRUD using MVC

·       Validation

·       View filtering/sorting

Module 3: Web API in ASP.NET Core (20 hours)

RESTful Concepts & API Basics (3 hours)

·       REST vs SOAP

·       Creating an API project

·       Controllers, Actions

·       HTTP methods & status codes

CRUD API with Entity Framework (4 hours)

·       Creating models

·       DBContext, Migrations

·       Using EF Core to interact with SQL Server

·       DTOs and AutoMapper

Routing, Versioning, and Filters (3 hours)

·       Attribute-based routing

·       API versioning

·       Filters: Exception, Action, Result, Authorization

Advanced API Topics (5 hours)

·       Token-based authentication with JWT

·       Global exception handling

·       Logging (ILogger, Serilog)

·       File upload/download

·       Pagination & sorting

Testing APIs (2 hours)

·       Postman basics

·       Swagger/OpenAPI configuration

·       Unit testing controllers with Moq + xUnit

Mini Project: Product Catalog API (3 hours)

·       CRUD API for products

·       Filtering, searching, sorting

·       JWT-based authentication

Module 4: SQL Server + EF Core (20 hours)

SQL Server Basics (4 hours)

·       Database design & normalization

·       Creating tables, indexes, constraints

·       Basic SQL: SELECT, INSERT, UPDATE, DELETE

·       Joins, Views, Stored Procedures

Intermediate SQL Concepts (4 hours)

·       Transactions and locking

·       Functions, triggers

·       Query optimization basics

Entity Framework Core (6 hours)

·       Code First vs Database First

·       Migrations and seeding data

·       Relationships: 1:1, 1:M, M:N

·       LINQ queries

·       Tracking vs NoTracking

Data Access Patterns (3 hours)

·       Repository Pattern

·       Unit of Work

·       Async EF operations

Database Project (3 hours)

·       Schema design for multi-entity system (e.g., Orders & Products)

·       Stored procedures for reporting

·       Integrate SQL logic in ASP.NET Core app

Capstone Project (6 hours)

Project: Online Course Management System

·       ASP.NET MVC UI + Web API backend

·       User registration & role-based login

·       Courses listing & enrollment APIs

·       Admin panel to manage content

·       SQL Server backend with EF Core