Wednesday, April 15, 2009

Ch. 8 Control Your Data, Control Your World

This chapter discussed about databases and how they relate to one another. 

Things Learned:
schemas - representation of the structures within a database
normalization - altering the design of a database to reduce duplicate data and improve placement of new data
Foreign Key - a column in a table used to relate a table to another table
for() - a loop code
? : - ternary operator used to perform simple true/false expression like a if-else statement
Inner Join - let you join table from two tables with matching rows
AS name - use as aliases to make column/table names more simple to code 

Ch. 7 cont.

Things learned:
PHP can used require_once to includes other code so that you don't have to type things over and over again.  As in, you can just include a header or footer instead of re-typing it. 
Sessions are don't last as long as cookies.