EIEIOTECHNOVATION
← Training programmes

EIEIO / DATA SCIENCE

MySQL and Core.Net

Course outline

4 days

Duration

4 days

Introduction

  • Evolution of .NET and .NET Core
  • .NET SKDs and Runtimes
  • Visual Studio and Visual Studio Code

ASP.NET Core Application Architecture

  • NuGet Packages
  • Application Startup
  • Hosting Environments
  • Middleware and the Request Pipeline
  • Services and Dependency Injection
  • MVC vs. Razor Pages

Application Configuration

  • Configure and ConfigureServices
  • Configuration Providers and Sources
  • Configuration API
  • Options Pattern
  • HTTPS and HTTP/2

Request Routing

  • RESTful Services
  • Endpoint Routing
  • Route Templates
  • Route Constraints
  • Route Template Precedence
  • Attribute-Based Routing

Models

  • Persistence Ignorance
  • Dependency Inversion
  • Asynchronous Data Access
  • Object-Relational Mapping
  • Entity Framework Core
  • Dapper ORM

Controllers

  • Responsibilities
  • Requirements and Conventions
  • Dependencies
  • Action Results

Views

  • Responsibilities
  • Conventions
  • Razor Syntax
  • Layouts
  • ViewData and ViewBag
  • Strongly-Typed Views
  • Partial Views
  • HTML and URL Helpers
  • Tag Helpers
  • View Components
  • Client-Side Dependencies
  • Razor Pages
  • View Models

HTML Forms

  • Tag Helpers
  • Form Submissions
  • Model Binding

Input Validation

Introduction

  • Data Annotations
  • Model Binding
  • Input Tag Helpers
  • Validation Tag Helpers

Application State

  • Client-Side vs. Server-Side
  • HttpContext.Items
  • Session State
  • TempData

Web APIs

  • API Controllers
  • OpenAPI / Swagger
  • Testing APIs
  • CRUD Operations
  • Cross-Origin Resource Sharing (CORS)

Programme scope, delivery arrangements and suitability are confirmed during enquiry.