Friday, 16 September 2016

Weeks 6 and 7 At QA Academy

Week 6

A month of training is nearly over! First thing Monday the group of 40 got split up into two groups, our group was going through databases for this week. We were given the task of creating the databases for NB Garden's new Inventory & Sales Management System using both MYSQL (in workbench) and Mongodb (NOSQL). I had little experience with SQL as I used it in my final year project but never had any proper training with databases so this week was very helpful, and learnt quite a lot. As for Mongodb I had never heard of it until this week but feel like it can be a very useful tool especially with data where length or type cannot be predetermined, such as product description.

We also found out where we will potentially be getting deployed after eight more weeks of training. Our group was told we will be deployed to the Office of National Statistics (ONS), although not sure exactly what project/projects we will be working on, we were given a rough idea of what sort of things we will be doing there, databases, big data and maybe some devops. This group was then further split into people joining the Southampton team of  ONS and the Wales (Newport) team. I am  part of the Wales team, which has around 14 odd people, were already talking about renting a house together so the next two years should be fun! Although we have been told not to put deposits down yet because it might change, I hope not though I'm pretty pleased with this outcome better Wales than London.

Week 7

Much needed three day weekend although it turned out to be a very eventful bank holiday. Ended up missing my coach back too so got back to Manchester at two on Tuesday morning after six hours of traveling. On week five already! Weeks are flying by, not long left till I'll be in a proper work life routine in wales.

This week is all about creating the Accounts and Sales Analytics System. The System is being made using Python 3, which I have never used before and the syntax took some time to get used to. We were given multiple user scenarios which were used to add functionalities to our system. The user stories showed a lot of missing data from the databases both the SQL and Mongodb so a lot of this week was spent going back and editing the databases created the first week. I also got to experience how different it is to call queries between SQL and Mongodb, I prefer SQL querying a lot more. I still managed to get a lot of the functionalities to work with both the SQL and Mongodb data being presented. But I had much more fun making the battleship game in Java from week three.

No comments:

Post a Comment