Microsoft ASP.NET MVC Core with SQL Server Training

Microsoft ASP.NET MVC Core with SQL Server Training

ASP.NET MVC Core is the most popular web application development framework. MVC Core is the last release framework 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.  Version 5 of ASP.NET MVC adds many new features such as template-based views based on the Bootstrap framework, attribute routing, support for Entity Framework 6, and more.

During the course, attendees build a fully functional data-driven ASP.NET MVC web application through a series of hands-on lab exercises.

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
Md. Mahbubur Rahman

Md. Mahbubur Rahman

Sr. Faculty

Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech