Projet de session
One deliverable from each class.
A snapshot of the current session: one real deliverable from each course, picked to show a different side of the work. These are graded coursework, not homelab repos, so none of them have a public repository yet.
Networking & Systems
Windows Server Administration
Session project with a lab partner: a 4-server Windows Server 2022 domain with AD DS, primary and secondary DNS, DHCP with MAC reservations, WSUS, GPO-enforced security and roaming profiles, Windows Server Backup, and IIS, FTP, and SSH on a domain-joined app server. Verified end to end: profile roaming across machines, DNS resolution, GPO lockdown, SFTP transfer, and WSUS update delivery.
Databases
Database Systems Audit
Team comparison of MySQL, Oracle Database, SQL Server, and PostgreSQL across cost, data volume, and concurrent users, followed by hands-on work in an Oracle 19c VM: connecting with SQL*Plus and SQL Developer and querying the HR schema.
Applied Security
SQL Injection: Find and Fix
A PyQt5 and Oracle employee-search app that was vulnerable to SQL injection through string-concatenated queries. Rewrote the query layer with bind variables to close the hole and verified the fix against the same inputs that broke the original.
Programming
Qt Parity Checker
A small object-oriented PyQt5 desktop app that validates numeric input and reports even or odd, built to practice GUI event handling and input validation in Python.
Each card opens a report I wrote up from the original lab submission. The originals, with their screenshots, are untouched in your files. For the homelab repositories, see Projects.