Today I had my networks and databases labs, these mostly covered the concepts that were brought up in the prior weeks including the idea of a 2 way handshake for encryption, the very bold concept of "The speed of light is slow but prime numbers are hard" and the introduction of SQL on its own using a client independent from Access. This lead into the databases practical where we were told to use the client pgAdmin to load and operate on a database. With this we were given varying tasks from using multiple selects to refine queries to generating views that could be used in future. Sadly I got stuck on exercise 4 due to its wording. It requested that you changed a specific employee's data using the query, many people simply used the side bar to find the employee and targeted her based on this. But I thought this solution wasn't scalable to a true database so I found the proper way with the tutors help which required multiple where and select statements to refine the search between 2 tables. I plan to finish the remaining 16 tasks on Wednesday.
Today I had my networks and databases labs, these mostly covered the concepts that were brought up in the prior weeks including the idea of a 2 way handshake for encryption, the very bold concept of "The speed of light is slow but prime numbers are hard" and the introduction of SQL on its own using a client independent from Access. This lead into the databases practical where we were told to use the client pgAdmin to load and operate on a database. With this we were given varying tasks from using multiple selects to refine queries to generating views that could be used in future. Sadly I got stuck on exercise 4 due to its wording. It requested that you changed a specific employee's data using the query, many people simply used the side bar to find the employee and targeted her based on this. But I thought this solution wasn't scalable to a true database so I found the proper way with the tutors help which required multiple where and select statements to refine the search between 2 tables. I plan to finish the remaining 16 tasks on Wednesday.
Comments
Post a Comment