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.
No comments:
Post a Comment