It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life

Microsoft Asp.net MVC 6 With SQL Server 2014

This training is jointly organized by BITM & People NTech Limited

 

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.  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 (Microsoft Asp.net MVC 6)

  • 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.

 

Learning Objectives (SQL Server 2014)

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

 

Training will be held in People N Tech Limited

FEE - Tk 20000(2,000 tk Discount for SEIP Trainee)

Prerequisite

Basic C# & OOP concept is Must.

Project Oriented Course

This will be discussed during the session.

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

Used Tools

MVC Framework

COURSE SUMMARY

Course Duration : 20 Days
Total Hour : 60 Hours
Number of Batch : 1 Batch

Class Starting Tentative Date 08 April, 2017
Application Last Date : 08 April, 2017

Class Schedule

Day & Time : Friday 3:00 pm - 6:00 pm
: Saturday 3:00 pm - 6:00 pm
Duration : 3 Hours per class

Project:

This will be discussed during the session


Certificate:

Certificate will be given afther the course completion