facebook


Professional Web Application Development using MVC CORE & SQL SERVER

Content

40+ Lessons

Duration

80 Hours

Resources

pdf book,materials

Quiz

Each module

Facilities

Problem solving,Certificate,Internship

Course Modules

  • Introduction to .Net Framework
  • Features of .NET Framework
  • .NET Framework Architecture
  • CLR Architecture
  • History of .NET Core
  • Why .NET Core? Features of Core?
  • Comparison with .NET Framework
  • .NET Core Architecture
  • Anatomy of C#
  • Datatypes and variables
  • Conditional Statement
  • Methods
  • Looping
  • Collections in C#
  • Value type & Ref type
  • OOP with example
  • Class & Object
  • Constructor
  • Field, Property
  • Method
  • Overloading
  • Overriding
  • Interface
  • Arrays
  • errors and exceptions
  • Extension Methods, Anonymous Methods
  • Asynchronous
  • Programming using C#
  • Generic, Non-generic Collections
  • Event, Delegates & Lambda Expressions
  1. Introduction to Microsoft SQL Server
  2. Introduction to databases, Relational
  3. database Management concepts
  4. Structured Query Language
  5. Querying Multiple Tables
  6. Sorting and Filtering Data
  7. Working with SQL Server Data Types
  8. Using DML to Modify Data
  9. Using Built-In Functions
  10. Grouping and Aggregating Data
  11. Using Sub queries/Nested / Inner Queries
  12. Relationship
  13. Aggregate Functions
  14. Executing Stored, Trigger, View, Packages
  15. SQL Joins like inner joins, left outer join, right outer join etc.
  16. Implementing Transactions
  1. Overview of Git and Online Git Repository   
  • What is MVC? Understanding MVC Philosophy.
  • Understanding the structure of an ASP.NET MVC project
  • 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. ASP.NET MVC and its feature.
  • Introduction to web application architecture, request and response. How an application works?
  • How separation of concern works?
  • Naming conventions
  • Differences between  ASP.NET Web Form and ASP.NET MVC   
  • Routing in MVC
  • Working with Entity Framework.
  • Repository Pattern
  • Routing in MVC
  • Security in ASP.NET MVC
  • MVC Unit Testing
  • Building RESTFUL Services with Web API 2
  • Model Validation in ASP.NET MVC
  • Partial view
  1. Learn structure of ASP NET MVC Core (.NET 6) Project
  2. Learn structure of ASP NET Core (.NET 6) Razor Project
  3. Learn basic fundamentals of ASP NET MVC Core (.NET 6)
  4. Security: Identity Framework
  5. Integrate Identity Framework and learn how to add more fields to Users
  6. Interact with Razor class library for Identity
  7. Integrate Entity Framework Core along with code first migrations
  8. Sessions in ASP NET Core (.NET 6)
  9. Custom Tag Helpers in ASP NET Core (.NET 6)
  10. View Components and Partial Views in ASP NET Core
  11. Bootstrap v5
  12. Authentication and Authorization in ASP NET Core (.NET 6)
  13. Google and Facebook Authentication/Login
  14. Role Management in ASP NET Core Identity
  15. Email notifications
  16. TempData in ASP NET Core (.NET 6)
  17. Repository Pattern to Access Database
  18. Seed Database Migrations Automatically
  19. Deploying website on Live Server
  • What JQuery?
  • Why JQuery?
  • JQuery Syntax
  • Selector Engine & Filters
  • DOM Traversal Methods
  • DOM Manipulation using JQuery
  • Event Handling using JQuery
  • CSS Manipulation
  • Animation & Effects
  • JQuery AJAX
  • JQuery Validate(Client Side Validation)
  • What is LINQ
  • Types Of LINQ
  • LINQ Architecture IN.NET
  • Why LINQ?
  • The building blocks of LINQ
  • LINQ Query Syntax
  • LINQ Lambda Syntax
  • How LINQ to SQL works?

 

  • 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
  • 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.
  • Authentication
  • ASP.NET Core Identity
  • Cookie Middleware
  • Authorization
  • Claims-Based Authorization
  • Best Practices
  • HTTP Error Status Codes
  • Developer Exception Page
  • Status Code Pages
  • Exception Filters

Logging :

  • Introduction 
  • Configuration 
  • ILogger

Testing:

  • Introuction
  • Unit Testing
  • xUnit
  • Testing Controllers
  • Integration Testing

 

Real project on any of the following

  • School Management
  • Hospital Management
  • HR
  • Inventory Management

project Includes :

  1. Clean Architecture
  2. Repository Pattern
  3. Dependency Injection
  4. Implementation of Security
  5. Integration of Payment Gateway
  6. Deployment on Server

Tools: Web API Core & MVC CORE