This slideshow gives a kind of high-level idea of what CS 304 is about.
The calm before the storm...
user clicks on a button, submitting a request to Apache
Apache gets it and hands it off to our code
Our Python/Flask code sends SQL code to the MySQL DBMS to get or modify data
MySQL returns results to our code, often a table of data.
Our code uses the data as it pleases and gives a response to Apache, in the form of a web page, probably dynamically constructed out of templates and the data from the database.
Apache sends the response (HTML, CSS and JavaScript) to the browser
And the round trip is complete.
The browser sends the request to a Flask development server, running on a different port.
Flask includes some code that you write to handle different routes (urls)
Your handler can connect to MySQL, sending it some SQL code