A Blog Containing College Projects and Certifications

This is a report that contains all the work that I’ve done throughout the semester in the database administration module. It will begin by describing the installation process, followed by the exploration of Oracle 11g from SQL Plus and from SQL developer. I will then look at the “File Management” section, followed by the “Memory Structures” section. Oracle processes will then be looked at in detail, this being made up of server, background and slave processes. The final sections of this document will look at “locking and latching”, “concurrency and multi-versioning” and transactions. The full report can be viewed below. https://drive.google.com/file/d/1hQcLsz5NnCbvu8Zl9EgXoHK_RZUqGiaD/view?usp=sharing

I was given a large and unstructured data set to clean, this cleaning took place in Microsoft Excel. The data set was in relation to product sales , and contained details such as product categories, shipping information, discounts and profit. Following on from this I created 2 dashboards, one for the sales manager and the other for the CEO. A number of KPI’s were developed for each individual, paying close attention to each component and purpose to each user group, adhering to a logical layout and a clarity of purpose. Sales Manager Dashboard Image CEO Dashboard Image Here is the Qlik file for the project  Grade - 73%

A place where people with an interest in the fitness industry can share details about their favourite workouts amongst other users of the forum. This is a Node.js based restful API which included significant advanced data persistence . It makes use of messaging i.e. when a user posts their favourite workout, a message is published to Pub Nub. Users can ad d a comment on another user’s workout (perhaps providing them feedback, increasing the social element of this project). The data is handled through MongoDB and Mongoose (This is an object modelling tool used to work in an asynchronous environment).   Unit testing of the API is achieved using Mocha, Should and SuperTest, with a report automatically generated by Mochawesome after each test has concluded. The combination of custom validation and unit testing increases the validity of posts. Security/Authentication: 2 users are added to the forum when the server starts up, upon registering they are given a JSON web token using J