MariaDB: PIVOT
I googled “mariadb pivot” and the first answer was this. Ouch, this is a big (and complex) procedure. Then I scrolled down, but I couldn’t find a quick answer, so I created one. Here is the template: Keep it simple :-)
root
Training: SQL is the top demanded programming language
Few days ago Business Insider posted a list of 8 in-demand programming languages. The big news is that SQL is number 1! Codingdojo report spots SQL as the best programming language to learn, based on the number of job postings on Indeed. Finally I decided to check the average salary for SQL Developer […]
Data Warehouse: Create Date Dimension (version 1)
Data Warehouse is “a system used for reporting and data analysis”. In general it is built by dim (dimension) and fact tables (structure and data tables). Here I create a stored procedure to build Date Dimension. Now it builds only calendar data and will be expanded to include “fiscal” data […]