Microsoft Asp.net MVC 6 With SQL Server 2014

ASP.NET MVC 6 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.

Batch Duration

Starting Date : 24th February, 2018

Last Date of Registration :24th February, 2018

Class Schedule : 3 Months (72 Hours); Friday & Saturday; Time: 3:00 PM - 6:00 PM

Total Hours :

Course Curriculum

Microsoft Asp.net MVC 6 Course Outline

Introduction

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

Routing

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

Controllers

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

Models

  • 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

Views

  • 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

Helpers

  • 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

ViewModels

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

Data Validation

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

Ajax

  • 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

Web API

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

Security

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

Deployment

  • 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

Course Instructor

Md. Mahbubur Rahman

Sr. Faculty

20%% OFF

Admission Open

Course Fee : ৳ 20000