Blazor, .NET Core Web API and Microsoft SQL full-stack app

Install Visual Studio using the free community version for education, run the installer, and select workloads such as dot net and web development.

Install Postman and begin testing the redBus API by sending requests to verify endpoints and functionality.

Install SQL Server Management Studio by accepting defaults, restart as required, and complete the setup to enable working with SQL Server databases.

Create a department table with an auto-generated id and name, and an employee table with id, name, department, join date, and profile picture; insert and verify data with select queries.

Create a dot net project in Visual Studio, review the dependencies, folders like controllers and startup, and configure the program to listen for http requests via dependency injection.

Enable cors by default and switch to a default json serializer, install the necessary package, import the namespace, run the project, and verify the sample controller returns expected results.

create a models folder and define a department model with department and department name fields, then an employee model with fields for employee name, department, and joining.

Learn to build department screen APIs by configuring the connection string, wiring dependency injection, and implementing get, post, update, and delete methods with parameterized queries to manage department data securely.

Implement employee details screen api by creating an empty api controller and mirroring the department comptroller, then verify get, post, and delete methods work as expected.

Build a post method API to upload photos into a dedicated folder, extract the first form file, and return a default anonymous picture name if saving fails.

Create a Blazer server app front end by opening Visual Studio, selecting the server template, and configuring routing to view a navigation menu and counter.

Implement routing and navigation with bootstrap, import bootstrap assets, and create two pages for department and employee details. Map routes /department and /employee and verify routing works.

Build a bootstrap table to display department data by fetching from an API with HttpClient and serializing JSON via System.Text.Json.

Use a bootstrap modal to add or edit departments, with dynamic title and fields for department id and name, using post and put requests, plus delete with confirmation.

Complete the employee details screen in the Blazor full-stack app by modeling an employee with name, department, date of joining, and profile picture, using a department dropdown and data arrays.

Install the input file package and add a JavaScript reference to enable uploading a profile picture by converting file to a memory stream and posting it via upload file API.

Implement a custom sorting and filtering feature for a bootstrap table to filter by department and department name, with text inputs and ascending/descending sort buttons.