Very Hot Week!!!

This week as been a very hot and eventful week.

It has been great because it is nice and warm but it gets to a point where it is that warm that I feel like I am in a sauna when I am in the office.

We do have some air conditioning units that my colleague Vince has kindly brought in for us to use, but even with all of them going, its still warm.

Apart from that, there is not much that I am doing currently at work apart from building accounts.

I am getting more SQL training done, my mentor Paul is creating questions on one of our test accounts for me to use select statement to collect a list of data.

I have been doing simple select statements such as select a list of fields from a single table.
I have also been doing joins too, such as trying to find all the people in a certain location in the software with their First name, surname, email address, location, and company. This means I have to join the [User] table (which has the First name and surname) to the [Email] table (which has their email address in), the [UserLocation] table (which has their location name in) and then finally the [company] table (which has the company name in).

I actually get how to do this and also it comes pretty quick to me as I am able to practice this in my job role for customers.

Below is the script if anyone is interested 😂

Comments

  1. It has been ridiculously hot! We bought an air con unit for the training room so you should have come here!!

    ReplyDelete
    Replies
    1. Yeah I can safely say that the air con unit made a massive difference :)

      Delete

Post a Comment