Xavier Geerinck

Creating a LinkedList with C++

Linked Lists are one of the fundamental data structures. The main usage of a Linked List is when constant insertion and deletion time is required, or when a dynamic list that can grow and shrink over time is needed.

How to benchmark Reading 10MB in C++

> This article is based on a vagrant Ubuntu system with an SSD so you might encounter different results.

Basic OOP with C++

This article is going to explain 1 example of an Object Oriented Program for C++.

SQL - Recursion

# Introduction

SQL - Part 5 - Common Table Expressions

CTE's (Common Table Expressions) are mostly used when creating recursive queries, creating temporary views (instead of subqueries).

SQL - Part 4 - JOIN + Simulating Functions

When creating JOIN queries in SQL we have to realize that we are going to combine every result from the result set with the result set itself. This means that we are going to create a new result set that is the size of the power of 2 of our original result set. (So if we have 1468 records, and we join it with itself, then we will get 2155024 records = 1468^2)

SQL - Part 3 - Analytical Functions (Ranking, Rows, Over, ...)

## Analytical Functions

SQL - Part 2 - Aggregate Functions (GROUP BY, CUBE, ROLLUP, ...)

## Aggregate Functions

SQL - Part 1 - Advanced CASE Selecting

While I was studying the course Databases at the University of Ghent, we encountered some special queries that we were not being thaught in the Professional Bachelor course. This is why I tried to summarise those queries here for everyone to learn from.

Solving a maze with Perl

Mazes are really famous puzzles where the goal is to find the exit starting from an entrance. We can see these kind of puzzles as a labyrinth. When we found the solution we then draw over them to mark the path that we have to find.