I am just starting to learn SQL, and this is probably a silly question, but what code is used for the front end, user friendly input to a database or table?
For example, when you fill in your contact information for a website that information obviously doesn't go off to someone who inputs it individually in to the table/database using SQL syntax, so how is the SQL tied to the individual form sections that are being filled in by the customer? Is it the responsibility of the database manager to create this link or of a web developer through something like HTML code?
This is a really open question, because there is a ton in the middle, but I guess this is the best way to summarize it:
The server will open up a connection to the desired RDBMS database (SQL Server, MySQL, PostgreSQL) or a NoSQL database like (MongoDB, CouchDB) at which point it will run SQL provided from the server or execute a procedure on the database with the sanitized data passed in.
Essentially a small workflow would be
This is a really rough picture, but these are the beginning steps to any enterprise n-tier architecture in most of the cases. Hopefully there are enough keywords for you to google and research on your own that will help you along the way with better understanding.