our first gist

filenameFred.txt

mysql> CREATE SCHEMA schems_2014
 CHARACTER SET utf8
 COLLATE utf8_general;

mysql> use schems_2014

mysql> CREATE TABLE inventory (
inv_id ...
);

mysql> CREATE TABLE io_obs (
obs_id ...
);

mysql> INSERT INTO io_stats VALUES ( ... );

mysql> CREATE TABLE io_stats (
stats_id ...
);

mysql> CREATE TABLE projects (
project_id ...
);

It is good timing that I explain gcc tools + hello world + databases + web servers....

Linux is at the ground floor of the LAMP stack, and all depends upon linux:

1. Linux and other local and network file systems, as you are quickly learning.
2. MySQL, which is a relational database management service
3. Apache, which is the web page server (listens for urls from browsers)
4. PHP = Server-side dev language

With this hands-on grasp of the LAMP stack, git will make WAY more sense! :)

In order to help you make $$ with logical and physical relational database technology:
0. ensure gcc tools are installed in OS X

1. mysqld database service installation and configs
2. mysql client connects and secures database
3. mysql db root account creates logical database schema
4. mysql db root account creates dbadmin + dbadmin_ro + dbdev accounts
5. mysql db root account confers all privs
   to dbadmin on schema(s) with grant options.
6. schema dbadmin connects and creates tables and keys
7. developer provides sample data and some structural changes
8. schema dbadmin makes structural changes + loads sample data
9. data sources and logic inputs reviewed
10. custom stored functions and procedures can reduce amount of dev code
11. CASE Tools aid in connecting actual code with diagrams that finalize system specs.
12. Environments --< Networks --< Systems --< Services

EXAMPLES OF SOFTWARE SPEC DIAGRAMS =>

1. ERD = Database Model = Entity Relational Diagrams (tables and keys)
2. DFD = Data Flow Diagrams = Process Flows for Devs
3. UI Prototyping = Focus on front end responsive templates and user experience.

TESTS ARE THE CONNECTIVE TISSUE THAT HELP THESE THREE LAYERS CONVERGE!