Microsoft ASP.NET MVC Core

Microsoft ASP.NET MVC Core

About The Course ASP.NET MVC Core 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.  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. Learning Objectives Learn advanced C# skills to more easily embrace the MVC framework including anonymous types, extension methods, partial types, anonymous methods, dynamic types, the Thread Parallel Library (TPL), the lambda operator, Language Integrated Query (LINQ), and Entity Framework. Learn to understand the MVC design pattern and how it is applied in ASP.NET MVC. Learn to recognize the benefits and drawbacks of using ASP.NET MVC. Learn to make good decisions about application architecture and the choice of data access technology. Learn to build a compelling and maintainable HTML user interface using the Razor view engine and client-side JavaScript. Learn Visual Studio scaffolding and how to take advantage of it for code generation. Learn to add models, views, controllers, and areas to an MVC website. Learn the best practices of using ViewBag, ViewData, and TempData. Learn the three (3) MVC Helper objects and create custom helper extension methods. Learn the basics of using Bootstrap within your MVC application for responsive web design. Learn to use the new Web API framework to simplify the creation of HTTP services. Learn to gain experience with using adaptive rendering, mobile-specific views, and a view switcher to support a variety of mobile devices. Learn to create asynchronous controllers using TPL for greater control over the IIS thread pool. Learn to extend and modify ASP.NET MVC 6 by creating custom components and templates. Learn the best practices to deploying an ASP.NET MVC 6 website. Querying Microsoft SQL Server 2014 Training Learning Objectives After completing this course, students will be able to: Write SELECT queries Query multiple tables Sort and filter data Describe the use of data types in SQL Server Modify data using Transact-SQL Use built-in functions Group and aggregate data Use sub queries Use table expressions Use set operators Use window ranking, offset and aggregate functions Implement pivoting and grouping sets Execute stored procedures Program with T-SQL Implement error handling Implement transactions

Microsoft MVC 6 Course Outline


  • Goals of Modern Web Development
  • Model-View-Controller Design Pattern
  • Basics of Unit Testing
  • Convention Over Configuration
  • Managing Dependencies
  • Introduction to Case-Study Application for Labs


  • Request Pipeline
  • Route Configuration
  • RouteValueDictionary
  • Route Constraints
  • Writing a Custom Constraint with IRouteConstraint
  • Catch-All Parameter
  • Ignoring Routes
  • Attribute Routing


  • Introduction
  • Naming and Location Conventions
  • Request Pipeline and Controller Factory
  • IController and Controller Class Hierarchy
  • ActionResult
  • Convenience Methods


  • Introduction

Data Access

  • Persistence Ignorance
  • Moving from ADO.NET to EF
  • Object-Relational Mapping (ORM) Frameworks
  • Entity Framework
  • Using Code First
  • Data Annotations
  • Application Initialization


  • Introduction
  • View Implementation with ViewContext
  • WebViewPage
  • View Engines and IView
  • View Naming Convention
  • Building a Custom View Engine
  • Razor View Engine Syntax
  • T4 View Templates
  • Introduction to Bootstrap Framework
  • Layouts
  • Render Methods in Layouts


  • Introduction
  • Three HTML Helper Objects
  • Html Helpers
  • Html.ActionLink()
  • Url.Action()
  • Strongly-Typed Helpers
  • Helper Attributes
  • Custom Helpers
  • Inline Razor Helpers

Strongly-Typed Views

  • Introduction
  • ViewData and ViewBag
  • Creating Strongly-Typed Views
  • Passing Model Objects
  • Controller Inheritance

HTML Forms

  • Introduction, GET/POST
  • Html Helpers
  • Html.BeginForm()
  • AntiForgery Token
  • Validation

Action Selectors

  • Action Selectors HttpGet, HttpPost, etc.
  • Multiple Accept Verbs
  • Model Binding
  • Default Model Binder
  • Determining Valid Model State
  • Using FormCollection
  • UpdateModel() and TryUpdateModel()

Partial Views

  • Partial Views
  • Html.Partial() and Html.Action()

Child Actions

  • ChildActionOnly Attribute
  • Display/Edit Data Annotations


  • Introduction
  • Remote Attribute for Validation
  • Model Binding Prefix
  • Inheritance

Data Validation

  • Introduction
  • Validation Attributes/Data Annotations
  • ModelState
  • IValidatableObject


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

jQuery UI

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

Action Filters

  • Introduction
  • OutputCache
  • HandleError
  • RequireHttps
  • Authorization
  • Global Filters
  • Custom Filters

Asynchronous Controller Actions

  • Introduction
  • IIS Thread Pool Threads
  • Example: Sync vs. Async
  • Timeouts

Mobile Clients

  • Introduction
  • Bootstrap and RWD
  • Overriding Views
  • .Mobile Views
  • Custom Client Views
  • jQuery Mobile


  • Introduction
  • ApiController
  • Four HTTP Verbs and CRUD
  • Action Parameters
  • Exceptions
  • Configuration
  • Routing
  • Model Binding
  • Formatters
  • Status Codes


  • Authentication
  • Cross-Site Scripting (XSS)
  • Cross-Site Request Forgery (CSRF)
  • Over-Posting


  • Introduction
  • Web.config Transformations
  • IIS Best Practices

SQL Server 2014 Course Outline

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

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