CS340 Activity 2 - Connect Webapp to Database
This assignment focused on setting up a web app that could connect to a MySQL database, run required SQL queries, and show the results through the browser.
The original deliverable was a working URL hosted on the ENGR server.
Assignment Scope
We were asked to set up a small web application stack, connect it to our CS340 database account, and run a sequence of SQL statements to verify proper connectivity.
The activity also included setup work such as VPN access through the colleges provided 'Cisco Secure Client', server account setup, and remote development on the ENGR servers.
What I Learned
This assignment was my first real introduction to SSH. Before it was something I had only a vague understanding of, and had never actually implemented in practice. I also learned the procedure for using the built in SSH functionality in VSCODE.
I recognize how important SSH is if I want to become a Database Administrator. Database and server environments are commonly managed remotely, so being comfortable with SSH is a foundational skill for troubleshooting, deployment, and day-to-day administration.