Real‑Time Application Development with N‑Tier Architecture

Develop a Windows-based application with a SQL Server database, set up and test the connection, create tables, and implement stored procedures for get employees and insert, update, delete.

Define a reusable employee data class that maps properties to table columns, consolidates validations into a single exception, and supports multiple constructors for easy object creation in a library.

Develop dao and bo classes to manage database operations using stored procedures, helper utilities, and a clean data access layer, while modeling business logic and transactions for real-time apps.

Develop a Windows Forms GUI by binding a grid to a dataset, configuring columns, and implementing add/edit dialogs with validation, while separating presentation, business, and data layers.

Learn to build an n-tier ASP.NET MVC app by separating business and data into a library, scaffolding a full employee CRUD UI, and reusing code across projects.

Learn to implement a CRUD workflow with entity framework in an MVC project by scaffolding a controller and views, building a code-first context, and integrating repository and dependency injection.

Enable migrations, add department module, create and apply migrations to update department and employee tables, resolve foreign key conflicts, and regenerate controllers to reflect navigational properties in a multi-tier architecture.

Move business logic from the controller into BO classes using entity framework, implementing create, read, update, and delete methods for employees and departments.

Learn to implement a generic repository and generic view that handle multiple entities, such as employees and departments, with reusable crud operations and options to override for specific needs.

Develop a multi-layer architecture that keeps business objects independent of persistence, using a repository pattern and interfaces to swap between Entity Framework and XML or flat-file storage.

Create a multi-tier solution from scratch, building models, repositories, and an entity framework repository to connect departments and employees with a one-to-many relationship.

Explore dependency injection to achieve loose coupling by injecting interfaces via the unity container, replacing direct dependencies with configurable implementations and enabling inversion of control across multi-tier architectures.

Learn to build a lucky seven game in an MVC app, starting with a view model, a home controller and view, dice roll logic, and cookie-based balance tracking.

Explore building a user profile controller to support registration and login, using repository pattern, Entity Framework, and dependency injection with scaffolding and migrations.

Learn how to implement a database migration when adding an is_active column to department, keep the schema in sync with code, and adapt repositories to query only active records.

Implement a real-time web app authentication workflow with a login view model, account controller, and user profile repository, enabling login and logout, with authorization addressed in part two.

Implement authorization for employees, departments, and user profiles, redirecting anonymous users to the login page, and use forms authentication with cookies and a remember-me option.

Explore solid principles of object-oriented design, including single responsibility, open-closed, Liskov substitution, and interface segregation, with examples like exporters and repositories to keep classes focused and extensible.

Apply the interface segregation principle and the single responsibility principle to design separate interfaces and dedicated processors for e-commerce and employee management.

Learn to apply test driven development and unit testing to verify a class and its methods, automate test cases, and ensure robust MVC controller behavior.

Learn test driven development for MVC controllers by simulating web context with mocks. Verify login flows and redirect behavior using session, request, and response mocks.

Deploy and manage web applications with Azure App Service, a fully managed platform as a service that supports web, mobile, API, logic apps, and serverless functions.

Publish a live web app to Azure App Service, configure SQL Server databases, manage connection strings, test locally, and perform staging to production slot swaps with firewall and domain setup.