Back-End DotNet

gggIntro To Operating Systems & Computer Architecture

History of programming, Languages C, C++, C# (how it works in depth), and .NET technologies

Prepare the work environment and take a quick tour of the tools (IDE vs Text editor)

Types of different errors (compiler error, linker error, runtime error, logic error, …)

Preprocess directive, comments, namespaces, basic IO

The first program in C# (Hello world)

Variables and constants, different types, sizes, and how they work

Arrays and its problems & dynamic collections (List)

Manipulating the list & other dynamic collections data types (Stack & Queue & Linked List & Double Linked List & Dictionary & more…)

Standard numeric format

Expressions, statements, and operators

Controlling program flow (if, else, switch, for, while, ...)

Characters and strings (C-style string & C# String)

Methods & parameters and arguments & and return values

Stack & Heap

Pass value types to methods by value and by ref vs Pass reference types by value and by ref

Implicit Vs Explicit Casting

Classes, objects

Constructors & copy constructors & destructors

Constructors & copy constructors & destructors

Abstraction

Private attributes & getter and setter methods

Properties

Automatic Properties

indexer

Encapsulation

Deal with class members through the object & Nullable

Structs vs Classes vs Records

Enums

String formatter & Guid

Inheritance

Access modifiers

Polymorphism

Overriding Vs Overloading & Virtua

Abstract

interface

Generics

Threading (Async Vs Sync & await)

Operator overloading

Exception handling

Globals usings

Reflation

Anonymous Types & Anonymous Methods & Lambda Expression

Built in Delegates & Custom Delegate

Pointers To Functions

Events Driven

Observable Design pattern

Best practices in C# & Updates

A list and a set of decisions and choosing between them

Bank Management System (Vodafone Cash)

University Management System (Menu - Store - Search - Edit - Delete and more…)

Library Management System (Menu - Authentication - Roles - Borrow - Return - Management - Search and more…)

Examination Management System (Doctor - Students - Add Quiz - Practical Exam - Final Exam - Take Exam - Calculate grades - Review - FeedBack and more…)

System Analysis

Database design

ERD => Entity Relationship diagram

EERD => Enhanced Entity Relationship diagram

Database Mapping

Database Normalization

Database Engine

Prepare the work environment and take a quick tour of the tools (SSMS)

DATA DEFINITION

DATA TYPES, different types, sizes, and how they work

Temporary Tables

Truncate Table vs Delete Table

Insert Mock & Dummy data

DATA QUERY & MANIPULATION

Aggregate Functions

Date Functions

String Functions

Math Functions

Expressoins (CASE - COALESCE - NULLIF)

DATA MANIPULATION (Common Table Expression (CTE), INSERT, UPDATE, DELETE, MERGE, Transaction)

Views

Indexs

Triggers

Stored Procedure

XML tables

Cursors

Database backups and restores

Multiple users & Administration

Intro to Entity Framework Core (Code First)

ApplicationDbContext (onConfiguration, onCreating)

Migrations Sycle (Add & Remove & Update & Generate SQL scripts)

Data Annotations vs Fluent API

SoC (Separation Of Concerns)

Relationships (one to one, one to many, many to many)

Scaffolding & Reverse Engineering (Database First)

Data seeding

Intro To ADO.Net & Intro To Dapper & Benchmark

What is Extension methods? Built a new one.

LINQ extension methods (All Methods)

Lazy loading vs Eager loading

IQueryable vs IEnumerable

Tracking Vs NoTracking

Deferred Execution

Logging

Tips to improve our queries to more than 40%

Improve The Last Projects to use the Database

Git & GitHub

Intro to web applications and how they run

Software Development Life Cycle

Into to structure ASP.Net Core (MVC & API)

Razor pages & Postman & Swgger & Scaler

RESTful services & Constrains

N-tier architecture

Areas

Middleware in the program file & Kestral server

First Model & View & Controller

Url mapping

IActionResult & ActionResult & ViewResult

EERD for our E-Commerce Website

Full CRUD operations on the model

Pagination

Filter & Search

Wite Complex queries to find related products

ViewModel & DTOs

Fluent Mapping

Implicit Vs Explicit Mapping

AutoMapper Vs Mappester

ViewData & ViewBag

State management (TempData & Cookie & Session & Cache & …)

Upload files (Database - Physical storage (file system or network share) - Cloud data storage service)

Validation (Server side - Client side)

Custom validation

HTML Helper

Tag Helper

Validation AntiForigen token

Layout & ViewStart & ViewImport

Partial View

Global Exception Handling

Ajax calling

SOLID Principles

Repository Design Pattern

Asynchronous programming

Inversion of control (IOC)

Dependency Injection

Singleton design pattern

Unit Of Work

Loclization

Identity

Identity using Razor (Basics)

Routing & Changing the map route

Email Sender

Log in to Facebook & Google

Send OTP

Change Role

Block & Unblock Users

Shopping Cart process

Favorite Items process

Manage Orders process

SignalR

Payment Gateway

Shipping companies

Reviews & Comments & Filters

Publish

CORS (Cross-Origin Resource Sharing) Block