Week 3: Day 11-14 - SQL Basics

Tuesday:
Today, I watched some of the Khan Academy videos. I learned about querying and aggregating data. However, halfway into the class Ian had problems updating Windows 10. I helped him, by manually installing the update.

Resources:
https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/p/querying-the-table
https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/p/aggregating-data

Wednesday:
Today, I did several things. First, I went to a guy called Larry to inquire about usage of a FireWire port. When I returned, I ensured that Ian's update went well, and it did. Next, I started watching the videos again. I have now learned the proper way to pronounce SQL, and apparently there is historical precedent for SQL to be called "sequel", since that was what it was previously called in the past. It's often pronounced "S-Q-L" by foreigners though. Next, I worked on a project assigned to me by the course on Khan Academy. I had to create a database for a store.

Resources:
https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/v/s-q-l-or-sequel


Thursday:
Today, I finished the project that was assigned to me by the course. I decided afterwards, to learn how to import that into my SQLite. Apparently all you have to do is specify the name of your new file upon creation, and then copy paste the commands, since all it's doing is redoing what I already told it. Tomorrow I'll start doing more advanced SQL queries.

Resources:
https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/p/project-design-a-store-database

Friday:
Today, I learned how to use AND/OR in SQL. It's a very useful selector, and I will be using it a lot in the future. It also mentioned "autoincrement", which is useful for IDs, so you don't have to specify them every time. I will be continuing this next week.

Resources:
https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/p/more-complex-queries-with-andor

Week 2: Day 06-10 - Starting SQLite

Monday:
Mr. Elkner decided that I'm done with all my Battlefield stuff for the time being, and is now telling me to focus on SQLite, and so I will. I have installed SQLite on my bash shell, and intend on starting to learn about databases.

Tuesday:
Today, I started reading the book "The Definitive Guide to SQL Lite" but I only have to read a couple chapters. However, I've decided to read chapter 2 as well, since it gives more context on how to use SQL. In any case, I have to decide whether I want to use the database they provide or recreate it.

Wednesday:
I tried using the resource that Mr. Elkner referred me to. It wasn't really working, or perhaps I'm just not using it properly. Regardless, Owen began showing me how to create tables using SQLite. I successfully created a table, and I made the first entry into it. It's an employee/time table, to track the time my employees show up to work!

Thursday:
I kept working on that table from yesterday, Owen assigned me to make 7 more entries into it, and so I did. My employees are: Billy Bob, Moe Lester, Owen Sirabella, and OJ Simpson. He told me to make multiple entries for them with different times. Then he showed me how to find out everyone who came in at a certain time, or all the times that one of my employees had come in. Afterwards, Mr. Elkner showed me new resources since he thought the other one was too advanced. I will be going through the Khan Academy course for SQL now. Conveniently, they also use SQLite in it.

Friday:
Today, I started watching the Khan Academy videos. In the middle of class though, Owen showed me some other essential functionalities of SQL, and it was very helpful. Great way of ending the week.

Week 1: Day 01-05 - Working on Battleship

Hello and welcome to my next and final blog for the class of Advanced Topics in IT, at the Career Center. In the weeks leading up to the 2nd semester, I had been working on a Battleship game. I spent last week creating a new table and modifying my code to fit with the standards provided by the game. I successfully made a new table, but I'm still having some trouble getting it acquainted with my code. I will probably be able to figure it out soon though.

Note: This blog entry represents what I did for the entirety of last week.