Microsoft ASP.NET MVC Core With SQL Server

ASP.NET MVC 6 is Microsoft's last MVC release based on .NET Framework for building scalable, standards-based web applications using well-established design patterns and the power of ASP.NET and the .NET Framework.

Batch Duration

Starting Date : 29th September, 2023

Last Date of Registration :28th September, 2023

Class Schedule : 3 months (72 Hours); Friday Time: 9:00 AM - 1:00 PM, Offline

Total Hours : 72

Course Curriculum

Module-1: Introduction to .NET Framework and .NET Core

  • Introduction to .NET Framework and .NET Core
  • .NET Core for Cross-Platform Development
  • Introduction to ASP.NET Core
  • Evolution of ASP, ASP.NET and ASP.NET Core
  • Any developer, any app, any platform
  • .NET Framework & .NET Core high level overview
  • NET Core High-Level Overview
  • Code Compilation Process
  • NET Core Features in Detail
  • Introduction to Visual Studio 2017 and Visual Studio Code
  • Installer, Project file, Template, Configuration file, dotnet CLI etc.

Module-2: Introduction to MVC Framework

  • What is MVC?
  • Introduction to design Pattern
  • What is framework and differences between framework and library
  • Component of MVC design pattern
  • Introduction to Model, View and Controller and their responsibility.
  • NET MVC and its feature
  • Introduction to web application architecture, request and response
  • How an application works?
  • How separation of concern benefit us?

Module-3: Understanding the Views of MVC

  • What are Views?
  • Responsibility of Views
  • Benefits of Using Views
  • Creating a View
  • Content of a View File
  • What is Layout?
  • How to create a Layout?
  • Specifying a Layout
  • Layout property of Razor views
  • Introduction to RenderBody, Section, RenderSection etc.
  • Ignoring sections
  • About _ViewStart.cshtml file
  • Razor Directives, Importing Shared Directives
  • About _ViewImports.cshtml file
  • Passing Data from Controller to View
  • Introduction to ViewBag and ViewData
  • Usages of TempData, ViewBag and ViewData

Module-4: Razor View Engine

  • Razor View Engine, Razor Syntax
  • Symbol to transition from HTML to C#
  • Implicit Razor expressions
  • Explicit Razor expressions
  • Expression encoding
  • Razor code blocks
  • Implicit transitions
  • Explicit transition
  • Transitions in decision and Control Structures
  • Comments in Razor Syntax

Module-5: Controller in ASP.NET Core MVC

  • What is a Controller ?
  • Responsibility of a Controller
  • Action Methods and Action Results
  • ActionResult vs IActionResult
  • ViewResult, JsonResult, ContentResult, EmptyResult,
  • RedirectResult, RedirectToActionResult, BadRequestResult
  • FileResult, FileContentResult, FileStreamResult
  • Dependency Injection in Controller
  • Implicit Dependencies Principle
  • Explicit Dependencies Principle
  • Constructor Injection
  • Action Injection

Module-6: Understanding the Model in ASP.NET Core MVC

  • What is a Model?
  • Responsibility of a Model
  • Introduction to Model binding  How Model binding works?
  • Data Sources To Bind Request Data
  • Form values, Route values, Query strings
  • Bind Request Data
  • Customize Model Binding With Attributes
  • [BindRequired], [BindNever]
  • Exact Binding source [FromHeader], [FromQuery], [FromRoute], [FromForm]  [FromServices], [FromBody] etc.
  • What happens Inside Model Binding?
  • Value providers and Model Binders activities.

Module-7: Model Validation in ASP.NET Core MVC

  • What is Model Validation?
  • Why Model Validation?
  • Where Model Validation ?
  • Introduction to Validation Attributes  How Model validation works?
  • Example of Model with Validation Attributes
  • Built-in Validation Attributes
  • ComponentModel.DataAnnotations Namespace for validation attributes
  • Model State and Handling Model State
  • Manual Validation and Custom validation
  • Client side validation and Remote validation

