Week 7: Day 30-34 - Postgres Server Pt. 2

Monday:
Today, I created a bash script for Marco for the Taco Truck project. Then I helped Edson move a bunch of files to a different directory. Afterwards, I started learning some Postgres commands regarding users and privileges. To create a new user, you have to do:

CREATE USER (username) WITH PASSWORD '(password)';

and you can delete just as easily doing:

DROP USER (username);

to give the user superuser (administrative) status do:

ALTER USER (username) WITH SUPERUSER;

to set a password:

ALTER USER (username) WITH PASSWORD '(password)';

To connect to your actual server, you do:

psql -h (ip address/hostname) -p 5432 -U (user) -d (name of database)

Tuesday:
Today, I wanted to work on the Postgres Server, unfortunately Mr. Elkner gave me a wacky password instead of just "password" like I suggested. So I was not able to log into the server. So instead, I added a new column to the Taco Truck table, and continued learning about querying in subqueries in SQL through Khan Academy, then did the follow up activity.

Wednesday:
Today, I had Mr. Elkner give me the password so I could get in to change it. I did that, and now I'm in and can learn how to use Postgresql.

Thursday:
Today, I helped Edzon with a Python syntax issue. Then Ian wanted to convert an image into a banner, and I helped him do that. Afterwards, Mr. Elkner assigned me to a new project. I started designing a database for the Virginia CS Standards. It's going to be a many-to-many relationship. You can check my github to see what work I've been doing on that.

Friday:
Today, I continued working on getting the many-to-many relationship to work on the Virginia CS Standards thing. It's been very tough to figure out, but I learned from this on how foreign keys work, and this reinforced it with an example in sqlite which joins two table for a many to many relationship. This is exactly what I emulated for the standards which I had to organize.

Week 6: Day 25-29 - Let's Get This Taco Truck Rolling

Monday:
My goal this week is to get the ball rolling on the Taco Truck project. I've already started with creating a document to organize our project, and now Marco is showing me some vital information regarding this project. He has shown me how he will get Python to interact with SQLite, and it's very intriguing. This seems to make a lot more sense to me now.

Tuesday:
Today, I helped Ali with his Red Hat Exam preparation. He asked me some questions about the networking side of things, and I pointed him in the right direction with what he should know before going into the test. Next, I created a table in SQLite for the Taco Truck project. Now it's time to get Marco to integrate it!

Wednesday:
Today I worked on the Taco Truck project even more. We created a Github page for it, and I stored my SQL file on there for Marco to work on. I also installed Postgresql on the virtual machine server that Ali made for me. Next time, I'm going to work on the VA Votes project.

Thursday:
N/A (Field Trip)

Friday:
N/A (Field Trip)

Week 5: Day 20-24 - Postgres Server

Monday:
Mr. Elkner has changed my focus for this week. Instead of Khan Academy, I will be focusing on setting up an SQL server. Today, I changed the hostname for the Raspberry Pi, as you can see it's "cdevlin" now, named after Catherine Devlin. In addition, I created a test database following your directions..

Tuesday:
Today, I gave Ali some great advice on his Red Hat test. I showed him how to hack the system to change the root password, and told him the biggest focuses he should have on the test. Afterwards, I made some great progress on my SQL server. I created it, and it seems to be working. Now, I need to make it so other computers on the network can connect to it. I will be doing that next class.

Wednesday:
Today, I helped out Edson, Ian, and Helber with Github. They needed to configure their SSH keys, which need to be generated using "ssh-keygen". In addition, I finished creating the Postgres SQL server, and Mr. Elkner is able to connect to it properly. There are several potential things I may end up doing moving forward. It seems that I might be helping a Wakefield student to help out a taco truck driver track his sales/resources using a database. At the same time, I will be furthering my studies using the Postgres server.

Thursday:
Today, I helped out even more people with Github. It seems that I have got most of the class to bind their terminals to github with SSH keys, despite the several problems that I encountered. In addition, Ali has been assigned to create a virtual machine for me, so I can transfer my Postgres server from the weak Raspberry Pi, to the more powerful and spacious Ubuntu VM that I'm getting. I've been told by Mr. Elkner the plan of action for this tack truck project. I will be handling the SQL side of things using SQLite, which will be receiving information in JSON through Python as middleware. Very exciting stuff!

Friday:
I spent a lot of time researching relational databases, to understand the concept. Edgar F. Codd is the guy who created the relational model, using relational algebra & calculus. Relational databases, use his relational model. Ali had finished creating my virtual machine server. I spent the rest of class creating the Postgres server, which I did successfully.

Week 4: Day 15-19 - Advanced SQL Queries

Monday:
Today I watched a video on Khan querying in subqueries. It was followed up by an activity as most of these videos are. It was extremely frustrating trying to figure out how to use IN.

Resources:
https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/p/querying-in-subqueries

Tuesday:
Today I helped out a fellow classmate on trying to get Github for Terminal on his Mac. Afterwards, I went to Mr. O'Day's to get footage transferred from my Sony HVR HD-1000u camera onto the computer. My predicament was that there are not that many devices which support FireWire. Thankfully after much searching, there was a PC in the room which had FireWire support. However, it took me a while to figure out how to get my camera into "VCR Mode" so it could start the transfer. I was about to start transfer, but in the middle there was a fire alarm. When I got back I started the transfer, and it was around the end of class when it finished.

Wednesday:
At the beginning of today, I quickly went to Mr. O'Day's to import video from the camera. While it was importing, I went back and did more Khan Academy. Now I'm looking at restricting grouped results with "having".

Resources:
https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/p/restricting-grouped-results-with-having

Thursday:
Today I learned about who issues SQL queries. Afterwards I moved on to calculating results with CASE, and followed up with another activity.

Resources:
https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/a/who-issues-sql-queries
https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/p/calculating-results-with-case

Friday:
Today, Mr. Elkner and I discussed a potential project that I will be working on with a fellow Wakefield student. It required an SQL server, which we set up on a Raspberry Pi. In the meantime I did some research on who the server should be named after. We chose someone whom Mr. Elkner knows for the honor.