Tasks
Tasks Archive
A structured ledger of academic and training tasks. Covering SQL database architecture, C# programming, and full-stack web development exercises.
| Project Status | Core Tech | Focus Areas | Methodology |
| :------------- | :--------------------------------------------------------------------------------------------------------------- | :----------------------- | :-------------------- |
| `ACTIVE` |  | `Database, Backend, Web` | `Iterative Lab Tasks` |
Table of Contents
Overview
This repository is a curated, numbered archive of assignments and exercises completed across academic courses and training programs. Each task folder is self-contained, containing source files, any required assets, and task-specific notes.
The repository is organized into three domains — SQL, C#, and Web — reflecting the full-stack learning path. It is maintained as a personal progress ledger and referenced in the profile portfolio as evidence of foundational skills.
SQL Tasks
| Task | Description |
|---|---|
| Task 1 | Basic SELECT, filtering, sorting — query fundamentals |
| Task 2 | JOINs — INNER, LEFT, RIGHT, FULL OUTER across related tables |
| Task 3 | Aggregations — GROUP BY, HAVING, COUNT, SUM, AVG |
| Task 4 | Subqueries and CTEs — nested SELECT and WITH clauses |
| Task 5 — CollegeDB | Enterprise-grade college management schema: 9 tables, 11 FK relationships, 4-level RBAC, optimized stored procedures, full ERD. Featured in the profile portfolio. |
| Task 6 | Views, Indexes, and query optimization |
| Task 7 | Transactions, ROLLBACK, and data integrity constraints |
C# Tasks
| Task | Description |
|---|---|
| Task 1 | Variables, data types, operators, and control flow |
| Task 2 | OOP fundamentals — classes, objects, constructors |
| Task 3 | Inheritance, polymorphism, and abstract classes |
| Task 4 | Interfaces and dependency inversion |
| Task 5 | Collections — List, Dictionary, LINQ basics |
| Task 6 | File I/O and exception handling |
Web Tasks
| File | Description |
|---|---|
| DEPI-schedule.html | Visual HTML schedule reference for the DEPI training program |
Tech Stack
| Domain | Technology |
|---|---|
| Database | SQL Server (T-SQL) — queries, schema design, stored procedures |
| Backend | C# (.NET) — OOP, collections, LINQ |
| Web | HTML5 — static schedule and reference pages |
Project Structure
Tasks/
├── 1. SQL Tasks/
│ ├── Task 1/
│ ├── Task 2/
│ ├── Task 3/
│ ├── Task 4/
│ ├── CollegeDB project- Task 5/ # Featured enterprise schema
│ ├── Task 6/
│ └── Task 7/
│
├── 2. C# Tasks/
│ ├── Task 1/
│ ├── Task 2/
│ ├── Task 3/
│ ├── Task 4/
│ ├── Task 5/
│ └── Task 6/
│
└── DEPI-schedule.html # Training program schedule page
Getting Started
# Clone the repository
git clone https://github.com/AhmedTyson/Tasks.git
# Browse SQL tasks
cd Tasks/1. SQL Tasks
# Browse C# tasks
cd Tasks/2. C# Tasks
# Open the schedule page
start DEPI-schedule.html
Each task folder contains its own source files. SQL tasks are
.sqlor.mdfiles. C# tasks are.csprojects or solution files.