SQL

I finished reading the book and it mainly talked about how SQL can be applied to the real world and how SQL works on a website and computer. I understood most of the book but there are a couple of concepts I don't get but after messing around with SQL a bit I think I will understand it more.

Chapter 5

Chapter 5 deals with user restrictions and security and it was all pretty straightforward

• It's possible to require user name and passwords to operate a database and accounts can be restricted to certain actions such as allowing someone to update but not insert
• A database can also prevent two or more people from entering data at the same time by setting up a queue
• Locks can also be put on data to prevent it from being messed with but all actions can be reverted before being applied
• If there is a lot of data an index can be used to search faster but an index should not be too big otherwise it ends up taking a long time to maintain
• Logs are also recorded that allow the database to be restored to a different status 

SQL Guide Chapter 4

Chapter 4 deals with SQL Commands like

• Search Statements:
• Wild Cards allow a user to search for data that starts or end with a certain character (%n or _t)
• Comparisons like less than or equal to (x>=y, x=y, x<>y means not equal to)
• Input and Retrieve Data:
• "Insert" obviously inserts data
• "Select" chooses a column
•  "Where" can be used to specify certain data (WHERE x=y)
• "From" can be used to specify a table
• "And", "Or", "Between", and "Not" can be used to make more complex statements with more restrictions

I still don't understand some things so I will probably have to review some of the book because I think it was fairly simple and then it got a bit complex quickly.

Manga Guide

I continued reading The Manga Guide to SQL and after finishing Chapter 3 I learned that

• Data tables should be divided whenever more than one value is taking up a row or column
• Tables should be divided if there is a lack of data
• Different relationships and how to analyze data, such as many to many or one to many

Basically, a table should be divided whenever there is too much or too little in a cell. Once tables are divided they should rely on another kind of like a math function so there is an input and another table is dependent on it and it has an output. The one concept I don't get entirely is normalization but I will worry about that later and I started Chapter 4.

Links

I added a hover color to my links and padding that I like. I was going to add a border but I didn't like the look of it because of how little I have on my web page.

Google Fonts

I started lesson 3 of "Getting Down with CSS" and I looked at adding colors while hovering over links but I was really interested in Google text effects although because it is in beta I think it may be preventing my page from validating so I will be removing the animated flames.

Fonts

I spent the majority of this day looking at Google fonts and I had trouble with it so it took me awhile to get it working due to my misunderstanding of how external style sheets work, but I finally set the font "Press Start 2P" to work as my title. I also looked a little bit at favicons and Google's text effects.
 

Refining the Home Page

For the first part of today I worked on changing the colors of my web page to look a little better and I may be changing it depending on what I add because there is currently very little on my web page.

This is what I am basing the color scheme off of:
http://colorschemedesigner.com/#2Q12AdUGWZpVa

I also started lesson 2 and tried to import a Google font but I was having trouble with it so I will give it another try later.

Getting down with weekly journals

In September I was working on html and I am currently done with that. Right now I am working on SQL and I have been learning from Chris and whenever he is not around I mainly read the manga. Our goal after learning how to work with SQL is to make a database called "check it out". I couldn't do much with what I know right now but I understand some of the format and how some things work.