This Training is jointly organized by BITM & PeopleNTech
Training will be held in PeopleNTech
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.
- 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 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.
- 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
- Request Pipeline
- Route Configuration
- Route Constraints
- Writing a Custom Constraint with IRouteConstraint
- Catch-All Parameter
- Ignoring Routes
- Attribute Routing
- Naming and Location Conventions
- Request Pipeline and Controller Factory
- IController and Controller Class Hierarchy
- Convenience Methods
- Persistence Ignorance
- Moving from ADO.NET to EF
- Object-Relational Mapping (ORM) Frameworks
- Entity Framework
- Using Code First
- Data Annotations
- Application Initialization
- View Implementation with ViewContext
- View Engines and IView
- View Naming Convention
- Building a Custom View Engine
- Razor View Engine Syntax
- T4 View Templates
- Introduction to Bootstrap Framework
- Render Methods in Layouts
- Three HTML Helper Objects
- Html Helpers
- Strongly-Typed Helpers
- Helper Attributes
- Custom Helpers
- Inline Razor Helpers
- ViewData and ViewBag
- Creating Strongly-Typed Views
- Passing Model Objects
- Controller Inheritance
- Introduction, GET/POST
- Html Helpers
- AntiForgery Token
- Action Selectors HttpGet, HttpPost, etc.
- Multiple Accept Verbs
- Model Binding
- Default Model Binder
- Determining Valid Model State
- Using FormCollection
- UpdateModel() and TryUpdateModel()
- Partial Views
- Html.Partial() and Html.Action()
- ChildActionOnly Attribute
- Display/Edit Data Annotations
- Remote Attribute for Validation
- Model Binding Prefix
- Validation Attributes/Data Annotations
- Introduction to jQuery
- jQuery Selectors
- Ajax Helpers
- ActionLink() and BeginForm()
- Datepicker Widget
- Autocomplete Widget
- Other Front-End Frameworks
- Global Filters
- Custom Filters
Asynchronous Controller Actions
- IIS Thread Pool Threads
- Example: Sync vs. Async
- Bootstrap and RWD
- Overriding Views
- .Mobile Views
- Custom Client Views
- jQuery Mobile
- Four HTTP Verbs and CRUD
- Action Parameters
- Model Binding
- Status Codes
- Cross-Site Scripting (XSS)
- Cross-Site Request Forgery (CSRF)
- Web.config Transformations
- IIS Best Practices
Querying Microsoft SQL Server 2014 Training
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
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
||Microsoft SQL Server
||Microsoft Asp.net MVC