Course Fee:-10000
Professional Web Application Development using MVC CORE & SQL SERVER
MVC CORE with C Sharp, SQL Server
Course instructors
![Eng, Shahanaj Begum](/img/default_Pic.png)
Eng, Shahanaj Begum
MCSD, MCAD, MSCSE
CEO & Founder, PowerSoft IT
Eng. Shahanaj Begum, the esteemed founder of Powersoft IT, is a highly skilled professional with a strong background in computer science & Engineering as well as extensive experience in the software & Web application development and training sector. She worked as a software developer in various software firms from 2009 to 2013. Since 2013, she has been playing an important role in creating IT Leaders through training. She has successfully imparted training in MS Office, and ASP.NET/ASP.NET CORE (C#) at High-tech Park, and IsDB Scholarship project, Corporate as well as Industrial attachment of several Polytechniq students. Currently, she is working as a software engineer and trainer. She is a woman entrepreneur certified by FNF. She also achieved Entrepreneurship Certifications from ILO. She With her expertise and leadership, Powersoft IT has become a trusted name in the industry, specializing in serving commercial, educational, and industrial clients.
Course Overview
ASP.NET MVC is a traditional version of ASP.NET by Microsoft. It is an open-source web framework which can be run only on Windows.
These course will help you understand ASP.NET MVC and Entity framework to build secure web application step by step.
ASP.NET MVC 5 covers all the new features of ASP.NET MVC 5, as well as the new features for web developers in Visual Studio 2019, including WebApi 2, OWIN, Katana, SignalR, and the Entity Framework version 6. Whether you're new to ASP.NET MVC or have some experience but are looking for a course to fill in the gaps, you'll love this course.
Description
ASP.NET MVC is a server-side web framework for building dynamic, data-driven web applications. Since its first release in 2009, it has gained a lot of popularity amongst developers using Microsoft technologies. If you want to get employed as a web developer at a company that utilizes Microsoft technologies, you need to master ASP.NET MVC.
ASP.NET MVC 5 covers all the new features of ASP.NET MVC 5, as well as the new features for web developers in Visual Studio 2019. The course looks at the Katana and OWIN middleware components to see how the components work at a low level and how they fit into ASP.NET pipeline. The new identity and membership components are covered, and a demonstration is included to customize and seed the membership database. We look at Bootstrap 3's grid and responsive design system, as well as the Web API 2, including a demo of making authenticated calls against a Web API from JavaScript. The Entity Framework version 6 is covered including the new async API in EF6, and we'll build an application to stream performance counter data using SignalR and Knockout. Finally, there are tips and tricks for editing HTML, JavaScript, CSS and LESS with Visual Studio 2013 and extensions like Web Essentials, which brings the Zen Coding plugin to the Visual Studio.
Requirements
- C# (at a minimum lambda expressions, LINQ)
- Basic familiarity with web development (HTML, CSS, JavaScript, jQuery)
Who this course is for:
- University Students who are passionate to learn ASP.NET MVC
- Developers with no knowledge of ASP.NET MVC 5 who want to build web apps with this framework
- Developers with some experience in ASP.NET MVC 5 who are looking for a comprehensive course to fill the gaps
By the end of this course, you'll be able to:
- Implement CRUD operations
- Build forms with validation
- Build RESTful services using ASP.NET Web API
- Use Entity Framework code-first workflow to build a model
- Implement security, authentication and authorization using ASP.NET Identity
- Use powerful jQuery plugins
- Optimize application's performance
- Build and deploy your applications and database
- Secure application settings and connection strings
- And more...
Whether you're new to ASP.NET MVC or have some experience but are looking for a course to fill in the gaps, you'll love this course.
Course Syllabus
Module01: Introduction of Microsoft.Net/Microsoft.Net Core
- 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
Module02: Object Oriented Programming using C#
- 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
Module03: Advanced C# Revisit
- Arrays
- errors and exceptions
- Extension Methods, Anonymous Methods
- Asynchronous
- Programming using C#
- Generic, Non-generic Collections
- Event, Delegates & Lambda Expressions
Module04: Microsoft SQL Server
- Introduction to Microsoft SQL Server
- Introduction to databases, Relational
- database Management concepts
- Structured Query Language
- Querying Multiple Tables
- Sorting and Filtering Data
- Working with SQL Server Data Types
- Using DML to Modify Data
- Using Built-In Functions
- Grouping and Aggregating Data
- Using Sub queries/Nested / Inner Queries
- Relationship
- Aggregate Functions
- Executing Stored, Trigger, View, Packages
- SQL Joins like inner joins, left outer join, right outer join etc.
- Implementing Transactions
Module05: Project Management Tools
- Overview of Git and Online Git Repository
Module06: Getting Started with ASP.NET MVC
- 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
Module07: Getting Started with MVCCORE
- Learn structure of ASP NET MVC Core (.NET 6) Project
- Learn structure of ASP NET Core (.NET 6) Razor Project
- Learn basic fundamentals of ASP NET MVC Core (.NET 6)
- Security: Identity Framework
- Integrate Identity Framework and learn how to add more fields to Users
- Interact with Razor class library for Identity
- Integrate Entity Framework Core along with code first migrations
- Sessions in ASP NET Core (.NET 6)
- Custom Tag Helpers in ASP NET Core (.NET 6)
- View Components and Partial Views in ASP NET Core
- Bootstrap v5
- Authentication and Authorization in ASP NET Core (.NET 6)
- Google and Facebook Authentication/Login
- Role Management in ASP NET Core Identity
- Email notifications
- TempData in ASP NET Core (.NET 6)
- Repository Pattern to Access Database
- Seed Database Migrations Automatically
- Deploying website on Live Server
Module08: : Client-Side Interactions using J Query
- 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)
Module09: 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 Lambda Syntax
- How LINQ to SQL works?
Module10: 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
Module11: 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.
Module12: Security, Authentication, and Authorization
- Authentication
- ASP.NET Core Identity
- Cookie Middleware
- Authorization
- Claims-Based Authorization
Module13: Error Handling
- Best Practices
- HTTP Error Status Codes
- Developer Exception Page
- Status Code Pages
- Exception Filters
Module14: Logging & Testing
Logging :
- Introduction
- Configuration
- ILogger
Testing:
- Introuction
- Unit Testing
- xUnit
- Testing Controllers
- Integration Testing
Module15: Project
Real project on any of the following
- School Management
- Hospital Management
- HR
- Inventory Management
project Includes :
- Clean Architecture
- Repository Pattern
- Dependency Injection
- Implementation of Security
- Integration of Payment Gateway
- Deployment on Server
Tools: Web API Core & MVC CORE
Frequently Asked Questions
What will you learn In MVC training?
How will MVC Online Training help your Career?
Why should you start MVC Online Training?
Do you provide any course material or live session videos?
Do you provide training on latest technology version?
Student's Feedback
![Professional Web Application Development using MVC CORE & SQL SERVER](/img/default_Pic.png)
Moazzem Hossain
![Professional Web Application Development using MVC CORE & SQL SERVER](/img/default_Pic.png)