Microsoft Asp.net MVC Core  With  SQL Server 2014

Microsoft Asp.net MVC Core With SQL Server 2014

During the course, attendees build a fully functional data-driven ASP.NET MVC web application through a series of hands-on lab exercises.

course at a glance

  • Date : 7 Oct - 30 Dec 2017
  • No. of Classes/ Sessions : 24
  • Total Hours : 60
  • Last Date of Registration : 6 Oct 2017
  • Class Schedule :
    • Saturday - 3:00 PM - 6:00 PM
    • Friday - 3:00 PM - 6:00 PM
  • venue : Good Luck Center, 151/7 Green Road, 7th Floor, Dhaka 1205

Price: TK. 20,000

This Training is jointly organzied by BITM & People N Tech
Training will be held in People N Tech

Description

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

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

 

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

 

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
     

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

Curriculum

Asp.Net MVC Microsoft Asp.net MVC 40 Hrs
SQL Microsoft SQL Server 20 Hrs

Tentative Class Start

7th October, 2017

Available Seat

10 / 15

who can join

If anybody knows about object oriented programming and has knowledge about web development.

Meet the Instructor