I forgot to mention in my week 7 update that our first continuous assessment exam took place at the end of that week. I think it merits a post of its own though. We were being tested in the Introduction to Computing & Web Technologies module on our understanding of MySql queries. The test format was "open book", meaning we were free to consult our lecture notes, or research online or in books for answers to the test questions. I'd never done an exam in this format before & initially thought it would make it a lot easier. At the end though, I felt it possibly made me too quick to consult the available resources, rather than spending a bit more time trying to figure out a solution on my own.
Prior to the start, we downloaded a sample database, which we then used to answer a number of queries, such as create a list of all orders shipped after a certain date. I was happy enough with how that part of the test went, though looking at the results a few weeks later, I had made a few more stupid mistakes than I thought at the time.
The second part of the test involved writing queries for a database whose structure was described in a diagram. Again, I felt this was going well until the last question where we were asked to return details of all suppliers that supply a product with a productid of 33. Both my brain & Google decided to give up on me at that stage, so I went for this answer:
select * from Suppliers where Products.ProductID = 33 Inner Join Products on Suppliers.SupplierID = Products.SupplierID;
when I should have used this:
select suppliers.companyname, suppliers.contactname, suppliers.contacttitle from suppliers, products where suppliers.supplierid = products.supplierid and products.productid = 33;
It's still an area that I need to go back to at some stage to make sure I fully understand what happens in each query. Since the test though, it's been project proposals & project work almost non-stop, so it'll be another while before I get to look at it again.