Microsoft ASP.NET MVC Core with SQL Server Training
To build applications today, a programmer must know how to combine the power of various technologies together to produce software that is powerful and web based application. The focus of this course is C# Training with ASP.NET Core and Microsoft SQL Server 2017 through Visual Studio, but along the way, you also see how to use Microsoft Visual Studio 2015 for Web , and you get to build a real dashboard system powered by SQL, C#, AJAX, CSS, HTML and JQuery. Any of these skills alone are valuable, but knowing how to combine these skills makes you immediately standout in the job market. Enroll today, and learn how to give yourself a great competitive advantage in the job world.
This course is designed to provide an
introduction to .NET Core for programmers who already know the C# language. The
course focuses on core portions of the .NET Framework that are common across
many application areas. It starts with an introduction to the architecture and
key concepts of .NET. The course then discusses class libraries, packages,
meta packages and frameworks. Coverage includes working with delegates and
events, I/O and serialization, memory management, processes and threads as well
as threading and an introduction to the Task Parallel Library (TPL).
This course also provides a practical hands-on introduction to developing Web applications using ASP.NET Core MVC 6 and C#. This Web development framework from Microsoft emphasizes separation of concerns in the architecture and testability of applications. This course covers the fundamentals of the Model-View-Controller design pattern and its implementation in ASP.NET Core MVC. Visual Studio 2019 with ASP.NET Core 3.0 is used as a productive platform for creating MVC Web applications.
After presenting the fundamentals of the technology with several examples, the main components of Model, Controller and View are covered in detail. The discussion of the Model incorporates Microsoft technologies for persisting data, including XML Serialization and ADO.NET with SQL Server 2016. The routing mechanism of ASP.NET MVC is covered. The course includes an introduction to ASP.NET Web API.
Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.
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
- Ajax Helpers
- ActionLink() and BeginForm()
- 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