Tuesday, November 4, 2014

Unit 10: Databases P.2 (Electric Bugaloo)

SQL seemed a lot easier to learn than Linux, its syntax is more like the kinds of things human beings say to one another (human readable) for the most part. Last week I committed an EPIC FAIL in posting some tables which were extremely flawed because I had accessed the Mostafa tutorials by means of googling Mostafa MySQL instead of accessing it through UACBT/VTC and doing it through GOogle was not the same as doing it through the VPN, so I was unable to download his movies after Section 2. This week I viewed all of last week's Mostafa videos and learned that I had not really normalized my data correctly, so it's gonna be the pre-fab images folder all the way for me, I guess. The data set I had in mind was a lot less complicated than what we have here and I couldn't really figure out a Primary Key for that. If this was the first time I discovered something I posted was completely messed up I wouldn't mention it, but now I will have a trail of online posts that make me look like an idiot, only a week after I posted them. Good thing the internet is so malleable that nobody will ever see that ;)
So the hardest concept for this week was the table joins, I think you join tables in expanding "your net" in looking for query results? Mr. Mostafa just about lost me when he started using single letter abbreviations for aliases in his commands.

In answer to a question in the assignments, I have a hunch it would be easy to transcribe requests to edit data in Webmin into the MySQL command line because Webmin seems to replicate in both syntax and semantics MySQL commands.
Hm, one real challenge for me was attempting to summon the Webmin, this whole thing of starting up  Webmin via the command line and then firing it up in a web browser can make your head spin from time to time, but we did it a couple of times and the second time I was able to do it successfully just from my notes and no needing to google it. Also when starting Webmin there was some message in the code about "No super cow powers" I would like to find out more about that (You can read about  it here, I guess it's Ubuntu/apt versus aptitude thing , not Webmin that is the source of super cow powers:
http://unix.stackexchange.com/questions/92185/whats-the-story-behind-super-cow-powers
).
Oh man, you can tell I've been working with the command line in SQL too long when I make my end parentheses on another line.
I am realizing sometimes it is easier for me to "get" things in review than when say, Joshua Mostafa is lecturing about it on the first go 'round. Like when he fires up MySQL in subsequent videos, I was able to write down the commands he used more easily than when he introduced those commands.

No comments:

Post a Comment