Guide to Oracle SQL (Computer Science 4 All Version)
Introduction to Databases
Wikipedia defines a database as "an organized collection of data. It is the collection of schemas, tables, queries, reports, views and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information, such as modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies."
A schema is "its structure described in a formal language supported by the database management system (DBMS). The term "schema" refers to the organization of data as a blueprint of how the database is constructed (divided into database tables in the case of relational databases).
A table is a collection of related data held in a structured format within a database. It consists of fields (columns), and rows. In relational databases and flat file databases, a table is a set of data elements (values) using a model of vertical columns (identifiable by name) and horizontal rows, the cell being the unit where a row and column intersect. Table (database) - Wikipedia https://en.wikipedia.org/wiki/Table_(database)
After logging in to your account you can use the Unix shell commands to manage your files.
Your files are stored in a directory (folder) which is setup and named a certain way so that the web server can find your files when someone enters your URL in their browser address window or clicks a link that goes to your web page. For my examples that directory is called *
public_html*. Again, using
bscacad3.buffalostate.edu as an example, the URL of your web site would be:
For example, my URL is:
After logging in to your web server account you need to issue the command '
cd public_html' to change your working directory to your *
public_html* folder where the files are stored that will make up your web site.
Your web pages are simple text files that have HTML tags that advise the browser how to render the look of your web page, including any images or hyperlinks are included on your web page. Once you place yourself in your *
public_html* folder you can use the *
vim* editor to create and modify your files. *
vim* is a modified (improved) version of the *
vi* editor. It is fairly easy to learn the handful of commands you need to create and maintain the files you'll need for the tasks in this guide. You can use the *
man vim* command at the Unix prompt to get helpful information about using the *
You will also need an SFTP (Secure File Transfer Protocol) client for your machine so you can upload any non-text files such as images, media (audio and video), and Java applets. If you are using a Windows machine, I recommend using FileZilla and for a Mac I recommend CyberDuck. Again, using the
bscacad3.buffalostate.edu server as an example, here are the necessary SFTP settings:
Another method for maintaining your web files is to use an HTML editor on your local machine to create and edit your files and then use one of the above mentioned SFTP clients to upload and download your files to your web server.
If all goes well your file should be listed in the left window.
On your Mac you can use the built-in application *
TextEdit* to edit your files and *
Fetch* to upload/download your files.