SQL – Frankie Inguanez

PingFIN X @ MCAST, Malta

Posted on 2019-04-21 by Frankie

For the fifth consecutive year MCAST IICT has hosted PingFIN, an International e-Payments Workshop organised by Odisee and currently in its tenth iteration. Also, co-hosting this event, in their respective campuses were Colchester Institute, UK and Fachhochshule FH Salzburg, Austria.

This event has become a staple in MCAST’s calendar and interest by our sponsors is growing, which this year included MITA, eSkills Foundation Malta, Microsoft Innovation Centre Malta, ccBill EU Ltd and RS2 Software PLC.

This year we had the highest attendance yet, with 24 local students and 15 visiting students and thus the change of venue. During the four day event from the 1st to the 4th of April all students were split into groups to work on the SEPA Credit Transfer and SEPA Recall Process using Oracle PL/SQL.

It most definitely was a unique experience for our participants working as a team, networking and learning new skills, whilst also getting feedback from professionals among our sponsors.

This was an unforgettable experience and I look forward for next year. I thank our sponsors, Kevin Picalausa from Odisee, all staff from MCAST for making this possible. Special thanks to my team: Alan Gatt, Daren Scerri, Luke Vella Critien and Robert Abela for their invaluable support. Finally and most of all, thanks to the students for taking our offer and making this experience special.

Simple MySQL 5.6.20 installation guide

Posted on 2014-09-11 by Frankie

For educational use only, I have prepared an installation guide of MySQL 5.6.20 Community Server tested on Windows XP (32-Bit), Windows 7 (32-Bit), Windows 8 (64-Bit), Ubuntu 14.04 (64-Bit) and Mac OS 10.9.4 (64.bit)

Click on the following link for the MySQL 10.6.20 Installation Guide.

SQL for not registering employees for conflicting appointments!

Posted on 2011-12-14 by Frankie

I was once asked by a fellow colleague if it was possible to have an SQL statement that would not allow employees from being registered to events that occur simultaneously.

Scenario

Consider a database that stores a list of persons and a list of events. Employees would eventually be registered as event attendees. It is possible that multiple events occur at the same time and therefore it is required that the SQL statement prevent any persons from being registered as attendees of conflicting events. It was required that the solution be all in one SQL statement for some reason whatsoever.

The SQL solution is found attached together with a supporting report! As always all feedback and queries are welcome!