Module-8: Ajax & JQuery

  • Introduction to jQuery
  • jQuery Selectors
  • Unobtrusive JavaScript
  • Ajax Helpers
  • ActionLink() and BeginForm()
  • AjaxOptions


  • Introduction JQuery UI
  • Datepicker Widget
  • Autocomplete Widget
  • Other Front-End Frameworks

Module-9: Understanding Routing in ASP.NET Core MVC

  • What is Routing?
  • Routing in ASP.NET Core
  • Routing Basics
  • Router Middleware
  • Incoming request, Route Handlers, RouteAsync Method, Route collection
  • Creating Default Routes
  • Extending Default Routes
  • Using Attributes
  • Building RESTful Routes
  • Using Constraints

Module-10: Language Integrated Query (LINQ)

  • What is LINQ ?
  • Types Of LINQ
  • LINQ Architecture IN .NET
  • Why LINQ ?
  • The building blocks of LINQ
  • LINQ Query Syntax
  • LINQ Lamda Syntax
  • How LINQ to SQL works?
  • Deferred execution
  • LINQ Query Operators

Module-11: Entity Framework Core (EF Core)

  • Entity Framework Core
  • What is ORM?
  • Introduction to Entity Framework Core
  • Conceptual Model, Storage Model, Mapping
  • Entity Framework Core in two scenarios
  • Domain Model and Database
  • Domain Model Approaches
  • Code First and Database First Approach
  • Concept of DBContext
  • Introduction to Scaffolding

Module-12: Entity Framework Architecture

  • Entity Framework Architecture
  • Create the Model
  • Register context with dependency injection
  • Add Migration and Create Database
  • Introduction to Asynchronous Code
  • Synchronous vs. Asynchronous code
  • Introduction to async and await
  • Entity States, No-tracking Queries etc.

Module-13: Security, Authentication, and Authorization in ASP.NET Core MVC

  • What is Authentication
  • Authentication in ASP.NET Core
  • Identity on ASP.NET Core
  • Configure Identity
  • Introduction to Authorization
  • Authorization Types
  • Authorization Namespace
  • What is Role?
  • Different Types of Authorization
  • Simple Authorization
  • Role based Authorization
  • Claims-Based Authorization
  • Custom Policy-Based Authorization
  • Resource Based Authorization
  • View Based Authorization
  • How to add role checks?
  • Policy based role checks
  • How to add claims checks?
  • Multiple Policy Evaluation etc.

Module-14: ASP.NET MVC Core application Deployment

  • Deploy WEB Application in Remote Server
  • Publishing and packaging Web API
  • Configuring Server
  • Deploying the Application and GO Live

Module-15: Project Work with ASP.NET Core MVC

  • Introduction about project
  • Project plan, approach and methodology identification
  • Setting up the Project environment
  • Conceptualization of requirements and develop requirements specification
  • Designing solution in detail
  • Development or construction based on the design
  • Testing and debugging the Application
  • Deploy Application to server

Module-16: MSSQL Server

  • Module 1: Introduction to Microsoft SQL Server 2014
  • Module 2: Introduction to T-SQL Querying
  • Module 3: Writing SELECT Queries
  • Module 4: Querying Multiple Tables
  • Module 5: Sorting and Filtering Data
  • Module 6: Working with SQL Server 2014 Data Types
  • Module 7: Using DML to Modify Data
  • Module 8: Using Built-In Functions
  • Module 9: Grouping and Aggregating Data
  • Module 10: Using Sub queries
  • Module 11: Using Table Expressions
  • Module 12: Using Set Operators
  • Module 13: Using Window Ranking, Offset, and Aggregate Functions
  • Module 14: Pivoting and Grouping Sets
  • Module 15: Executing Stored Procedures
  • Module 16: Programming with T-SQL
  • Module 17: Implementing Error Handling
  • Module 18: Implementing Transactions

Course Instructor


Sr. Faculty (C# .Net )

Admission Open

10% OFF

Course Fee : ৳ 20000

Our Clients

We're proud of our strategies and glad to work with some fantastic companies.