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