MySQL

MySQL Field Types

Gliffy is for Flowcharting

.

SQL

• What does SQL stand for?
• What is a database query?
• For the following query, what table is the information being pulled from?
• select (name, address) from (roster) where (class=programming)
• Do you have to learn an SQL language in order to control a database?
• What is the Microsoft Office application that can be used for controlling databases?

Commercial Web Hosting

Answer the following questions concerning web hosting:

1. Which files can FTP users edit?
2. Is FTP secure?
3. Where do files get saved if you "get" them from the server?
4. Where to MySQL tables reside?
5. What are 3 examples of field types?
6. The auto-increment feature serves what purpose?
7. What field type is used to store bulk binary data?
8. Explain what DNS does.
9. Provide examples of both over-priced and under-priced web hosting options (include URL's).

.

Martine Tours

Today, we're beginning preliminary design work on the massive Martine Tours web application.

Here's the URL for what's already done with the project:

http://howardm.com/Bus_Template

User: Barack

Password: 2012

.